On 4/22/2014 5:55 PM, Andy Goth wrote:
On 4/22/2014 5:16 PM, Dominique Devienne wrote:
sqlite with cte(a) as (select 1)
... select * from cte
... union all
... select * from cte;
Error: no such table: cte
All these queries work for me without error.
Try upgrading to 3.8.4 or
I spend much time to find for reference of
implementing VFS.
But I can’t find
any reference of that.
I wanna know some requirement and manual
for implementing my own VFS.
Is there anything that help me?
___
sqlite-users mailing list
On 23 Apr 2014, at 8:58am, 김병준 bjkm1...@naver.com wrote:
I spend much time to find for reference of
implementing VFS.
But I can’t find
any reference of that.
I wanna know some requirement and manual
for implementing my own VFS.
Is there anything that help me?
Please see
Hi,
Please correct me on below points for Sqlite3 on Linux platform.
1) Sqlite3 doesn’t have any concurrency issue when multiple process
reading one database file at same time. This doesn’t required any special
mode setting (Like WAL)
2) One process is reading other process tries
On 23 Apr 2014, at 10:29am, techi eth techi...@gmail.com wrote:
1) Sqlite3 doesn’t have any concurrency issue when multiple process
reading one database file at same time. This doesn’t required any special
mode setting (Like WAL)
Correct.
2) One process is reading other process
Many Thanks for quick reply.
Could you please suggest me other journal mode for second case.My target
filesytem dosen't support mmap WAL required mmap support.
Thanks
On Wed, Apr 23, 2014 at 3:05 PM, Simon Slavin slav...@bigfraud.org wrote:
On 23 Apr 2014, at 10:29am, techi eth
Hi,
Is there a way of preventing triggers cascading?
I have a table where I need to set a timestamp field when a new record is
INSERTED. The table uses an auto-increment key field so a BEFORE INSERT trigger
is ruled out. An AFTER INSERT trigger which UPDATEs the new row solves that
problem,
On 23 Apr 2014, at 10:42am, techi eth techi...@gmail.com wrote:
Many Thanks for quick reply.
Could you please suggest me other journal mode for second case.My target
filesytem dosen't support mmap WAL required mmap support.
http://www.sqlite.org/pragma.html#pragma_journal_mode
It would
On 04/23/2014 05:05 PM, Peter Hardman wrote:
Hi,
Is there a way of preventing triggers cascading?
I have a table where I need to set a timestamp field when a new record
is INSERTED. The table uses an auto-increment key field so a BEFORE
INSERT trigger is ruled out. An AFTER INSERT trigger
http://www.freelancer.com/projects/MySQL-SQL/Import-Turkish-CSV-Data-SQLite.html
I saw the above on twitter and thought somebody here might be interested.
Seems simple enough, but hard to judge without first looking at the CSV
files.
Additional resources: http://www.sqlite.org/cli.html#csv
--
Hi,
I encoutered an issue similar to what is mentioned here:
http://sqlite.1065341.n5.nabble.com/I-O-errors-with-WAL-on-ZFS-td68390.html
I was able to solve the problem by simply hacking the configure script to set
HAVE_POSIX_FALLOCATE=0. I can give more detail on my setup and the issue I
On 4/23/2014 6:05 AM, Peter Hardman wrote:
I have a table where I need to set a timestamp field when a new record
is INSERTED. The table uses an auto-increment key field so a BEFORE
INSERT trigger is ruled out. An AFTER INSERT trigger which UPDATEs the
new row solves that problem, but I have a
On Wed, Apr 23, 2014 at 6:56 AM, Keith Medcalf kmedc...@dessus.com wrote:
You don't ever really need a GUID at all. Simply use an integer primary
key (an integer starting at 1) and simply pretend that it is being added
to the applicable base GUID of your random choosing. Everything will
On 23/04/14 17:00, sqlite-users-requ...@sqlite.org wrote:
Date: Wed, 23 Apr 2014 17:54:27 +0700
From: Dan Kennedydanielk1...@gmail.com
To:sqlite-users@sqlite.org
Subject: Re: [sqlite] Trigger cascade/nesting
Message-ID:53579be3.1090...@gmail.com
Content-Type: text/plain; charset=ISO-8859-1;
On 4/23/2014 12:26 PM, Peter Hardman wrote:
Igor, thanks for your suggestion, but I'm using a trigger partly to
prevent the user faking the timestamp.
If that's the concern, then if you find a mechanism by which an update
made by your trigger isn't logged, the user would be able to use that
The possibility of having to merge data from several independent test stations
is what made me think of using GUID in the first place. I don't think there's a
better way.
As for wasted space, the few extra bytes needed by GUID is a drop in the bucket
compared to the blobs I'm storing. If I was
On Wed, Apr 23, 2014 at 12:20 AM, Steve Wills swi...@freebsd.org wrote:
Hi,
I encoutered an issue similar to what is mentioned here:
http://sqlite.1065341.n5.nabble.com/I-O-errors-with-WAL-on-ZFS-td68390.html
I was able to solve the problem by simply hacking the configure script to
set
On 4/23/2014 10:21 AM, Drago, William @ MWG - NARDAEAST wrote:
If I was sure I wouldn't be merging data I might use timer ticks as my ID,
but I'm not sure and I can't take the chance.
-Bill
Would it be possible to use INTEGER PRIMARY KEY AUTOINCREMENT for the
ID, and manually start
Ok, you can store a JSON like structure, by reproducing the graf adapted
to SQL I wrote that (for fun, not only writing code for my day to day job)
[mostly that what core data does with all this mysterious ids, that's just
a transpose vertical to horizontal], there are primitive-tables named by
Ok, you can store a JSON like structure, or plist, coding is a creative
discipline, not a nerd stuff.
On Wed, Apr 23, 2014 at 12:16 PM, mm.w 0xcafef...@gmail.com wrote:
Ok, you can store a JSON like structure, by reproducing the graf
adapted to SQL I wrote that (for fun, not only writing code
On Wed, Apr 23, 2014 at 02:06:33PM -0400, Richard Hipp wrote:
On Wed, Apr 23, 2014 at 12:20 AM, Steve Wills swi...@freebsd.org wrote:
Hi,
I encoutered an issue similar to what is mentioned here:
http://sqlite.1065341.n5.nabble.com/I-O-errors-with-WAL-on-ZFS-td68390.html
I was able
On Wed, Apr 23, 2014 at 3:34 PM, Steve Wills swi...@freebsd.org wrote:
On Wed, Apr 23, 2014 at 02:06:33PM -0400, Richard Hipp wrote:
On Wed, Apr 23, 2014 at 12:20 AM, Steve Wills swi...@freebsd.org
wrote:
I think http://www.sqlite.org/src/info/1bbb4be1a25 addresses your
problem.
That
On Wed, Apr 23, 2014 at 03:39:21PM -0400, Richard Hipp wrote:
On Wed, Apr 23, 2014 at 3:34 PM, Steve Wills swi...@freebsd.org wrote:
On Wed, Apr 23, 2014 at 02:06:33PM -0400, Richard Hipp wrote:
On Wed, Apr 23, 2014 at 12:20 AM, Steve Wills swi...@freebsd.org
wrote:
I think
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
boun...@sqlite.org] On Behalf Of Gerry Snyder
Sent: Wednesday, April 23, 2014 2:36 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] BLOBs and NULLs
On 4/23/2014 10:21 AM, Drago, William
On Wed, Apr 23, 2014 at 3:46 PM, Steve Wills swi...@freebsd.org wrote:
On Wed, Apr 23, 2014 at 03:39:21PM -0400, Richard Hipp wrote:
So what problem are you seeing, exactly? Is the fact that
posix_fallocate() is being called at all causing some kind of problem for
ZFS?
I am deploying
On Wed, 23 Apr 2014 17:51:17 +0200
Stephan Beal sgb...@googlemail.com wrote:
On Wed, Apr 23, 2014 at 6:56 AM, Keith Medcalf kmedc...@dessus.com
wrote:
You don't ever really need a GUID at all. Simply use an integer
primary
key (an integer starting at 1) and simply pretend that it is being
Thank you this is very helpful.
Can anyone share the process to get an official build released? Would be
great for the community to have it available on nuget.
Cheers
Ryan
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of
27 matches
Mail list logo