PostgreSQL

2155 readers
1 users here now

The world's most advanced open source relational database

Project
Events
Podcasts
Related Fediverse communities

founded 3 years ago
MODERATORS
Ategon@programming.dev
starman@programming.dev
jnovinger@programming.dev
listing: all - local
76
1
Is it possible to upgrade PostreSQL from 14 to 16 directly when using containers? (social.touha.me)
submitted 2 years ago* (last edited 2 years ago) by dragnucs@social.touha.me to c/postgresql@programming.dev
0 comments fedilink
 
 

Is it possible to upgrade PostreSQL from 14 to 16 directly when using containers?
@postgresql

77
1
UUID Benchmark War (ardentperf.com)
submitted 2 years ago by agilob@programming.dev to c/postgresql@programming.dev
0 comments fedilink
78
1
The performance cost of pl/pgsql exception block in Postgres (dev.to)
submitted 2 years ago by Serpent7776@programming.dev to c/postgresql@programming.dev
0 comments fedilink
79
1
“But how much does a PostgreSQL license actually cost?” A Frequently Asked Question from Oracle users considering PostgreSQL (stormatics.tech)
submitted 2 years ago by jnovinger@programming.dev to c/postgresql@programming.dev
0 comments fedilink
80
1
One PID to Lock Them All: Finding the Source of the Lock in Postgres (www.crunchydata.com)
submitted 2 years ago by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
81
1
Prague PostgreSQL Developer Day 2024 / Call for Papers & Sponsors (www.postgresql.org)
submitted 2 years ago by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
82
1
How we migrated our PostgreSQL database with 11 seconds downtime - Government Digital Service (gds.blog.gov.uk)
submitted 2 years ago* (last edited 2 years ago) by starman@programming.dev to c/postgresql@programming.dev
0 comments fedilink
83
1
Waiting for Postgres 17: Incremental base backups (pganalyze.com)
submitted 2 years ago by starman@programming.dev to c/postgresql@programming.dev
0 comments fedilink
 
 

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.

84
1
Don't Do This - PostgreSQL wiki (wiki.postgresql.org)
submitted 2 years ago by jnovinger@programming.dev to c/postgresql@programming.dev
0 comments fedilink
85
1
Nine ways to shoot yourself in the foot with PostgreSQL (philbooth.me)
submitted 2 years ago by jnovinger@programming.dev to c/postgresql@programming.dev
0 comments fedilink
86
1
Query Exercise: Find Posts with the Wrong CommentCount (smartpostgres.com)
submitted 2 years ago by jnovinger@programming.dev to c/postgresql@programming.dev
0 comments fedilink
 
 

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"

87
1
PostgreSQL is the DBMS of the Year for 2023 (db-engines.com)
submitted 2 years ago* (last edited 2 years ago) by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
88
1
Waiting for PostgreSQL 17 – Add support for incremental backup. – select * from depesz; (www.depesz.com)
submitted 2 years ago by daamien@lemmy.world to c/postgresql@programming.dev
0 comments fedilink
89
1
How to setup TLS connection for PostgreSQL (postgr.es)
submitted 2 years ago by daamien@lemmy.world to c/postgresql@programming.dev
0 comments fedilink
90
1
AI Meets PostgreSQL - The pgvector Revolution in Text Search - Stormatics (postgr.es)
submitted 2 years ago by daamien@lemmy.world to c/postgresql@programming.dev
0 comments fedilink
91
1
PostgreSQL: Full text search with the “websearch” syntax (adamj.eu)
submitted 2 years ago by norambna@programming.dev to c/postgresql@programming.dev
0 comments fedilink
 
 

via https://fosstodon.org/@adamchainz/111694569833742858

92
1
An Introduction to EDB's Transparent Data Encryption - Stormatics (stormatics.tech)
submitted 2 years ago by jnovinger@programming.dev to c/postgresql@programming.dev
0 comments fedilink
93
1
2023 State of PostgreSQL Survey Results (www.timescale.com)
submitted 2 years ago by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
94
1
Functions to Validate User's Input (fluca1978.github.io)
submitted 2 years ago by jnovinger@programming.dev to c/postgresql@programming.dev
0 comments fedilink
95
1
Postgres Language Server: implementing the Parser (supabase.com)
submitted 2 years ago by jnovinger@programming.dev to c/postgresql@programming.dev
0 comments fedilink
 
 

Via https://botsin.space/@planetpostgresql/111602978945432365

96
1
Transaction Isolation in Postgres, explained (www.thenile.dev)
submitted 2 years ago by lysdexic@programming.dev to c/postgresql@programming.dev
0 comments fedilink
97
1
PGDay Chicago [2024] | PostgreSQL Conference (2024.pgdaychicago.org)
submitted 2 years ago by jnovinger@programming.dev to c/postgresql@programming.dev
0 comments fedilink
 
 

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.

98
1
Fly Postgres, managed by Supabase (supabase.com)
submitted 2 years ago by starman@programming.dev to c/postgresql@programming.dev
0 comments fedilink
 
 

A managed Postgres offering developed by Supabase and Fly.io

99
1
Zero downtime postgres updates (knock.app)
submitted 2 years ago by starman@programming.dev to c/postgresql@programming.dev
0 comments fedilink
100
1
Advent of Code in PostgreSQL: Tips and Tricks from 2022 (www.crunchydata.com)
submitted 2 years ago by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
view more: ‹ prev next ›