@opensource_db profile picture
OpenSource-DB.com @opensource_db

Software company

Joined September 2021
  • Tweets 130
  • Following 0
  • Followers 6
88 Photos and videos
Celebrate the Grand Finale of #PG18Hacktober !! We're excited to announce the culmination of our 31-day journey exploring PostgreSQL 18's innovative features! shorturl.at/81nmP 31 days. 31 blogs. #PG18Hacktober. #PG18 #OpenSourceDB
3
41
Its Day30 of PG18Hacktober !! PG18 brings significant improvements to its system catalogs and statistics views, expanding monitoring capabilities and providing DBAs & Devs with more granular insights into operations. shorturl.at/PHq5U #PG18Hacktober #PG18 #OpenSourceDB

PG18 Hacktober: 31 Days of New Features : Catalog Views Got Smarter - OpenSourceDB

Welcome to the Day30 of PG18Hacktober !! PostgreSQL 18 brings significant improvements to its system catalogs and statistics views, expanding […]

opensource-db.com
3
22
Welcome to the final third of #PG18Hacktober Day29 is live: pg_unicode_fast is a new built-in collation introduced in PostgreSQL 18, available exclusively for UTF-8 encoded databases. opensource-db.com/pg18-hackt… 31 days.31 blogs.#PG18Hacktober. #PG18 #OpenSourceDB

PG18 Hacktober: 31 Days of New Features : Internationalization: pg_unicode_fast Collation -...

Welcome back to the Day29 of the PG18Hacktober !! pg_unicode_fast is a new built-in collation introduced in PostgreSQL 18, available exclusively […]

opensource-db.com
2
28
Welcome to the #PG18Hacktober Day28 is live: In PostgreSQL 18, the LIKE operator becomes more powerful and more compliant with the SQL standard, it now supports use with nondeterministic collations. opensource-db.com/pg18-hackt… 31 days.31 blogs.#PG18Hacktober. #PG18 #OpenSourceDB

PG18 Hacktober: 31 Days of New Features : Internationalization LIKE comparisons - OpenSourceDB

In PostgreSQL 18, the LIKE operator becomes more powerful and more compliant with the SQL standard, it now supports use […]

opensource-db.com
3
21
Welcome to the #PG18Hacktober Among the many new features, one quiet and small feature is making its debut, promising to enable developers and DBAs approach case-insensitive string matching: the casefold() function. opensource-db.com/pg18-hackt… 31 days.31 blogs. #PG18 #OpenSourceDB

PG18 Hacktober: 31 Days of New Features : casefold() function - OpenSourceDB

Welcome to the 27th blog post of PG18 Hacktober! Among the many new features, one quiet and small feature is making […]

opensource-db.com
1
8
Meet pg_overexplain, a brand-new #PostgreSQL18 extension that lets you peek behind the curtain to see what the planner actually executes — not just what your SQL looks like. Read more : opensource-db.com/pg18-hackt… #OpenSourceDB #PG18Hacktober

PG18 Hacktober: 31 Days of New Features : pg_overexplain - See the Real Plans - OpenSourceDB

Welcome to Day 26 of the PG18 Hacktober series! Have you had this discussion with Devs? I wrote a clean […]

opensource-db.com
2
12
Want to peek into logical replication without breaking it? PostgreSQL 18’s new pg_logicalinspect extension lets you inspect slots, WAL, and snapshots, all from SQL! Day 25 of #PG18Hacktober opensource-db.com/pg18-hackt… #PG18Hacktober #PostgreSQL #PG18 #LogicalReplication #OpenSource

PG18 Hacktober: 31 Days of New Features : pg_logicalinspect Logical Replication Insights - OpenSo...

Welcome to Day 25 of the PG18 Hacktober PostgreSQL continues to evolve with powerful extensions that help developers and DBAs […]

opensource-db.com
2
23
Welcome to the Day24 of #PG18Hacktober!! Today, let's explore how #PostgreSQL18 elevates the psql experience with the ability to \parse, \bind_named, and \close the prepared statements right at the CLI. Read more: opensource-db.com/pg18-hackt… #OpenSourceDB

PG18 Hacktober: 31 Days of New Features : Named Prepared Statements - OpenSourceDB

Welcome to the 24th blog post of PG18 Hacktober! The release of PostgreSQL 18 introduced a valuable enhancement for developers who […]

opensource-db.com
2
11
#PostgreSQL18 just made psql a lot more powerful! With the introduction of pipeline query support, we can now send multiple queries together. No C code, no drivers — just pure psql magic with commands like \startpipeline & \syncpipeline. opensource-db.com/pg18-hackt… #PG18Hacktober

PG18 Hacktober: 31 Days of New Features : Supercharging psql with Pipeline Query Support - OpenSo...

Welcome to a brand-new segment of PG18Hacktober — Client Applications, where we explore the exciting enhancements and hidden gems that […]

opensource-db.com
1
11
In today’s #PG18Hacktober spotlight — PostgreSQL18 makes postgres_fdw smarter and safer with SCRAM pass-through authentication. No more passwords in mappings, no more manual secret management — just secure, seamless cross-server connections. opensource-db.com/pg18-hackt… #OpenSourceDB

PG18 Hacktober: 31 Days of New Features : postgres_fdw: SCRAM authentication without storing the...

In today’s post of the PG18 Hacktober segment!, we’re going to discuss the  postgres_fdw SCRAM authentication pass throughout. Introduction : […]

