PostgreSQL

852 readers
2 users here now

The world's most advanced open source relational database

Project
Events
Podcasts
Related Fediverse communities

founded 2 years ago
MODERATORS
Ategon
starman
jnovinger
listing: all - local
26
9
UUID Benchmark War (ardentperf.com)
submitted 1 year ago by agilob to c/postgresql
0 comments fedilink
27
9
The performance cost of pl/pgsql exception block in Postgres (dev.to)
submitted 1 year ago by Serpent7776 to c/postgresql
0 comments fedilink
28
27
“But how much does a PostgreSQL license actually cost?” A Frequently Asked Question from Oracle users considering PostgreSQL (stormatics.tech)
submitted 1 year ago by jnovinger to c/postgresql
3 comments fedilink
29
8
One PID to Lock Them All: Finding the Source of the Lock in Postgres (www.crunchydata.com)
submitted 1 year ago by mac to c/postgresql
0 comments fedilink
30
9
Prague PostgreSQL Developer Day 2024 / Call for Papers & Sponsors (www.postgresql.org)
submitted 1 year ago by mac to c/postgresql
0 comments fedilink
31
19
How we migrated our PostgreSQL database with 11 seconds downtime - Government Digital Service (gds.blog.gov.uk)
submitted 1 year ago* (last edited 1 year ago) by starman to c/postgresql
2 comments fedilink
32
5
Waiting for Postgres 17: Incremental base backups (pganalyze.com)
submitted 1 year ago by starman to c/postgresql
1 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.

33
31
Don't Do This - PostgreSQL wiki (wiki.postgresql.org)
submitted 1 year ago by jnovinger to c/postgresql
1 comments fedilink
34
15
Nine ways to shoot yourself in the foot with PostgreSQL (philbooth.me)
submitted 1 year ago by jnovinger to c/postgresql
1 comments fedilink
35
5
Query Exercise: Find Posts with the Wrong CommentCount (smartpostgres.com)
submitted 1 year ago by jnovinger to c/postgresql
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"

36
14
PostgreSQL is the DBMS of the Year for 2023 (db-engines.com)
submitted 1 year ago* (last edited 1 year ago) by mac to c/postgresql
1 comments fedilink
37
6
Waiting for PostgreSQL 17 – Add support for incremental backup. – select * from depesz; (www.depesz.com)
submitted 1 year ago by [email protected] to c/postgresql
0 comments fedilink
38
6
How to setup TLS connection for PostgreSQL (postgr.es)
submitted 1 year ago by [email protected] to c/postgresql
0 comments fedilink
39
6
AI Meets PostgreSQL - The pgvector Revolution in Text Search - Stormatics (postgr.es)
submitted 1 year ago by [email protected] to c/postgresql
0 comments fedilink
40
10
PostgreSQL: Full text search with the “websearch” syntax (adamj.eu)
submitted 1 year ago by norambna to c/postgresql
0 comments fedilink
 
 

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

41
4
An Introduction to EDB's Transparent Data Encryption - Stormatics (stormatics.tech)
submitted 1 year ago by jnovinger to c/postgresql
0 comments fedilink
42
12
2023 State of PostgreSQL Survey Results (www.timescale.com)
submitted 1 year ago by mac to c/postgresql
0 comments fedilink
43
5
Functions to Validate User's Input (fluca1978.github.io)
submitted 1 year ago by jnovinger to c/postgresql
0 comments fedilink
44
8
Postgres Language Server: implementing the Parser (supabase.com)
submitted 1 year ago by jnovinger to c/postgresql
0 comments fedilink
 
 

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

45
4
Transaction Isolation in Postgres, explained (www.thenile.dev)
submitted 1 year ago by lysdexic to c/postgresql
0 comments fedilink
46
4
PGDay Chicago [2024] | PostgreSQL Conference (2024.pgdaychicago.org)
submitted 1 year ago by jnovinger to c/postgresql
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.

47
8
Fly Postgres, managed by Supabase (supabase.com)
submitted 1 year ago by starman to c/postgresql
2 comments fedilink
 
 

A managed Postgres offering developed by Supabase and Fly.io

48
10
Zero downtime postgres updates (knock.app)
submitted 1 year ago by starman to c/postgresql
0 comments fedilink
49
5
Advent of Code in PostgreSQL: Tips and Tricks from 2022 (www.crunchydata.com)
submitted 1 year ago by mac to c/postgresql
0 comments fedilink
50
3
Greenmask Beta Release (www.postgresql.org)
submitted 1 year ago by mac to c/postgresql
0 comments fedilink
view more: ‹ prev next ›