Faster PostgreSQL To BigQuery Transfers
A technical guide on using ClickHouse to export PostgreSQL data to Parquet format for faster loading into Google BigQuery.
A technical guide on using ClickHouse to export PostgreSQL data to Parquet format for faster loading into Google BigQuery.
Investigates unexpected WAL growth and disk space consumption in an idle Postgres database due to an inactive logical replication slot.
Investigates unexpected WAL growth in an idle Postgres database due to an inactive replication slot, with analysis and solution.
A step-by-step tutorial on integrating Prisma ORM with a NestJS backend, including database setup, CRUD operations, and testing.
Explains how to use the SQL LATERAL keyword to create local column variables and simplify complex queries, improving readability.
Explores a powerful jOOQ feature: using implicit JOINs within explicit JOIN ON clauses for complex PostgreSQL metadata queries.
A guide to creating ASCII bar charts directly in PostgreSQL using SQL queries, eliminating the need for external visualization tools.
Explains how to filter a SQL query's nested collection (ARRAY/MULTISET) by a specific value, using PostgreSQL and jOOQ examples.
A technical guide on extracting Monaco's road network from OpenStreetMap, importing it into PostgreSQL/PostGIS, and rendering it with a tile server.
A tutorial on building a distributed PostgreSQL proof-of-concept using external libraries for SQL parsing, wire protocol, Raft consensus, and storage.
Explores efficient database strategies for fetching large view counts on social platforms, avoiding costly SELECT COUNT(*) operations.
A tutorial on building a REST API using Express.js and PostgreSQL, covering database integration and CRUD operations.
A tutorial on connecting a PostgreSQL database to an Express.js application using the Sequelize ORM.
Explains PostgreSQL wire protocol compatibility and how new databases reuse it for client compatibility, independent of query language.
A guide to creating and using PostgreSQL triggers for automating data processing tasks, covering types, functions, and examples.
Explores hidden PostgreSQL features like upsert row counts, column grants, and pivot tables to improve database workflows.
Building a Forth-like language interpreter from scratch using PL/pgSQL in PostgreSQL, demonstrating stack-oriented programming implementation.
A tutorial exploring PL/pgSQL fundamentals like strings, arrays, recursion, and building a simple JSON parser to learn the language.
A technical guide on building high-performance PostgreSQL extensions using the Rust programming language and the pgx framework.
A tutorial on building and deploying a GraphQL API using Apollo Server, Prisma, TypeScript, and Heroku with a Postgres database.