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.
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 […]
In this article we will see a SQL script that will drop all objects in an Oracle database
Oracle has a LONG RAW datatype that is used primarily in its system tables. There are cases where these tables need to be read from an application. There is a catch though, the common methods used to cast a datatype to another cannot be used in a plain SQL statement, but the developer must use […]
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 […]