In this post we will see an example model for Objection.js and how we can define basic database concepts to our model. Objection.js is a relational query builder for Nodejs and is built on top of the Knex SQL query builder.
Query JSON data as relational in MySQL
MySQL can support the JSON datatype, and allows to write queries that can query the JSON data directly. In the case where the JSON value is an array of objects, we will see how we can query the table and retrieve the JSON data as relational data. We will see how we can use JSON_TABLE […]
Backup the data from your Sql Server
An often requirement in a CMS is the user to be able to backup the database of its CMS installation. If you are using MS Sql Server there is a simple command that creates a .bak file of your database. BACKUP DATABASE [mydb] TO DISK = N'<bak_file_path>’ Restoring the database is also simple with the […]