InfoQ

PostgreSQL advances in the JSON datastore landscape

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Dany Lepage discusses the architectural ...
InfoWorld

PostgreSQL 16 advances query parallelism

Next major release of the major open source relational database, now in beta, brings performance improvements to query execution and to logical replication. PostgreSQL 16, the next major update of the ...
InfoWorld

JSONB in PostgreSQL today and tomorrow

PostgreSQL was the first relational DBMS to introduce JSON support, and its JSONB index search capability is unique. More is on the way. We know that data drives innovation and powers better customer ...
GitHub

n-e/pg-typesafe

pg-typesafe can only type queries where the SQL query is a constant, as dynamic queries cannot be analyzed. You should however, when possible, do so, as it avoids SQL injections and is faster. If your ...
GitHub

In this course, master PostgreSQL through hands-on labs covering relationships, advanced data types, indexing, transactions, views, permissions, queries, triggers, backups ...

01 🧩 🆓 PostgreSQL Relationships and Joins Beginner Start Lab 02 🧩 🆓 PostgreSQL Advanced Data Types Beginner Start Lab 03 🧩 🆓 PostgreSQL Index Optimization Beginner Start Lab 04 🧩 🆓 PostgreSQL ...