News for hackers. Stuff that matters.
Re:SimpleDB: A Basic RDBMS Built from Scratch by akrymski on Wednesday February 02, 2022 @04:54PM (#30184591)
1) Indeed you should only use mmap for reads afaik

2) Was thinking more of an event-sourcing model, whereby you log the SQL statements first, then update a B-Tree in the background.

Read via mmap, write by appending to a log and asynchronously applying the changes to the file.

3) Rather than yet another QL, expose a higher level API that I can target in any language

Re:SimpleDB: A Basic RDBMS Built from Scratch by akrymski on Thursday February 03, 2022 @08:05AM (#30191907)
Another thing to consider is pluggable storage (a key/value interface) and pluggable query language (relational algebra interface?) and how to fit the two together.