Sammlung von Newsfeeds

Elizabeth Garrett Christensen: Connecting QGIS to Postgres and PostGIS

Neues vom PostgreSQL Planet - 6. März 2024 - 14:00

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

Neues vom PostgreSQL Planet - 5. März 2024 - 18:43

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

Neues vom PostgreSQL Planet - 5. März 2024 - 14:00

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?

Neues vom PostgreSQL Planet - 5. März 2024 - 12:33

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.

Neues vom PostgreSQL Planet - 5. März 2024 - 8:00

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.

David Wheeler: State of the Extension Ecosystem

Neues vom PostgreSQL Planet - 4. März 2024 - 19:50

A quick reminder that I’ll be giving a brief talk on the “State of the Extension Ecosystem” on Wednesday at noon US Eastern / 17:00 UTC. This talk is the first in a series of community talks and discussions on the postgres extension ecosystem leading up to the Extension Ecosystem Summit at pgconf.dev on May 28.

Sai Srirampur: Comparing Postgres Managed Services: AWS, Azure, GCP and Supabase

Neues vom PostgreSQL Planet - 4. März 2024 - 18:24
At PeerDB, we are building a fast and a cost-effective way to replicate data from Postgres to Data Warehouses such as Snowflake, BigQuery, ClickHouse, Postgres and so on. All our customers run Postgres at the heart of the data stack, running fully ma...

Jan Karremans: Open source key areas for digital autonomy

Neues vom PostgreSQL Planet - 4. März 2024 - 17:00
How PostgreSQL is destined to make a difference at a European level Why

And not just “Why”, but also how.

How do you bring free and open source initiatives and something as regulated as the European Union? Both of these questions triggered me to accept the invitation to travel to Brussels and participate in this day of workshops.

Francesco Tisiot: From dbf to PostgreSQL with Python

Neues vom PostgreSQL Planet - 4. März 2024 - 16:00

Some time ago I found an interesting database file suffix I never faced before: the .dbf and saw aroung that it was first introduced in 1983 with dBASE II. This article showcases how we can automatically generate the PostgreSQL table and fill it with data using Python and dbfread.

Sergey Pronin: Percona Operator for PostgreSQL is Red Hat OpenShift Certified

Neues vom PostgreSQL Planet - 4. März 2024 - 15:02
Percona Operator for PostgreSQL is now Red Hat OpenShift certified. You can now use Percona Operator for PostgreSQL to deploy and manage highly available PostgreSQL clusters on OpenShift. Certification guarantees that our Operator meets standards for interoperability, security, and life cycle management when deployed on Red Hat OpenShift. It is fully supported by Red Hat’s […]

Andreas 'ads' Scherbaum: Divya Sharma

Neues vom PostgreSQL Planet - 4. März 2024 - 15:00
PostgreSQL Person of the Week Interview with Divya Sharma: I am originally from India, but based in Dublin,Ireland for the past 8 years. I hold a Bachelor’s degree in Computer Science Engineering from TU, Dublin. I moved to Dublin after getting a scholarship to finish my final year of engineering in Ireland. After finishing the course, I got a job offer from AWS as a support engineer (in 2017). I have been working with PostgreSQL since then, and now I am working as a Sr. RDS PostgreSQL SA at AWS.

Pavel Stehule: using jq for processing PostgreSQL logs in json format

Neues vom PostgreSQL Planet - 4. März 2024 - 8:32

PostgreSQL supports logging in json format. From my perspective json logs are badly readable, but allows machine processing, and with good tools, it is beautifully simple.

There are more tools for json processing - I use jq.

For simple analyze of errors in log, I can use sequence of commands:

Jeremy Schneider: Postgres Indexes, Partitioning and LWLock:LockManager Scalability

Neues vom PostgreSQL Planet - 4. März 2024 - 2:44

I have decided that – in Postgres circles – I shall henceforth refer to 2023 as THE YEAR OF THE LOCK MANAGER’S REVENGE.

Let me explain.

Gabriele Bartolini: CloudNativePG Recipe 1 - Setting up your local playground in minutes

Neues vom PostgreSQL Planet - 3. März 2024 - 1:00

Dive into the world of running PostgreSQL in Kubernetes with CloudNativePG in this inaugural guide. Follow along as we walk you through the process of setting up a disposable local cluster using kind. Gain insights into creating PostgreSQL clusters, installing CloudNativePG, and leveraging the cnpg plugin for kubectl. Wrap up your journey by tidying up your local cluster.

Claire Giordano: What’s in a name? Hello POSETTE: An Event for Postgres 2024

Neues vom PostgreSQL Planet - 1. März 2024 - 21:58

When I think about naming something—like a feature or product or even an event—this quote always comes to mind.

What’s in a name? That which we call a rose
By any other name would smell as sweet;

–William Shakespeare

What’s in a name, after all? I’m no expert on Romeo and Juliet, but friends tell me Shakespeare’s point was that names don’t matter. The thing itself is the thing itself, regardless of the name.

Ryan Booz: PGSQL Phriday #016: Tuning That One Big Query

Neues vom PostgreSQL Planet - 1. März 2024 - 18:32
PostgreSQL continues to dominate in growth and interest by many people and teams across the globe. In my role at Redgate I’m often brought into conversations with long-time SQL Server developers and DBA’s that are now being tasked with learning Postgres. I was one of those people myself a few years ago. Aside from the ... Read more

Gilles Darold: Partitioning by reference – Oracle vs PostgreSQL

Neues vom PostgreSQL Planet - 29. Februar 2024 - 17:09

Sometimes, when you are working on a migration to PostgreSQL, you can encounter features that do not exist in PostgreSQL. This especially happens when we do not have any extension to emulate the feature you are looking at. At HexaCluster Corp, we often face these kind of situations. When it is possible to create an […]

The post Partitioning by reference – Oracle vs PostgreSQL appeared first on HexaCluster.

Francesco Tisiot: List of PostgreSQL® AI Projects and Resources

Neues vom PostgreSQL Planet - 29. Februar 2024 - 11:00

Everyone is now talking about AI, and modern databases like PostgreSQL® are increasingly being adopted in companies' AI journey as sources of data or key pieces of the AI infrastructure. Moreover there's a new set projects that are solving PostgreSQL problems with AI.

PRs are welcome!

Gilles Darold: PostgreSQL security – Password Reuse Policy

Neues vom PostgreSQL Planet - 29. Februar 2024 - 7:02

A database password reuse policy is a set of rules that govern the use of passwords within a database system. The policy is designed to ensure that users create strong and unique passwords, and that they do not reuse the same password. By implementing a database password reuse policy, organizations can reduce the risk of […]

The post PostgreSQL security – Password Reuse Policy appeared first on HexaCluster.

Ryan Lambert: Can you use ltree for Nested Place Data?

Neues vom PostgreSQL Planet - 29. Februar 2024 - 6:01

The topic of the ltree data type has come up a few times recently. This intersects with a common type of query used in PostGIS: nested geometries. An example of nested geometries is the state of Colorado exists within the United States. The PgOSM Flex project calculates and stores nested polygon data from OpenStreetMap places into a handful of array (TEXT[], BIGINT[]) columns.

Seiten