db

• SQL - Introductory resource on SQL to learn how to store, manipulate, and retrieve data in various databases.
• Working With SQL and Databases in JetBrains IDEs - YouTube - Video tutorial on managing SQL databases within JetBrains IDEs.
• Airbyte | Open-Source Data Integration Platform | ELT tool - Open-source platform for data ingestion and ELT workflows.
• DbGate | Open Source (no)SQL Database Client - Lightweight database client supporting multiple database types for data management visually.
• Goodbye integers. Hello UUIDv7! - Article on benefits of using UUIDv7 over integers for database identifiers.

Bitemporal

• Bitemporal History - Overview of bitemporal data concepts and history tracking.
• Temporal Patterns - Explanation of temporal patterns in data modeling.
• Bitemporal modeling - Wikipedia article on bitemporal data modeling techniques.
• Temporal tables - Guide on using temporal tables in SQL databases.
• Temporale Datenhaltung – Wikipedia - German Wikipedia article on temporal data storage.
• Temporale Datenhaltung in der Praxis mit Java | heise online - Practical article on temporal data handling with Java.
• Bitemporal Data Model: Making it happened in Postgres- Chad Slaughter & Hennrietta Dombrovskaya - YouTube - Presentation on implementing bitemporal data in PostgreSQL.
• Understanding Bitemporal Data - Comprehensive explanation of bitemporal data concepts.
• 8 Gründe, warum man bitemporale Daten benötigt - Eight reasons for using bitemporal data in German.
• BiTemporal data access patterns using MongoDB – Accelerate with PeerIslands - Discussion on bitemporal data patterns with MongoDB.
• Bi-temporale Historisierung – konsilium - German blog on bitemporal historical data.
• Temporal Extensions - PostgreSQL wiki page on temporal extensions support.
• Historisierung von Daten in der Versicherungswirtschaft - German article on data historization in insurance.
• Time travel: two-dimensional time with bitemporal data - Blog on two-dimensional time travel with bitemporal data.
• Understanding Bitemporal Primary Keys - Article explaining temporal primary keys design.
• https://hdombrovskaya.wordpress.com/wp-content/uploads/2016/09/bi_temporal_pg_open_2016.pdf - PDF presentation on bitemporal Postgres implementation.
• https://postgresql.us/events/pgdaychicago2024/sessions/session/1553/slides/130/bitemporal_standard.pdf - Slide deck on bitemporal standards in PostgreSQL.
• (Bi)Temporal Tables, PostgreSQL and SQL Standard | The World of Data - Blog post on bi-temporal tables and SQL standards.

postgresql

• Awesome Postgres | awesome-postgres - Curated list of awesome PostgreSQL tools and resources.
• Postgres in Kubernetes: How to Deploy, Scale, and Manage - Guide for deploying and managing Postgres in Kubernetes environments.
• Just Use Postgres! - Book promoting PostgreSQL usage with practical advice.
• Unexpected downsides of UUID keys in PostgreSQL | CYBERTEC PostgreSQL | Services & Support - Article covering UUID usage issues in Postgres keys.
• PostgreSQL 18 just dropped: 10 powerful new features devs need to know | by | Run.it.Bare | May, 2025 | Medium - Overview of new features in PostgreSQL 18 release.
• An Overview of Distributed PostgreSQL Architectures - Examination of distributed Postgres deployment architectures.
• Recurring Events and PostgreSQL - Handling recurring events data using PostgreSQL.
• Nine ways to shoot yourself in the foot with PostgreSQL - Common pitfalls to avoid when using PostgreSQL.
• How to Deploy PostgreSQL on Kubernetes - Step-by-step tutorial for Postgres deployment in Kubernetes.
• Backfilling Postgres TOAST Columns in Debezium Data Change Events - Technical article on Debezium handling of Postgres TOAST columns.
• How Discord Indexes Trillions of Messages - Insight into Discord's message indexing using Postgres.
• A roadmap to scaling Postgres - Guide outlining strategies for scaling PostgreSQL databases.

Partitioning

