News for hackers. Stuff that matters.

A comment on SQLite Internals: Pages and B-trees. Parent comment

Re:SQLite Internals: Pages and B-trees by packetlost on Wednesday July 27, 2022 @01:09PM (#32253177)
You could probably do it with BRIN indexes similar to how TimescaleDB handles their time-series hypertables
[ Parent | on HN ]
Re:SQLite Internals: Pages and B-trees by LoriP on Wednesday July 27, 2022 @01:23PM (#32253394)
TimescaleDB is packaged as a postgres extension, there's a GitHub project here if anyone is interested to check in on that https://github.com/timescale/timescaledb
[ Parent | on HN ]
Re:SQLite Internals: Pages and B-trees by zresdtfugyihoi on Thursday July 28, 2022 @02:29AM (#32261086)
Indeed! That seems like quite the ideal use-case for BRIN indexes.
[ Parent | on HN ]