Re: [sqlite] (no subject)

That worked thanks Igor. On 16 May 2013 15:33, Paul Sanderson wrote: > Rob yes thats correct > > Igor - thanks I'll give that a go > > > > On 16 May 2013 14:51, Rob Richardson wrote: > >> First idea: include a subject line. >> >> I'm not 1

Re: [sqlite] (no subject)

> I'm guessing you wanted to say: > " For those entries in table1 where there is a null in t1..." > > Is that right? > > RobR > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin

[sqlite] (no subject)

I have two tables of the form create table1 (id1 int, t1 text) create table2 (id2 int unique, t2 text) the data in table 1 is such that some values for t1 are NULL ID1 can contain duplicates ID2 is unique and for every instance of ID1 in table1 there will be a corresponding ID2 entry in table2 t

Re: [sqlite] Possible bug in type conversion prior to comparison

Actually, to be more accurate, the internal storage may be far from a float (as in IEEE double) but a divide on an integer-looking value will certainly be done with floating point math. On Mon, May 13, 2013 at 6:13 PM, Paul van Helden wrote: > > I should have asked you for (1,2,20) as we

Re: [sqlite] Possible bug in type conversion prior to comparison

> I should have asked you for (1,2,20) as well and we could see whether it > outputs '10' or '10.0'. But yes, it would appear that in Oracle, NUMERIC > means FLOAT. > > Of course it does! All the others too. ___ sqlite-users mailing list sqlite-users@sql

Re: [sqlite] SQLite and integer division 1/2=0

Tim, Simon & Darren, if you read my whole OP you will see that I've discovered this: use REAL instead. My point is that the behaviour of a NUMERIC column is not intuitive and gives mixed results which wouldn't be a problem if the division operator could be modified. My suggestion cannot be too outl

Re: [sqlite] SQLite and integer division 1/2=0

On Sun, May 12, 2013 at 1:54 PM, Michael Black wrote: > PRAGMA INTEGER_DIVISION would probably not have saved you this bug as you > would not have known to turn it on (default would have to be OFF for > backwards compatibility). I will use it on every connection I make in future to avoid futur

[sqlite] SQLite and integer division 1/2=0

don't know this, as I'm sure most regular users don't, it can really burn you. I don't mind the conversion to integer, but then 1/2 should be 0.5. On my wishlist: PRAGMA INTEGER_DIVISION = off; I would use it all the time. Yes "feature creep" I can hear you

Re: [sqlite] Is there a way to select a precision?

> A delared type of NUMBER(10,2) has NUMERIC affinity, which means that > SQLite will attempt to store (string) values as integers first and floats > second before giving up and storing strings. > This has nothing to do with my reply and I understand how it works. > > You do realize that there ar

Re: [sqlite] Is there a way to select a precision?

> > > What do you mean, select precision? The double value you pass to > sqlite3_bind_double() will be used as is. Are you saying you want to round > it first? Then go ahead and do that - I'm not sure what that has to do with > SQLite. > -- > It is an issue with SQLite because the values in NUMBER(

[sqlite] Slowness with FTS Queries and non-FTS tables

Hi All, We've got some trouble with FTS4 queries taking too long in which we're looking for a subset of matching records in the FTS table, as narrowed by a non-FTS table. CREATE TABLE metadata( key AS INTEGER PRIMARY KEY, sectionID AS INTEGER ); CREATE INDEX sectionIdx on metadata(sectionID)

[sqlite] SQLite Shell with Custom FTS Tokenizer

into a build of the sqlite shell, without modifying the shell sources?   Thanks! -Paul ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Restrictions on JOINs with FTS tables

ping to do, but I don't quite see the pattern of when FTS tables can co-mingle with regular tables in queries.  Could someone help clarify the behavior of when MATCH can be used and when it can't when joining FTS and regular tables? Thanks! -Paul ___

[sqlite] FTS Find Tokens at Record Start

be a subset of those results.  It looks like I could programmatically parse the output of the offsetsfunction to find this info and manually filter my results, but is there a way to set up the query so it does the filtering for me, and only returns results that start at byte offset 0 in the c

Re: [sqlite] looking up records with terms in a table