• Practical Partitioning with PostgreSQL (in Production!) - Video showcasing effective PostgreSQL partitioning techniques in production.
• Partitioned table statistics - Article discussing statistics collection on partitioned tables in Postgres.
• Partitioning in Postgres and the risk of high partition counts - YouTube - Video explaining partitioning risks related to many partitions.
• When to Consider Postgres Partitioning - Guidance on deciding when to use table partitioning in PostgreSQL.
• Partition an existing table on PostgreSQL | by Rodolphe Quiédeville | Medium - Tutorial on partitioning existing tables.
• They Enabled Postgres Partitioning and their Backend fell apart - YouTube - Cautionary tale on pitfalls of enabling Postgres partitioning.

Tuning

• pgtuned/pgtune.sh at main · esgn/pgtuned - Script to generate optimized PostgreSQL configuration parameters.
• jfcoz/postgresqltuner: Simple script to analyse your PostgreSQL database configuration, and give tuning advice - Tool for PostgreSQL config analysis and tuning recommendations.
• Optimizing Postgres table layout for maximum efficiency - Article on efficient physical layout for Postgres tables.
• How Notion Runs PostgreSQL at Scale on Amazon RDS with pganalyze - Case study of Notion's Postgres scaling with monitoring.
• Tuning your PostgreSQL for High Performance - Guide for tuning Postgres for performance.
• PostgreSQL Performance Tuning Settings - Overview of key PostgreSQL settings for performance tuning.
• nexsol-technologies/pgassistant: PgAssistant is an open-source tool designed to help developers understand and optimize their PostgreSQL database performance. - Open source PostgreSQL performance optimization tool.
• darold/pgcluu: PostgreSQL Cluster performances monitoring and auditing tool - Monitoring and auditing tool for Postgres clusters.
• SQL Performance Explained - Resource for understanding SQL performance tuning.
• How to Reduce Your PostgreSQL Database Size - Tips to reduce storage footprint of Postgres databases.
• The Unexpected Find That Freed 20GB of Unused Index Space - Case study on reclaiming Postgres storage by removing unused indexes.
• Understanding Postgres IOPS: Why They Matter Even When Everything Fits in Cache - Explanation of importance of I/O operations per second in Postgres.
• Postgres performance at any scale | PostgreSQL Tuning - pganalyze - Platform for comprehensive PostgreSQL performance tuning.
• pgBadger :: PostgreSQL Log Analyzer - Tool for analyzing PostgreSQL log files for performance.
• PGTune - calculate configuration for PostgreSQL based on the maximum performance for a given hardware configuration - Web-based PostgreSQL tuning parameter calculator.
• le0pard/pgtune: Pgtune - tuning PostgreSQL config by your hardware - Hardware-aware PostgreSQL tuning tool.
• » Deep dive into postgres stats: pg_stat_bgwriter - Deep analysis of Postgres background writer statistics.

Extensions

• PGXN: PostgreSQL Extension Network - Official network for discovering and distributing Postgres extensions.
• THE DESIGN OF POSTGRES EXTENSION MANAGER “PGXMAN” - Article on a new Postgres extension manager design.
• pgcalendar - Infinite Calendar Extension for PostgreSQL - PostgreSQL extension providing advanced calendar support.
• Using LTree to Represent and Query Hierarchy and Tree Structures - Postgres OnLine Journal - Guide on representing hierarchical data using Postgres LTREE.
• Postgres Ltree Cheatsheet - Syntax and usage cheatsheet for LTREE in Postgres.
• Saving a Tree in Postgres Using LTREE - Example of saving tree-structured data with LTREE.
• Using PostgreSQL ltree type with a Java ORM layer - Genera Codice - Integration of Postgres LTREE with Java ORM tools.
• Saving a Tree in Postgres Using LTREE - DZone Database - Article on tree data handling using LTREE.
• F.9. btree_gist — GiST operator classes with B-tree behavior - Postgres documentation on GiST operator classes.
• pg_bm25: Elastic-Quality Full Text Search Inside Postgres - Extension enabling BM25 text search ranking in Postgres.
• zombodb/zombodb: Making Postgres and Elasticsearch work together like it's 2022 - Integration between Postgres and Elasticsearch for advanced search.

Tips

