Menu
View
Theme
Text size
The paper in your inbox every morning
Straight from the source · Guides by the people who build it

The Tech Gazette

Learn: Databases

Vol. I No. 26 Saturday, October 17, 2026 Closing 12:53 PM UTC · next edition 10:00 AM UTC

Postgres, analytics and caches.

5 steps to the basics

Start here

  1. The PostgreSQL tutorialPostgreSQL · Tables, queries and joins, from the start.
  2. Using EXPLAINPostgreSQL · Reading a query plan to see why it's slow.
  3. The query plannerSQLite · How indexes really speed up a query.
  4. Get started with RedisRedis · Caching and fast data, by example.
  5. DuckDB documentationDuckDB · Analytics on your laptop, straight from files.

New for beginners

  1. Neo4jSep 30, 2026
    How to Set Up and Redeem Your Neo4j Startup Program Credits
  2. PulumiSep 25, 2026
    Change your components, keep your infrastructure

Go deeper

  1. AWS DatabasesOct 12, 2026
    Understanding the differences between PgBouncer and Amazon RDS Proxy for PostgreSQL connection pooling
  2. AWS DatabasesOct 12, 2026
    Migrate CLR code to AWS Lambda when upgrading Amazon RDS for SQL Server to 2025
  3. CloudflareOct 12, 2026
    Filter, reshape, and redact logs before export with Transformers
  4. RenderOct 8, 2026
    Data needs its DevOps moment
  5. AWS DatabasesOct 7, 2026
    Migrate SSIS packages to Aurora PostgreSQL – Part 2
  6. DuckDBOct 7, 2026
    A DuckDB Database with No Data in It
  7. Azure SQLOct 6, 2026
    PostgreSQL to SQL Field Notes: Connections
  8. AWS Big DataOct 6, 2026
    Cost-effective ETL with DuckDB and Amazon S3 Tables on AWS Glue
  9. DuckDBOct 5, 2026
    Importing Data using Java Table Functions
  10. AWS Architecture BlogOct 2, 2026
    Deploy Oracle Database step by step on Amazon EVS with FSx for ONTAP
  11. Azure Cosmos DBOct 1, 2026
    Genspark protects live agent sessions with Azure Cosmos DB Global Secondary Indexes
  12. DatabricksSep 30, 2026
    A practical guide to cost optimization with Lakebase Postgres
  13. AWS DatabasesSep 30, 2026
    Migrate Db2 z/OS to Amazon Aurora PostgreSQL using AWS DMS and gateway server
  14. AWS Big DataSep 29, 2026
    Aurora PostgreSQL zero-ETL integration with Amazon SageMaker
  15. QdrantSep 29, 2026
    Managed Cloud Prometheus Monitoring
  16. DuckDBSep 29, 2026
    Jev and DuckDB: Plain-English Conditions in SQL
  17. PingCAP (TiDB)Sep 26, 2026
    The FinTech Scalability Crisis: How Distributed SQL Unlocks Innovation with Zero Downtime Operations
  18. PineconeSep 25, 2026
    How to add hybrid search to a Postgres app with Pinecone in 2026
  19. AWS DatabasesSep 25, 2026
    How to stream PostgreSQL changes to Amazon S3 with AWS Fargate
  20. DuckDBSep 25, 2026
    DuckDB and Hugging Face: Querying Datasets Directly
  21. DatabricksSep 24, 2026
    Running open-Jev in SQL on Databricks
  22. ValkeySep 24, 2026
    Browsing a Valkey keyspace safely: SCAN, INFO, and a read-only ACL user
  23. PrismaSep 24, 2026
    Hosting and Postgres after your first 100 users
  24. PrismaSep 24, 2026
    Neon vs Prisma Postgres: app and database in one place
  25. PlanetScaleSep 22, 2026
    Anatomy of a (Postgres) search engine
  26. PrismaSep 22, 2026
    Where to host a TypeScript frontend, API and Postgres
  27. AWS DatabasesSep 21, 2026
    Migrate SQL Server multi-result-set procedures to PostgreSQL
  28. OpenTelemetrySep 18, 2026
    Dual-exporting .NET metrics with OTLP and Prometheus
  29. PlanetScaleSep 18, 2026
    The architecture of Neki
  30. DuckDBSep 18, 2026
    Persistent Databases in the Browser with DuckDB-Wasm and OPFS
  31. DatabricksSep 17, 2026
    Database for AI Agents: 5 Evaluation Criteria
  32. TigerBeetleSep 17, 2026
    High-Throughput OLTP in Three Simple Steps

