How about a simple image upload app built with Django 3.1 and backed by PostgreSQL 13, that takes advantage of the PL/Python procedural language for processing?
In this post I'll walk through the steps to connect a Django app to PostgreSQL in the cloud via Crunchy Bridge.
What are some PostgreSQL monitoring stats that are typically used to monitor the health of your databases?
What are some of the key stats to look at to ensure your PostgreSQL cluster is healthy? How can you use this stats to diagnose the problem?
Kat explores a few interesting things she encountered in PL/Python data type mapping, especially when adding NumPy and SciPy to the picture.
In this post, we'll try running NumPy in a simple user-defined function which also takes advantage of PL/Python database access functions. The function will show a working example of how to easily convert a data table in Postgres to a NumPy array.
If you're getting started with learning about indexes, here are a few things that hopefully will help round out your understanding.
In this post, we'll take a quick look at how to get started with using PL/Python to write Postgres functions.
When the keyword LATERAL is added to your join the output will now apply the right hand part of the join to every record in the left part of the join.
A BRIN is a Block Range Index. A block is Postgres’ base unit of storage and is by default 8kB of data.
In my first post, I talk about how Django's built-in authentication system can do some of the heavy lifting for your registration setup. In this post, I'll walk you through how we tied our data models and authentication together by extending Django's User model.
Learn how to add a user registration system using Django's built in authentication.
This post is a refresher on INSERT and also introduces the RETURNING and ON CONFLICT clauses if you haven't used them yet, commonly known as upsert.
Learn how to use composite primary keys in a PostgreSQL many-to-many relationship table while building a Django application.
An overview of composite types within Postgres and when to use them.
In Postgres, we have several data types that may not be as well known even for experienced developers. Take a quick look at arrays, enum, and range types.
Kat Batuigas dives into some interesting aspects of PostgreSQL base data types.
Learn how to document all of the tables in your PostgreSQL database without having to type all the commands that needed.
A PostgreSQL block range index, or BRIN, can help you to significantly reduce the amount of disk space required for high performance queries on big data.
WITH queries, aka common table expressions, aka CTEs, are a very powerful but often misused feature in PostgreSQL. The upcoming PostgreSQL 12 introduces the ability to inline WITH queries with can provide a huge performance optimization to how developers use CTEs.