Vivek Varma in PostgreSQL How to Build an AI-Powered Semantic Search in PostgreSQL with pgvector Learn how to build a sleek, AI-powered semantic search engine that lives inside your existing database. We’ll walk through how... 15 December 2025 12 min read 11
Lukas Vileikis in Databases Making AI Talk to Your Database: AI-Powered Database Queries Made Simple Learn how AI-driven tools bridge the gap between human language and databases, making data access faster, easier, and more intuitive.… 04 December 2025 9 min read 32
Aisha Bukar in Databases MySQL vs PostgreSQL: JSON Data Types MySQL and PostgreSQL both support JSON, but they handle it in very different ways. This article compares their JSON data... 02 December 2025 22 min read 21
Lee Asher in Databases 5 Strategies to Refactor SQL Code Struggling with messy SQL queries? Discover 5 smart refactoring strategies to clean up your code, boost performance, and simplify maintenance.… 12 November 2025 16 min read 53
Mercy Bassey in PostgreSQL Secure PostgreSQL in Docker: SSL, Certificates & Config Best Practices Learn how to run PostgreSQL in Docker with production-grade SSL encryption, certificate-based authentication, and custom configuration files - perfect for... 13 August 2025 10 min read
Robert Sheldon in PostgreSQL How to Use the psql Command-Line Tool with Azure Database for PostgreSQL Flexible Server Learn how to install and use the psql command-line tool to connect to and manage Azure Database for PostgreSQL Flexible... 04 August 2025 20 min read
Robert Sheldon in PostgreSQL How to use pgAdmin with Azure Database for PostgreSQL flexible server Learn how to connect and manage Azure PostgreSQL Flexible Server using pgAdmin, a powerful GUI tool for PostgreSQL.… 23 July 2025 17 min read
Robert Sheldon in PostgreSQL Getting started with Azure Database for PostgreSQL Flexible Server Along with its many other cloud services, Microsoft now offers Azure Database for PostgreSQL Flexible Server, a database-as-a-service platform based... 18 June 2025 19 min read
Jagdish Mohite in PostgreSQL Securing PostgreSQL Against Injection, Misconfiguration, and Privilege Escalation PostgreSQL is a robust and trusted database platform, but it’s not invincible. The PostgreSQL Global Development Group “takes security seriously,”... 06 June 2025 22 min read 1
Aisha Bukar in MySQL MySQL vs. PostgreSQL: Date and Time Data Types Date and time data types are important because they help track and manage time-based information in databases. This includes things... 03 June 2025 21 min read 1
Louis Davidson in Books Introduction to PostgreSQL for the Data Professional Learning something new has elements of bliss and terror. We all know the bliss of learning something new. The first... 13 May 2025 2 min read 1
Boris Novikov in PostgreSQL A Method for Managing Hierarchies in PostgreSQL The Postgres database management system was originally designed as object-relational. We remind why PostgreSQL is an object-relational rather than just... 17 April 2025 22 min read 1
Grant Fritchey in PostgreSQL Multi-Version Concurrency Control (MVCC) in PostgreSQL: Learning PostgreSQL with Grant It’s a tale as old as time. You want to read data. Your mate wants to write data. You’re stepping... 02 April 2025 15 min read 21
Lee Asher in PostgreSQL The Wide World of GiST Indexes In Parts I (Solving the Overlap Query Problem in PostgreSQL) and II (Overlapping Ranges in Subsets in PostgreSQL) of... 25 March 2025 15 min read 11
Aisha Bukar in MySQL MySQL vs PostgreSQL – String Datatypes A very common task in creating a database is to store string data. For example, words, paragraph(s) or even documents.... 20 March 2025 22 min read 2
Aisha Bukar in MySQL MySQL vs. PostgreSQL: Character Sets and Collations When working with strings in a database system, you need to ensure that the data is stored, sorted, and compared... 17 March 2025 18 min read
Lee Asher in PostgreSQL Overlapping Ranges in Subsets in PostgreSQL In Part I of this series, we explored overlap queries and the problems that accompany them, along with ways to... 29 November 2024 10 min read 22
Aisha Bukar in Databases MySQL vs PostgreSQL: Numeric Datatype Comparison When you think of how to store data in a database, you think of data types. A data type represents... 15 November 2024 18 min read 2
Boris Novikov in PostgreSQL Making Temporal Databases Work. Part 3: Saving Data The temporal database is a database that can keep information on time when the facts represented in the database were,... 11 September 2024 19 min read 1
Grant Fritchey in PostgreSQL PostgreSQL Backups to Support Point In Time Recovery: Learning PostgreSQL with Grant The focus of your backup strategy should not be backups. Instead, you should be focused on restoring databases, because, after... 07 September 2024 12 min read 111