Advanced

  1. CloudflareOct 13, 2026
    Under the hood, off the hot path: How D1 scales to millions of databases
  2. ClickHouseOct 13, 2026
    Chasing that 32 ms tail latency in ClickHouse
  3. PlanetScaleOct 12, 2026
    What gets TOASTed in Postgres
  4. ClickHouseOct 8, 2026
    How we migrated Clera’s 500 GB production database to ClickHouse Managed Postgres overnight
  5. MariaDB FoundationOct 8, 2026
    Building a Public Performance Change Detection Library for MariaDB
  6. Microsoft for Java DevelopersOct 8, 2026
    Faster by Design: Performance engineering in the Microsoft JDBC Driver for SQL Server
  7. Airbnb TechOct 6, 2026
    Beyond synthetic testing: Capturing and replaying real database workloads at Airbnb
  8. AWS DatabasesOct 6, 2026
    A decision framework for Amazon Neptune availability
  9. PerconaOct 6, 2026
    What Is Running on My MongoDB Right Now? Real-Time Analytics in PMM
  10. MariaDB FoundationOct 5, 2026
    Migrating a 500 GB Production MariaDB Database from Amazon RDS to EC2, With a Rollback Path
  11. Jane Street Tech BlogOct 5, 2026
    Scaling and benchmarking a critical message bus using a new indexing strategy
  12. AWS Architecture BlogOct 2, 2026
    Architect highly available Oracle Database on Amazon EVS and FSx for ONTAP
  13. ClickHouseOct 2, 2026
    What is direct I/O, and why does ClickHouse Managed Postgres use it for backups?
  14. PingCAP (TiDB)Oct 1, 2026
    The Database Is the Product: What Breaks When Memory Devices Scale
  15. AWS DatabasesOct 1, 2026
    Working with foreign key constraints in Aurora DSQL
  16. ClickHouseOct 1, 2026
    How LinkedIn extended ClickHouse from distributed tracing to metric discovery and analytics
  17. PlanetScaleOct 1, 2026
    Designing Neki for performance
  18. AWS DatabasesSep 30, 2026
    Resolving PostgreSQL replication lag with heartbeat tables in change data capture scenarios
  19. ClickHouseSep 28, 2026
    Can your Postgres survive a bad query?
  20. PerconaSep 28, 2026
    PgQ and PgQue: Workflow Engines you might need in PostgreSQL
  21. NeonSep 28, 2026
    Inside branch-based restores in Lakebase Postgres
  22. PlanetScaleSep 28, 2026
    Handling hot shards
  23. DremioSep 25, 2026
    Apache Iceberg Views: Portable View Metadata Across SQL Engines
  24. DremioSep 25, 2026
    MERGE INTO Patterns for Apache Iceberg: Upserts and SCD Type 2
  25. ModalSep 24, 2026
    Quail: Speeding up AI-SQL by jointly optimizing query planner and inference engine
  26. PlanetScaleSep 23, 2026
    TIN Postgres search is faster, better, and cheaper
  27. RedisSep 23, 2026
    Stay up when a region goes down: Highly available Redis for Python apps
  28. ClickHouseSep 21, 2026
    Postgres on NVMe: performance and the convergence of transactions and analytics
  29. PlanetScaleSep 21, 2026
    Blocking cutovers to save replication slots
  30. AWS DevOpsSep 4, 2026
    Investigate DMS migration issues with AWS DevOps Agent
  31. ValkeySep 1, 2026
    Analyzing Atomic Slot Migration ACL requirements

Words to know

New research

  1. PremiseSQL: Evaluating Premise Critique and Abstention in Text-to-SQL Systems

More in Systems and databases →