PostgreSQL

2142 readers
1 users here now

The world's most advanced open source relational database

Project
Events
Podcasts
Related Fediverse communities

founded 2 years ago
MODERATORS
Ategon@programming.dev
starman@programming.dev
jnovinger@programming.dev
listing: all - local
76
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
77
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
78
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
79
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
80
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.

81
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
82
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
83
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"

84
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
85
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
86
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
87
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
88
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

89
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
90
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
91
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
92
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

93
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
94
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.

95
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

96
1
Zero downtime postgres updates (knock.app)
submitted 2 years ago by starman@programming.dev to c/postgresql@programming.dev
0 comments fedilink
97
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
98
1
Greenmask Beta Release (www.postgresql.org)
submitted 2 years ago by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink