Anayrat links

Data for Good x Bayes Impact

June 29, 2018 at 12:05:31 PM GMT+2 * · permalink

http://www.dataforgood.fr

How not to structure your database-backed web applications: a study of performance bugs in the wild

Publication · database

June 29, 2018 at 12:01:50 PM GMT+2 * · permalink

https://hyperloop-rails.github.io/220-HowNotStructure.pdf

Pg11 pgday 2018

PostgreSQL

June 29, 2018 at 12:01:06 PM GMT+2 * · permalink

https://www.slideshare.net/JeanChristopheArnu/pg11-pgday-2018

Postgres 11 highlight - New System Roles

PostgreSQL · roles

June 29, 2018 at 10:45:37 AM GMT+2 * · permalink

https://paquier.xyz/postgresql-2/postgres-11-new-system-roles/

Portable Services with systemd v239

systemd · linux

June 29, 2018 at 10:44:35 AM GMT+2 * · permalink

http://0pointer.net/blog/walkthrough-for-portable-services.html

Introduction to Data Vault Modeling

modelisation · sql · data_vault · not_read

June 29, 2018 at 10:39:49 AM GMT+2 * · permalink

https://fr.slideshare.net/kgraziano/introduction-to-data-vault-modeling

Default Partition - Adopting the Odds | EnterpriseDB

PostgreSQL · partionning

June 29, 2018 at 10:37:35 AM GMT+2 * · permalink

https://www.enterprisedb.com/blog/default-partition-adopting-odds

Optimizing queries on TimescaleDB hypertables with thousands of partitions

PostgreSQL · TimescaleDB

June 29, 2018 at 10:37:10 AM GMT+2 * · permalink

https://blog.timescale.com/optimizing-queries-timescaledb-hypertables-with-partitions-postgresql-6366873a995d

PostgreSQL Concurrency: Data Modification Language

PostgreSQL · sql

June 26, 2018 at 9:40:26 AM GMT+2 * · permalink

https://tapoueh.org/blog/2018/06/postgresql-concurrency-data-modification-language/

Improve run-time partition pruning to handle any stable expression.

PostgreSQL · partition_pruning · partionning

June 26, 2018 at 9:39:54 AM GMT+2 * · permalink

https://www.depesz.com/2018/06/25/waiting-for-postgresql-11-improve-run-time-partition-pruning-to-handle-any-stable-expression/

Walking with the Elephant: Planning queries involving foreign PostgreSQL tables

PostgreSQL · planner · FDW

June 23, 2018 at 10:26:56 AM GMT+2 * · permalink

http://ashutoshpg.blogspot.com/2018/06/planning-queries-involving-foreign.html

Upgrade your partitioning from inheritance to declarative

PostgreSQL · partionning

June 23, 2018 at 10:26:31 AM GMT+2 * · permalink

http://ashutoshpg.blogspot.com/2018/06/upgrade-your-partitioning-from.html

Using Cryptographic Hardware to Secure Applications

PostgreSQL · Crypto

June 22, 2018 at 2:22:05 PM GMT+2 * · permalink

https://momjian.us/main/writings/crypto_hw_use.pdf

Scaling Postgres at Affinity with Citus

PostgreSQL · Performance · citus

June 22, 2018 at 2:21:28 PM GMT+2 * · permalink

https://build.affinity.co/scaling-postgres-at-affinity-with-citus-bc93bb7f4441

Tuning Input/Output (I/O) Operations for PostgreSQL | Severalnines

PostgreSQL · Performance

June 22, 2018 at 2:20:58 PM GMT+2 * · permalink

https://severalnines.com/blog/tuning-io-operations-postgresql

Fun with SQL: Functions in Postgres

PostgreSQL · sql

June 22, 2018 at 8:20:01 AM GMT+2 * · permalink

https://www.citusdata.com/blog/2018/06/21/fun-with-sql-functions/

Robert Haas: Using force_parallel_mode Correctly

PostgreSQL · Parallel

June 21, 2018 at 5:55:30 PM GMT+2 * · permalink

http://rhaas.blogspot.com/2018/06/using-forceparallelmode-correctly.html

Missing Data - Simple Talk

sql · celko

June 20, 2018 at 11:08:53 PM GMT+2 * · permalink

https://www.red-gate.com/simple-talk/sql/sql-development/missing-data-2/

Procédures

PostgreSQL · sql · procedure

June 17, 2018 at 2:14:18 PM GMT+2 * · permalink

http://pgphil.ovh/procedure_11_beta_01.php

GitHub - djrobstep/migra: Like diff but for PostgreSQL schemas

PostgreSQL · schema

June 15, 2018 at 7:55:34 PM GMT+2 * · permalink

https://github.com/djrobstep/migra