Functions for CockroachDB

Introduction We will learn to use Functions for CockroachDB Applications from Python to increase efficiency, modularity, and ease of maintenance of your database or web-database application. This is how: We will learn the ins and outs of how to create and use Python functions for web database applications that have a CockroachDB database by focusing … Continued

Python Functions for Postgres Apps

Introduction We will learn to use Python Functions for Postgres Apps to increase efficiency, modularity, and ease of maintenance. This is how: How? We will learn the ins and outs of how to create and use Python functions for web database applications that have a PostgreSQL database by looking at syntax, followed by real world … Continued

Use of ASCII and CHR Functions in Postgres SQL

Introduction In this article, we will study the ASCII and CHR functions in Postgres SQL from three perspectives, including: What? What is the overview and syntax of the ASCII() and CHR() functions? Why? In what circumstances do we use the ASCII and CHR functions in our PostgreSQL queries? How? How do we use the ASCII … Continued

Postgres Substring and Position Functions in SQL

Introduction In this article, we will learn to use the Postgres Substring and Position functions SQL when manipulating strings to isolate words in multi-word strings, including: What? What do the SUBSTRING and POSITION functions do? How? How do we use these functions in our SQL execution? Why? When do we need these functions? A real … 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.