5 ms·

sure, but aren't there some things that can't calculated in advance like i/o, locked tables or priority queries just to name a few

• qwerty456127 8y ago
  > sure, but aren't there some things that can't calculated in advance I don't mean precise calculation but a reasonable guess > like i/o It can be benchmarked and estimated. > locked tables Why would tables be locked if we work in read-only mode?
  • jondumbau 8y ago
    How did the data get there.
    • qwerty456127 8y ago
      The page by the link says it's about the immutable mode and INSERT and UPDATE errors raise errors. As about me it's a very usual use case: I pre-populate a database with a huge data set (some GiBs) in a single batch and work with the data (data science stuff) in read-only mode then, some time after, add another batch of data (usually much smaller than the initial one) to it but database writing and reading never happens simultaneously in this scenario. In fact Datasette seems a thing I've always wanted as it is probably going to let me access my SQLite databases over a network this way.