Anayrat links

Robert Haas: Talking about the PostgreSQL Optimizer at CMU

June 22, 2021 at 9:32:20 PM GMT+2 * · permalink

http://rhaas.blogspot.com/2021/06/talking-about-postgresql-optimizer-at.html

INDEX / REINDEX progress report (PG12+)

PostgreSQL · snippet · index

June 22, 2021 at 7:59:27 PM GMT+2 * · permalink

https://gitlab.com/-/snippets/2138417

Docker : découverte des bases - Code Heroes

Docker

June 14, 2021 at 9:05:07 PM GMT+2 * · permalink

https://www.codeheroes.fr/2021/06/14/docker-decouverte-des-bases/

GitHub - Networks-Learning/stackexchange-dump-to-postgres: Python scripts to import StackExchange data dump into Postgres DB.

stackoverflow · PostgreSQL

June 11, 2021 at 11:05:33 AM GMT+2 * · permalink

https://github.com/Networks-Learning/stackexchange-dump-to-postgres

GitHub - SkobelevIgor/stackexchange-xml-converter: Stackexchange (e.g., stackoverflow) data dump converter from XML to CSV format.

stackoverflow

June 11, 2021 at 11:05:02 AM GMT+2 * · permalink

https://github.com/SkobelevIgor/stackexchange-xml-converter

GitHub - niderhoff/nlp-datasets: Alphabetical list of free/public domain datasets with text data for use in Natural Language Processing (NLP)

nlp · Opendata · dataset

June 11, 2021 at 10:39:37 AM GMT+2 * · permalink

https://github.com/niderhoff/nlp-datasets

GitHub - pemistahl/lingua-rs: 👄 The most accurate natural language detection library in the Rust ecosystem, suitable for long and short text alike

rust · FTS · nlp · language-recognition · language-detection

June 11, 2021 at 10:24:59 AM GMT+2 * · permalink

https://github.com/pemistahl/lingua-rs

Leipzig Corpora Collection / Deutscher Wortschatz

dataset · nlp · Opendata · language-recognition · language-detection

June 11, 2021 at 10:23:17 AM GMT+2 * · permalink

https://wortschatz.uni-leipzig.de/en

Supervision de SystemD avec systemd-cgtop | Commandes et Système | IT-Connect

systemd · cgroup · linux

June 9, 2021 at 10:34:17 PM GMT+2 * · permalink

https://www.it-connect.fr/supervision-de-systemd-avec-systemd-cgtop

Better Range Types in Postgres 14: Turning 100 Lines of SQL Into 3

pg14 · PostgreSQL · range

June 9, 2021 at 9:46:47 PM GMT+2 * · permalink

https://blog.crunchydata.com/blog/better-range-types-in-postgres-14-turning-100-lines-of-sql-into-3

Postgres: UPDATE will work differently in v14

pg14 · PostgreSQL · partition_pruning · partionning

June 9, 2021 at 2:07:40 PM GMT+2 * · permalink

https://amitlan.com/2021/06/08/pg14-update-perf.html

GitHub - meilisearch/MeiliSearch: Lightning Fast, Ultra Relevant, and Typo-Tolerant Search Engine

rust · FTS

June 6, 2021 at 8:48:15 PM GMT+2 * · permalink

https://github.com/meilisearch/MeiliSearch

GitHub - greyblake/whatlang-rs: Natural language detection library for Rust. Try demo online: https://whatlang.org/

rust · FTS · nlp · language-recognition · language-detection

June 6, 2021 at 8:40:54 PM GMT+2 * · permalink

https://github.com/greyblake/whatlang-rs

Hash Joins Past, Present & Future

PostgreSQL · Hash · Join

June 3, 2021 at 11:33:25 PM GMT+2 * · permalink

https://www.pgcon.org/2017/schedule/attachments/455_pgcon-2017-hash-joins.pdf

WAL in PostgreSQL: 3. Checkpoint : Postgres Professional

PostgreSQL · checkpoint · WAL

June 3, 2021 at 6:04:50 PM GMT+2 * · permalink

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

PostgreSQL: Time and Temporal Data | Korban.net

PostgreSQL · SQL · time

June 3, 2021 at 5:17:39 PM GMT+2 * · permalink

https://korban.net/postgres/book/

Bring your own CI/CD.

drone · CI

June 3, 2021 at 2:58:11 PM GMT+2 * · permalink

https://icinga.com/blog/2021/06/03/bring-your-own-ci-cd/

GitHub - timClicks/pg_rot13: A PostgreSQL extension module to apply ROT13 to text

PostgreSQL · Extension · rust

June 2, 2021 at 3:12:44 PM GMT+2 * · permalink

https://github.com/timClicks/pg_rot13

Enabling and disabling autovacuum in PostgreSQL | CYBERTEC

Vacuum · PostgreSQL

June 2, 2021 at 1:19:06 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/enabling-and-disabling-autovacuum-in-postgresql/

GitHub - plasma-umass/scalene: Scalene: a high-performance, high-precision CPU, GPU, and memory profiler for Python

Python · profiling

June 1, 2021 at 5:48:37 PM GMT+2 * · permalink

https://github.com/plasma-umass/scalene