Re: [sqlite] Connection open to nonexistent database succeeds! WTF?

It looks like you're using C# and System.Data.SQLite. If that's the case, use the connection string parameter FailIfMissing=True to throw an exception if the file does not exist. On 1 April 2018 at 02:34, Jens Alfke wrote: > > > On Mar 31, 2018, at 8:17 AM, Mike Clark

Re: [sqlite] Select query does not give new added records

On 31 Mar 2018, at 2:04pm, Koen Amant wrote: > there is a service running in the background who adds records > to the database (POS system) I can't stop this service and all the new > records that are added I can't see in my query result. It's like the > database is locked

[sqlite] Select query does not give new added records

I have a table with 9 records. When I run 'SELECT * FROM table;' in my VB.Net I only get 6 from the 9 records. When I run the query in 'DB Browser' an SQLite viewer I get them all. The thing is there is a service running in the background who adds records to the database (POS system) I can't

[sqlite] Before Insert/Update Trigger

Other DBMS support the following construct in a trigger: CREATE TRIGGER name BEFORE UPDATE ON table FOR EACH ROW BEGIN SET NEW.column = anyvalue END; In SQLite, the NEW record appearently is read-only. Support for changeable NEW records would however be graceful as it automatically prevents

Re: [sqlite] Fixes to the transliteration table in ext/misc/spellfix.c

On Friday, 30 Mar 2018 11:38 AM -0400, Ian Zimmerman wrote: > On 2018-03-30 11:28, Marcin Ciura wrote: > >> { 0x0426, 0x54, 0x63, 0x00, 0x00 }, /* Ц to Tc */ >> { 0x0446, 0x74, 0x63, 0x00, 0x00 }, /* ц to tc */ >> >> This Cyrillic letter is usually transliterated as Ts. Unless "Tc" is >>

Re: [sqlite] MIN() and MAX() of set of row values

As a sidenote, I believe row values were added because of keyset pagination https://use-the-index-luke.com/no-offset. I found them to not be actually useful, so I thought I'd explain here. (copied from my comments on that page (now no longer visible), slightly edited) I ended up implementing

Re: [sqlite] Connection open to nonexistent database succeeds! WTF?

> On Mar 31, 2018, at 8:17 AM, Mike Clark wrote: > > Is this expected behavior? Yes. If the database file doesn’t exist, opening it will create it. (That’s how you create new databases.) There is a flag to sqlite3_open (in the C API) that prevents creating a file.

[sqlite] Connection open to nonexistent database succeeds! WTF?

I've written the following code for the ADO.NET client for SQLite, and the odd thing I've noticed is that even when the connection string passed to it does not refer to a file that exists, the code returns true! Does SQLite not actually check for a valid connection until you try to perform a data

Re: [sqlite] Change name part of a JSON object

On 03/31/2018 09:58 AM, Robert M. Münch wrote: A hack would be to search & replace “Untitled“: with the new name… but might be dangerous… any better idea? Unless you are certain that the text you are replacing cannot occur anywhere else, this is asking for problems.

[sqlite] Change name part of a JSON object

Hi, we use one JSON column to store column data that was added after tables were created. If such a column is now renamed, we need to rename the name part as well. Example: {"Untitled":"bla"} How to change “Untitled“ ? A hack would be to search & replace “Untitled“: with the new name… but