Try this: SELECT Sentences FROM T1 JOIN T2 ON T1.Sentences LIKE CONCAT('%',T2.Terms,'%') Paul -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rob Richardson Sent: Tuesday, March 26, 2013 10:27 AM To: G

Re: [sqlite] Joining tow tables with subset of columns from one

Yes thanks Kevin Dull question and I was just coming back here to say I have sorted it. Thanks anyway :) On 13 March 2013 17:59, Kevin Martin wrote: > > On 13 Mar 2013, at 17:44, Paul Sanderson wrote: > > > I want to join two table by doing a select in the form > >

[sqlite] SQLite2010 Pro ODBC Driver

ounty from zip where state = 'AZ' returns 82,011records. Select Distinct does not change the result. The SQLite3 ODBC Driver does not have this issue. Thank you, Paul ___ sqlite-users mailing list sqlite-users@sqlite.org http://s

Re: [sqlite] column totals

Hmm works OK at an sqlite prompt but not when I pass the query though a data access component On 23 February 2013 11:05, Clemens Ladisch wrote: > Paul Sanderson wrote: > > Works well summing the columns but I don't get a 'tot' label I, get > > > > 1

Re: [sqlite] column totals

Thank You Works well summing the columns but I don't get a 'tot' label I, get 1 54 3 2 26 4 3 56 8 0136 15 On 22 February 2013 23:20, Clemens Ladisch wrote: > Paul Sanderson wrote: > > SELECT cat, COUNT(*) AS occ, COUNT(DISTINCT te

[sqlite] column totals

I have the following query that produces a summary table SELECT cat, COUNT(*) AS occ, COUNT(DISTINCT tes) AS uni, COUNT(tag) AS tagged FROM rtable WHERE qu > 0 AND qu < 4 GROUP BY qu The table would look something like 1 54 3 2 26 4 3 56 8 I want to modify the above sql

Re: [sqlite] creating a summary table

That did the job - Thank You On 18 February 2013 18:15, James K. Lowden wrote: > On Mon, 18 Feb 2013 17:02:53 + > Paul Sanderson wrote: > > > nc > > 1a > > 2a > > 3a > > 4b > > 5b > > 3b > > 4b >

[sqlite] creating a summary table

nc 1a 2a 3a 4b 5b 3b 4b 2b 3a 5b 2b I have a table as above I want to create a summary table that shows in the first column the total number of occurrences of a value in the first column (n) and in the second column for each value in n a count of t

[sqlite] Unlocking locked database and preventing locking to start with

I have a user who has a locked database. I don't know why the db is locked but suspect either he killed the program when it was adding an index or my program crashed (he was using a beta version). Irrespective of wghich he has a db that is locked and I'd like to unlock it. My database would normal

Re: [sqlite] populating a table as quickly as possible

This is a fast way to load data. sqlite3.exe C:\\Your Dir\\dbname.db mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Paul Sanderson Sent: Tuesday, February 05, 2013 2:32 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] populating a table as quickly as possible Currently

Re: [sqlite] populating a table as quickly as possible

Currently ading 5000 at a time, will try increasing to 20 and 50K and see what happens. Just one table - but interesting On 4 February 2013 18:24, Dominique Pellé wrote: > Paul Sanderson wrote: > > > I want to populate a large table (millions of rows) as quickly as > possib

Re: [sqlite] populating a table as quickly as possible

currently using : journal_mode = off page_size=16386 cache_size = 1 synchronous = off I load lots of similar data sets (each into a separate db) and load time is definitely an issue. There are processing delays and loading a db can take 30+ minutes, if I can shave off even a few minutes on eac

Re: [sqlite] Sqlite query doesn't run correctly on different databases

Thanks Richard that worked On 1 February 2013 11:23, Richard Hipp wrote: > The expression "x NOT IN (something-that-contains-NULL)" is always false. > I suggest you add an additional term to the WHERE clause of the subquery: > "... AND md5 NOT NULL". > > O

Re: [sqlite] Determine if an index has been created

even easier - thank you. Paul On 1 February 2013 11:46, Simon Slavin wrote: > > On 1 Feb 2013, at 10:12am, Paul Sanderson > wrote: > > > I will know the name of the index - I just need to check that it has been > > created. > > Oh, in that case just submit the &

Re: [sqlite] Determine if an index has been created

