PostgreSQL

745 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
Prague PostgreSQL Developer Day 2024 / Call for Papers & Sponsors (www.postgresql.org)
submitted 1 year ago by mac to c/postgresql
0 comments fedilink
27
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
28
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.

29
31
Don't Do This - PostgreSQL wiki (wiki.postgresql.org)
submitted 1 year ago by jnovinger to c/postgresql
1 comments fedilink
30
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
31
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"

32
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
33
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
34
6
How to setup TLS connection for PostgreSQL (postgr.es)
submitted 1 year ago by [email protected] to c/postgresql
0 comments fedilink
35
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
36
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

37
4
An Introduction to EDB's Transparent Data Encryption - Stormatics (stormatics.tech)
submitted 1 year ago by jnovinger to c/postgresql
0 comments fedilink
38
12
2023 State of PostgreSQL Survey Results (www.timescale.com)
submitted 1 year ago by mac to c/postgresql
0 comments fedilink
39
5
Functions to Validate User's Input (fluca1978.github.io)
submitted 1 year ago by jnovinger to c/postgresql
0 comments fedilink
40
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

41
4
Transaction Isolation in Postgres, explained (www.thenile.dev)
submitted 1 year ago by lysdexic to c/postgresql
0 comments fedilink
42
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.

43
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

44
10
Zero downtime postgres updates (knock.app)
submitted 1 year ago by starman to c/postgresql
0 comments fedilink
45
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
46
3
Greenmask Beta Release (www.postgresql.org)
submitted 1 year ago by mac to c/postgresql
0 comments fedilink
47
9
PostgreSQL and FIPS mode (peter.eisentraut.org)
submitted 1 year ago by jnovinger to c/postgresql
0 comments fedilink
48
6
PostgreSQL Conference Germany 2024 (www.postgresql.org)
submitted 1 year ago by mac to c/postgresql
0 comments fedilink
49
2
Data Generator version 4.0 released (www.postgresql.org)
submitted 1 year ago* (last edited 1 year ago) by mac to c/postgresql
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.
50
3
Amazon RDS for PostgreSQL now supports major version 16 (aws.amazon.com)
submitted 1 year ago by mac to c/postgresql
0 comments fedilink
view more: ‹ prev next ›