Ancient Transaction Records from 3100 BC and Modern Database Timestamp Limits
By
avinassh
A respectable bake. You'd come back tomorrow for another.
Summary
The article discusses the oldest recorded transaction from 3100 BC, which was an ancient accounting record of malt and barley groats that has survived for 5000 years. The author humorously compares its durability to modern databases and investigates the oldest timestamps supported by MySQL (1000 AD), PostgreSQL (4713 BC), and SQLite (4713 BC), noting that MySQL cannot handle dates as ancient as the 3100 BC transaction.
Key quotes
· 5 pulledThis is the oldest transaction database from 3100 BC - recording accounts of malt and barley groats.
Considering this thing survived 5000 years (holy shit!) with zero downtime and has stronger durability guarantees than most databases today.
I call it rock solid durability.
What is the oldest timestamp a database can support?
Too bad you cannot use MySQL for dates as ancient as 3100 BC.
You might also wanna read
The DECmate II: How DEC turned the PDP-8 minicomputer into a desktop word processor
A detailed historical retrospective on Digital Equipment Corporation's DECmate II, a desktop microcomputer based on the PDP-8 minicomputer a
oldvcr.blogspot.com·1d ago
MotherDuck's AI lead explains how the startup commercializes DuckDB without forking the open-source database
MotherDuck's AI lead Till Döhmen discusses how the startup commercializes the open-source DuckDB analytical database without forking it. At
bit.ly·1d agoMotherDuck's AI lead explains how the startup commercializes DuckDB without forking the open-source database
MotherDuck's AI lead Till Döhmen discusses how the startup commercializes the open-source DuckDB analytical database without forking it. At
bit.ly·1d ago
AI helps historians decode centuries-old encrypted manuscripts and secret remedies
Artificial intelligence is helping historians decode centuries-old encrypted manuscripts and ciphers that have remained unread for hundreds
buff.ly·1d ago
Second Anglo-Saxon oven unearthed at Felton dig site in Northumberland
Archaeologists have uncovered a second oven during their fourth dig at an Anglo-Saxon site near Felton, Northumberland. The site, popular wi
bbc.co.uk·1d ago
Skeletal remains of Queen Elisenda of Montcada and 24 others discovered in Barcelona monastery excavation
Archaeologists in Barcelona opened eight 14th-century graves at the Royal Monastery of Santa Maria Pedralbes and discovered 25 skeletons, in
livescience.com·2d ago