Anayrat links

Be careful with “public” in PostgreSQL

October 4, 2022 at 10:47:57 AM GMT+2 * · permalink

https://www.dbi-services.com/blog/be-careful-with-public-in-postgresql/

GitHub - kakoni/awesome-healthcare: Curated list of awesome open source healthcare software, libraries, tools and resources.

awesome

October 4, 2022 at 10:40:01 AM GMT+2 * · permalink

https://github.com/kakoni/awesome-healthcare

Test de Lixee Zlinky : La téléinformation en Zigbee avec Home Assistant et Jeedom

linky

domotic

October 3, 2022 at 10:53:02 AM GMT+2 * · permalink

https://www.domo-blog.fr/test-lixee-teleinformation-zigbee-avec-home-assistant-jeedom/

How Unique Index Works in PG - Highgo Software Inc.

PostgreSQL · index · unique · Internal

September 30, 2022 at 10:19:31 PM GMT+2 * · permalink

https://www.highgo.ca/2022/09/30/how-unique-index-works-in-pg/

ESPHome — ESPHome

domotic · esp32

September 20, 2022 at 11:39:46 PM GMT+2 * · permalink

https://esphome.io/

Rome2rio: discover how to get anywhere

September 15, 2022 at 12:18:15 PM GMT+2 * · permalink

https://www.rome2rio.com

LXC and LXD: a different container story

lxc · lxd · linux

September 13, 2022 at 11:34:35 PM GMT+2 * · permalink

https://lwn.net/Articles/907613/

Auto setup remote branch and never again see an error about the missing upstream | pawelgrzybek.com

    git config --global --add push.default current
    git config --global --add push.autoSetupRemote true

git

September 13, 2022 at 3:37:09 PM GMT+2 * · permalink

https://pawelgrzybek.com/auto-setup-remote-branch-and-never-again-see-an-error-about-the-missing-upstream/

GitHub - afiskon/postgresql-extensions: Experiments with PostgreSQL extensions

PostgreSQL · hack · Extension · Internal

September 13, 2022 at 1:56:53 PM GMT+2 * · permalink

https://github.com/afiskon/postgresql-extensions

GitHub - supabase/pg_jsonschema: PostgreSQL extension providing JSON Schema validation

PostgreSQL · JSON · pgx

September 7, 2022 at 11:35:45 AM GMT+2 * · permalink

https://github.com/supabase/pg_jsonschema

GitHub - johnkerl/miller: Miller is like awk, sed, cut, join, and sort for name-indexed data such as CSV, TSV, and tabular JSON

csv · tools · JSON

September 6, 2022 at 1:32:52 PM GMT+2 * · permalink

https://github.com/johnkerl/miller

Fixing Slow PostgreSQL Queries: How to Make a Smart Optimizer More Stupid

ORDER BY a + 0

PostgreSQL · optimizer · Tricks

August 30, 2022 at 10:03:54 PM GMT+2 * · permalink

https://ottertune.com/blog/how-to-fix-slow-postgresql-queries

Rust Language Cheat Sheet

rust · cheatsheet

August 30, 2022 at 10:25:57 AM GMT+2 * · permalink

https://cheats.rs/

GitHub - mfvanek/pg-index-health-sql: pg-index-health-sql is a set of sql-queries for analyzing and maintaining indexes health in Postgresql databases.

tools · PostgreSQL

August 27, 2022 at 10:15:31 AM GMT+2 * · permalink

https://github.com/mfvanek/pg-index-health-sql

PostgreSQL 15: Stats Collector Gone? What's New? - Percona Database Performance Blog

pg15 · PostgreSQL

August 27, 2022 at 10:02:56 AM GMT+2 * · permalink

https://www.percona.com/blog/postgresql-15-stats-collector-gone-whats-new/

Rise of the Anti-Join

PostgreSQL · Join · anti-join

August 17, 2022 at 12:18:13 PM GMT+2 * · permalink

https://www.crunchydata.com/blog/rise-of-the-anti-join

Queries in PostgreSQL: 6. Hashing : Postgres Professional

PostgreSQL · Internal · Hash · Join

August 17, 2022 at 12:05:46 PM GMT+2 * · permalink

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

Column order in PostgreSQL does matter - CYBERTEC

PostgreSQL · column_storage

July 28, 2022 at 2:06:09 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/column-order-in-postgresql-does-matter/

Better SQL functions in PostgreSQL v14 - CYBERTEC

PostgreSQL · pg14 · functions

July 28, 2022 at 1:59:44 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/better-sql-functions-in-postgresql-v14/

My Notes on GitLab Postgres Schema Design – Shekhar Gulati

gitlab · PostgreSQL · modelisation · schema

July 28, 2022 at 1:20:29 PM GMT+2 * · permalink

https://shekhargulati.com/2022/07/08/my-notes-on-gitlabs-postgres-schema-design/