PostgreSQL®

Run a query against a PostgresSQL® database to inspect the data inside its tables using the command line, a graphical interface, and a language-specific package

Leveraging TensorFlow, PostgreSQL®, PGVector, and Next.js for vector search with this step-by-step video guide.

Learn the theory and the details of how to speed up PostgreSQL® pgvector queries using indexes IVFFlat, HNSW and traditional indexes

An SQL optimization guide for developers. With best practices, warnings, and pro tips to speed up your SQL query optimization.

GraphQL is a great technology for working with complex data models. Learn how to query an Aiven for PostgreSQL® database with GraphQL using Hasura

Follow along to implement the outbox pattern in PostgreSQL® and create a change data capture workflow that doesn't create duplicate data!

Deploy an Aiven for PostgreSQL® service and integrate it as a data source with Aiven for ClickHouse® using Terraform. A part of Aiven's Terraform Cookbook.

Use Debezium as a source connector to integrate PostgreSQL® and Apache Kafka® and use Terraform to deploy. A part of Aiven's Terraform Cookbook.

Use Aiven for Grafana® to visualize metrics for Aiven for PostgreSQL® or another PostgreSQL® service. A part of Aiven's Terraform Cookbook.

Create a read-only replica of a PostgreSQL® service and deploy it to Aiven for PostgreSQL® using Terraform. A part of Aiven's Terraform Cookbook.

Set up a Aiven for PostgreSQL® database with configurations defined in Terraform. A part of Aiven's Terraform Cookbook.

Deploy PostgreSQL® services to multiple clouds and regions using Terraform. A part of the Aiven Terraform Cookbook.

Find out how to deploy an example Netlify app that uses Next.js, Aiven for PostgreSQL® and Aiven for Caching

Vector embeddings are key to ML, and here we describe how to use OpenCV, OpenAI CLIP and pgvector to generate vectors and use them to perform image recognition on a corpus of photos.

Caching is used to speed up cloud applications, particularly for database reads. Read on to learn more, and find out how to build caching with Valkey™ into a simple PostgreSQL® web app.

Learn how to validate your data as it goes into your databases to improve data quality

A cheatsheet for the PostgreSQL® JSONB functions, providing a set of consistent examples of all the most common JSONB (and JSON) functions and operators.

Choosing the name of your new child is really serious, so as a data professional you will naturally want to reach for PostgreSQL®. Find out more below.

There's more than one way to use Aiven. Read on to learn how to use the Aiven command line tool to do common tasks.

Django is a fully-featured high-level Python web framework. Read on to see how to get it to store its data in an Aiven for PostgreSQL® database.

Static credentials are a potential security risk. Learn how to setup dynamic credentials for your PostgreSQL® database with Hashicorp Vault.

Find out how to use Apache Kafka® to migrate across database technologies while keeping the target continually in sync with the source.

Using Laravel? Read about our new way to easily reconfigure your Aiven database connection: connect to any Aiven database and power off any unused ones.

The knapsack problem: how to fit all the items you're most likely to need on holiday? Find out how to use the world's best OS database to help you pack.

Find out how to use Apache Kafka® Connect to update an old app-to-db design to use up-to-date tech tools without disrupting the original solution.

Applications and databases go together like milk and cookies; on the menu today, a PostgreSQL® cookie with a splash of refreshing Go milk. Bon appetit!

Improve PostgreSQL® performance by setting up a multiregion service: isolate read-intensive workloads to replicas. Trevor explains how, using Aiven and Pulumi.