Sammlung von Newsfeeds
Andreas Scherbaum: PostgreSQL March Meetup in Berlin
On March 5th, 2024, we had the PostgreSQL March Meetup in Berlin. Zalando hosted the Meetup in their Berlin Headquarter near the Mercedes-Benz Arena, close to the River Spree, and the Oberbaum Bridge.
Protected: PostgreSQL Day-to-Day
This content is password protected. To view it please enter your password below:
Password:
Adrian Klaver: Using Polars & DuckDB with Postgres
Shaun M. Thomas: PG Phriday: Getting It Sorted
When it comes to reordering the items in a list, databases have long had a kind of Faustian Bargain to accomplish the task. Nobody really liked any of the more common solutions, least of all the poor database tasked with serving up the inevitable resulting hack.
Postgres is no different in this regard. Consider a list_item table like this, demonstrating five items in a to-do list:
Akhil Reddy Banappagari: IN, OUT and INOUT parameters in Oracle vs PostgreSQL
When migrating Oracle routines to PostgreSQL, handling OUT and INOUT parameters can be tricky. Understanding the distinctions between Oracle and PostgreSQL in how they manage these parameters is essential for a successful migration. This knowledge helps you smoothly adjust your routines, ensuring your code works well without any issues. In this article, we shall explore […]
oded valin: Speed up PostgreSQL pgvector queries with indexes
er sideUsing AI, it’s possible to find similar text information, photos or products in a database. As the number of searches increases, performance can be a problem, though.In this article, I’ll show you how indexes can help.
Steven Miller: Announcing Tembo CLI: Infrastructure as code for the Postgres ecosystem
Postgres isn’t just a database; it’s a whole ecosystem of extensions and tools for all kinds of tasks. At Tembo Cloud, we’ve made it easy to deploy the Postgres ecosystem of extensions and apps combined to create solutions, which we call “Stacks”.
Gabriele Bartolini: CloudNativePG Recipe 2 - Inspecting Default Resources in a CloudNativePG Cluster
Dive into the nitty-gritty of how CloudNativePG works its magic with PostgreSQL cluster stuff, zooming in on configmaps and secrets. Peek behind the curtain of the default Private Key Infrastructure – the secret sauce for stress-free mutual TLS authentication. Get to know the default user and database setups, all decked out for maximum security. This article is your go-to roadmap, cruising through CloudNativePG’s resource wizardry and dishing out real-world tips for a breeze in deploying and handling PostgreSQL clusters.
semab tariq: Recovery Hack: Restoring Tablespace Using Barman on Windows
We uncover manual hacks to successfully recover tablespaces with Barman, navigating through encountered errors.
The post Recovery Hack: Restoring Tablespace Using Barman on Windows appeared first on Stormatics.
Jagadeesh Panuganti: Data Navigation with PostgreSQL Cursors – Part III
Welcome back to our series on PostgreSQL Cursors. As we continue exploring PostgreSQL Cursors, including Scrollable and Non-Scrollable Cursors, we’re now focusing on With-Hold Cursors in this article. With-Hold Cursors in PostgreSQL provide a crucial mechanism for managing data, enabling users to maintain query result sets even beyond transaction commitments. Data Navigation with PostgreSQL Cursors. […]
Andrew Atkinson: Rails + Postgres Postgres.FM 086 — Extended blog post edition! 🎙️
I recently joined Michael and Nikolay as a guest on a favorite podcast of mine, postgres.fm, which has been a favorite going back to when it started in August 2022. Why’s that?
Why I like the postgres.fm podcastAs a weekly-release podcast covering PostgreSQL for nearly 100 episodes, Michael and Nikolay have covered a lot of ground! All of the episodes have great content, covering a nice level of depth, in a short amount of time. Each host brings their unique perspective.
David Z: Setting up a debugging environment in PostgreSQL to better understand OpenSSL APIs
In my previous blog, I discussed how to enhance PostgreSQL TLS security with OCSP Stapling. In this blog, I will share a simple procedure for setting up a gdb debugging environment to dive into TLS connections and gain a better understanding of the OpenSSL APIs used in PostgreSQL.
Ryan Booz: PGSQL Phriday #016
Invitation from Ryan Booz
Many of the PostgreSQL newbies that I’ve engaged with lately are coming from other databases often because of company priorities to start adopting Postgres and migrating projects. Inevitably, one of the first things they want to learn once data starts flowing is how to tune queries. They typically have a lot of experience doing this type of work previously, just not with Postgres.
Goutham Reddy Banala: Exploring JSONB in PostgreSQL
PostgreSQL is a powerful Open-Source database management system and a migration target for Unstructured databases like MongoDB. as well as Relational databases like Oracle and SQL Server. One of the feature supporting the transition from MongoDB to PostgreSQL is its support for JSONB (Binary JSON). JSONB is a data type that allows efficient storage, indexing, […]
The post Exploring JSONB in PostgreSQL appeared first on HexaCluster.
Elizabeth Garrett Christensen: Connecting QGIS to Postgres and PostGIS
QGIS, the Quantum Geographic Information System, is an open-source graphical user interface for map making. QGIS works with a wide variety of file types and has robust support for integrating with Postgres and PostGIS. Today I just wanted to step through getting QGIS connected to a Postgres database and the basic operations that let you connect the two systems.
Regina Obe: PostgreSQL Mistakes and How To Avoid them
The adoption of PostgreSQL is growing each year. Many people coming to PostgreSQL are often coming from other relational databases, with assumptions of how relational databases work. Although PostgreSQL may feel very familiar to these people, it is different enough to cause some misunderstandings which lead to bad and slow queries. There are also people coming often from only programming backgrounds, who assume data processing in SQL is much like data processing in any language.
Pavlo Golub: How to use PostgreSQL for (military) geoanalytics tasks by Taras Klioba
During the PGConf.EU 2023, my friend, colleague, and PostgreSQL Ukraine co-founder Taras Klioba delved into the fascinating intersection of geospatial analysis and modern warfare.
Pavel Stehule: How fast is plpgsql?
Ten years ago I did some speed tests of plpgsql. I did same tests on same computer, and now, the plpgsql is about 3-4 times faster. There is still significant overhead against native (without plpgsql function) query, but it is reduced (little bit). I would to compare again with Python
Deepak Mahto: Why I Love psql – PostgreSQL Terminal.
At PGConf India 2024, I delivered a lightning talk expressing my fondness for the psql terminal. During the presentation, I shared various tips and tricks that I personally cherish. The talk was well-received, particularly among those new to PostgreSQL, as they were pleasantly surprised by the insights and information shared.