bert hubert 🇺🇦🇪🇺🇺🇦 on Nostr: If you are doing any kind of bulk data analysis in SQLite, it almost immediately pays ...
If you are doing any kind of bulk data analysis in SQLite, it almost immediately pays off to convert your data to DuckDB. It is often more then a factor of 10 faster and offers more data analysis functionality to boot (like median/quantile). For actual storing of data I'd still trust SQLite more, btw.
Published at
2026-08-30 11:03:40 UTCEvent JSON
{
"id": "ea9d4bc9c55d37b75da5840e4f52de19f8958c0cbd114500ff4e7e253ff4e6e3",
"pubkey": "3507f6c32f8d7e3edbe5570ad3340a49a863d9b75fadd3622d6f6bc5372a2af3",
"created_at": 1788087820,
"kind": 1,
"tags": [
[
"proxy",
"https://eupolicy.social/@bert_hubert/117184123375647114",
"web"
],
[
"proxy",
"https://eupolicy.social/users/bert_hubert/statuses/117184123375647114",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://eupolicy.social/users/bert_hubert/statuses/117184123375647114",
"pink.momostr"
],
[
"-"
]
],
"content": "If you are doing any kind of bulk data analysis in SQLite, it almost immediately pays off to convert your data to DuckDB. It is often more then a factor of 10 faster and offers more data analysis functionality to boot (like median/quantile). For actual storing of data I'd still trust SQLite more, btw.",
"sig": "5ca848544dd2c3371ed42bf2ab811d3a383d49952f54870c9c19d50fc5151af61d6695cc04d3829a4e4001693a3a4cf6c5cd6b75a66260ed61df428c9a3fbd94"
}
