121
122
Devious SQL: Message Queuing Using Native PostgreSQL
An interesting question came up on the postgresql IRC channel about how to use native PostgreSQL features to handle some sort of queuing behavior. While the specific usage was related to handling serialization of specific events to some external broker, the specifics are less important than the overall structure.
123
Multiranges in Postgres
Multiranges are a new feature in PostgreSQL 14. Here's a brief introduction on how to use them - learn the basics & important new uses.
124
PlanetScale increases plans to include billions of reads
PlanetScale offers the world’s fastest and most scalable cloud hosting for Vitess, Neki, and Postgres.
125
It’s fine, Rewind: Revert a migration without losing data
Learn how PlanetScale lets you revert changes to your database after a migration with no downtime and zero data loss.
126
Bottomless, consumption-based storage for PostgreSQL built on Amazon S3
Data management decisions don’t have to be costly. Introducing Tiered Storage, a low-cost infinite storage tier for your historical data needs.
127
Supabase Vault is now in Beta
A Postgres extension to store encrypted secrets and encrypt data.
128
Improving Postgres text search speed
CharityAPI.org improved our Postgres response time so that searches initiated via our API were 760% faster without adding an additional tool like Elastic Search. This is how we did it.
129
Why use Paxos instead of Raft?
TLDR: Neon separates storage and compute, substituting the PostgreSQL persistency layer with a custom-made distributed storage written in Rust. Due to this separation, some nodes don’t have persistent disks. The original Raft paper works only with uniform nodes, but Paxos variants support proposers without storage and…
130
Querying Postgres Tables Directly from DuckDB
DuckDB can now directly query tables stored in PostgreSQL and speed up complex analytical queries without duplicating data.
131
IPFS Backed by Decentralized Storage
Filebase now supports IPFS! Learn more about our latest network integration and how you can pin data onto IPFS in seconds, at a fraction of the cost of existing services.
132
Simple, Fast, and Scalable Reverse Image Search
How we built our first iteration of content matching at Canva.
133
How Palo Alto Networks Replaced Kafka with ScyllaDB for Stream Processing
Learn how Palo Alto Networks rearchitected their real time data systems using ScyllaDB’s monstrously fast and scalable NoSQL database.
134
Introducing ArcticDB: A Database for Observability
Continuous profiling needed a columnar database, so we built it.
135
136
137
Quirks, Caveats, and Gotchas in SQLite
The SQL language is a "standard". Even so, no two SQL database engines work exactly alike. Every SQL implementation has its own peculiarities and oddities, and SQLite is no exception to this rule.
138
Propagation of mistakes in papers
A blog by and for database architects.
139
Building a High Performance Data Integration Framework in Go
Behind the scenes of building CloudQuery — architectural decisions, engineering challenges, and lessons learned creating the open-source cloud asset inventory.
140
Supabase Wrappers: A framework for building Postgres foreign data wrappers
A framework for building Postgres Foreign Data Wrappers which connects to Stripe, Firebase, Clickhouse, and more.
141
MongoDB Releases Queryable Encryption Preview
Today we are announcing the preview release of Queryable Encryption which allows customers to encrypt sensitive data from the client side, store it as fully randomized encrypted data on the database server side, and run expressive queries on the encrypted data. Learn more.
142
Custom SQL functions for data analytics in PostgreSQL
There is a better way to explore and analyze time-series data with PostgreSQL: hyperfunctions. Learn how to ease your workload with faster and simpler data.
143
Making Faster B-Trees with Go Generics
Go generics are a new way to improve performance in golang. Let’s see what effect generics had on Google’s B-tree implementation.
144
One Million Database Connections
Learn how to use PlanetScale to safely include your database in your serverless functions without hitting connection limits in MySQL.
145
RStudio Is Becoming Posit
We are very excited to announce that RStudio has a new name, Posit.
146
SQLite Release 3.40.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 .
147
K-Nearest Neighbors
One Machine Learning algorithm that relies on the concepts of proximity and similarity is K-Nearest Neighbor (KNN). KNN is a supervised learning algorithm capable of performing both classification and regression tasks.
148
How do cash transfers impact the people who don’t receive them? (2019)
GiveDirectly partnered with academic researchers to find out how cash transfers affect local economies, including nearby non-recipients. Read the results.
149
TimescaleDB 2.7 vs. PostgreSQL 14
TimescaleDB expands PostgreSQL query performance by 1000x, reduces storage utilization by 90%, and provides time-saving features for time-series and analytical.
150
Scraping data from an app: real world example
How to inspect the network traffic of an app with Fiddler Everywhere and scrape the data from its servers.