• Don't Do This - PostgreSQL wiki - Common Postgres anti-patterns to avoid.
• Five Tips For a Healthier Postgres Database in the New Year - Practical advice for maintaining Postgres health.
• How To Use ON CONFLICT CLAUSE in PostgreSQL - Guide on Postgres UPSERT feature via ON CONFLICT.
• Subqueries and performance in PostgreSQL - CYBERTEC - Analysis of subqueries impact on Postgres performance.
• What is SKIP LOCKED for in PostgreSQL 9.5? - 2ndQuadrant | PostgreSQL - Explanation of SKIP LOCKED feature for concurrency.

Tools

• PGSync - Tool for syncing data between Postgres databases.
• PGSlice - PostgreSQL slicing tool for analytics and audits.
• PGHero - Postgres performance monitoring tool.
• Dexter - Postgres schema change tool.
• PGActivity - Real-time Postgres activity monitor.
• supabase/pg_graphql: GraphQL support for PostgreSQL - Postgres extension adding GraphQL capabilities.
• PostgresqlCO.NF: PostgreSQL configuration for humans - PostgreSQL parameter documentation aimed at users.

searchengines

• OpenSearch - YouTube - YouTube channel for OpenSearch project updates.
• Launch highlight: Paginate with Point in Time · OpenSearch - Blog post on OpenSearch pagination improvements.
• Learn-to-Rank with OpenSearch and Metarank · OpenSearch - Introduction to learning-to-rank features in OpenSearch.
• GitHub - elastic/curator: Curator: Tending your Elasticsearch indices - Tool for managing Elasticsearch indices.
• Elasticvue - Elasticsearch gui for the browser - Browser GUI client for Elasticsearch management.
• Elasticsearch Indexing Strategy in Asset Management Platform - Case study on Elasticsearch indexing techniques.
• Highlighting | Elasticsearch Guide [7.15] | Elastic - Documentation on Elasticsearch text highlighting.
• Using must_not and wildcard to search - Elastic Stack / Elasticsearch - Discuss the Elastic Stack - Forum discussion on advanced Elasticsearch search syntax.
• Elastic Search: Highlighting Text That Contains HTML Tags - Hamid Mosalla - Blog on Elasticsearch highlighting for HTML content.
• Elasticsearch Highlights - Guide on text highlights using Elasticsearch.
• Suggesters | Elasticsearch Guide [7.15] | Elastic - Elasticsearch search suggesters documentation.
• Multiplexer token filter | Elasticsearch Guide [7.15] | Elastic - Elasticsearch token filter for multiple analyses.
• Autocomplete with Elasticsearch - Part 1: Prefix Queries - Guide on prefix query autocomplete in Elasticsearch.
• Autocomplete with Elasticsearch - Part 2: Index-Time Search-as-You-Type - Explanation of search-as-you-type features.
• Autocomplete with Elasticsearch - Part 3: Completion Suggester - Completion suggester implementation in Elasticsearch.
• Improving the performance of high-cardinality terms aggregations in Elasticsearch - Performance tuning tips for Elasticsearch aggregations.
• Tune for search speed | Elasticsearch Guide [master] | Elastic - Guide to optimize search speed in Elasticsearch.
• Circuit breaker settings | Elasticsearch Guide [7.15] | Elastic - Documentation on Elasticsearch circuit breaker settings.
• Field data cache settings | Elasticsearch Guide [7.15] | Elastic - Configuring field data cache in Elasticsearch.
• FIELDDATA Data is too large - StackOverflow discussion on Elasticsearch fielddata size errors.
• stopwords-de/stopwords-de.txt at master · stopwords-iso/stopwords-de - German stopwords list for search engines.
• Stopwords and Phrase Queries | Elasticsearch: The Definitive Guide [master] | Elastic - Elasticsearch guide on stopwords handling.
• Zusammengesetzte Worte in Elasticsearch - Forum on handling compound words in Elasticsearch (German).
• GitHub - wikimedia/search-highlighter - Wikimedia's search highlighting library.
• OpenSearch Shard Optimization - Dattell - Blog on shard optimization strategies in OpenSearch.
• quickwit-oss/tantivy: Tantivy is a full-text search engine library inspired by Apache Lucene and written in Rust - Rust-based full-text search engine library inspired by Lucene.