~lobsters | Bookmarks (98)

clear filters

pg_analytics: Transforming Postgres into a Very Fast Analytical Database - ParadeDB

paradedb.com

databases rust
1
What I Talk About When I Talk About Query Optimizer (Part 1): IR Design

xuanwo.io

code databases linux plt program
2
rqlite 8.17.0 & 8.18.0: Scheduled VACUUMs and Enhanced JSON Support | Vallified

philipotoole.com

databases distributed go
1
Adaptive _time compression — A database hacker story

axiom.co

compsci databases distributed go performance
2
Implementing System-Versioned Tables in Postgres

hypirion.com

databases
3
Perf is not enough

motherduck.com

databases duckdb duckdb snippets duckdb-snippets duckdb-snippets.com
2
Scalable OLTP in the Cloud: What’s the BIG DEAL?

muratbuffalo.blogspot.com

This paper is from Pat Helland, the apostate philosopher of database systems, overall a superb person,...
This paper is from Pat Helland, the apostate philosopher of database systems, overall a superb person, and a good friend of mine. The paper appeared this week at CIDR'24. (Check out the program for other interesting papers). The motivating question behind this work is: "What are the asymptotic limits to scale for cl...

databases
1
The importance of being earnestly random: Metamorphic Testing in CockroachDB

cockroachlabs.com

databases engineering testing
1
In search of a Search Engine, beyond Elasticsearch: Introducing Zinc

prabhatsharma.in

A search engine is a software that can search for any text in the data that...
A search engine is a software that can search for any text in the data that has been indexed for full text. While there are public search engines like Google and Bing, we are not talking about them in this blog, but of softwares that would allow you to search for text in your own data. Think of a this kind of search...

artificial intelligence aws cloud databases distributed
1
Introduction to Apache Hudi

medium.com

Apache Hudi is an open-source data management framework that emerged to address specific challenges in handling...
Apache Hudi is an open-source data management framework that emerged to address specific challenges in handling large-scale data lakes. Developed by Uber in 2016, its primary focus is on optimizing the efficiency of updates and deletes in columnar file formats like Parquet and ORC, which are commonly used in big dat...

data architecture data engineering data streaming data warehouse databases
1
Scaling Golang to 192 Cores with Heavy I/O

jazco.dev

databases go
2
Writing a minimal in-memory storage engine for MySQL/MariaDB | notes.eatonphil.com

eatonphil.com

c++databases
1
SQLite 3.45: Interactive release notes

antonz.org

databases release
1
An Overview of Distributed PostgreSQL Architectures

crunchydata.com

databases distributed
2
My PostgreSQL wishlist

ryanguill.com

If you know me you’re aware that I love SQL and relational databases. Of all of...
If you know me you’re aware that I love SQL and relational databases. Of all of the databases I have used, PostgreSQL is by far my favorite. SQL is the one technology I have seen in common across every job I have had over the past two decades. I would bet you could say the same - even if you aren’t writing it direct...

databases
2
Minimalist PostgreSQL Migrations | Alan Johnson

nalanj.dev

databases
1
Docs • Flame – Data model and query library for Firestore.

flame-odm.com

databases javascript nodejs
1
Happy New Year: GPT in 500 lines of SQL - EXPLAIN EXTENDED

explainextended.com

ai databases
4
Does Your Test Suite Account For Weak Transaction Isolation? | Concerning Quality

concerningquality.com

databases testing
2
The One Billion Row Challenge

morling.dev

databases java performance programming
2
Rolling aggregates with SQL window functions

antonz.org

databases
1
Merkle Search Trees: Efficient State-Based CRDTs in Open Networks

hal.science

compsci databases distributed pdf
1
A Closer Look to a Key-Value Storage Engine | Yihang's Blog

silhding.github.io

“Please design a key-value storage engine”. You might hear this during a system design interview. While...
“Please design a key-value storage engine”. You might hear this during a system design interview. While this question in fact is pretty, designing a storage engine is not easy. In this post, I want to start with some simple designs and principles and gradually approach a solution of a relatively complete key-value s...

databases
1
Chris's Wiki :: blog/tech/EmailAddressesBadPermanentIDs

utoronto.ca

Every so often someone needs to create a more or less permanent internal identifier in their...
Every so often someone needs to create a more or less permanent internal identifier in their system every person's account. Some of the time they look at how authentication systems like OIDC return email addresses among other data and decide that since pretty much everyone is giving them an email address, they'll us...

databases
1