Timothy Moore
Timothy Moore
In case anyone is looking for something similar I created a TypeScript wrapper around rqlite for my purposes: https://github.com/Tjstretchalot/tsrqdb Has a lot of the features requested here (built for typing,...
Thank you for the detailed report! It's surprising that this is happening with triangles and rectangles. Would it be possible to dump the location of each polygon (the vertices +...
I'll leave this up in the hope that I will have an opportunity at some point to test some polygons by eyeballing reasonable numbers for what was in the video.
I like the alternative idea. The only additional part that I would add is some hint that clients can see that provides a hint for if a snapshot is desired...
Building on that, if additional 503s that aren't opt-in aren't desirable, it could be instead accomplished with as a precondition on the request, similar to freshness. I can't think of...
Additional context I'm relinking here from my interpretation of the sqlite forum post you made - https://sqlite.org/forum/forumpost/d6ac6bf752 is that it's not just one read query that slows it down, its...
I'm trying to understand this a little better, so I'm going to restate some background knowledge for my own reference: SQLite can be run in [write-ahead-log (WAL) mode](https://www.sqlite.org/wal.html). In WAL...
The more I think about it the more I like the logging the blocking queries / flagging queries as may block snapshotting idea. It'd help detect slow queries without arbitrary...
> Interesting point, hadn't thought about that, but "without limit"? Even your own system shows it doesn't happen without limit. It just fails occasionally. You're just not seeing the process...
> > I don't see how this would help with checkpointing though > Yeah, that's because your mental model of what is going on isn't right. No worries, rqlite is...