On Oct 17, 2019, at 4:33 AM, Warren Young <war...@etr-usa.com> wrote:
>
> $ echo 'select count(*) from MyTable where rowid > 1234' |
> nc dbserver 8888
Clarification: that echo line should begin with “Query: “ and end in a
semicolon, which is a short form method of querying a Bedrock DB over the
network. See
https://bedrockdb.com/#how-to-use-it
If anyone thinks they see a race condition here between the query and the file
generation step, you’re right, but there’s one in the make(1) file timestamp
scheme, too. If it’s a problem for you, you can modify the scheme to query the
row contents instead of a count, then merge the new rows into the output file
instead of completely re-generating it. That would be more ACID-compliant.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
