Anayrat links

Less is More - CommandPrompt Inc.

linux · tips · tools

March 8, 2024 at 21:31:23 GMT+1 * · permalink

https://www.commandprompt.com/blog/less-is-more/

rest linter

python-restructuredtext_lint => rst-lint
rstcheck
sphinx-lint

rest · linter

March 7, 2024 at 16:49:12 GMT+1 * · permalink

/shaare/LLOXIQ

Factcheck: What is the carbon footprint of streaming video on Netflix? - Carbon Brief

climat

February 29, 2024 at 11:01:18 GMT+1 * · permalink

https://www.carbonbrief.org/factcheck-what-is-the-carbon-footprint-of-streaming-video-on-netflix/

Eager Aggregation in SQL queries - Simple Talk

PostgreSQL · Aggregate · SQL · tips · Tricks · group_by

February 29, 2024 at 10:17:35 GMT+1 * · permalink

https://www.red-gate.com/simple-talk/databases/postgresql/eager-aggregation-in-sql-queries/

PostgreSQL 16: Playing with pg_stat_io (1) – extends

PostgreSQL · pg16 · pg_stat_io

February 27, 2024 at 13:45:12 GMT+1 * · permalink

https://www.dbi-services.com/blog/postgresql-16-playing-with-pg_stat_io-1-extends/

DigiPDF by La Digitale

pdf

February 26, 2024 at 13:07:52 GMT+1 * · permalink

https://digipdf.app/

Speeding up partial COUNT(*) in Postgres by using LIMIT in a subquery

PostgreSQL · SQL · Tricks

February 24, 2024 at 20:46:43 GMT+1 * · permalink

https://pganalyze.com/blog/5mins-postgres-limited-count

The Rest is History: Investigations of WAL... | Crunchy Data Blog

PostgreSQL · Pitr · WAL

February 24, 2024 at 20:37:22 GMT+1 * · permalink

https://www.crunchydata.com/blog/the-rest-is-history-investigations-of-wal-history-files

Popular git config options

git

February 24, 2024 at 20:26:31 GMT+1 * · permalink

https://jvns.ca/blog/2024/02/16/popular-git-config-options/

Benchmarking PostgreSQL connection poolers: PgBouncer, PgCat and Supavisor | Tembo

pooler

February 22, 2024 at 14:33:48 GMT+1 * · permalink

https://tembo.io/blog/postgres-connection-poolers

Out of range planner statistics and "get_actual_variable_range" in Postgres

PostgreSQL · planner · get_actual_variable_range

February 16, 2024 at 19:59:12 GMT+1 * · permalink

https://pganalyze.com/blog/5mins-postgres-out-of-range-planner-statistics

Magasins vélo en ligne – Carnet de notes

rczbikeshop.com (déstockage uniquement)
bike24.fr
bikediscount.de
bikester.fr
mantel.com
bikeinn
xxcycle.fr
bike-components.de
alltricks.fr
lecyclo.com
decathlon.fr (oui, je mets aussi D4)

velo

February 13, 2024 at 19:37:13 GMT+1 * · permalink

https://n.survol.fr/n/magasins-velo-en-ligne

(mcorbin.fr): Réflexion sur les microservices: avantages, inconvénients, patterns, complexité accidentelle

February 12, 2024 at 10:31:31 GMT+1 * · permalink

https://www.mcorbin.fr/posts/2024-02-12-microservice/

The continuous amnesia issue

February 9, 2024 at 19:00:27 GMT+1 * · permalink

https://www.ufried.com/blog/continuous_amnesia_issue/

What’s new in the Postgres 16 query planner / optimizer

PostgreSQL · planner · optimizer · pg16

February 8, 2024 at 21:01:26 GMT+1 * · permalink

https://www.citusdata.com/blog/2024/02/08/whats-new-in-postgres-16-query-planner-optimizer/

Créer un index B-tree composé efficace, – Le blog Tech d'Indy

un index composé efficace commence par les colonnes dont les valeurs ont les plus faibles cardinalités : le moins de valeurs possibles.

PostgreSQL · index

February 8, 2024 at 20:56:18 GMT+1 * · permalink

https://tech.indy.fr/2022/04/07/creer-un-index-b-tree-compose-efficace/

SELECT 'amazing_features' FROM "postgresql"

SQL · PostgreSQL · CTE · Lateral · Modern_SQL

February 4, 2024 at 10:40:13 GMT+1 * · permalink

https://download.davinkevin.fr/presentations/select-amazing-features-from-postgresql/snowcamp-2024/select-amazing-features-from-postgresql.pdf

What's up in PostGIS today ?

Postgis · versions

February 3, 2024 at 22:15:33 GMT+1 * · permalink

https://whatsup.postgis.app

Stockage physique, gestion des données et VACUUM – BazinGa's

PostgreSQL · Internal · Vacuum · HoT · MVCC

February 3, 2024 at 22:14:00 GMT+1 * · permalink

https://blog.arthurbazin.com/bdd/postgresql/stockage-physique-gestion-des-donnees-et-vacuum

A Comprehensive Overview of PostgreSQL Query Processing Stages - Highgo Software Inc.

PostgreSQL · Internal · planner · hack

February 2, 2024 at 16:02:59 GMT+1 * · permalink

https://www.highgo.ca/2024/01/26/a-comprehensive-overview-of-postgresql-query-processing-stages/