PostgreSQL
- notso.boringsql.com How not to change PostgreSQL column type | boringSQL
Deep dive into SQL & PostgreSQL to build reliable, rock-solid solutions with tips and tricks that keep business online. Data is everything. Explore, learn and innnovate to get them where you need faster and more efficiently.
Via https://fosstodon.org/@hunleyd/113205392466307810
- www.postgresql.org PostgreSQL 17 Released!
The [PostgreSQL Global Development Group](https://www.postgresql.org) today announced the release of [PostgreSQL 17](https://www.postgresql.org/docs/17/release-17.html), the latest version of the world's most advanced …
-
Via https://fosstodon.org/@hunleyd/113080821469886930
- github.com GitHub - supabase/pg_jsonschema: PostgreSQL extension providing JSON Schema validation
PostgreSQL extension providing JSON Schema validation - supabase/pg_jsonschema
-
POSETTE: An Event for Postgres 2024 | 3rd annual virtual event organized by the Postgres team at Microsoft | 48 Hours of Virtual Presentations and Meetings Starting Tue, June 11 @ 3:00 PM UTC
www.citusdata.com POSETTE: An Event for Postgres 2024Join us at POSETTE: An Event for Postgres (formerly Citus Con), a virtual and free developer event happening on Jun 11-13, 2024. Come learn what you can do with the world’s most advanced open source relational database—from the nerdy to the sublime. Organized by the Postgres team at Microsoft.
-
Via https://mastodon.social/@[email protected]/112220150255942506
- github.com GitHub - tatut/pgprolog: PostgreSQL Prolog language handler
PostgreSQL Prolog language handler. Contribute to tatut/pgprolog development by creating an account on GitHub.
> Prolog language for PostgreSQL > > This is a PostgreSQL extension that allows writing stored procedures in Prolog. > > This embeds Scryer Prolog into a PostgreSQL extension. > > Proof of concept! Not ready for any actual use.
-
PostgreSQL maintainer Simon Riggs has died in a small airplane crash
m6n.io Berkubernetus (@[email protected])PostgreSQL maintainer Simon Riggs has died in a small airplane crash, on Tuesday. For those who didn't know Simon, he's responsible for PostgreSQL Binary Replication and many big data features. He and I worked together at Greenplum 2006-2008. Postgres would not be the world-leading DB it is tod...
> PostgreSQL maintainer Simon Riggs has died in a small airplane crash, on Tuesday. > > For those who didn't know Simon, he's responsible for PostgreSQL Binary Replication and many big data features. He and I worked together at Greenplum 2006-2008. Postgres would not be the world-leading DB it is today if it weren't for him. > > https://www.bbc.com/news/articles/cjex992z0wlo
- www.cybertec-postgresql.com Recovering Deleted Data From PostgreSQL Tables
Four options in recovering deleted data. In this article we will show you four options how to restore your data.
- xata.io Introducing pgzx: create PostgreSQL extensions using Zig
We are excited to introduce pgzx, a framework for creating Postgres extensions using the Zig programming language.
- www.postgresql.org PGConf NYC 2024 - Call for Presentations (CFP) and Sponsors!
[PGConf NYC 2024](https://2024.pgconf.nyc/) (September 30 - October 2, 2024, New York City) is packed with user stories and best practices …
- www.postgresql.org PostgreSQL JDBC 42.7.3, 42.6.2, 42.5.6, 42.4.5, 42.3.10, 42.2.29 Released
The JDBC team has release minor versions for all supported versions. This release fixes 2 things. 1. Make sure we …
-
Request for SQL experts: Lemmy PR to combine action tables
github.com Combine action tables by dullbananas · Pull Request #4459 · LemmyNet/lemmyThis should cause a huge improvement in query plans, especially for queries that previously reached the from/join collapse limits. For example, getting saved posts might now start with an index sca...
Lemmy currently uses distinct tables like
post_like: (post_id, person_id, score)
andpost_saved
. Unfortunately this causes performance issues when we have to join many of these tables to create views.One suggestion in this PR, is to combine these into a single
post_action
table, with a lot of optional columns depending on the action. This solution scares me a little, because I'm afraid we might lose data integrity, and many of our constraints with so many optional columns.Is there a better way of doing this in SQL?
- www.citusdata.com What’s new in the Postgres 16 query planner / optimizer
Postgres 16 introduces quite a few improvements to the query planner and makes many SQL queries run faster than they did on previous versions of PostgreSQL. This post is a deep dive into 10 of the improvements, including code blocks and comparisons of query plan output between Postgres 15 & Post...
-
Is it possible to upgrade PostreSQL from 14 to 16 directly when using containers?
Is it possible to upgrade PostreSQL from 14 to 16 directly when using containers? @postgresql
- ardentperf.com UUID Benchmark War
This month’s PGSQL Phriday #015 topic is about UUIDs, hosted by Lætitia Avrot. Lætitia has called for a debate. No, no, no. I say let’s have an all-out war. A benchmark war. I have deci…
- dev.to The performance cost of pl/pgsql exception block in Postgres
One of the languages that Postgres offers for writing stored procedures is pl/pgsql. One of it's...
-
“But how much does a PostgreSQL license actually cost?” A Frequently Asked Question from Oracle users considering PostgreSQL
stormatics.tech “But how much does a PostgreSQL license actually cost?” A Frequently Asked Question from Oracle users considering PostgreSQL - StormaticsUnraveling the Mystery: Why PostgreSQL Costs You Nothing Each time I mention that PostgreSQL comes with zero licensing fees, I’m met with skeptical looks and a barrage of “Really? But how much does the license actually cost?”. It has happened enough times that I decided to write a blog explain...
-
One PID to Lock Them All: Finding the Source of the Lock in Postgres
www.crunchydata.com One PID to Lock Them All: Finding the Source of... | Crunchy Data BlogOne process can lock your Postgres database, dominating all will, blocking other processes and queries. Jesse shows you how to find that one process that’s ruling them all. Once you’ve grabbed this lock and held it close to your chest, he’ll help you on your quest to cast it into the depths of Mt Do...
-
Prague PostgreSQL Developer Day 2024 / Call for Papers & Sponsors
www.postgresql.org Prague PostgreSQL Developer Day 2024 / Call for Papers & SponsorsPrague PostgreSQL Developer Day 2024 (P2D2 2024) will be held on June 4 and 5 in Prague, Czech Republic. The …
- gds.blog.gov.uk How we migrated our PostgreSQL database with 11 seconds downtime - Government Digital Service
GDS is leading the digital transformation of the UK government.
- pganalyze.com Waiting for Postgres 17: Incremental base backups
We walk through the incremental backup feature committed to the Postgres 17 development branch by Robert Haas. We show an example on our local machine.
- philbooth.me Nine ways to shoot yourself in the foot with PostgreSQL
Previously for Extreme Learning, I discussed all the ways I've broken production using healthchecks. In this post I'll do the same for PostgreSQL.
- smartpostgres.com Query Exercise: Find Posts with the Wrong CommentCount
For this week’s query challenge, we’re going to do some data validation. Pop open the Stack Overflow database and check out the commentcount column on the posts table: In theory, that&#…
Via https://mstdn.social/@michristofides/111738621686733546
> There's a fun looking new weekly #PostgreSQL newsletter from Brent Ozar (one of my favourite authors from the SQL Server community). > > From this week's post: "But… I’m a DBA, and you know what DBA stands for: Doesn’t Believe Anyone"
- postgr.es AI Meets PostgreSQL - The pgvector Revolution in Text Search - Stormatics
pgvector is a revolutionary extension that infuses PostgreSQL with the magic of vector data.
-
PostgreSQL: Full text search with the “websearch” syntax
adamj.eu PostgreSQL: Full text search with the “websearch” syntax - Adam JohnsonPostgreSQL’s powerful full text search feature supports several query syntaxes. Of these, a website search feature should typically pick the websearch syntax. websearch copies some features from popular search engines, as covered below, offering familiar short syntax to users. It is also forgiving a...
via https://fosstodon.org/@adamchainz/111694569833742858
- stormatics.tech An Introduction to EDB's Transparent Data Encryption - Stormatics
This post covers EDB's Transparent Data Encryption (TDE) solution and also provides a few notes about what has been proposed for community Postgres.
-
2023 State of PostgreSQL Survey Results
www.timescale.com 2023 State of PostgreSQL SurveyRead the 2023 State of PostgreSQL survey results for insights into the experiences of PostgreSQL users with the open-source relational database.
- fluca1978.github.io Functions to Validate User's Input
PostgreSQL 16 introduces a couple of functions to validate user’s input.
- supabase.com Postgres Language Server: implementing the Parser
A detailed analysis of our iterations to implement a Parser for Postgres
Via https://botsin.space/@planetpostgresql/111602978945432365
- www.thenile.dev Transaction Isolation in Postgres, explained
Ever dealt with glitches in a SaaS platform where your actions don't seem to sync up? That's often a transaction isolation issue in databases. Lets talk about transaction isolation and how they work in Postgres, so you can write reliable and performant code with minimal headache.
-
PGDay Chicago | PostgreSQL Conference
> PGDay Chicago is a non–profit, community–run conference series in the United States focused on PostgreSQL, the world’s leading open source database. Our conference delivers one day packed with presentations about PostgreSQL and related technologies and the usual hallway and social track. Our conference will be held April 26th, 2024, in Chicago, IL.
- supabase.com Fly Postgres, managed by Supabase
A managed Postgres offering developed by Supabase and Fly.io