Upsert in SQL
https://antonz.org/sql-upsert/
Inserting and updating data with a single query.
Fix Posts List Performance + cursor-based pagination by phiresky · Pull Request #3872 · LemmyNet/lemmy
Fix Posts List Performance + cursor-based pagination by phiresky · Pull Request #3872 · LemmyNet/lemmy
https://github.com/LemmyNet/lemmy/pull/3872
This PR implements two things: Cursor-based pagination for the /posts/list API request. A new opaque parameter page_v2 is added that fetches the next page based on the previous one. The request n...
Timeseries with PostgreSQL
https://alexplescan.com/posts/2023/07/15/postgres-timeseries/
How to use set-returning functions in PostgreSQL to generate simple timeseries data
How This SQL Command Blew Up a Billion Dollar Company
https://youtu.be/R7VVwfh0Wpo
A story of the Heartland Payment Systems breach from 2007-2009, the world's largest at the time. The specific details of how everything went down is unknown,...
SQL BETWEEN Operator
SQL BETWEEN Operator | Domesticated Brain
https://domesticatedbrain.com/sql-between-operator/
This SQL tutorial explains the way of using the SQL BETWEEN Operator and the SQL NOT BETWEEN Operator to select data from a database table based on a given range.
SQL Aggregate Functions
SQL Aggregate Functions | Domesticated Brain
https://domesticatedbrain.com/sql-aggregate-functions/
This SQL tutorial explains the SQL Aggregate functions which help us to get a single value after processing data in a column
Cloud Backed SQLite: Cloud Backed SQLite
https://sqlite.org/cloudsqlite/doc/trunk/www/index.wiki
SQL:2023 is finished: Here is what’s new
http://peter.eisentraut.org/blog/2023/04/04/sql-2023-is-finished-here-is-whats-new
SQL:2023 has been wrapped. The final text has been submitted by the working group to ISO Central Secretariat, and it’s now up to the ISO gods when it will be published. Based on past experience, it could be between a few weeks and a few months.
Joins 13 Ways
https://justinjaffray.com/joins-13-ways/?a=b
GitHub - saulpw/visidata: A terminal spreadsheet multitool for discovering and arranging data
https://github.com/saulpw/visidata
A terminal spreadsheet multitool for discovering and arranging data - GitHub - saulpw/visidata: A terminal spreadsheet multitool for discovering and arranging data