PostgreSQL 19 connects the dots with standardized graph queries
Baked-in SQL syntax arrives through multi-vendor collaboration, although indexing still needs to catch up
Search fresh public links, source activity, and ready-to-use post angles for Postgresql Compatible.
Fresh curated links around PostgreSQL compatible are collected here so marketers can spot useful updates and turn timely ideas into posts faster.
Recent items include:
Recent curated links from global sources. Generate one free draft from any story, then use SocialBu to schedule and refine your content calendar.
Baked-in SQL syntax arrives through multi-vendor collaboration, although indexing still needs to catch up
PostgreSQL 19 adds SQL/PGQ graph queries, a critical logical replication flaw is patched, and AWS DMS now uses AI agents for SQL Server migrations. Get the full breakdown. The post...
PGW: A PGBACKREST INTERLUDE:(Andreas Scherbaum, Jimmy Angelakos)Andreas Scherbaum and Jimmy Angelakos presented a quantitative analysis of the PostgreSQL CommitFest process using d...
Originally appeared on The Rails Tech Debt Blog.Heroku sent us an email about the database behind ips.fastruby.io, a small app we run for sharing benchmark-ips results. That databa...
SQL Server stored procedures can return multiple result sets from one call, but PostgreSQL cannot. This post presents two PostgreSQL-native alternatives to refcursors, session-scop...
PostgreSQL 19 removes SQL/PGQ, but REPACK CONCURRENTLY, Spinnaker's migration tools, Vacuum monitoring, and AlloyDB Omni orchestrator bring new capabilities for DBAs. The post Post...
PostgreSQL 19 adds native SQL/PGQ graph support, while a critical logical replication flaw (CVE-2026-6471) is patched in all versions. Learn what this means for your database. The...
PostgreSQL 19 is set to ship with native SQL/PGQ support for property graph queries, thanks to a multi-vendor collaboration. Here’s what it means for you and when to expect it. The...
SQL/PGQ gets bounced over unresolved bugs as concurrent REPACK promises fewer midnight calls for DBAs
PostgreSQL news roundup: AWS DuckDB in Aurora, Babelfish FTS gaps, DBtune automation, Nebius managed clusters, Tom Lane architecture, Splunk CVE. The post PostgreSQL Ecosystem Expa...
https://thomasleecopeland.com/2026/08/17/from-sphinx-to-postgres-fts.html
You wanna learn PostgreSQL, and you wanna use a sample database with big real-world data, the same kinds of issues that pop up with real-life data distribution skew, and fun query...
Привет, Хабр. Я хочу рассказать историю, которую вы уже, наверняка, где-то слышали. Только с другой стороны.Пару месяцев назад я сидела на созвоне с техдиром стартапа, который дела...
Компания Oracle против своей воли поспособствовала быстрому развитию системы управления базами данных (СУБД) PostgreSQL. Oracle владеет прямым конкурентом PostgreSQL, СУБД MySQL, и...
PostgreSQL has released updates to address a security flaw that allows an account with the REPLICATION attribute to run arbitrary code as the operating-system user running the data...
Stop relying on slow LIKE queries. Learn how to implement Trigrams and Full Text Search in PostgreSQL for lightning-fast, pro-level results. The post Mastering Advanced Search Tech...
Завершаем цикл статей с обзором изменений 19-й версии. Предыдущие статьи были посвящены первым четырем коммитфестам: 2025-07, 2025-09, 2025-11, 2026-01.А сегодня начнем обзор марто...
Продолжаем обзор мартовского коммитфеста 19-й версии. В третьей статье серии рассмотрим изменения, относящиеся к материалам курсов DBA3 и DBS.Напоминаю план статей о последнем комм...
Migrating full-text search from SQL Server to PostgreSQL can silently change results because the engines handle text, linguistics, and accents differently. This post shows how to r...
Database migrations can pass every check in development and still take production down, and the classic example is adding a NOT NULL column with no default to a table that already...
Продолжаем обзор мартовского коммитфеста 19-й версии. Во второй статье серии рассмотрим изменения, относящиеся к материалам курсов DBA1 и DBA2.Напоминаю план статей о последнем ком...
Когда говорят о DuckDB, обычно вспоминают аналитику: локальные запросы к Parquet, быстрые агрегации, ноутбуки. Но у него есть свойство, к аналитике отношения не имеющее: он умеет с...
Big Red's acquisition of MySQL sent users running toward the open source alternative, says Michael Stonebraker
PostgreSQL является самой распространённой СУБД согласно исследованию StackOverflow. Но самостоятельный хостинг PostgreSQL сопряжён с риском потери данных и неоптимальной настройки...
Use SocialBu to discover ideas, generate post drafts, and schedule them across your social channels.