Thank You On 1 February 2013 10:38, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 01/02/13 02:12, Paul Sanderson wrote: > > I will know the name of the index - I just need to check that it has > > been created. > > Just use pragm

Re: [sqlite] Determine if an index has been created

I will know the name of the index - I just need to check that it has been created. On 1 February 2013 00:09, Simon Slavin wrote: > > On 31 Jan 2013, at 10:57pm, Igor Tandetnik wrote: > > > On 1/31/2013 5:45 PM, Paul Sanderson wrote: > >> Is it possible to ascertain if

Re: [sqlite] (no subject)

etnik wrote: > On 1/31/2013 2:33 PM, Paul Sanderson wrote: > >> My query is >> >> select fileref from rtable as r where vsc > 0 and isgraphic = 1 and not >> exists (select md5 fr >> om rtable as r1 where r.md5 = r1.md5 and isgraphic = 1 and vsc = 0); >>

Re: [sqlite] SQL query

Still playing with this I have the following table and I run the following query - the results of which are what I expect name, num, md5 sqlite> select * from rtable; $RmMetadata|0|8465-CEEF-126A-0F04-1EDC-1D7B-331F-9279 $RmMetadata|1|8465-CEEF-126A-0F04-1EDC-1D7B-331F-9279 $RmMetadata|2|8465-CE

Re: [sqlite] (no subject)

Thanks all All columns in the query are indexed. I'll try teh suggestions and see how they perform. On 31 January 2013 19:54, Igor Tandetnik wrote: > On 1/31/2013 2:33 PM, Paul Sanderson wrote: > >> My query is >> >> select fileref from rtable as r where vsc

Re: [sqlite] SQL query

242-E734-B125-D02F-A7F0-DC29 > file1|8|01EE-7E2E-2242-E734-B125-D02F-A7F0-DC29 > sqlite> SELECT * FROM files WHERE hash NOT IN (SELECT hash FROM files WHERE > setid=0) group by hash; > file1|8|01EE-7E2E-2242-E734-B125-D02F-A7F0-DC29 > file1|6|0546-4667-5A69-6478-FC97-6F27-840D-7D62 &

Re: [sqlite] SQL query

jpg',4,'890B-4533-447E-6461-070E-FDB7-799E-1FB8'); > sqlite> SELECT * FROM files WHERE hash NOT IN (SELECT hash FROM files WHERE > setid=0); > 1.jpg|4|890B-4533-447E-6461-070E-FDB7-799E-1FB8 > > > -Original Message- > From: sqlite-users-boun...@sqlit

Re: [sqlite] SQL query

ich is great and solves my problem, but I cant see why the first query doesn't work. On 30 January 2013 21:37, Paul Sanderson wrote: > > Thanks All - duplicated means the content is the same as well as the name, > different is the filename is the same but the content is differe

Re: [sqlite] SQL query

Thanks All - duplicated means the content is the same as well as the name, different is the filename is the same but the content is different. I need to refine my query to produce only one copy of any that is not in set 0 file10ABCD file11ABCD file13EF01 file20BCE2

Re: [sqlite] Substring Search Across Many Columns

As I understand, it's tricky to get FTS to do substring matching, no?  What's the best way to do that? Thanks! Paul From: Roger Binns To: General Discussion of SQLite Database Sent: Friday, January 25, 2013 12:01 PM Subject: Re: [sqlite] Substr

[sqlite] Substring Search Across Many Columns

posite index that has all those columns speed up a LIKE query across all the columns in that index?  That is, we'd like it to only have to do one index scan, rather than multiple table scans - will a composite key help with that? Any other sugges

[sqlite] Best practices for Valgrind

Valgrind suppression files to be used with SQLite using programs like PyGObject has [1]? Thanks and sorry if I wrote nonsense, Paul [1] http://www.midori-browser.org [2] https://mail.gnome.org/archives/commits-list/2010-December/msg11251.html signature.asc Description: This is a digitally signed

Re: [sqlite] Bug: Segmentation fault in libsqlite3.so.0.8.6[b69a4000+ac000]

Am Sonntag, den 02.12.2012, 22:49 +0100 schrieb Paul Menzel: > using Debian Sid/unstable with self-built Evolution 3.4.4 and > libsqlite3-0 3.7.14.1-1, Evolution crashed with a segmentation fault. > > pool[15522]: segfault at 5 ip b69bafe3 sp 8acf0850 error 6 in > libs

