Anayrat links

Intégrez vos produits SwitchBot à Home assistant - Devotics

domotic

January 20, 2023 at 6:26:44 PM GMT+1 * · permalink

https://devotics.fr/integrez-vos-produits-switchbot-a-home-assistant/

GitHub - jnidzwetzki/pg-lock-tracer: A BPF based lock tracer for the PostgreSQL database

PostgreSQL · BPF · Extension · lock

January 19, 2023 at 9:53:24 PM GMT+1 * · permalink

https://github.com/jnidzwetzki/pg-lock-tracer

Debugging PostgreSQL CI failures faster: 4 tips - Microsoft Community Hub

PostgreSQL · hack · meson

January 18, 2023 at 9:39:00 PM GMT+1 * · permalink

https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/debugging-postgresql-ci-failures-faster-4-tips/ba-p/3718371

hex, oct, bin integers in PostgreSQL 16

PostgreSQL · pg16 · types

January 11, 2023 at 11:42:22 AM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/hex-oct-bin-integers-in-postgresql-16/

Improving GROUP BY with CREATE STATISTICS - CYBERTEC

PostgreSQL · Statistics

January 11, 2023 at 11:36:40 AM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/improving-group-by-with-create-statistics/

Rethinking buffer mapping for modern hardware architectures

PostgreSQL · Internal · shared_buffers

January 10, 2023 at 11:44:47 AM GMT+1 * · permalink

https://www.orioledata.com/blog/buffer-management/

Pagination and the problem of the total result count - CYBERTEC

offset · PostgreSQL · SQL · pagination · cursor

January 10, 2023 at 11:44:25 AM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/pagination-problem-total-result-count/

Running fast and slow: experiments with BPF programs performance · Erthalion's blog

BPF · not_read

January 2, 2023 at 11:52:50 PM GMT+1 * · permalink

https://erthalion.info/2022/12/30/bpf-performance/

PostgreSQL 16: part 3 or CommitFest 2022-11 : Postgres Professional

PostgreSQL · pg16

January 2, 2023 at 8:10:15 PM GMT+1 * · permalink

https://postgrespro.com/blog/pgsql/5969929

Using ULIDs at incident.io | Lawrence Jones

PostgreSQL · uuid · ulid

January 2, 2023 at 8:04:07 PM GMT+1 * · permalink

https://blog.lawrencejones.dev/ulid/

GitHub - epoupon/lms: Lightweight Music Server. Access your self-hosted music using a web interface.

subsonic

December 26, 2022 at 7:35:25 PM GMT+1 * · permalink

https://github.com/epoupon/lms

GitHub - Koenkk/zigbee2mqtt: Zigbee 🐝 to MQTT bridge 🌉, get rid of your proprietary Zigbee bridges 🔨

domotic · zigbee

December 25, 2022 at 8:37:36 PM GMT+1 * · permalink

https://github.com/Koenkk/zigbee2mqtt

Welcome to Comprehensive Rust 🦀 - Comprehensive Rust 🦀

rust

December 23, 2022 at 5:32:02 PM GMT+1 * · permalink

https://google.github.io/comprehensive-rust/

https://www.youtube.com/playlist?list=PLiT-kUSX8USXMSdIeV9QZTrem57h_Ksut

December 13, 2022 at 2:23:27 PM GMT+1 * · permalink

https://www.youtube.com/playlist?list=PLiT-kUSX8USXMSdIeV9QZTrem57h_Ksut

Faceting large result sets in PostgreSQL

PostgreSQL · RoaringBitmap

December 8, 2022 at 10:20:47 PM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/faceting-large-result-sets/

Some tips when developing in PostgreSQL’s PL/pgSQL

PostgreSQL · plpgsql

December 7, 2022 at 9:44:41 AM GMT+1 * · permalink

https://www.dbi-services.com/blog/some-tips-when-developing-in-postgresqls-pl-pgsql/

QOwnNotes

tools · markdown

December 5, 2022 at 8:11:38 PM GMT+1 * · permalink

https://www.qownnotes.org/fr/

Signature PDF

pdf

November 26, 2022 at 5:42:06 PM GMT+1 * · permalink

https://pdf.24eme.fr/signature

5mins of Postgres E45: IN lists vs ANY operator: Bind parameters and performance

PostgreSQL · IN · optimizer · pg14

November 24, 2022 at 9:44:31 PM GMT+1 * · permalink

https://pganalyze.com/blog/5mins-postgres-performance-in-lists-vs-any-operator-bind-parameters

The way PG store null value in record - Highgo Software Inc.

PostgreSQL · Internal · NULL

November 16, 2022 at 10:51:55 AM GMT+1 * · permalink

https://www.highgo.ca/2020/10/20/the-way-to-store-null-value-in-pg-record/