Anayrat links

Simplifying Recursive SQL Queries

August 4, 2018 at 12:09:16 PM GMT+2 * · permalink

https://haughtcodeworks.com/blog/software-development/recursive-sql-queries-using-ctes/

Learn Go in Y Minutes

golang

August 3, 2018 at 3:00:58 PM GMT+2 * · permalink

https://learnxinyminutes.com/docs/go/

Designing the most performant Row Level Security strategy in Postgres

PostgreSQL · RLS · Security

August 3, 2018 at 2:07:52 PM GMT+2 * · permalink

https://medium.com/@cazzer/designing-the-most-performant-row-level-security-strategy-in-postgres-a06084f31945

GitHub - avito-tech/pg_reindex: Reindexing PostgreSQL databases

PostgreSQL · reindex

August 2, 2018 at 7:54:30 PM GMT+2 * · permalink

https://github.com/avito-tech/pg_reindex

Scheduled Data Processing: How to use cron?

PostgreSQL

August 1, 2018 at 9:38:02 PM GMT+2 * · permalink

https://tapoueh.org/blog/2018/08/scheduled-data-processing-how-to-use-cron/

It's all in database: Parallel index-only scan in PostgreSQL

PostgreSQL · index · Parallel

July 31, 2018 at 1:30:56 PM GMT+2 * · permalink

https://rafiasabih.blogspot.com/2018/07/parallel-index-only-scan-in-postgresql.html

PostgreSQL Triggers and Stored Function Basics | Severalnines

PostgreSQL · Trigger · plpgsql

July 30, 2018 at 1:45:36 PM GMT+2 * · permalink

https://severalnines.com/blog/postgresql-triggers-and-stored-function-basics

What you should know about database storage and retrieval.

index · Hash · Btree · LSM

July 28, 2018 at 5:21:46 PM GMT+2 * · permalink

https://ordepdev.me/posts/what-you-should-know-about-database-storage-and-retrieval

Aller plus loin avec avec ICU (Postgres 10)

PostgreSQL · ICU

July 28, 2018 at 1:28:41 PM GMT+2 * · permalink

http://blog-postgresql.verite.pro/2018/07/27/icu_ext.html

Exposing more of ICU to PostgreSQL

PostgreSQL · ICU

July 26, 2018 at 3:07:06 PM GMT+2 * · permalink

https://postgresql.verite.pro/blog/2018/07/25/icu-extension.html

Jignesh Shah's Blog: Loading data in PostgreSQL 11 Using Native Logical Replication from PostgreSQL 10 in Amazon RDS

PostgreSQL · Replication · logique · RDS · cloud

July 26, 2018 at 3:05:56 PM GMT+2 * · permalink

http://jkshah.blogspot.com/2018/07/loading-data-in-postgresql-11-using.html

Batch Updates and Concurrency

PostgreSQL · _on_conflict · UPSERT

July 24, 2018 at 6:53:30 PM GMT+2 * · permalink

https://tapoueh.org/blog/2018/07/batch-updates-and-concurrency/

PostgreSQL Time-based Partitioning for IoT Data using pg_partman |

PostgreSQL · partionning · Extension

July 24, 2018 at 6:53:03 PM GMT+2 * · permalink

https://blog.2ndquadrant.com/postgresql-time-based-partitioning-iot-pgpartman/

One of those things: pgbouncer and self-signed certificates

PostgreSQL · PgBouncer · certificate

July 23, 2018 at 7:41:45 PM GMT+2 * · permalink

http://thebuild.com/blog/2018/07/23/one-of-those-things-pgbouncer-and-self-signed-certificates/

PostgreSQL LISTEN/NOTIFY

PostgreSQL · listen

July 19, 2018 at 9:14:10 PM GMT+2 * · permalink

https://tapoueh.org/blog/2018/07/postgresql-listen/notify/

Ask TOM "IN & EXISTS"

can you give me some example at which situation
IN is better than exist, and vice versa.

sql

July 18, 2018 at 9:47:48 PM GMT+2 * · permalink

https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:953229842074

pg_rewind and checkpoints: caution!

pg_rewind · PostgreSQL

July 18, 2018 at 9:07:52 PM GMT+2 * · permalink

http://thebuild.com/blog/2018/07/18/pg_rewind-and-checkpoints-caution/

Uniting SQL and NoSQL for Monitoring: Why PostgreSQL is the ultimate data store for Prometheus

PostgreSQL · TimescaleDB

July 18, 2018 at 9:04:42 PM GMT+2 * · permalink

https://blog.timescale.com/sql-nosql-data-storage-for-prometheus-devops-monitoring-postgresql-timescaledb-time-series-3cde27fd1e07

It's all in database: Performance of parallel index scans in PostgreSQL

PostgreSQL · Parallel · index

July 18, 2018 at 9:03:45 PM GMT+2 * · permalink

https://rafiasabih.blogspot.com/2018/07/performance-of-parallel-index-scans-in.html

How SQL DISTINCT and ORDER BY are Related – Java, SQL and jOOQ.

PostgreSQL · sql

July 17, 2018 at 12:34:10 PM GMT+2 * · permalink

https://blog.jooq.org/2018/07/13/how-sql-distinct-and-order-by-are-related/