Re: [sqlite] Bug: Segmentation fault in libsqlite3.so.0.8.6[b69a4000+ac000]

Dear SQLite folks, Am Sonntag, den 02.12.2012, 22:49 +0100 schrieb Paul Menzel: > using Debian Sid/unstable with self-built Evolution 3.4.4 and > libsqlite3-0 3.7.14.1-1, Evolution crashed with a segmentation fault. > > pool[15522]: segfault at 5 ip b69bafe3 sp 8acf085

[sqlite] Bug: Segmentation fault in libsqlite3.so.0.8.6[b69a4000+ac000]

ad (arg=0x8acf1b70) at pthread_create.c:304 __res = __ignore1 = __ignore2 = pd = 0x8acf1b70 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {-1228271628, 0, 4001536, -1966140728, 2098

[sqlite] list: Please allow signed messages.

Dear list administrators, please allow signed messages to be sent to the list. I got: »The message's content type was not explicitly allowed« Thanks, Paul ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cg

Re: [sqlite] sqlite-users Digest, Vol 59, Issue 28

9|868763 854808|854809 |854808 sqlite> SELECT c FROM mytable WHERE c NOT IN (SELECT IFNULL(b,0) FROM mytable); 868763 Regards, Paul. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] creating indexes on empty columns

Sorry - generally the sorts will be on one column - but they may choose at a later time to sort by another column. They will (but rarely - sort by two or more columns at the same time). On 26 November 2012 14:20, Clemens Ladisch wrote: > Paul Sanderson wrote: > > My software create

Re: [sqlite] creating indexes on empty columns

Thanks for the replies - I'll try and read through them all thoroughly a bit later. But for now a bit of background. My software creates a large table containing anything between about 250K and Millions of rows when first run, the indexes are created immediately after the table is populated and t

Re: [sqlite] creating indexes on empty columns

turn. This would save on the overhead of reading the entire table for each column. On 24 November 2012 14:40, Clemens Ladisch wrote: > Paul Sanderson wrote: > > Whilst building a new app I created an index on every column some of > which > > were empty. > > And with "

[sqlite] creating indexes on empty columns

don't really have an idea of how sqlite works internally, but this seems like an area where there could be some optimisation - or anm I totally off track? -- Paul ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/ma

Re: [sqlite] Finding .db file in XCode project

he same > iDevice to access them because that other app will be looking inside its own > space. > > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > __

Re: [sqlite] FTS substring behavior

That's a promising project; I hope it reaches maturity. I assume your modified tokenizer did a similar thing, like tokenizing "full text search" as [full, text, search, ull, ll, l, ext, xt, xt, earch, arch, rch, ch, h]? What worked and what did not work

[sqlite] FTS substring behavior

main table? The number of unique tokens we have is small compared to the total number of records, so if it only scanned the token index it would in theory help. Thanks Paul ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-b

Re: [sqlite] TRUNCATE TABLE alias for DELETE FROM

> > It would be possible to implement TRUNCATE TABLE on top of that, but > this would be only syntactic sugar. > ..or better portability. TRUNCATE TABLE works (since only a few years) nearly everywhere. So when writing portable applications it seems a bit silly to make an exception for SQLite if t

[sqlite] TRUNCATE TABLE alias for DELETE FROM

Hi, TRUNCATE TABLE is now in the SQL:2008 standard. http://en.wikipedia.org/wiki/Truncate_(SQL) It would make portability easier if SQLite understood TRUNCATE TABLE to be the same as DELETE FROM without WHERE. Yes? No? Paul. ___ sqlite-users mailing

Re: [sqlite] SQLite on flash (was: [PATCH 00/16] f2fs: introduce flash-friendly file system)

unlink() the memory because we know in what order our processes start & stop. But presumably you already have that issue in the mmap() version. Paul. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Unofficial poll

I am using this feature a lot. My applications log all changes to the database, SQL and parameters. So I have an attached log.db with a field for the SQL and then 32 typeless columns for the parameters. Works like a charm! On Sun, Sep 23, 2012 at 12:37 PM, Baruch Burstein wrote: > I am curious ab

