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
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
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
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
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
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
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
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
Introduction If you have data stored in PostgreSQL tables, there’s a good chance you’ll need to update the contents of those tables at some point. The PostgreSQL UPDATE statement makes it easy to perform any modifications you might need. In this tutorial, we’ll discuss this statement in detail and check out some examples of how … Continued
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
