Anayrat links

PostgresqlCO.NF: PostgreSQL configuration for humans

April 5, 2023 at 11:44:03 AM GMT+2 * · permalink

https://postgresqlco.nf/

Inside logical replication in PostgreSQL: How it works

PostgreSQL · Replication · logique · Internal

March 16, 2023 at 11:07:31 AM GMT+1 * · permalink

https://www.postgresql.fastware.com/blog/inside-logical-replication-in-postgresql

Postgres 15 highlight - Custom WAL Resource Managers

PostgreSQL · WAL · Internal · Extension · hack · pg15

March 15, 2023 at 1:47:16 PM GMT+1 * · permalink

https://paquier.xyz/postgresql-2/postgres-15-custom-rmgr/

Tout sur l’installation domotique de ma maison – Tech2Tech | News, Astuces, Tutos, Vidéos autour de l'informatique

domotic

March 10, 2023 at 1:32:02 PM GMT+1 * · permalink

https://www.tech2tech.fr/tout-sur-linstallation-domotique-de-ma-maison/

Mr. Free Tools - The Best Free Tools & Resources

tools

March 10, 2023 at 11:19:32 AM GMT+1 * · permalink

https://mrfreetools.com/

Postgres 16 highlight - Normalization of utilities in pg_stat_statements

PostgreSQL · pg16 · pg_stat_statements

March 9, 2023 at 2:11:51 PM GMT+1 * · permalink

https://paquier.xyz/postgresql-2/postgres-16-pgstatstatements-norm/

Batteries and chargers

battery

March 4, 2023 at 11:59:59 PM GMT+1 * · permalink

https://lygte-info.dk/info/indexBatteriesAndChargers%20UK.html

The Integer at the End of the Universe: Integer Overflow in Postgres

PostgreSQL · sequence

March 3, 2023 at 7:23:34 PM GMT+1 * · permalink

https://www.crunchydata.com/blog/the-integer-at-the-end-of-the-universe-integer-overflow-in-postgres

Starting PostgreSQL logical replication for some tables based on a dump

PostgreSQL · Replication · logique

March 2, 2023 at 10:23:25 AM GMT+1 * · permalink

https://www.dbi-services.com/blog/starting-postgresql-logical-replication-for-some-tables-based-on-a-dump/

Waiting for PostgreSQL 16 – Add pg_stat_io view, providing more detailed IO statistics – select * from depesz;

PostgreSQL · pg_stat_io · pg16

February 27, 2023 at 10:36:10 PM GMT+1 * · permalink

https://www.depesz.com/2023/02/27/waiting-for-postgresql-16-add-pg_stat_io-view-providing-more-detailed-io-statistics/

Postgres Raster Query Basics

PostgreSQL · Postgis · Raster

February 24, 2023 at 9:13:11 AM GMT+1 * · permalink

https://www.crunchydata.com/blog/postgres-raster-query-basics

How to migrate from Django’s PostgreSQL CI Fields to use a case-insensitive collation - Adam Johnson

PostgreSQL · Collation · LIKE

February 23, 2023 at 10:54:29 PM GMT+1 * · permalink

https://adamj.eu/tech/2023/02/23/migrate-django-postgresql-ci-fields-case-insensitive-collation/

Graphs in the Database: Rdbms In The Social Networks Age

SQL · GraphDB · RECURSIVE · CTE

February 23, 2023 at 6:54:21 PM GMT+1 * · permalink

https://www.slideshare.net/quipo/rdbms-in-the-social-networks-age

Trees In The Database - Advanced data structures

SQL · GraphDB · CTE · RECURSIVE

February 23, 2023 at 6:54:03 PM GMT+1 * · permalink

https://www.slideshare.net/quipo/trees-in-the-database-advanced-data-structures

PostgreSQL Basics: Object Ownership and Default Privileges - Simple Talk

PostgreSQL · Privileges

February 22, 2023 at 9:36:46 AM GMT+1 * · permalink

https://www.red-gate.com/simple-talk/uncategorized/postgresql-basics-object-ownership-and-default-privileges/

Waiting for Postgres 16: Cumulative I/O statistics with pg_stat_io

PostgreSQL · pg16 · pg_stat_io

February 15, 2023 at 1:10:46 PM GMT+1 * · permalink

https://pganalyze.com/blog/pg-stat-io

PostgreSQL 16: More I/O statistics

PostgreSQL · pg16 · Statistics · pg_stat_io

February 14, 2023 at 11:06:44 AM GMT+1 * · permalink

https://www.dbi-services.com/blog/postgresql-16-more-i-o-statistics/

Paris Web - Transferts de données : est-ce que je peux encore utiliser des fournisseurs américains ?

rgpd

February 10, 2023 at 3:27:59 PM GMT+1 * · permalink

https://www.paris-web.fr/2022/conferences/transferts-de-donnees-est-ce-que-je-peux-encore-utiliser-des-fournisseur-americains.php

GitHub - cybertec-postgresql/pgfaceting: Faceted query acceleration for PostgreSQL using roaring bitmaps

RoaringBitmap · PostgreSQL · Extension · facet

February 8, 2023 at 4:02:18 PM GMT+1 * · permalink

https://github.com/cybertec-postgresql/pgfaceting

PostgreSQL unique constraint, but NULL conflicts with everything

PostgreSQL · constraint · Exclusion_constraint · GiST

February 8, 2023 at 2:34:37 PM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/unique-constraint-null-conflicts-with-everything/