PostgreSQL

1199 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
jnovinger@programming.dev
starman@programming.dev
listing: all - local
51
18
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
2 comments fedilink
 
 

GDS is leading the digital transformation of the UK government.

52
5
Waiting for Postgres 17: Incremental base backups (pganalyze.com)
submitted 2 years ago by starman@programming.dev to c/postgresql@programming.dev
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.

53
30
Don't Do This - PostgreSQL wiki (wiki.postgresql.org)
submitted 2 years ago by jnovinger@programming.dev to c/postgresql@programming.dev
1 comments fedilink
54
15
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
1 comments fedilink
55
5
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"

56
13
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
1 comments fedilink
57
6
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
58
6
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
59
6
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
60
8
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

61
4
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
62
12
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
63
5
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
64
8
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

65
4
Transaction Isolation in Postgres, explained (www.thenile.dev)
submitted 2 years ago by lysdexic@programming.dev to c/postgresql@programming.dev
0 comments fedilink
66
4
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.

67
7
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

68
10
Zero downtime postgres updates (knock.app)
submitted 2 years ago by starman@programming.dev to c/postgresql@programming.dev
0 comments fedilink
69
5
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
70
3
Greenmask Beta Release (www.postgresql.org)
submitted 2 years ago by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
71
8
PostgreSQL and FIPS mode (peter.eisentraut.org)
submitted 2 years ago by jnovinger@programming.dev to c/postgresql@programming.dev
0 comments fedilink
72
6
PostgreSQL Conference Germany 2024 (www.postgresql.org)
submitted 2 years ago by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
73
2
Data Generator version 4.0 released (www.postgresql.org)
submitted 2 years ago* (last edited 2 years ago) by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
 
 
  • Support for dark visual theme added.
  • SSL implemented.
  • Unicode names of objects are now supported.
  • Support for Windows 11 ARM added.
  • Updated SSH library with ECDSA, Ed25519 keys and Keyboard-interactive authentication method support.
  • Support for PostgreSQL 16.
  • JSON data type is now supported.
  • Schema selection is now available.
  • Encoding option for script file has been added.
  • Files with test data are now supplied with the program installation pack.
  • Many other improvements and fixes.
74
3
Amazon RDS for PostgreSQL now supports major version 16 (aws.amazon.com)
submitted 2 years ago by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
75
4
Exploring a Postgres query plan | notes.eatonphil.com (notes.eatonphil.com)
submitted 2 years ago by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
view more: ‹ prev next ›