Replying to Avatar Ademan

Do you know what the motivation for this over just-using-postgres was? I’m confident you can beat postgres if you’re careful and thoughtful, but I’m also reasonably confident rolling your own system like this is at minimum going to be brittle, and probably have at least as many performance pitfalls at the end of the day.
Avatar
hodlbod 2y ago

I've read that sqlite is significantly faster for read-heavy applications.

Reply to this note

Please Login to reply.

Discussion

Avatar
Alex Gleason 2y ago

Faster than Postgres? That would be surprising, but then again they proved it's faster to read from sqlite than to read from a file... even though sqlite is a file.

Avatar
hodlbod 2y ago

Yeah, some people at a previous job used to use it for serving a large amount of pre-processed data

72
nobody 2y ago

Technology requires a different kind of common sense.