Re: [sqlite] IN operator hits

On 17 September 2012 17:23, E. Timothy Uy wrote: > Is there a way to figure out which of the terms in an IN operator > actually hit? Perhaps making a temp table is the only way. Any help Do you mean... SELECT DISTINCT col FROM tbl WHERE col IN ('a', 'b',

[sqlite] Getting query results as new records are added

to the database, some of which may match our query.   We'd like update the query results view with new records as they're added, without having to repeat the whole query and weed out the results we're already showing? Any suggestions are appreciated. -Paul ___

Re: [sqlite] Select rows where a column is not unique

On Mon, Aug 6, 2012 at 2:58 PM, Tilsley, Jerry M. wrote: > Guys, > > I'm sure this is a pretty lame question, but my thinking hat is > malfunctioning this morning. How can I select all rows from a table where > a specific column is NOT UNIQUE? Table has three columns (charge_code, > mnemonic, de

Re: [sqlite] database AND table already exist?

ch column in the named table". Obviously this doesn't tell you anything about the schema of the table, just a '1' or a '0'. Regards, Paul. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Update trigger fires for all rows even if sqlite3_changes returns 0

> > > Then why do you keep hammering on the idea that SQLite is somehow > incorrect or wrong? > > You've explained what you're trying to do. We've explained there is > a better way to do that, that also happens to provide the correct > answer on all platforms, AND likely runs faster-- es

Re: [sqlite] Update trigger fires for all rows even if sqlite3_changes returns 0

On Tue, Jul 3, 2012 at 3:03 PM, Black, Michael (IS) wrote: > And Oracle says the opposite: > > Yet they all give the same answer when done with "update testtable set > testrow=null where testrow not null; > > You keep hammering this one, it is obvious, I understand, THANKS! What if the SET and WH

Re: [sqlite] Update trigger fires for all rows even if sqlite3_changes returns 0

On Tue, Jul 3, 2012 at 2:45 PM, Black, Michael (IS) wrote: > What's better is that it tells you what you asked for...not what you think > you asked for...which it does. > I asked for changes :-) > > You've already been shown the correct solution...a WHERE clause... > > I've done that even before

Re: [sqlite] Update trigger fires for all rows even if sqlite3_changes returns 0

On Tue, Jul 3, 2012 at 2:43 PM, Paul van Helden wrote: > >> The statement "UPDATE table SET column=NULL" updates every row in the >> table. The fact that some rows may already have a NULL in that >> column is not important. >> >> Well, it is impo

Re: [sqlite] Update trigger fires for all rows even if sqlite3_changes returns 0

> > > The statement "UPDATE table SET column=NULL" updates every row in the > table. The fact that some rows may already have a NULL in that > column is not important. > > Well, it is important to me, the word "change" means before != after :-) ___

Re: [sqlite] Update trigger fires for all rows even if sqlite3_changes returns 0

n it comes to triggers? On Tue, Jul 3, 2012 at 2:19 PM, Yuriy Kaminskiy wrote: > Paul van Helden wrote: > > Is this correct? Should update triggers not only fire for actual > changes? I > > have a large table with a column which contains all NULL values except > for > &

[sqlite] Update trigger fires for all rows even if sqlite3_changes returns 0

Hi, Is this correct? Should update triggers not only fire for actual changes? I have a large table with a column which contains all NULL values except for 4. I expected an UPDATE table SET column=NULL to only fire 4 triggers, except it fires for every row. Thanks, Paul

[sqlite] SQLite Encryption Extension Performance?

Hi there, We are considering using the SQLite Encryption Extension in one of our products, and are wondering what the performance characteristics of it are?   Does the encryption algorithm affect performance?   Any stats on this you might have would be useful. Thanks! -Paul

Re: [sqlite] Specifying a nullable column

On 12-Jun-2012 08:08, Richard Hipp wrote: On Tue, Jun 12, 2012 at 7:04 AM, Paul Medynski wrote: Hi Kevin, I understand the 'NOT NULL' column constraint and the syntax diagram and text describe it quite well. What isn't described is whether or not specifying simply 'NULL

Re: [sqlite] Specifying a nullable column

