Re: [sqlite] disable file locking mechanism over the network

I like the idea of FLoM-based VFS !! I am not sure I am up to actually doing it, but this should be as good a locking mechanism as any other. Thank you, Keith. Roman From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of Keith

Re: [sqlite] Import XLS file?

If you are uncomfortable with exporting to csv and importing csv from the command line, you could install DB Browser for SQLite, https://github.com/sqlitebrowser/sqlitebrowser. Then manually build your SQLite tables and cut and paste into them from the spreadsheet. On Tue, Oct 1, 2019 at 8:58 PM

Re: [sqlite] [EXTERNAL] Re: Newbie Issues with COLLATE

I'm guessing that LOCALE_NOCASE will probably be causing things that collate distinct in NOCASE to collate equal, so the risk of breaking UNIQUE constraints seems rather small -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag