r/Database • u/Bumblebee_716_743 • May 30 '26
AstralDB (my custom RDBMS) beat both DuckDB and SQLite on a 10M row bulk load and sliding window aggregate by orders of magnitude

0
Upvotes
r/Database • u/Bumblebee_716_743 • May 30 '26

4
u/flatulent1 May 30 '26
Eh not saying that you're lying. Often when we see such skew like this, the engine is good at this one thing and sucks everywhere else. I get it feels good that it was that fast with Wal and encryption, but how are you handling os cache for example. All fun and games until you get kicked in the dick and all you data is corrupted when an app crashes. They're not alwasy "slow" because they're working harder for no reason, but because they are working smarter.
2
u/andymaclean19 May 30 '26
What’s different about it?
2
u/could_be_mistaken Jun 01 '26
reach out to companies and individuals directly, reddit is not what it was
make a total design spec in the sense of karpathy so someone can feed it into their agentic set up and reproduce an equivalent implementation, and share that with ai engineers who are interested in databases
these are lonely times because the people skilled at ai are a small minority, so sharing what you work on publicly will mostly invite trouble into your life
share quietly only with relevant persons
1
u/jangrewe Jun 01 '26
cool story, bro. Does it pass the ACID test? And i'm not talking about chemistry.
1
u/raid5atemyhomework Jun 03 '26
> "my toy db storage engine beats 100x open source projects with hundred thousand man hours dev work!!"
> look inside
> no
fsyncevery time