~hackernews | Bookmarks (8)

clear filters

sql ×

The Bloat Busters: pg_repack vs. pg_squeeze

boringsql.com

As the database size increases and the number of transactions per second rise, you'll inevitably face...
As the database size increases and the number of transactions per second rise, you'll inevitably face the challenge of the table bloat. Although PostgreSQL assists as much as possible with its auto-vacuum feature, there will come a time when you will compel whether to run FULL VACUUM. Unless you have option of longi...

boringsql postgresql sql
1
Meta Used Monolithic Architecture to Ship Threads in Only Five Months

infoq.com

Zahan Malkani talked during QCon London 2024 about Meta's journey from identifying the opportunity in the...
Zahan Malkani talked during QCon London 2024 about Meta's journey from identifying the opportunity in the market to shipping the Threads application only five months later. The company leveraged Instagram's existing monolithic architecture and quickly iterated to create a new text-first microblogging service in reco...

architecture & design development mysql qcon london 2024 sql
1
Researchers, please replace SQLite with DuckDB now

medium.com

You are a researcher, potentially in the life or social sciences, and your organization offers you...
You are a researcher, potentially in the life or social sciences, and your organization offers you access to a fast machine with many CPUs and lots of memory, potentially as part of a CPU cluster. You are familiar with Linux and use Python/Pandas and/or R to manipulate and analyze your data. You sometimes use SQLite...

duckdb postgres researchers sql sqlite
1
MO| Why is shuffle support needed?

medium.com

The basic principle of the shuffle algorithm is to bucket the input data, where each bucket’s...
The basic principle of the shuffle algorithm is to bucket the input data, where each bucket’s data can be processed independently and output results. This reduces the size of the hash table when aggregating data.Taking the group operator as an example, there are two implementation methods: sort group and hash group....

database development distributed systems shuffle sql
1
Show HN: SQL Workbench in the Browser

sql-workbench.com

data engineering in-browser querying rapid prototyping sql
1
Quadratic – Open-Source Spreadsheet Is Now Multiplayer

quadratichq.com

data science python spreadsheet sql
1
Shouldn't FROM come before SELECT in SQL?

stackoverflow.com

select sql
1
A Guide to Rust ORMs in 2024

shuttle.rs

comparison orm rust sql
1

~hackernews | Bookmarks (8)

Tags

Domains

The Bloat Busters: pg_repack vs. pg_squeeze

Meta Used Monolithic Architecture to Ship Threads in Only Five Months

Researchers, please replace SQLite with DuckDB now

MO| Why is shuffle support needed?

Show HN: SQL Workbench in the Browser

Quadratic – Open-Source Spreadsheet Is Now Multiplayer

Shouldn't FROM come before SELECT in SQL?

A Guide to Rust ORMs in 2024