Re:IO Devices and Latency
by chatmasta on Thursday March 13, 2025 @11:05PM
(#43359234)
That’s a limitation you’ll hit pretty quickly unless you’ve specifically planned your architecture to be mostly read-only SQLite or one SQLite per session.
[ Parent
| on HN ]
You certainly won’t hit it with most corporate OLAP processing, which is nearly all read-only SQlite. Writes are generally batched and processed outside ‘normal’ business hours, where the limitations of SQlite writing are irrelevant.
Where are they batched?
In a separate system maintained by the DuckDB cargo cultists.
I'm having a hard time imagining this. Aren't most CRUD apps using OLTP mostly read-only in the first place?
I just feel like you'd need thousands of concurrent users on a typical CRUD app to even get close to straining SQLite.