News for hackers. Stuff that matters.
Re:BTrDB: Berkeley Tree Database by dboreham on Wednesday June 26, 2019 @05:57AM (#20283417)
Type is one thing. Efficient querying (which implies some appropriate index structure) is another.
Re:BTrDB: Berkeley Tree Database by asah on Wednesday June 26, 2019 @06:27AM (#20283575)
Weak example to ask precisely when the plane is at X feet, not an inch higher/lower - this is more typically a range query, and the Postgres range datatype is quite good at this, notably GiST indexes for overlap queries: https://www.postgresql.org/docs/9.3/functions-range.html#RAN... https://www.postgresql.org/docs/current/rangetypes.html#RANG...
Re:BTrDB: Berkeley Tree Database by vog on Thursday June 27, 2019 @09:24AM (#20294122)
PostgreSQL allows for all of that: User-defined types with user-defined index structures and whatnot. PostgreSQL is great and flexible, yet transaction safe and fast. You should really try it. It is one of the highest-quality FLOSS projects I have ever seen, not just in term of code quality, but also in terms of project and community management.