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.