4 ms·

Yeah that would be awesome! I'd rephrase your comment as a suggestion rather than a demand though personally. :)

benbjohnson 4y ago
That's a good idea. There's a careful balance though since once you start talking about specific functions in SQLite then the post becomes very low-level and starts to become less accessible. I'll try to integrate that more in the future though.
- eatonphil 4y ago
  Yeah maybe it would force you to get too close to the code, I don't know SQLite well enough. When I do surveys of software I try to provide links to source (mostly just the relevant file or directory) so folks can verify for themselves. For example when looking into the parsers behind Postgres-compatible DBs [0] and parser techniques in a few major language implementations [1]. But both those posts are at a higher-level than what you're doing here. I'm sure you'll have good reason either way for this series. [0] https://datastation.multiprocess.io/blog/2022-02-08-the-world-of-postgresql-wire-compatibility.html https://datastation.multiprocess.io/blog/2022-02-08-the-worl... [1] https://notes.eatonphil.com/parser-generators-vs-handwritten-parsers-survey-2021.html https://notes.eatonphil.com/parser-generators-vs-handwritten...
- mandeepj 4y ago
  > https://github.com/sqlite/sqlite/blob/master/src/btreeInt.h https://github.com/sqlite/sqlite/blob/master/src/btreeInt.h Woah, Ben! I'm so glad the above link was shared above; thanks to the poster as well. There's a very good amount of in-depth knowledge shared via comments and a reference to Donald knuth's book
  - benbjohnson 4y ago
    There's a lot of goodies in the comments. I like this one about how POSIX locks are broken: https://github.com/sqlite/sqlite/blob/master/src/os_unix.c#L1026-L1114 https://github.com/sqlite/sqlite/blob/master/src/os_unix.c#L...
    - mandeepj 4y ago
      Thanks! Enough catalyst for me to read through all of SQLite source files
samatman 4y ago
GP's account page says From Morocco With Love, and I'm sure their Arabic and French are far beyond mine. This reads to me like an accidental slip into the imperative, breaking a sentence in two parts, and not adding a phrase such, "For example,". In fact, changing the period to a colon would defuse the imperative. It's subtle!

That's a good idea. There's a careful balance though since once you start talking about specific functions in SQLite then the post becomes very low-level and starts to become less accessible. I'll try to integrate that more in the future though.

eatonphil 4y ago
Yeah maybe it would force you to get too close to the code, I don't know SQLite well enough. When I do surveys of software I try to provide links to source (mostly just the relevant file or directory) so folks can verify for themselves. For example when looking into the parsers behind Postgres-compatible DBs [0] and parser techniques in a few major language implementations [1]. But both those posts are at a higher-level than what you're doing here. I'm sure you'll have good reason either way for this series. [0] https://datastation.multiprocess.io/blog/2022-02-08-the-world-of-postgresql-wire-compatibility.html https://datastation.multiprocess.io/blog/2022-02-08-the-worl... [1] https://notes.eatonphil.com/parser-generators-vs-handwritten-parsers-survey-2021.html https://notes.eatonphil.com/parser-generators-vs-handwritten...
mandeepj 4y ago
> https://github.com/sqlite/sqlite/blob/master/src/btreeInt.h https://github.com/sqlite/sqlite/blob/master/src/btreeInt.h Woah, Ben! I'm so glad the above link was shared above; thanks to the poster as well. There's a very good amount of in-depth knowledge shared via comments and a reference to Donald knuth's book
- benbjohnson 4y ago
  There's a lot of goodies in the comments. I like this one about how POSIX locks are broken: https://github.com/sqlite/sqlite/blob/master/src/os_unix.c#L1026-L1114 https://github.com/sqlite/sqlite/blob/master/src/os_unix.c#L...
  - mandeepj 4y ago
    Thanks! Enough catalyst for me to read through all of SQLite source files

samatman 4y ago

GP's account page says From Morocco With Love, and I'm sure their Arabic and French are far beyond mine. This reads to me like an accidental slip into the imperative, breaking a sentence in two parts, and not adding a phrase such, "For example,". In fact, changing the period to a colon would defuse the imperative. It's subtle!