Recent PostgreSQL articles on Simple Talk

• 

  Boris Novikov

  April 17, 2025

  A Method for Managing Hierarchies in PostgreSQL

  The Postgres database management system was originally designed as object-relational. We remind why PostgreSQL is an object-relational rather than just relational database management system, and briefly discuss what kind of object-oriented features it offers. We demonstrate how these features can be used to manage hierarchies, and how applications can benefit using them. The discussion is illustrated with examples of SQL code based on the postgres_air database [6, https://github.com/hettie-d/postgres_air]. There are many ways to implement a hierarchy in a relational database. Techniques with names like adjacency lists and nested sets, not to mention some other RDBMS have built methods of managing...… Read more

• 

  Grant Fritchey

  April 2, 2025

  Multi-Version Concurrency Control (MVCC) in PostgreSQL: Learning PostgreSQL with Grant

  It’s a tale as old as time. You want to read data. Your mate wants to write data. You’re stepping on each other’s toes, all the time. When we’re talking about relational data stores, one aspect that makes them what they are is the need to comply with the ACID properties. These are: A whole lot of effort is then made to build databases that both allow you to meet the necessary ACID properties while simultaneously letting lots of people into your database. PostgreSQL does this through the Multi-version Concurrency Control (MVCC). In this article we’ll discuss what MVCC is...… Read more

• 

  Lee Asher

  March 25, 2025

  The Wide World of GiST Indexes

    In Parts I (Solving the Overlap Query Problem in PostgreSQL) and II (Overlapping Ranges in Subsets in PostgreSQL) of this series, we used the GiST index type – and its lesser known cousin: SP-GiST – to turbocharge the performance of overlap queries. But GiST indexes are extremely versatile, with uses far beyond the examples I have used so far. In this final article, we’ll explore some of the many other ways they can be used. Stuck in the Middle With You We’ve used only one operator in all our queries so far: the “&&” operator, which returns true if...… Read more

• 

  Aisha Bukar

  March 20, 2025

  MySQL vs PostgreSQL – String Datatypes

  A very common task in creating a database is to store string data. For example, words, paragraph(s) or even documents. String data types allow you to do just that and store and represent text. They handle everything from simple names and addresses to complex data. A string is simply a sequence of characters. These characters can be letters, numbers, symbols, or even spaces. For example, “Simple Talk”, “MySQL and PostgreSQL”, “1234” are all strings. Think of each character as a building block. A string is made up of these blocks, arranged in a specific order. String data types are important...… Read more

PostgreSQL events at Redgate

• Community event
• PostgreSQL

PostgreSQL Conference Germany

Redgate is delighted to be sponsoring at PostgreSQL Conference Germany! Join us at the 9th annual PostgreSQL Conference in Berlin, Germany, May 8-9, 2025. This is the second largest PostgreSQL conference in Europe. PostgreSQL Conference is a unique chance for German and European PostgreSQL users and developers to catch up, learn, build relationships, get to know each other and consolidate a real network of professionals that use and work with PostgreSQL. Stop by the Redgate booth to speak to our friendly crew about how we can help you on your end-to-end database DevOps journey. Register here.

• May 8 - May 9, 2025

Register

• Live training session
• Flyway

Redgate Flyway AutoPilot with PostgreSQL: Get Flying in Under 30 Minutes

Chris Hawkins and Huxley Kendell, Solution Engineers at Redgate, are back to lead you through a hands-on session with Flyway AutoPilot, this time featuring PostgreSQL. This interactive, ready-made sample project will allow you to experience using Redgate Flyway Enterprise in under 30 minutes.

• May 15, 2025

  4:00pm - 4:45pm BST

• May 15, 2025

  11:00am - 11:45am EDT

Register

• Workshop
• Database DevOps

Virtual Database DevOps in a Day

Join us for this hands-on virtual workshop. Database DevOps in a Day will get you started on your Database DevOps journey and illustrate how Redgate’s tools can help to bridge the gap between development and operations.

• Jun 11, 2025

Register

• Rapperswil
• Community event

Swiss PGDay 2025

Treffen Sie Redgate auf dem Swiss PGDay 2025 Am 26. Juni ist es wieder so weit: Der Swiss PGDay bringt die PostgreSQL-Community in der Schweiz zusammen – und Redgate ist als Sponsor mit dabei! Freuen Sie sich auf spannende Vorträge, neue Impulse und den Austausch mit Gleichgesinnten. Besuchen Sie uns an unserem Stand und: Entdecken Sie, wie Redgate Sie bei der Entwicklung und Bereitstellung Ihrer PostgreSQL-Datenbanken unterstützen kann. Sprechen Sie mit unserem Team über Ihre Herausforderungen und Erfahrungen mit PostgreSQL. Nehmen Sie an unserem Gewinnspiel teil und sichern Sie sich tolle Redgate-Goodies. Wir freuen uns auf Ihren Besuch in Rapperswil! ...

• Jun 26 - Jun 27, 2025

Register