Registration in TimescaleDB

Introduction In this instructional article we’ll learn how to create Registration in TimescaleDB for most kinds of applications, including games. We learn step by step how to register a user using an HTML page retrieveed up by Python. The first thing to do is set up a database instance. We prefer using Objectrocket because we … Continued

Managing Tables with TimescaleDB

Introduction In this instructional article we’ll learn to create an interface to provide a way for managing tables with TimescaleDB and Python. we’ll build an application in Python to show a list of tables to the user and and offer them the opportunity to delete any of the tables via a click or tap. We … Continued

Shopping Cart with TimescaleDB

Introduction In this instructional article we’ll learn to set up an HTML screen to offer users a way to modify a web-based shopping cart with TimescaleDB using Python. The Python TimescaleDB application we build here will make use of many methods, types, and functions, including: Python List: a variable type for storing the rowset returned … Continued

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

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

Connect to Redis server on ObjectRocket using WSL

Introduction Windows Subsystem for Linux, typically referred to as WSL, is a newer compatibility layer designed to run Linux binary executable files on Windows 10 operating systems and servers. WSL is an optional feature that can be enabled via the Windows Features dialog. WSL allows for running native Linux command-line tools alongside traditional Windows applications. … 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

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.