121
Supabase Vault
Today we're announcing Vault, a Postgres extension for managing secrets and encryption inside your database.
122
FoundationDB: A distributed unbundled transactional key value store
This paper from Sigmod 2021 presents FoundationDB, a transactional key-value store that supports multi-key strictly serializable transacti...
123
Implementing "seen by" functionality with Postgres
Different approaches for tracking visitor counts with PostgreSQL.
124
Historical weather data API for machine learning, free for non-commercial
Get weather data for the past days, weeks or months
125
Notes on the SQLite DuckDB Paper
SQLite: Past, Present, and Future is a newly published paper authored by Kevin P. Gaffney, Martin Prammer and Jignesh M. Patel from the University of Wisconsin-Madison and D. Richard Hipp, …
126
Why I Enjoy PostgreSQL – Infrastructure Engineer's Perspective
Why I enjoy PostgreSQL - Infrastructure Engineer's Perspective
127
Jepsen: Redpanda 21.10.1
Redpanda is a Kafka -compatible distributed streaming system based around append-only logs. Compared to Kafka, Redpanda aims to offer users lower latencies and reduced operational complexity. It uses the Raft consensus algorithm internally, rather than depending on a separate installation of Zookeeper . Redpanda…
128
How Wikipedia influences judicial behavior
Mixed appraisals of one of the Internet’s great friends (or foes), Wikipedia, are reflected in the slightly dystopian article “List of Wikipedia Scandals”, which sits below a Wikipedia web address. Scrutiny aside, billions of users routinely flock to the online, anonymously editable encyclopedia knowledge bank for…
129
Time-Series Compression Algorithms
These algorithms aren't magic – but combined they can save over 90% of storage costs and speed up queries. Here’s how 5 common ones work.
130
SQLite Release 3.39.0
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
131
132
How to create a dashboard in Python with Jupyter Notebook
Learn how to create a dashboard in Python with Jupyter Notebook, including interactive components and sharing options.
133
A Critique of SQL, 40 Years Later
Homepage of Carlin Eng
134
135
Google Analytics 4
Universal Analytics is sunsetting next year. Prepare now by moving over to the next generation Analytics solution, Google Analytics 4.
136
New ScyllaDB Go Driver: Faster Than GoCQL and Its Rust Counterpart
How we built a new Go ScyllaDB driver that’s almost 4x faster than its GoCQL predecessor and 2X faster than its Rust counterpart.
137
Backblaze Drive Stats for Q1 2022
Backblaze wants to be as transparent as possible with our customers about our business. Here’s what you need to know about our drives in Q1 2022.
138
Cracking encrypted LastPass vaults
The recent (2022) compromise of Lastpass included email addresses, home addresses, names, and encrypted customer vaults. In this post I will demonstrate how attackers may leverage tools like Hashcat to crack an encrypted vault with a weak password.
139
Where in the world are Trader Joe’s warehouses? (2015)
Personal website of Samuel Burer, Tippie Rollins Professor of Business Analytics, University of Iowa.
140
PostgreSQL views and materialized views and how they influenced TimescaleDB
Continuous aggregates are one of Timescale's most popular features, but you can’t fully understand them without some context on Postgres views and materialized.
141
Postgres Data Flow
What happens when you query Postgres? Data can actually come from many different places like the application cache, buffer cache, and even down into the physical disk cache. This post surveys the data storage and flow of Postgres data.
142
How and why the Relational Model works for databases
This is a note on, the Turing Award laureate, Ted Codd’s revolutionary paper — A Relational Model of Data for Large Shared Data Banks. In this post, I will review the paper and add my comments with a perspective from modern distributed databases.
143
144
A Graph-Based Firebase
In A Database in the Browser , I wrote that the schleps we face as UI engineers are actually database problems in disguise [1] . This begged the question: would a database-looking solution solve them?
145
Zero-downtime schema migrations in Postgres using Reshape
About six months back, I wrote a post on how to use views in Postgres to encapsulate tables and create a versioned interface to a database. At the end of the…
146
147
148
Index Merges vs. Composite Indexes in Postgres and MySQL
Composite indexes aka multi-column indexes are about 10x faster than index merges. In Postgres, the gap is larger than in MySQL because Postgres doesn’t support index-only scans for queries that involve index merges.
149
150
Analyzing Indie Hacker Products with Verified Revenue
Indie Hackers is a wonderful community for founders, a vast ocean of shared knowledge and a place to showcase your product journey. A lot of people are sharing their products there along with the revenue, often verified by Stripe. We analyzed the available data to check how much revenue are those products making and…