Re: [sqlite] R*Tree and foreign key constraints

Bernd wrote: > I found nothing on the SQLite website stating that R*Tree tables don't > support foreign key constraints but apparently they don't. Is this > a limitation of virtual tables in general or is there something I > missed? When you execute "CREATE VIRTUAL TABLE t USING xxx(...)", any tex

[sqlite] Backwards compatibility from 3.8.4.3 to 3.6.20

Hi, I've been using latest v3.8.4.3 to write a database file, but when I try to open the file with my current distro's sqlite shell I get this error: $ sqlite3 file.sqlite SQLite version 3.6.20 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .schema Error: file i

Re: [sqlite] Backwards compatibility from 3.8.4.3 to 3.6.20

On Mon, Apr 7, 2014 at 5:47 AM, Alejandro Santos wrote: > Hi, > > I've been using latest v3.8.4.3 to write a database file, but when I > try to open the file with my current distro's sqlite shell I get this > error: > > $ sqlite3 file.sqlite > SQLite version 3.6.20 > Enter ".help" for instruction

[sqlite] Fwd: Re: comma-separated string data

This message went to the wrong address, apologies, herewith the repost: On 2014/04/06 20:23, Dominique Devienne wrote: On Sat, Apr 5, 2014 at 11:46 AM, RSmith wrote: WITH csvrec(i,l,c,r) AS ( SELECT tmpcsv.ID, 1, colCSV||',', '' FROM tmpcsv UNION ALL SELECT i,

Re: [sqlite] Is there a way to load a blob from the shell?

On Sun, 6 Apr 2014 21:43:27 -0400, Richard Hipp wrote: > At http://www.sqlite.org/sar there is a utility program that generates an > "SQLite Archive", similar to a ZIP archive but using SQLite as the file > format instead of the ZIP format. Wonderful, thanks! [Open]Solaris users may want to a

Re: [sqlite] comma-separated string data

On Sun, Apr 6, 2014 at 8:15 PM, Dominique Devienne wrote: > [...]. I'd much prefer a cleaner Oracle-like TABLE() > operator transforming the result array of a table-function operating > on correlated values from a join as an intermediate result-set, i.e. > > select t.key, csv.COLUMN_VALUE from tab

Re: [sqlite] Backwards compatibility from 3.8.4.3 to 3.6.20

On Mon, Apr 7, 2014 at 11:47 AM, Alejandro Santos wrote: > Hi, > > I've been using latest v3.8.4.3 to write a database file, but when I > try to open the file with my current distro's sqlite shell I get this > error: > For some reason I can see Richard Hipp answer on the Web but not on my Gmail a

Re: [sqlite] Backwards compatibility from 3.8.4.3 to 3.6.20

On Mon, Apr 7, 2014 at 9:32 AM, Alejandro Santos wrote: > On Mon, Apr 7, 2014 at 11:47 AM, Alejandro Santos > wrote: > > Hi, > > > > I've been using latest v3.8.4.3 to write a database file, but when I > > try to open the file with my current distro's sqlite shell I get this > > error: > > > > >

[sqlite] SQLite VFS for Chan FatFS

Hey All, Does anyone have an example of a VFS for use with Chan FatFS or Petit FatFS? Ref: http://elm-chan.org/fsw/ff/00index_e.html F. Andrew Beal Woods Hole Oceanographic Institution 266 Woods Hole Road MS#18 Woods Hole, MA 02543 Office: 508-289-2970 Email: [email protected]

Re: [sqlite] SQLite VFS for Chan FatFS

On Mon, Apr 7, 2014 at 9:52 AM, Andrew Beal wrote: > Hey All, > > Does anyone have an example of a VFS for use with Chan FatFS or Petit > FatFS? > > Ref: http://elm-chan.org/fsw/ff/00index_e.html > > Just glaceing at the interface spec, it appears that Petit FatFS only allows a single file to be

Re: [sqlite] Backwards compatibility from 3.8.4.3 to 3.6.20

On Mon, Apr 7, 2014 at 3:32 PM, Alejandro Santos wrote: > > Changing the journal_mode does not solve my issue :( > A self contained test case: $ LD_LIBRARY_PATH= ./sqlite3 /tmp/broken2.sqlite SQLite version 3.8.4.3 2014-04-03 16:53:12 Enter ".help" for usage hints. sqlite> PRAGMA page_size=65536

Re: [sqlite] Backwards compatibility from 3.8.4.3 to 3.6.20

On Mon, Apr 7, 2014 at 10:41 AM, Alejandro Santos wrote: > On Mon, Apr 7, 2014 at 3:32 PM, Alejandro Santos > wrote: > > > > Changing the journal_mode does not solve my issue :( > > > > A self contained test case: > > $ LD_LIBRARY_PATH= ./sqlite3 /tmp/broken2.sqlite > SQLite version 3.8.4.3 2014-

Re: [sqlite] Backwards compatibility from 3.8.4.3 to 3.6.20

On 2014/04/07 16:44, Richard Hipp wrote: On Mon, Apr 7, 2014 at 10:41 AM, Alejandro Santos wrote: On Mon, Apr 7, 2014 at 3:32 PM, Alejandro Santos wrote: Changing the journal_mode does not solve my issue :( A self contained test case: $ LD_LIBRARY_PATH= ./sqlite3 /tmp/broken2.sqlite SQLite

Re: [sqlite] Backwards compatibility from 3.8.4.3 to 3.6.20

On Mon, Apr 7, 2014 at 10:48 AM, RSmith wrote: > On 2014/04/07 16:44, Richard Hipp wrote: > >> On Mon, Apr 7, 2014 at 10:41 AM, Alejandro Santos > >wrote: >> >> On Mon, Apr 7, 2014 at 3:32 PM, Alejandro Santos >>> wrote: >>> Changing the journal_mode does not solve my issue :( A

[sqlite] What's the purpose of the "automatic index on" warning message?

We get an sqlite3_log() message with errorCode 284 and message "automatic index on ...". I assume this is some performance penalty warning, but I have no idea what to make of it: We do have an explicit index on the table and column mentioned in the warning message, so I don't know what to do to

Re: [sqlite] What's the purpose of the "automatic index on" warning message?

On Mon, Apr 7, 2014 at 11:51 AM, Jens Miltner wrote: > We get an sqlite3_log() message with errorCode 284 and message "automatic > index on ...". > I assume this is some performance penalty warning, but I have no idea what > to make of it: > > We do have an explicit index on the table and column

Re: [sqlite] SQLite VFS for Chan FatFS

Richard, I appreciate the reference. I am trying to replace a method based on the implementation you suggested since we discovered that the SQLite DB doesn't take up even a full 5 MB on our system so we are trying to reclaim the extra space on the flash chip for other features. Andrew Beal E

Re: [sqlite] comma-separated string data

On Apr 7, 2014, at 3:28 PM, Dominique Devienne wrote: > For those interested, here's an article along the same lines that > better demonstrate what I mean by the above: > > http://technology.amis.nl/2013/06/26/oracle-database-12c-joining-and-outer-joining-with-collections/ Aha! That’s what tha

[sqlite] How to speed up a bulk import

Hi I am using SQLite running under VB.net in a import routine of a series of csv files, but it seems to be slow, and I don't mean microseconds, I mean minutes. A typical INSERT might be: INSERT INTO AllSales (Source, MachineName, Location, UserPIN, TariffName, CustomerID, DateOfSale, TimeOf

Re: [sqlite] How to speed up a bulk import

On Apr 7, 2014, at 8:33 PM, J Trahair wrote: > Any suggestions welcome. Thank you. One word: transaction. ___ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to speed up a bulk import

On 7 Apr 2014, at 7:33pm, J Trahair wrote: > Would having a field index or key help? Adding more indexes and keys make searches faster, at the expense of making the original INSERT slower. As a test, instead of executing the INSERT commands, write the commands themselves to a text file. The

Re: [sqlite] How to speed up a bulk import

On 2014/04/07 20:33, J Trahair wrote: Hi I am using SQLite running under VB.net in a import routine of a series of csv files, but it seems to be slow, and I don't mean microseconds, I mean minutes. A typical INSERT might be: INSERT INTO AllSales (Source, MachineName, Location, UserPIN, Tari

Re: [sqlite] comma-separated string data

Hello, Dear Petite Abeille, you may repeat it 1 times, they don't listen, they prefer adding to the previous mistake instead of fixing the origin (hiding behind falsehood constraints, like it is way it is...) until it will fall apart with unsolvable issues and developer-made-bugs, surely that'

[sqlite] activate statement count with sqlite3_interrupt

Hi, I am considering using sqlite3_interrupt to interrupt a long query - but the documentation states that the order will stand until the activate statement count is zero. How do I know that the activate statement count is zero? ___ sqlite-users mailing l

Re: [sqlite] activate statement count with sqlite3_interrupt

On Mon, Apr 7, 2014 at 2:47 PM, E. Timothy Uy wrote: > Hi, I am considering using sqlite3_interrupt to interrupt a long query - > but the documentation states that the order will stand until the activate > statement count is zero. How do I know that the activate statement count is > zero? > You

Re: [sqlite] comma-separated string data

On Apr 7, 2014, at 8:48 PM, mm.w <[email protected]> wrote: > Dear Petite Abeille, you may repeat it 1 times, they don't listen, they > prefer adding to the previous mistake instead of fixing the origin (hiding > behind falsehood constraints, like it is way it is...) until it will fall > a

Re: [sqlite] activate statement count with sqlite3_interrupt

Isn't the interrupt in play until all active statements have been stopped? Including statements that are added after the interrupt is called? I just want to make sure it is safe to call the next statement. " Any new SQL statements that are started after the sqlite3_interrupt() call and before the

Re: [sqlite] activate statement count with sqlite3_interrupt

In this case I have a text box where the user types in search results. I want to cancel all pending searches the moment they start typing something else. On Mon, Apr 7, 2014 at 12:04 PM, E. Timothy Uy wrote: > Isn't the interrupt in play until all active statements have been stopped? > Includin

Re: [sqlite] comma-separated string data

On 2014/04/07 20:57, Petite Abeille wrote: Lipstick Driven Design: “You can put lipstick on a pig, but it’s still a pig.” But if the Customer can't tell the difference, does that make you a good pimp? ___ sqlite-users mailing list sqlite-users@sqli

Re: [sqlite] Is there a way to load a blob from the shell?

About my shell extension implementing ".blobextract" and ".blobreplace" commands, Richard Hipp writes: "apparently uses the incremental BLOB I/O interface to avoid the need to load entire images into memory." and "That is nice, but on a modern workstation with many GB of RAM, is it really necessar

Re: [sqlite] How to speed up a bulk import

I do 12.3 million inserts with a single commit in approx 1 minute using prepared statements and parameters in accordance with the "Getting the best performance out of SQLite" section of the SQLite.NET.chm help file, which is available here: http://system.data.sqlite.org/index.html/doc/trunk/Doc

Re: [sqlite] comma-separated string data

"But if the Customer can't tell the difference, does that make you a good pimp?" Hello, you just don't get it then you don't get it, that's it. Best Regards On Mon, Apr 7, 2014 at 12:09 PM, RSmith wrote: > > On 2014/04/07 20:57, Petite Abeille wrote: > >> Lipstick Driven Design: “You can pu

Re: [sqlite] Is there a way to load a blob from the shell?

Hi Richard, 'SAR' looks like a great utility! However, on production *nix machines, the path to the SQLite 'sar' will probably have to be absolute, or else the native 'sar' (System Activity Reporter) will run instead. Perhaps add a caveat to the docs for SQLite's 'sar?' Keith On Sun, Apr 6, 2

Re: [sqlite] comma-separated string data

Why are these people allowed to use this discussion board? Using SQLite on a critical corporation application I find that by reading the material provided it is handling terabyte databases with remarkable performance. SQLite does not have the cost associated with one like Oracle and does not

Re: [sqlite] Is there a way to load a blob from the shell?

On Mon, Apr 7, 2014 at 6:56 PM, Keith Christian wrote: > > However, on production *nix machines, the path to the SQLite 'sar' > will probably have to be absolute, or else the native 'sar' (System > Activity Reporter) will run instead. > Huh. Never heard of it. It is not installed on my Ubuntu d

Re: [sqlite] comma-separated string data

On Apr 8, 2014, at 1:02 AM, David Simmons wrote: > Why are these people allowed to use this discussion board? Hmmm? What we've got here is failure to communicate perhaps. ___ sqlite-users mailing list [email protected] http://sqlite.org:8080/

Re: [sqlite] Is there a way to load a blob from the shell?

On Apr 8, 2014, at 1:13 AM, Richard Hipp wrote: > Huh. Never heard of it. It is not installed on my Ubuntu desktop. $ which sar /usr/bin/sar $ man sar sar(1) NAME sar -- system activity reporter $ uname -s Darwin http://www.linuxmanpages.com/man1/sar.1.php _

Re: [sqlite] comma-separated string data

On 2014/04/08 01:02, David Simmons wrote: Why are these people allowed to use this discussion board? Using SQLite on a critical corporation application I find that by reading the material provided it is handling terabyte databases with remarkable performance. SQLite does not have the cost ass

Re: [sqlite] Is there a way to load a blob from the shell?

On Mon, Apr 7, 2014 at 4:13 PM, Richard Hipp wrote: > Realize the my whole purpose in writing "sar" was to demonstrate that > SQLite could serve at least as well as an application's "save-file format" > as does a ZIP archive. Note that ZIP is used as the file format for ePUB > and ODT. > > Additi

Re: [sqlite] Is there a way to load a blob from the shell?

On Apr 8, 2014, at 1:46 AM, Andreas Kupries wrote: > Most generally, a website to show off any kind of contribution to > sqlite, be it custom function, virtual table, virtual filesystem, > schemata, other extensions, … ? A bit obsolete, but: http://www.sqlite.org/contrib Perhaps github could

Re: [sqlite] comma-separated string data

Hello, thus, good, incident closed, we've seen worse; I guess, the misunderstanding was triggered by not following up and well on the lipstick 8-p Best. On Mon, Apr 7, 2014 at 4:27 PM, RSmith wrote: > On 2014/04/08 01:02, David Simmons wrote: > >> Why are these people allowed to use this disc

Re: [sqlite] comma-separated string data

On Mon, Apr 7, 2014 at 5:28 PM, Dominique Devienne wrote: > So the only piece > that's missing is an official way to use vtables "on the fly", and > pass in to its xFilter method the value from the left-correlated value > for each joined left value, so the resulting cursor can "iterate" the > righ