PostgreSQL SELECT First Record on an ObjectRocket Instance

Introduction When you perform a typical PostgreSQL query, you can expect to have the entire result set returned. However, that may not be exactly what you need. What if you wanted to select just the first record of the result set? With the help of the LIMIT clause, it’s possible to specify how many rows … Continued

PostgreSQL Insert for an ObjectRocket Instance

Introduction The ObjectRocket platform is the futuristic-minded developer’s choice for managing business applications today and in the years to come. One main feature of the platform is its ability to make table management limitations a thing of the past. For example, technical specialists need to organize PostgreSQL data this and that way. And often, the … Continued

How to Use the Postgres COUNT on an ObjectRocket Instance

Introduction When you execute a PostgreSQL query, your results will include any records that match the conditions defined in the WHERE clause. However, there are times when it’s more important to have the number of non-NULL values in a column that match the query criteria, instead of the values themselves. The PostgreSQL COUNT function makes … Continued

PostgreSQL UPSERT for an ObjectRocket Instance

Introduction When you insert a record into PostgreSQL, there’s an assumption that no such record already exists in the table. However, it’s possible that a duplicate record does exist, and attempting to perform the insert will result in constraint violations. What if you wanted to take action in the event that a matching record already … Continued

How to use PostgreSQL UPDATE WHERE on an ObjectRocket Instance

Introduction The PostgreSQL UPDATE clause is used to modify records that already exist in a table. Using the WHERE clause in conjunction with the UPDATE clause will target, and update, only the rows that are selected. If the WHERE clause is not used when executing the PostgreSQL UPDATE function, all the rows in the table … Continued

How to Perform the PostgreSQL Coalesce in ObjectRocket Instance

Introduction The Postgres COALESCE function can accept an unlimited number of arguments without constraints and evaluates arguments until locating the first non-null argument. The remaining arguments are not evaluated once a non-null argument is found, however, it will return null if all of the arguments are null. This tutorial will explain how to perform the … Continued

How to Use the Postgres Similar To Operator on an ObjectRocket instance

Introduction The Postgres SIMILAR TO operator works similar to the LIKE operator, but the SIMILAR TO function uses the SQL standard’s definition of a regular expression to interpret the pattern. However, unlike the ordinary regular expression action, where the pattern may match any part of the string, the SIMILAR TO operator succeeds only when the … Continued

How to Use the PostgreSQL in Docker in ObjectRocket Instance

Introduction PostgreSQL, Docker, and ObjectRocket all help developers get their applications up and running as fast as possible. PostgreSQL is the popular open-source object-relational database many technical professionals rely on to manage their small, medium, and large scale data. Docker containers simplify code development. ObjectRocket allows you to build and manage your applications with performance … Continued

TimescaleDB Tutorial for an ObjectRocket Instance

Introduction TimescaleDB is a time-series database system, often referred to by it TSDB acronym. TimescaleDB is celebrated for being able to efficiently managing large data and executing CRUD functions faster than traditional relational databases. TimescaleDB tutorial for an ObjectRocket instance will explain how to create a TimescaleDB ObjectRocket instance for easier data management and remotely … Continued

Keep in the know!

Subscribe to our emails and we’ll let you know what’s going on at ObjectRocket. We hate spam and make it easy to unsubscribe.