documentation doesn't mention it explicitly. Thanks, -Paul On 11-Jun-2012 15:35, Kevin Benson wrote: On Mon, Jun 11, 2012 at 10:35 AM, Paul Medynski wrote: Hi folks, I notice that the syntax diagram for 'create table' shows the 'column-constraint' definition as r

[sqlite] Specifying a nullable column

3 3.7.3 or 3.7.9, I can create a table and specify any column as "Foo null", and it works as expected allowing the column to contain null values. Is the syntax diagram simply out of date, or am I doing something that appears to work, but will bite me in the end? :) Thanks, -P

[sqlite] SQL Query - finding rows in a table that are not present in another

I have a couple of table seach of which has one column but millions of rows, the column is a text column. I need to return all of the rows in table B that are not present in table A What is the most efficient way of doing this? ___ sqlite-users mailing

Re: [sqlite] Data race (file race) in pager

ey will be once I have an interesting study. Thanks, Paul On 5 May 2012 06:14, Dan Kennedy wrote: > On 05/04/2012 11:21 PM, Paul Thomson wrote: >> >> I am working on a tool that (among other things) can detect data >> races, including file access races. I have detected

[sqlite] Data race (file race) in pager

thread when the race occurs, unless it becomes obvious that the above functions cannot race. What is best way to provide these files? (attachments? upload to a website and provide a link?) Thanks, Paul ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Typo in documentation

Hello! I just found a typo in http://www.sqlite.org/fileformat.html Search for "stored with the must significant byte first" that should read: "stored with the most significant byte first". A one letter typo, no big deal. -- Barbu Paul - Gheorghe Common sense is not so com

Re: [sqlite] SQL help

Thanks all, dates are stored internally as integers -- Paul ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQL help

is 1 1/1/2011 2 1/1/2011 2 2/1/2011 3 1/1/2011 3 2/1/2011 3 3/1/2011 5 7/1/2011 I want to be left with 1 1/1/2011 2 1/1/2011 3 1/1/2011 5 7/1/2011 -- Paul ___ sqlite-users mailing list

Re: [sqlite] select ... where [=] or [like]

On 09 November 2011 15:32, hmas wrote: > sqlite> select hex(foocol) from footable where foocol like > '98012470700566'; > 39393939393830313234373037303035363600 It looks like there's an extra 00 on the end. x'3900' != x'39' Paul. ___

Re: [sqlite] Slow INDEX

> If you could use DTrace you could really find out, but since we have How about something like sysinternals diskmon? http://technet.microsoft.com/en-us/sysinternals/bb896646 That should give you (OP) some indication of what disk activity is going on. P

Re: [sqlite] Slow INDEX

On 02 November 2011 16:42, Fabian wrote: > Maybe there is a very simple explanation, I just can't think of any. A stateful antivirus that does lots of heavy processing when you first open the file? Have you tried: 1) Reboot 2) Wait 10 minutes (don't even touch the computer)

Re: [sqlite] EXT : core dump happened in sqlite3_step for 30 statements in BEGIN TRANSACTION executing every 10 Millisecond Take 3

e given was generated from the core file with gdb then in gdb I'd try frame 10 print *dbStatementsIter to see the query to see if that gives any clues. It might need "gdb-stl-views" or similar installed to make any sense. Regards, Paul.

Re: [sqlite] Tables as ASCII - is it possible?

- anyway, I wouldn't use it. If I could go with a scripting language, it would be Python - vastly superior IMHO to Perl - YMMV. It's shell scripting that I want to be able to do - remember my manager? Thanks for your input. Paul... > Puneet Kishor

Re: [sqlite] Tables as ASCII - is it possible?

ption would be slower than the current one - only if the user chose it though. > Feel free to write it, and contribute your code. I consider anything more sophisticated than "Hello World" to be advanced C! ;) Thanks for your input. Paul...

[sqlite] Tables as ASCII - is it possible?

might be a good idea. Paul... -- lineh...@tcd.ie Mob: 00 353 86 864 5772 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] feed "endless" data into sqlite, thru a shell script

ts data into SQLite, the third sleep 20 &c. I know it's an appalling hack, but could be useful to somebody? Sincères saluations. Paul... > patpro -- lineh...@tcd.ie Mob: 00 353 86 864 5772 ___ sqlite-users mailing list sqlite-user

