Bookmarks with tag "db", page 2 of 8

Git for Data.

Open-Source Headless CMS

YouTube-like Short IDs as Postgres Primary Keys.

A headless CMS

At work I was tasked to migrate our time-series analytics data from CSV file dumps that we’ve been feeding into Power BI to a dedicated database. Our Rails app’s primary database is currently MariaDB, but we wanted to have our analytics data in a separate database either way, so this was a good opportunity to use Postgres which we’re most comfortable with anyway.

Learn about smaller indexes with B-Tree Deduplication, Extended Statistics Improvements, Parallel VACUUM, improved WAL Usage Stats in Postgres 13, and more.

Git Query language is a SQL like language to perform queries on .git files with supports of most of SQL features such as grouping, ordering and aggregations functions

Managing distributed transactions across multiple microservices is challenging. Two solutions, two-phase commits and the Saga pattern are explored.

TL;DR: When you are making a new application that requires persistent storage of data, like is the case for most web applications, your default choice should be Postgres

SQL window functions allow us to see the rows in a table with a new column showing a running total, rank or moving average.

A collaborative offline-first wrapper around SQLite designed to synchronize web application state between users, devices, and the edge.