Understanding Subqueries in PostgreSQL- Part 1
Subqueries, often called nested queries or inner queries, are a powerful feature in SQL that allow you to execute one […]
Understanding Subqueries in PostgreSQL- Part 1 Read Post »
Collaboration in Action
How Teamwork and Partnerships drive the PostgreSQL community forwardAt OpenSource DB (OSDB), collaboration is not just a guiding value, it’s
Collaboration in Action Read Post »
Resolving Replica Identity Issues After Dropping Logical Replication
Recently, one of our clients encountered a perplexing issue with their PostgreSQL database. They had been using logical replication and
Resolving Replica Identity Issues After Dropping Logical Replication Read Post »
Building Bonds Beyond the Event: Celebrating Community Connections
Building Bonds Beyond the Event: Celebrating Community ConnectionsNovember marks the start of Networking November, a month where we celebrate the
Building Bonds Beyond the Event: Celebrating Community Connections Read Post »
Postgres HA Architecture: Eliminating SPoF with Keepalived
Production PostgreSQL deployments demand high availability. Applications requiring four or five nines of uptime need resilient database clusters built on
Postgres HA Architecture: Eliminating SPoF with Keepalived Read Post »
Cultural Optimization: Building a continuous improvement mindset
At OpenSource DB, we believe optimization isn’t just about databases, queries, or infrastructure, it’s about People and Culture.A high-performing organization
Cultural Optimization: Building a continuous improvement mindset Read Post »
PG18 Hacktober: 31 Days of New Features : Wrap Up with Our Top picks,Community shout-outs & Postgres gratitude
PG18 Hacktober D-Day: Wrap Up with Our Top picks, Community shout-outs & Postgres gratitude. What a Month!Over the last 31
PG18 Hacktober: 31 Days of New Features : Catalog Views Got Smarter
Welcome to the Day30 of PG18Hacktober !! PostgreSQL 18 brings significant improvements to its system catalogs and statistics views, expanding
PG18 Hacktober: 31 Days of New Features : Catalog Views Got Smarter Read Post »
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
PG18 Hacktober: 31 Days of New Features : Internationalization LIKE comparisons
In PostgreSQL 18, the LIKE operator becomes more powerful and more compliant with the SQL standard, it now supports use
PG18 Hacktober: 31 Days of New Features : Internationalization LIKE comparisons Read Post »
PG18 Hacktober: 31 Days of New Features : casefold() function
Welcome to the 27th blog post of PG18 Hacktober! Among the many new features, one quiet and small feature is making
PG18 Hacktober: 31 Days of New Features : casefold() function Read Post »
PG18 Hacktober: 31 Days of New Features : pg_overexplain – See the Real Plans
Welcome to Day 26 of the PG18 Hacktober series! Have you had this discussion with Devs? I wrote a clean
PG18 Hacktober: 31 Days of New Features : pg_overexplain – See the Real Plans Read Post »
PG18 Hacktober: 31 Days of New Features : pg_logicalinspect Logical Replication Insights
Welcome to Day 25 of the PG18 Hacktober PostgreSQL continues to evolve with powerful extensions that help developers and DBAs
PG18 Hacktober: 31 Days of New Features : pg_logicalinspect Logical Replication Insights Read Post »
PG18 Hacktober: 31 Days of New Features : Named Prepared Statements
Welcome to the 24th blog post of PG18 Hacktober! The release of PostgreSQL 18 introduced a valuable enhancement for developers who
PG18 Hacktober: 31 Days of New Features : Named Prepared Statements Read Post »
Financial efficiency and Smart spending
Getting more value out of every rupee, the open way.Smart spending in 2025, balancing growth, innovation, and financial discipline. In
Financial efficiency and Smart spending Read Post »
PG18 Hacktober: 31 Days of New Features : Supercharging psql with Pipeline Query Support
Welcome to a brand-new segment of PG18Hacktober — Client Applications, where we explore the exciting enhancements and hidden gems that
PG18 Hacktober: 31 Days of New Features : Supercharging psql with Pipeline Query Support Read Post »
PG18 Hacktober: 31 Days of New Features : postgres_fdw: SCRAM authentication without storing the password
In today’s post of the PG18 Hacktober segment!, we’re going to discuss the postgres_fdw SCRAM authentication pass throughout. Introduction :
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
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
PG18 Hacktober: 31 Days of New Features : Ansible based Installation & Replication
PG18 Hacktober shifts gears from database features to DevOps. We’ll explore how to automate the setup of PostgreSQL 18 and
PG18 Hacktober: 31 Days of New Features : Ansible based Installation & Replication Read Post »
PG18 Hacktober: 31 Days of New Features : Virtual Generated columns
Welcome to Day 18 of the PG18 Hacktober !! In PostgreSQL, generated columns are table columns whose values are computed
PG18 Hacktober: 31 Days of New Features : Virtual Generated columns Read Post »