opensource-db.com
1
15
PostgreSQL 18 adds schema magic to FDWs with: CREATE FOREIGN TABLE ... LIKE In Part 2 of our #PG18Hacktober series, we unpack: INCLUDING COMMENTSSTORAGE / COMPRESSIONGotchas & best practices opensource-db.com/pg18-hackt… #PG18Hacktober #PostgreSQL

PG18 Hacktober: 31 Days of New Features : FDW Enhancements: CREATE FOREIGN TABLE .. LIKE - Part-2 -...

In today’s continuation of the PG18 Hacktober series, we’re diving deeper into PostgreSQL 18’s enhanced LIKE clause for creating foreign […]

opensource-db.com
1
2
9
New in #PG18Hactober: CREATE FOREIGN TABLE ... LIKE Clone your schema with ease — constraints, defaults & all Part 1 of our #PG18Hacktober blog explores why this tiny feature packs a punch. opensource-db.com/pg18-hackt… #PostgreSQL #PG18Hactober #OpenSourceDB

PG18 Hacktober: 31 Days of New Features : FDW Enhancements: CREATE FOREIGN TABLE .. LIKE - Part-1 -...

In today’s post of the PG18 Hacktober segment!, we’re going to discuss the LIKE operator that was introduced to simplify […]

opensource-db.com
1
2
15
Automating #PostgreSQL18 installation and replication with #Ansible — no more manual setup or downtime. In Day19 of #PG18Hacktober, let's deploy, configure, and scale your clusters seamlessly across RHEL with one playbook. Read here : opensource-db.com/pg18-hackt… #OpenSourceDB

PG18 Hacktober: 31 Days of New Features : Ansible based Installation & Replication - OpenSourceDB

PG18 Hacktober shifts gears from database features to DevOps. We’ll explore how to automate the setup of PostgreSQL 18 and […]

opensource-db.com
2
19
Virtual Generated Columns are here in #PostgreSQL18! In Day 18 of #PG18Hacktober, we explore how virtual columns make dynamic fields clean, fast, and space-efficient. Read it opensource-db.com/pg18-hackt… #PG18Hacktober

PG18 Hacktober: 31 Days of New Features : Virtual Generated columns - OpenSourceDB

Welcome to Day 18 of the PG18 Hacktober !! In PostgreSQL, generated columns are table columns whose values are computed […]

opensource-db.com
2
11
Welcome to the 2nd blog of Asynchronous I/O in #PG18Hacktober series. In Day 17 ,let's break down why — from CPU-bound checksums to memcpy bottlenecks — and share tuning tips for io_method and io_workers. opensource-db.com/pg18-hackt… #OpenSourceDB

PG18 Hacktober: 31 Days of New Features : Asynchronous I/O - Part II - OpenSourceDB

Welcome to the 2nd part of the blog post on PG18 Asynchronous I/O. Here’s the first part of the blog post […]

opensource-db.com
2
7
Halfway through #PG18Hacktober! After years of anticipation, PostgreSQL18 finally delivers one of its most transformative features: Asynchronous I/O (AIO). Let's deep dive into PostgreSQL internal and the performance revolution behind PG18. opensource-db.com/pg18-hackt… #OpenSource

PG18 Hacktober: 31 Days of New Features : Asynchronous I/O in PostgreSQL 18 - OpenSourceDB

Welcome to the 16th blog post of PG18 Hacktober! PostgreSQL 18 is bringing a host of anticipated features, from the beautifully […]

opensource-db.com
1
21
Welcome to the #PG18Hacktober Day15 is live: PostgreSQL 18 introduces powerful temporal constraints that help manage and validate time-based data directly within the database schema. opensource-db.com/pg18-hackt… 31 days.31 blogs.#PG18Hacktober. #PG18 #OpenSourceDB
2
13
Welcome to the #PG18Hacktober Day14 is live: PostgreSQL 18 introduced significant enhancements in logical replication, including better handling and tracking of write conflicts. opensource-db.com/pg18-hackt… 31 days.31 blogs.#PG18Hacktober. #PG18 #OpenSourceDB

PG18 Hacktober: 31 Days of New Features : Logical Replication - Write Conflict Logging - OpenSour...

Welcome to the 14th blog post in the “Logical replication” segment of PG18 Hacktober! PostgreSQL 18 introduced significant enhancements in […]

opensource-db.com
2
18
Welcome to the Day13 of #PG18Hacktober Let's learn how to capture the modified rows using RETURNING Clause. opensource-db.com/pg18-hackt… #PG18 #SQL #OpenSource #Databases #ReturningClause #DML

PG18 Hacktober: 31 Days of New Features : Harnessing OLD and NEW Row Values with RETURNING Clause -...

Welcome to the Day13 of the PG18 Hacktober !! PostgreSQL 18 introduces a powerful enhancement to DML operations: the ability […]

opensource-db.com
1
10
In Part 2 of our Logical replication section series is out! Day12 of #PG18Hacktober : Learn how to replicate only the columns you need using stored generated columns column lists. More control, less overhead opensource-db.com/pg18-hackt… #LogicalReplication #OpenSource #Databases

PG18 Hacktober: 31 Days of New Features : Logical Replication of Stored Generated Columns - Part II...

Welcome to the 12th blog post in the “logical replication” segment of PG18 Hacktober! In the previous blog, we explored how […]

opensource-db.com
1
10
Load more