Search: [PostgreSQL] - Anayrat links

What's New for Developer's in PostgreSQL 17

PostgreSQL · pg17

September 3, 2024 at 10:32:46 PM GMT+2 * · permalink

https://docs.google.com/presentation/d/1tdqYFHBdkIHVSZNEmh2ZvJPmusoucje-5eyZu-7Lo5I/edit#slide=id.g2e06aaddb08_0_164

How to Get or Create in PostgreSQL | Haki Benita

PostgreSQL · not_read

August 12, 2024 at 12:50:31 PM GMT+2 * · permalink

https://hakibenita.com/postgresql-get-or-create

Talking Postgres with Claire Giordano | How I got started as a developer (& in Postgres) with David Rowley

PostgreSQL · not_read

August 12, 2024 at 12:49:25 PM GMT+2 * · permalink

https://share.transistor.fm/s/35ba396b

Robert Haas: Posting Your Patch On pgsql-hackers

PostgreSQL · not_read · hack

August 12, 2024 at 12:48:52 PM GMT+2 * · permalink

http://rhaas.blogspot.com/2024/08/posting-your-patch-on-pgsql-hackers.html

Robert Haas: PostgreSQL Hacking Workshop - August 2024

PostgreSQL · not_read

August 4, 2024 at 5:10:38 PM GMT+2 * · permalink

http://rhaas.blogspot.com/2024/07/postgresql-hacking-workshop-august-2024.html

Faire vivre une communauté

PostgreSQL · community

August 4, 2024 at 5:10:14 PM GMT+2 * · permalink

https://fljd.in/2024/07/30/faire-vivre-une-communaute/

The state of the Postgres community - Tomas Vondra

PostgreSQL · community

August 4, 2024 at 5:10:02 PM GMT+2 * · permalink

https://vondra.me/posts/the-state-of-the-postgres-community/

Keyset pagination with descending order

PostgreSQL · SQL · offset · pagination

July 16, 2024 at 7:50:41 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/keyset-pagination-with-descending-order/

Synopsis of several compelling features in PostgreSQL 16 | AWS Database Blog

pg16 · PostgreSQL

July 15, 2024 at 12:48:47 PM GMT+2 * · permalink

https://aws.amazon.com/fr/blogs/database/synopsis-of-several-compelling-features-in-postgresql-16/

Check Your Privileges - The PostgreSQL Role System

PostgreSQL · Privileges · not_read

July 11, 2024 at 12:49:17 PM GMT+2 * · permalink

https://thebuild.com/presentations/cyp.pdf

https://tech.instacart.com/creating-a-logical-replica-from-a-snapshot-in-rds-postgres-886d9d2c7343

PostgreSQL · logique · Upgrade

July 6, 2024 at 11:25:23 AM GMT+2 * · permalink

https://tech.instacart.com/creating-a-logical-replica-from-a-snapshot-in-rds-postgres-886d9d2c7343

Gestion des permissions sous PostgreSQL

PostgreSQL · Privileges · Permissions

July 2, 2024 at 5:30:17 PM GMT+2 * · permalink

https://blog.dalibo.com/2024/06/28/permission.html

https://postgresql.verite.pro/blog/2024/07/01/pg17-utf8-collation.html

PostgreSQL · pg17 · ICU · Collation

July 2, 2024 at 2:09:13 PM GMT+2 * · permalink

https://postgresql.verite.pro/blog/2024/07/01/pg17-utf8-collation.html

Online upgrade of replication clusters without downtime

PostgreSQL · Upgrade · logique · pg17 · pg_createsubscriber

June 25, 2024 at 3:22:38 PM GMT+2 * · permalink

https://www.pgevents.ca/events/pgconfdev2024/sessions/session/20/slides/22/ONLINE%20UPGRADE%20OF%20REPLICATION%20CLUSTERS%20WITHOUT%20DOWNTIME_submit.pdf

PostgreSQL 17 and beyond

PostgreSQL · pg17

June 25, 2024 at 2:39:40 PM GMT+2 * · permalink

https://www.pgevents.ca/events/pgconfdev2024/sessions/session/52/slides/36/PostgreSQL%2017%20and%20beyond_conf.pdf

Reduce Vacuum by Using “ON CONFLICT” Directive | 🛩️ Shane Borden's Technology Blog

PostgreSQL · constraint · _on_conflict

June 25, 2024 at 1:29:24 PM GMT+2 * · permalink

https://stborden.wordpress.com/2024/06/18/reduce-vacuum-by-using-on-conflict-directive/

Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 1 – PL/pgSQL | Database and Migration Insights

PostgreSQL · pg17 · plpgsql

June 9, 2024 at 9:22:17 AM GMT+2 * · permalink

https://databaserookies.wordpress.com/2024/06/08/exploring-postgresql-17-a-developers-guide-to-new-features-part-1-pl-pgsql/

On analyse la nouvelle collation de PostgreSQL 17

PostgreSQL · pg17 · Collation

June 9, 2024 at 9:16:53 AM GMT+2 * · permalink

https://blog-postgresql.verite.pro/2024/06/07/pg17-utf8-collation.html

Collations from A to Z

PostgreSQL · Collation · pg17 · ICU

June 4, 2024 at 10:05:21 PM GMT+2 * · permalink

https://www.pgevents.ca/events/pgconfdev2024/sessions/session/95/slides/26/pgcon24_collation.pdf

Default Sort Order in Db2, SQL Server, Oracle & Postgres 17 | Ardent Performance Computing

PostgreSQL · pg17 · Collation

May 22, 2024 at 8:20:41 PM GMT+2 * · permalink

https://ardentperf.com/2024/05/22/default-sort-order-in-db2-sql-server-oracle-postgres-17/