Re: [sqlite] Is foreign key support disabled within triggers with raise functions?

On 1/11/18, Shane Dev wrote: > > CREATE VIEW vtrig as select 1; > CREATE TRIGGER ttrig instead of insert on vtrig begin > delete from deptab; > delete from reftab; > insert into deptab(ref) select 2; > select raise(FAIL, 'this statement seems to temporarily disable

[sqlite] Is foreign key support disabled within triggers with raise functions?

Hello, Table deptab has a foreign key relationship with table reftab - sqlite> .sch CREATE TABLE reftab(id integer primary key); CREATE TABLE deptab(id integer primary key, ref int references reftab); foreign key support is enabled - sqlite> pragma foreign_keys; foreign_keys 1 the referenced

Re: [sqlite] SQLite 3.22.0 coming soon

On 2018/01/11 8:11 PM, petern wrote: With SQLITE_INTROSPECTION_PRAGMAS turned on, is a function description on the roadmap? It would be very helpful to expose a short description of function arguments. Implementation suggestion: a new trailing argument "description" on

Re: [sqlite] SQLite 3.22.0 coming soon

Or, more practically, please consider a virtual style API where PRAGMA function_list() gathers function description strings from all registered 2 argument functions named like %_function_description(F,N) where F is the function name and N is the argument count. A good example implementation might

Re: [sqlite] Crash when querying a unique index containing 12 columns using sub-selects

On 11-01-18 18:01, Matthew Towler wrote: > Hi > > I believe I have found a bug in sqlite, which my tests show was introduced > between versions 3.7.17 and 3.8.0 and remains present in all versions up to > and including 3.21.0 (I have also tested 3.8.11, 3.9.3, 3.12.2 all of which > hang. I

Re: [sqlite] SQLite 3.22.0 coming soon

With SQLITE_INTROSPECTION_PRAGMAS turned on, is a function description on the roadmap? It would be very helpful to expose a short description of function arguments. Implementation suggestion: a new trailing argument "description" on sqlite3_create_function() or sqlite3_create_function_v2() and

Re: [sqlite] SQLite Application Server Concurrency

Thanks Ryan John and Lee. Quite a few options. I will look at a 'server service' in C# using WCF as I am familiar with it. Also, investigate the MySQL avenue. Much obliged for your help. James -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]

Re: [sqlite] Crash when querying a unique index containing 12 columns using sub-selects

On 11 Jan 2018, at 5:01pm, Matthew Towler wrote: > With versions prior to 3.8.0 the query returns in under a second (which is > very impressive!). A query without all the sub-selects (so just selecting > some specific ID values from the main table) always works

Re: [sqlite] Crash when querying a unique index containing 12 columns using sub-selects

On 1/11/18, Matthew Towler wrote: > for the > volumes of data I have sqlite hangs Is it hanging, or is it crashing? Your statement of the problem is unclear on this point. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users

[sqlite] Crash when querying a unique index containing 12 columns using sub-selects

Hi I believe I have found a bug in sqlite, which my tests show was introduced between versions 3.7.17 and 3.8.0 and remains present in all versions up to and including 3.21.0 (I have also tested 3.8.11, 3.9.3, 3.12.2 all of which hang. I believe it closely related to, and probably just a

Re: [sqlite] sqlite3_column_decltype and max and min

On Jan 11, 2018, at 5:47 AM, John G wrote: > > Is this because I am stuck with version 3.8.8.3 which is what MacOS Sierra > provides? I have sqlite3 version 3.16.0 in /usr/bin on this 10.12.6 (Sierra) system. ___ sqlite-users

Re: [sqlite] SQLite Application Server Concurrency

Depending on your level of expertise with C#, you could create a .NET Windows service to run on machine X that contains a WCF service which controls the database access. The Y and Z clients would be WCF clients that talk to the WCF service on X. They could communicate via http or TCP. From:

Re: [sqlite] SQLite Application Server Concurrency

I have several such applications, running in industrial environment. I always use a TCP server on 'X' and TCP client on 'Y' with some simple, specialized http-like protocol on top. All this can be implemented very easy, especially if you don't need a top performance and millions of clients.

Re: [sqlite] sqlite3_column_decltype and max and min

On 1/11/18, John G wrote: > > Is this because I am stuck with version 3.8.8.3 which is what MacOS Sierra > provides? > You are not stuck with the software provided by Sierra. You can download and/or compile your own up-to-date SQLite that is twice as fast and has all the

Re: [sqlite] sqlite3_column_decltype and max and min

Keith Looks like a good idea but I get : sqlite> create view if not exists SysColumns ...> as ...> select ObjectType collate nocase, ...>ObjectName collate nocase, ...>ColumnID collate nocase, ...>ColumnName collate nocase, ...>Affinity collate

Re: [sqlite] SQLite Application Server Concurrency

On 2018/01/11 11:06 AM, James Colehan wrote: Hi, I am looking for some advice on using SQLite for my given situation. My system involves a windows network. On PC 'X', I have an SQLite database with a process that handles amendment's to the database ie INSERTS, DELETES and UPDATES. Also, on

Re: [sqlite] [EXTERNAL] SQLite Application Server Concurrency

Thanks Hick, points noted. James -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Hick Gunter Sent: 11 January 2018 09:23 To: 'SQLite mailing list' Subject: Re: [sqlite] [EXTERNAL] SQLite

Re: [sqlite] [EXTERNAL] SQLite Application Server Concurrency

Accessing SQLite files via network filesystems is high on the list of "how to corrupt SQLite databases", see section 2.1 in http://sqlite.org/howtocorrupt.html WAL mode requires shared memory. How are you going to do that with processes running on different PCs? See sections 4 and 6 of

Re: [sqlite] SQLite Application Server Concurrency

Hi Simon, Thanks for getting back so quickly. Web programming is not something I am familiar with. My application is desktop based mostly written in C#. However, your suggestion is something I can look deeper into. James -Original Message- From: sqlite-users

Re: [sqlite] SQLite Application Server Concurrency

On 11 Jan 2018, at 9:06am, James Colehan wrote: > My concern is that I have a requirement to query the database on PC 'X' from > other PC's. Basically, performing (SELECT) statements from stations 'Y' and > 'Z'. This creates a client/server situation that I

[sqlite] SQLite Application Server Concurrency

Hi, I am looking for some advice on using SQLite for my given situation. My system involves a windows network. On PC 'X', I have an SQLite database with a process that handles amendment's to the database ie INSERTS, DELETES and UPDATES. Also, on PC 'X' I have some other processes running that