Anayrat links

Preventing SQL Injections

PostgreSQL · sql · Security

August 30, 2018 at 9:58:09 AM GMT+2 * · permalink

https://tapoueh.org/blog/2018/08/preventing-sql-injections/

A Missing Link in Postgres 11: Fast Column Creation with Defaults — Brandur Leach

PostgreSQL · sql · constraint · schema_migration

August 30, 2018 at 9:57:46 AM GMT+2 * · permalink

https://brandur.org/postgres-default

pg_upgrade 9.1 → 9.5 trainline

PostgreSQL · Upgrade

August 28, 2018 at 4:41:39 PM GMT+2 * · permalink

https://paulrbr.io/slides/pg_upgrade-9.1_9.5-leboncoin-10112016.pdf

What hot_standby_feedback in PostgreSQL really does - Cybertec

PostgreSQL · Replication · Vacuum

August 28, 2018 at 1:00:43 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/what-hot_standby_feedback-in-postgresql-really-does/

Scaling at Instacart: Distributing Data Across Multiple Postgres Databases with Rails

PostgreSQL · ruby

August 28, 2018 at 9:07:03 AM GMT+2 * · permalink

https://tech.instacart.com/scaling-at-instacart-distributing-data-across-multiple-postgres-databases-with-rails-13b1e4eba202

Greenplum Database: Evolving Advanced Analytics on PostgreSQL

PostgreSQL · Greenplum

August 27, 2018 at 9:51:01 PM GMT+2 * · permalink

https://wiki.postgresql.org/images/e/e5/PPgconfbr-2k18-greenplum.pdf

Real world SSD wearout – okmeter.io blog

PostgreSQL · SSD · storage · System

August 27, 2018 at 8:01:24 PM GMT+2 * · permalink

https://blog.okmeter.io/real-world-ssd-wearout-a3396a35c663

Beware of your next glibc upgrade

PostgreSQL · linux · libc

August 27, 2018 at 8:01:08 PM GMT+2 * · permalink

https://postgresql.verite.pro/blog/2018/08/27/glibc-upgrade.html

ProvSQL: Provenance and Probability Management in PostgreSQL

PostgreSQL · Publication · not_read

August 27, 2018 at 8:00:46 PM GMT+2 * · permalink

http://www.vldb.org/pvldb/vol11/p2034-senellart.pdf

Understanding System Columns in PostgreSQL | Severalnines

PostgreSQL · Internal

August 27, 2018 at 7:59:47 PM GMT+2 * · permalink

https://severalnines.com/blog/understanding-system-columns-postgresql

Geolocation with PostgreSQL

PostgreSQL · ip4r · GiST

August 26, 2018 at 4:22:58 PM GMT+2 * · permalink

https://tapoueh.org/blog/2018/08/geolocation-with-postgresql/

Simple/hard metrics that help reduce MTTR when looking for a root cause

monitoring

August 26, 2018 at 12:59:27 PM GMT+2 * · permalink

https://blog.okmeter.io/simple-hard-metrics-that-help-reduce-mttr-when-looking-for-a-root-cause-637eaf5b3518

What’s new in MariaDB 10.3

MariaDB

August 26, 2018 at 12:57:51 PM GMT+2 * · permalink

https://modern-sql.com/blog/2018-08/whats-new-in-mariadb-10.3

Cost of a Join

PostgreSQL · Join

August 16, 2018 at 3:16:01 PM GMT+2 * · permalink

https://www.brianlikespostgres.com/cost-of-a-join.html

Transactional Data Operations in PostgreSQL Using Common Table Expressions – Rob Conery

sql · PostgreSQL · CTE

August 14, 2018 at 4:57:51 PM GMT+2 * · permalink

https://rob.conery.io/2018/08/13/transactional-data-operations-in-postgresql-using-common-table-expressions/

Synthetic Data Blog | Tonic

subset

August 13, 2018 at 3:01:55 PM GMT+2 * · permalink

https://www.tonic.ai/blog/condenser-a-database-subsetting-tool

Partitioning Improvements in PostgreSQL 11œœ

PostgreSQL · partionning

August 12, 2018 at 10:58:29 AM GMT+2 * · permalink

https://wiki.postgresql.org/images/8/82/Alvherre-partitioning-2018.pdf

MySQL High Availability at GitHub | GitHub Engineering

MySQL · HA

August 10, 2018 at 11:16:53 AM GMT+2 * · permalink

https://githubengineering.com/mysql-high-availability-at-github/

GLB: GitHub’s open source load balancer | GitHub Engineering

linux · haproxy

August 10, 2018 at 11:15:02 AM GMT+2 * · permalink

https://githubengineering.com/glb-director-open-source-load-balancer/

Three Steps to pg_rewind Happiness

PostgreSQL · pg_rewind

August 9, 2018 at 9:08:34 PM GMT+2 * · permalink

https://thebuild.com/blog/2018/08/09/three-steps-to-pg_rewind-happiness/