> ?On 5/14/18, 8:47 AM, "sqlite-users on behalf of Bernard Ertl"
> <sqlite-users-boun...@mailinglists.sqlite.org on behalf of
> bern...@interplansystems.com> wrote:
> This is the latest:
This is the latest:
I contributed to the last SQLitening update. No one has reported any issues
that need fixing or updating since that update. It seems to be working quite
> On 5/13/18, 6:48 AM, "sqlite-users on
> ... If your application requires concurrent network access, you should be
> using either a network client/server DBMS or programming your own
> Client/Server pair with the server process calling the SQLite API to modify
> the db file held on the servers' local filesystem. ...
There is an
Is it possible to do something like this:
SELECT c1, c2, CurrentDate, (CASE ActiveCol WHEN 0 THEN c3 ELSE c4 END) AS ac,
MyFn(c1,ac,CurrentDate) AS xc1, MyFn(c2,ac,CurrentDate) AS xc2 FROM ...
where c1, c2, CurrentDate, ActiveCol, c3, c4 are all columns in the table(s)
referenced in the
Jay A. Kreibich-2 wrote:
> On Wed, Nov 17, 2010 at 04:36:12PM -0600, Bernard Ertl scratched on the
>> Is it not possible to reference the SQLite
>> internal/default column for the RowID in a foreign key definition?
> Even if y
> On Wed, 17 Nov 2010 16:36:12 -0600, "Bernard Ertl"
> <bern...@interplansystems.com> wrote:
>>I'm getting a "foreign key mismatch" error with the following code:
>>PRAGMA foreign_keys = ON;
I'm getting a "foreign key mismatch" error with the following code:
PRAGMA foreign_keys = ON;
CREATE TABLE IF NOT EXISTS JobPlans (Name UNIQUE);
CREATE TABLE IF NOT EXISTS Tasks (JobPlan_ID INTEGER NOT NULL REFERENCES
JobPlans(RowID) ON DELETE CASCADE, UID UNIQUE NOT NULL);
Kees Nuyt wrote:
>> Nicolas Williams-2 wrote:
>> > Do you have recursive triggers enabled?
>> I'm not sure. How do I check?
I'm not using any pragma commands, so no, I'm not using recursive triggers.
Nicolas Williams-2 wrote:
> Do you have recursive triggers enabled?
I'm not sure. How do I check?
View this message in context:
Sent from the SQLite mailing list archive at Nabble.com.
Dan Kennedy-4 wrote:
> Sounds like it.
> Calling sqlite3_prepare_v2() generates the VM code for all
> triggers that could possibly be invoked by your statement.
> All it considers when determining which triggers might be
> needed is the type of statement (UPDATE, DELETE, INSERT) and
I'm experiencing some performance issues with triggers at the moment and hoping
someone can help shed some light on what is happening.
I have a database with ~20 tables and >100 triggers. I noticed a severe
performance degradation after adding the last few triggers and it puzzled me
Mail list logo