31
Querying Parquet with Precision Using DuckDB
DuckDB, a free and open source analytical data management system, can run SQL queries directly on Parquet files and automatically take advantage of the advanced features of the Parquet format.
Most cited
Posts that commenters keep linking to, ranked by how many different people have cited them in Hacker News comments. 54 posts.
32
How Discord Stores Billions of Messages (2017)
Discover the latest news and app updates, stories, company insights, and plenty more about Discord, all in one place.
33
Pg_GraphQL: A GraphQL Extension for PostgreSQL
GraphQL support is in development for PostgreSQL + Supabase.
34
Excel Never Dies
The Spreadsheet That Launched A Million Companies
35
The data model behind Notion's flexibility
Notion’s data model enables the product’s most foundational component: blocks. Through blocks, we allow users more flexibility over their information.
36
Backblaze Hard Drive Stats for 2020
The AFR for 2020 dropped below 1% down to 0.93%. In 2019, it stood at 1.89%. That’s over a 50% drop year over year.
37
New Machine Learning Gems for Ruby
In August, I set out to improve the machine learning ecosystem for Ruby and wasn’t sure where it would go. Over the next 5 months, I ended up...
38
An opinionated map of incremental and streaming systems
Disclaimer: I used to work for Materialize which is one of the systems being compared in this post.
39
AuthZ: Scalable permissions system
How we built an authorization system based on Google Zanzibar
40
The Problem with Perceptual Hashes
Apple just announced that they will use “perceptual hashing” to detect illegal photos on iPhones. I have some experience to share on this technology.
41
Building a data team at a mid-stage startup
You are brought into a startup to run their three-person data team. This is a story about teams and organization, and how you spend a year getting the team to a good place.
42
A Docker footgun led to a vandal deleting NewsBlur's MongoDB database
tl;dr: A vandal deleted NewsBlur’s MongoDB database during a migration. No data was stolen or lost.
43
Migrating Facebook to MySQL 8.0
MySQL, an open source database developed by Oracle, powers some of Facebook’s most important workloads. We actively develop new features in MySQL to support our evolving requirements. These feature…
44
An early look at Postgres 14: Performance and monitoring Improvements
We take a look at whats new in Postgres 14, with idle and active connection scaling, memory monitoring, query IDs and more
45
An Introduction to JQ
In this article, I'm going to go over the basics building blocks of jq in enough depth that you will be able to understand how jq works.
46
I don't want to learn your query language (2018)
This is a bit of a rant but I really don't like software that invents its own query language. There's a trillion different ORMs out there. Another trillion databases with their own query language. Another trillion SaaS products where the only way to query is to learn some random query DSL they made up.
47
Trademark Actions Against the PostgreSQL Community
The PostgreSQL Core Team and the PostgreSQL Community Association of Canada (PGCAC) wish to provide clarification on the ownership and …
48
How we built a serverless SQL database
CockroachDB serverless is the first truly scalable serverless SQL database. Learn how it works and how a serverless sql database can relieve the operational burden of developers.
49
Spending $5k to learn how database indexes work
At Superwall we’re building an SDK to help App Developers increase their revenue by showing the right offer to the right person at the right time. Follow me on twitter for little tips and articles like this one.
50
DuckDB-Wasm: Efficient analytical SQL in the browser
DuckDB-Wasm is an in-process analytical SQL database for the browser. It is powered by WebAssembly, speaks Arrow fluently, reads Parquet, CSV, and JSON files backed by Filesystem APIs or HTTP requests, and has been tested with Chrome, Firefox, Safari, and Node.js. You can try it at shell.duckdb.org or on Observable.
51
52
How PostgreSQL aggregation works and how it inspired our hyperfunctions’ design
A discussion of aggregation in PostgreSQL and how it integrates with the design of Timescale’s hyperfunctions.
53
54
Faster DISTINCT queries on PostgreSQL
Learn common performance pitfalls and discover techniques to optimize your DISTINCT PostgreSQL queries. Read the full article on the Tiger Data blog.