Bookmarks

dev/db

(Bi)Temporal Tables, PostgreSQL and SQL Standard | The World of Data - Blog post on bi-temporal tables and SQL standards.
8 Gründe, warum man bitemporale Daten benötigt - Eight reasons for using bitemporal data in German.
A roadmap to scaling Postgres - Guide outlining strategies for scaling PostgreSQL databases.
Airbyte | Open-Source Data Integration Platform | ELT tool - Open-source platform for data ingestion and ELT workflows.
An Overview of Distributed PostgreSQL Architectures - Examination of distributed Postgres deployment architectures.
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.
Awesome Postgres | awesome-postgres - Curated list of awesome PostgreSQL tools and resources.
Backfilling Postgres TOAST Columns in Debezium Data Change Events - Technical article on Debezium handling of Postgres TOAST columns.
Bi-temporale Historisierung – konsilium - German blog on bitemporal historical data.
BiTemporal data access patterns using MongoDB – Accelerate with PeerIslands - Discussion on bitemporal data patterns with MongoDB.
Bitemporal Data Model: Making it happened in Postgres- Chad Slaughter & Hennrietta Dombrovskaya - YouTube - Presentation on implementing bitemporal data in PostgreSQL.
Bitemporal History - Overview of bitemporal data concepts and history tracking.
Bitemporal modeling - Wikipedia article on bitemporal data modeling techniques.
darold/pgcluu: PostgreSQL Cluster performances monitoring and auditing tool - Monitoring and auditing tool for Postgres clusters.
DbGate | Open Source (no)SQL Database Client - Lightweight database client supporting multiple database types for data management visually.
Dexter - Postgres schema change tool.
Don't Do This - PostgreSQL wiki - Common Postgres anti-patterns to avoid.
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.
Elasticsearch Indexing Strategy in Asset Management Platform - Case study on Elasticsearch indexing techniques.
Elasticvue - Elasticsearch gui for the browser - Browser GUI client for Elasticsearch management.
F.9. btree_gist — GiST operator classes with B-tree behavior - Postgres documentation on GiST operator classes.
FIELDDATA Data is too large - StackOverflow discussion on Elasticsearch fielddata size errors.
Five Tips For a Healthier Postgres Database in the New Year - Practical advice for maintaining Postgres health.
GitHub - elastic/curator: Curator: Tending your Elasticsearch indices - Tool for managing Elasticsearch indices.
GitHub - wikimedia/search-highlighter - Wikimedia's search highlighting library.
Goodbye integers. Hello UUIDv7! - Article on benefits of using UUIDv7 over integers for database identifiers.
Historisierung von Daten in der Versicherungswirtschaft - German article on data historization in insurance.
How Discord Indexes Trillions of Messages - Insight into Discord's message indexing using Postgres.
How Notion Runs PostgreSQL at Scale on Amazon RDS with pganalyze - Case study of Notion's Postgres scaling with monitoring.
How to Deploy PostgreSQL on Kubernetes - Step-by-step tutorial for Postgres deployment in Kubernetes.
How to Reduce Your PostgreSQL Database Size - Tips to reduce storage footprint of Postgres databases.
How To Use ON CONFLICT CLAUSE in PostgreSQL - Guide on Postgres UPSERT feature via ON CONFLICT.
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.
Improving the performance of high-cardinality terms aggregations in Elasticsearch - Performance tuning tips for Elasticsearch aggregations.
jfcoz/postgresqltuner: Simple script to analyse your PostgreSQL database configuration, and give tuning advice - Tool for PostgreSQL config analysis and tuning recommendations.
Just Use Postgres! - Book promoting PostgreSQL usage with practical advice.
Launch highlight: Paginate with Point in Time · OpenSearch - Blog post on OpenSearch pagination improvements.
le0pard/pgtune: Pgtune - tuning PostgreSQL config by your hardware - Hardware-aware PostgreSQL tuning tool.
Learn-to-Rank with OpenSearch and Metarank · OpenSearch - Introduction to learning-to-rank features in OpenSearch.
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.
Nine ways to shoot yourself in the foot with PostgreSQL - Common pitfalls to avoid when using PostgreSQL.
OpenSearch - YouTube - YouTube channel for OpenSearch project updates.
OpenSearch Shard Optimization - Dattell - Blog on shard optimization strategies in OpenSearch.
Optimizing Postgres table layout for maximum efficiency - Article on efficient physical layout for Postgres tables.
Partition an existing table on PostgreSQL | by Rodolphe Quiédeville | Medium - Tutorial on partitioning existing tables.
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.
pg_bm25: Elastic-Quality Full Text Search Inside Postgres - Extension enabling BM25 text search ranking in Postgres.
PGActivity - Real-time Postgres activity monitor.
pgBadger :: PostgreSQL Log Analyzer - Tool for analyzing PostgreSQL log files for performance.
pgcalendar - Infinite Calendar Extension for PostgreSQL - PostgreSQL extension providing advanced calendar support.
PGHero - Postgres performance monitoring tool.
PGSlice - PostgreSQL slicing tool for analytics and audits.
PGSync - Tool for syncing data between Postgres databases.
PGTune - calculate configuration for PostgreSQL based on the maximum performance for a given hardware configuration - Web-based PostgreSQL tuning parameter calculator.
pgtuned/pgtune.sh at main · esgn/pgtuned - Script to generate optimized PostgreSQL configuration parameters.
PGXN: PostgreSQL Extension Network - Official network for discovering and distributing Postgres extensions.
Postgres in Kubernetes: How to Deploy, Scale, and Manage - Guide for deploying and managing Postgres in Kubernetes environments.
Postgres Ltree Cheatsheet - Syntax and usage cheatsheet for LTREE in Postgres.
Postgres performance at any scale | PostgreSQL Tuning - pganalyze - Platform for comprehensive PostgreSQL performance tuning.
PostgreSQL 18 just dropped: 10 powerful new features devs need to know | by <devtips> | Run.it.Bare | May, 2025 | Medium - Overview of new features in PostgreSQL 18 release.
PostgreSQL Performance Tuning Settings - Overview of key PostgreSQL settings for performance tuning.
PostgresqlCO.NF: PostgreSQL configuration for humans - PostgreSQL parameter documentation aimed at users.
Practical Partitioning with PostgreSQL (in Production!) - Video showcasing effective PostgreSQL partitioning techniques in production.
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.
Recurring Events and PostgreSQL - Handling recurring events data using PostgreSQL.
Saving a Tree in Postgres Using LTREE - Example of saving tree-structured data with LTREE.
Saving a Tree in Postgres Using LTREE - DZone Database - Article on tree data handling using LTREE.
SQL - Introductory resource on SQL to learn how to store, manipulate, and retrieve data in various databases.
SQL Performance Explained - Resource for understanding SQL performance tuning.
stopwords-de/stopwords-de.txt at master · stopwords-iso/stopwords-de - German stopwords list for search engines.
Subqueries and performance in PostgreSQL - CYBERTEC - Analysis of subqueries impact on Postgres performance.
supabase/pg_graphql: GraphQL support for PostgreSQL - Postgres extension adding GraphQL capabilities.
Temporal Extensions - PostgreSQL wiki page on temporal extensions support.
Temporal Patterns - Explanation of temporal patterns in data modeling.
Temporal tables - Guide on using temporal tables in SQL databases.
Temporale Datenhaltung in der Praxis mit Java | heise online - Practical article on temporal data handling with Java.
Temporale Datenhaltung – Wikipedia - German Wikipedia article on temporal data storage.
THE DESIGN OF POSTGRES EXTENSION MANAGER “PGXMAN” - Article on a new Postgres extension manager design.
The Unexpected Find That Freed 20GB of Unused Index Space - Case study on reclaiming Postgres storage by removing unused indexes.
They Enabled Postgres Partitioning and their Backend fell apart - YouTube - Cautionary tale on pitfalls of enabling Postgres partitioning.
Time travel: two-dimensional time with bitemporal data - Blog on two-dimensional time travel with bitemporal data.
Tuning your PostgreSQL for High Performance - Guide for tuning Postgres for performance.
Understanding Bitemporal Data - Comprehensive explanation of bitemporal data concepts.
Understanding Bitemporal Primary Keys - Article explaining temporal primary keys design.
Understanding Postgres IOPS: Why They Matter Even When Everything Fits in Cache - Explanation of importance of I/O operations per second in Postgres.
Unexpected downsides of UUID keys in PostgreSQL | CYBERTEC PostgreSQL | Services & Support - Article covering UUID usage issues in Postgres keys.
Using LTree to Represent and Query Hierarchy and Tree Structures - Postgres OnLine Journal - Guide on representing hierarchical data using Postgres LTREE.
Using must_not and wildcard to search - Elastic Stack / Elasticsearch - Discuss the Elastic Stack - Forum discussion on advanced Elasticsearch search syntax.
Using PostgreSQL ltree type with a Java ORM layer - Genera Codice - Integration of Postgres LTREE with Java ORM tools.
What is SKIP LOCKED for in PostgreSQL 9.5? - 2ndQuadrant | PostgreSQL - Explanation of SKIP LOCKED feature for concurrency.
When to Consider Postgres Partitioning - Guidance on deciding when to use table partitioning in PostgreSQL.
Working With SQL and Databases in JetBrains IDEs - YouTube - Video tutorial on managing SQL databases within JetBrains IDEs.
zombodb/zombodb: Making Postgres and Elasticsearch work together like it's 2022 - Integration between Postgres and Elasticsearch for advanced search.
Zusammengesetzte Worte in Elasticsearch - Forum on handling compound words in Elasticsearch (German).
» Deep dive into postgres stats: pg_stat_bgwriter - Deep analysis of Postgres background writer statistics.