Veille de la semaine - Numéro #8
Culture générale
How to use indexing effectively: https://medium.com/nerd-for-tech/how-to-use-indexing-effectively-c69d97f0f983
Know SWIFT? Here's how it works: https://twitter.com/alexxubyte/status/1497253004017209347
Cloud a typed list be flatten: https://blog.ploeh.dk/2022/02/28/can-one-flatten-a-statically-typed-list/
Transitioning to trunk based development: https://medium.com/devcycle/transitioning-to-trunk-based-development-b515ab8488ed
Modernizing our search stack: https://engblog.nextdoor.com/modernizing-our-search-stack-6a56ab87db4e
The painfully shy developer's guide to networking for a better job: https://www.samjulien.com/shy-dev-networking
How I do empathetic and effective technical interviews: https://scullwm.medium.com/how-i-do-empathetic-and-effective-technical-interviews-b3f0ea6eebff
Distributed rate-limiting algorithms: https://medium.com/criteo-engineering/distributed-rate-limiting-algorithms-a35f7e24783
Cloud computing
Automatic release propagation for canary releases with Cloud Run: https://medium.com/google-cloud/automatic-release-propagation-for-canary-releases-with-cloud-run-1ccc2ec74c7f
Apko, build OCI images using APK without Dockerfiles: https://github.com/chainguard-dev/apko
Lxd, a system container and virtual machine manager: https://github.com/lxc/lxd
Database
SQLite 3.38 will improve JSON support: https://tirkarthi.github.io/programming/2022/02/26/sqlite-json-improvements.html
Represent the United Kingdom public record as a knowledge graph: https://towardsdatascience.com/represent-united-kingdoms-public-record-as-a-knowledge-graph-647b6fd07b3d
Writing SQL like Google? Your SQL is bad and you should feel bad about it: https://blog.devgenius.io/write-sql-like-google-your-sql-is-bad-you-should-feel-bad-4fbacd1fbd3
What GraphQL can learn from databases: https://thenewstack.io/what-graphql-can-learn-from-databases/
OrioleDB, a new storage engine for Postgres: https://github.com/orioledb/orioledb
Useful database / SQL tricks for data engineering: https://medium.com/@DakaiZhou/useful-database-sql-tricks-for-data-engineering-83fa671cc1d7
SQL query optimization: https://betterprogramming.pub/sql-query-optimization-level-up-your-sql-performance-tuning-d93af175b24b
Consider explaining a query before executing it: https://twitter.com/tobias_petry/status/1499467708290805760
Analyzing iMessage with SQL: https://databasedive.com/analyzing-imessage-with-sql-5e3be5b9159
how to setup Postgres High-Availability using Petroni: https://databasedive.com/how-to-set-up-postgresql-high-availability-with-patroni-c91450ec3c16
CI / CD
The art of automating automation: https://medium.com/paypal-tech/the-art-of-automating-automation-17b32594a41f
PHP
Which methods are optimized in the PHP compiler: https://tideways.com/profiler/blog/compiler-optimized-php-functions