Create a Table in CockroachDB

Introduction CockroachDB has a built-in SQL interface client that uses much of the same syntax and format as many SQL-based relational database systems, including PostgreSQL, MariaDB and MySQL. The CockroachDB interface is designed to execute SQL statements directly from the command line or an interactive shell. This tutorial will provide an overview of the SQL … Continued

RTrim Function in Postgres SQL

Introduction In this article we use the RTrim function in Postgres SQL to attain various text-related results, including: What? What is the syntax of the RTRIM function and what does it do? How do we use the RTrim() function in our PostgreSQL queries and what parameters does rtrim() use? Why? Why and when do we … Continued

Normalize Postgres Database with Foreign Keys

Introduction In this article we will learn to normalize a Postgres database with foreign keys (one-to-many relationships). Before relational databases were developed, we stored data much like you see in spreadsheets, where you typically have duplicate data like customer names for example. Imagine a table called “orders” that has a row for every order. If … Continued

The Quote_Literal Function in Postgres SQL

Introduction In this article, we will study the Quote_Literal function in Postgres SQL, including the following perspectives: What? What is the general idea and syntax of the QUOTE_LITERAL() function? Why? In what circumstances do we use the QUOTE_LITERAL function in our PostgreSQL queries? How? How do we use the QUOTE_LITERAL function in our SQL? Similar … Continued

Python Request and Postgres SQL

Introduction In this article we learn how to use Python Request and Postgres SQL to get form data from web pages and insert that data into a database. Here’s how we’ll do it: What? What is the request function and it’s syntax? How? We’ll set up our Python environment to use Request via Flask, use … Continued

Python Templates with Postgres SQL

Introduction In this article we learn how to use Python Templates with Postgres SQL to create web pages and send data to be displayed in those web pages via use of the render_template function. Here’s how we’ll do it: What? What is the syntax of the render_template function? How? How do we build the HTML … Continued

Repeat Function in Postgres SQL

Introduction In this tutorial to use the Repeat function to achieve various text- and integer- related tasks in Postgres SQL, including: What? What’s the syntax of the REPEAT function and what does the function do? How do we use the Repeat() function in our PostgreSQL queries? What parameters does it use? Why? When do we … Continued

Reverse Function in Postgres SQL

Introduction In this tutorial, we will learn to use the Reverse function in Postgres SQL to manipulate strings, to isolate words in multi-word text. We’ll also go over: What? What does the REVERSE function do and how do we use this function in our SQL execution? Why? When do we need the reverse() function? A … Continued

Use of Arrays in Postgres SQL

Introduction In this tutorial, we will learn how to use Arrays in Postgres SQL. We’ll explore the array data type from more than one perspective, including: What? What is the description of and syntax for using the Array data type? Why? In what situations and how do we use Arrays in our PostgreSQL queries? Additional … Continued

Use of Floor Function in Postgres SQL

Introduction In this tutorial, we learn to use the Floor function in our Postgres SQL queries. We’ll begin easy and then add some complexity in order to best understand the scope and use of this function. Here we will explore: What? From the highest level, what does the FLOOR function do? Why? What are a … 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.