Re: [sqlite] feed "endless" data into sqlite, thru a shell script

2011/9/27 Patrick Proniewski : >> Take a look at a utility called dstat. > no, it's linux only. But it is written in Python - so it should be relatively transportable. I've even managed to modify the code myself - and if I can do it, anybody can! 8-) Paul... > pa

Re: [sqlite] feed "endless" data into sqlite, thru a shell script

anyway? I'm interested because I've done something similar. Paul... > patpro -- Hmmm a "life": wonder where I can download one of those? lineh...@tcd.ie Mob: 00 353 86 864 5772 ___ sqlite-users mailing list sqlite-us

Re: [sqlite] feed "endless" data into sqlite, thru a shell script

2011/9/27 Patrick Proniewski : > That's what I do, but I think using a loop is ugly, and I would like to find a > way to feed data continuously into sqlite. cron Paul... > patpro -- Hmmm a "life": wonder where I can download one of those? lineh...@tcd.ie

Re: [sqlite] feed "endless" data into sqlite, thru a shell script

iostat say yesterday?". When I have it fully working with Oracle (XE 10), I plan to get it working with SQLite - it should be reasonably easy using .csv and cron jobs. Paul... -- Hmmm a "life": wonder where I can download on

Re: [sqlite] Feature about Foreign Keys

om Oracle - it's free to use and is *_very_* nice for doing just what you want, albeit manually. Paul... -- Hmmm a "life": wonder where I can download one of those? lineh...@tcd.ie Mob: 00 353 86 864 5772 ___ sqlite-users m

Re: [sqlite] Could someone explain why this query is so slow

Ahh I was sure that this was being created :( ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Could someone explain why this query is so slow

-TREE FOR ORDER BY Which seems to indicate that the b-tree is still being created (I'll test shortly, but running another long test at the moment) On 21 September 2011 14:33, Igor Tandetnik wrote: > Paul Sanderson wrote: >> select ID FROM rtable WHERE search > 0 and MD5 is NULL an

[sqlite] Could someone explain why this query is so slow

The query below takes about 10 mins to run, any idea why this would be? select ID FROM rtable WHERE search > 0 and MD5 is NULL and isf = 0 ORDER BY afo The same query without the ORDER BY takes a few seconds. select ID FROM rtable WHERE search > 0 and MD5 is NULL and isf = 0 There are approxima

Re: [sqlite] update required

incères salutations. Paul... > D. Richard Hipp -- lineh...@tcd.ie Mob: 00 353 86 864 5772 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Suggest some Tools for Sqlite

fox extension - I think it's great! Paul... > Madhan Kumar R -- lineh...@tcd.ie Mob: 00 353 86 864 5772 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL query help

Hmm thanks Roger Table could have a few million rows, i'll have a play and see what the run time is. The relevant column is indexed On 20 August 2011 17:14, Roger Andersson wrote: >  On 08/20/11 05:42 PM, Paul Sanderson wrote: >> Hi all >> >> I am trying to create a qu

[sqlite] SQL query help

Hi all I am trying to create a query that works to craete a subset of a table based on duplicate items Examples work best so consider the contrived table with the following rows 10 socata 7 socata 13 cessna 2 piper 7 piper 55 piper 1 diamond I want to see the subset that is 10 socata 7 socata 2

Re: [sqlite] Performance Improvement

> I can at least store all the data, for the cases I have tested till > now (600 billion entries for now), but it is awfully slow. I'm not surprised. Maybe you should consider some sort of partitioning scheme? Take a look at VoltDB.com - it might be an approach? Paul... -- Hmmm.

Re: [sqlite] current version support wal mode?

QL or PL/SQL is SQL, it is an "extension", albeit a non-proprietary one. Having said that, I will take my punishment like a man and admit to being wrong in this context - apologies for any offence/confustion caused! > Have a nice day. Agus tusa! Paul... > Danny --

Re: [sqlite] current version support wal mode?

2011/7/2 Kees Nuyt : > Just feed it the SQL statement: >        PRAGMA jounal_mode=WAL; I'm not being nasty here, but that is *_not_* an SQL statement. It is a C directive (or, at least, that's what I think it is!). Rgs, Paul... -- lineh...@tcd.ie Mob: 00

<    1   2   3   4   5   6   7   8   >