[sqlite] [ANN] SQLiteAdmin Released

I'm pleased to announce the general availability of SQLiteAdmin, an SQLite database administration tool for Mac and Windows. A 30-day demo of the application is available for download here. To mark the launch of SQLiteAdmin, I am making it available for $9.99

Re: [sqlite] is SQLite the right tool to analyze a 44GB file

Hi Michael, May I make a request on behalf of the C++ challenged crowd? Is it possible to fuse your contribution with the existing capabilities of the ".import" command so that it can be activated via syntax similar to - "RECORDS DELIMITED BY... FIELDS TERMINATED BY... OPTIONALLY ENCLOSED BY..."

Re: [sqlite] inner join problem

> update dzhhq set mnote= > case when mnote in (select mnote from dzhhq inner join (select bs,stkcode > from buysell) b on dzhhq.stkcode=b.stkcode) then 'sell'||mnote > else mnote > end > is ok, but when I use this cmd then appear error msg: > update dzhhq set mnote= > case when mnote in

[sqlite] inner join problem

update dzhhq set mnote= case when mnote in (select mnote from dzhhq inner join (select bs,stkcode from buysell) b on dzhhq.stkcode=b.stkcode) then 'sell'||mnote else mnote end is ok, but when I use this cmd then appear error msg: update dzhhq set mnote= case when mnote in (select mnote from

Re: [sqlite] Details on New Features

On Sun, May 6, 2012 at 8:00 PM, Donald Griggs wrote: > Regarding:   What precisely are the > "improvements" in handling of CSV inputs? > > > Gabor, I don't know about "precisely" -- I'll let others on the list tell > me where I'm off, but here's my take: > > > A lot of strange

Re: [sqlite] Details on New Features

Regarding: What precisely are the "improvements" in handling of CSV inputs? Gabor, I don't know about "precisely" -- I'll let others on the list tell me where I'm off, but here's my take: A lot of strange things call themselves csv, but the change attempts to make the sqlite3 utility's CSV

Re: [sqlite] Ubuntu 11.10 and Sqlite3

On Sun, 6 May 2012 19:01:02 +0200 (CEST), "pl...@libero.it" wrote: >Hi at all, >i have installed sqlite3 on Ubuntu 11.10 but I get error mismatch when i >execute sqlite3 by terminal session > >SQLite header and source version mismatch >2009-09-11 14:05:07

Re: [sqlite] Ubuntu 11.10 and Sqlite3

http://comments.gmane.org/gmane.comp.db.sqlite.general/71215 -- -- -- --Ô¿Ô-- K e V i N On Sun, May 6, 2012 at 1:01 PM, pl...@libero.it wrote: > Hi at all, > i have installed sqlite3 on Ubuntu 11.10 but I get error mismatch when i > execute sqlite3

Re: [sqlite] Locking/Concurrency

KUSHAL SHAH wrote: > My scenario: Multiple processes want to access the database. How do I > configure so that I can get as much concurrency w.r.t read > and write. Meaning, have multiple readers and writers. The best concurrency between separate processes (and thus,

Re: [sqlite] Locking/Concurrency

Sorry, when I said mutex mode, I meant the Runtime selection of threading mode: http://sqlite.org/threadsafe.html   At this point, I am sorry, I am confused with threading mode, journal mode and locking modes.   My scenario: Multiple processes want to access the database. How do I configure so

Re: [sqlite] ordering doesn't work the way I expected

On May 6, 2012, at 8:34 PM, Simon Slavin wrote: > I'm not sure about a requirement for consistency. NULL isn't a value. It > means something like 'value unknown'. Anything attempting to sort columns > with nulls in can sort any of the nulls into any position. Well, as pointed out by Yuriy

Re: [sqlite] how to update the select commad

叶艳红 wrote: > update dzhhq set mnote= > case when (select dzhhq.*,b.bs from dzhhq inner join (select bs,stkcode > from buysell) b on dzhhq.stkcode=b.stkcode) then 'sell'||mnote > else mnote > end I'm not quite sure I understand what you are trying to achieve. Perhaps something

Re: [sqlite] ordering doesn't work the way I expected

On 06-05-2012 20:28, Petite Abeille wrote: > > On May 6, 2012, at 8:18 PM, Luuk wrote: > >> So, if it is not defined how to sort column b, >> how can anyone correctly sort the column a? > > While the standard itself might well have nothing helpful to say about how a > null value should be

Re: [sqlite] ordering doesn't work the way I expected

On 6 May 2012, at 7:28pm, Petite Abeille wrote: > On May 6, 2012, at 8:18 PM, Luuk wrote: > >> So, if it is not defined how to sort column b, >> how can anyone correctly sort the column a? > > While the standard itself might well have nothing helpful to say about how

[sqlite] how to update the select commad

update dzhhq set mnote= case when (select dzhhq.*,b.bs from dzhhq inner join (select bs,stkcode from buysell) b on dzhhq.stkcode=b.stkcode) then 'sell'||mnote else mnote end this command: (select dzhhq.*,b.bs from dzhhq inner join (select bs,stkcode from buysell) b on dzhhq.stkcode=b.stkcode);

Re: [sqlite] ordering doesn't work the way I expected

On May 6, 2012, at 8:18 PM, Luuk wrote: > So, if it is not defined how to sort column b, > how can anyone correctly sort the column a? While the standard itself might well have nothing helpful to say about how a null value should be sorted by default ( NULLS FIRST or NULLS LAST), a given

Re: [sqlite] ordering doesn't work the way I expected

This is already fixed in the SQLite's trunk code (see http://www.sqlite.org/src/info/2a5629202f) and thus will be fixed in next SQLite release, i.e. 3.7.12. Pavel On Sun, May 6, 2012 at 1:34 PM, William Parsons wrote: > In my application, I've encountered a problem with

Re: [sqlite] ordering doesn't work the way I expected

William Parsons wrote: > In my application, I've encountered a problem with ordering where the result > doesn't match what I would have expected, and would like some clarification. > The issue is illustrated by the following: > > % sqlite3 :memory: > SQLite version 3.7.10 2012-01-16 13:28:40 >

Re: [sqlite] ordering doesn't work the way I expected

On May 6, 2012, at 7:34 PM, William Parsons wrote: > Why aren't the numbers sorted as I would have expected? Hmmm, yes, sounds like a, hmmm, functional anomaly :( > Note that if I remove > the unique constraint from column b it works as expected. Hmmm, yes, sounds like a, hmmm, functional

Re: [sqlite] ordering doesn't work the way I expected

On 06-05-2012 19:34, William Parsons wrote: > In my application, I've encountered a problem with ordering where the result > doesn't match what I would have expected, and would like some clarification. > The issue is illustrated by the following: > > % sqlite3 :memory: > SQLite version 3.7.10

[sqlite] ordering doesn't work the way I expected

In my application, I've encountered a problem with ordering where the result doesn't match what I would have expected, and would like some clarification. The issue is illustrated by the following: % sqlite3 :memory: SQLite version 3.7.10 2012-01-16 13:28:40 Enter ".help" for instructions Enter

[sqlite] Ubuntu 11.10 and Sqlite3

Hi at all, i have installed sqlite3 on Ubuntu 11.10 but I get error mismatch when i execute sqlite3 by terminal session SQLite header and source version mismatch 2009-09-11 14:05:07 b084828a771ec40be85f07c590ca99de4f6c24ee 2012-03-20 11:35:50 00bb9c9ce4f465e6ac321ced2a9d0062dc364669 On

Re: [sqlite] is SQLite the right tool to analyze a 44GB file

Hi Simon, My test cases weren't intended to supply data, they're crash tests. I have faith that Mike's software correctly interprets syntactically correct cases. I was interested in making sure it didn't crash, hang or spew on syntactic errors. You're right. JcD

Re: [sqlite] is SQLite the right tool to analyze a 44GB file

On 6 May 2012, at 3:20pm, Jean-Christophe Deschamps wrote: > Also fields starting with a " delimiter should comply with the rules. My test cases weren't intended to supply data, they're crash tests. I have faith that Mike's software correctly interprets syntactically

Re: [sqlite] is SQLite the right tool to analyze a 44GB file

Not sure I buy your test cases. I don't either, but for diverging reasons. Fields containg double quotes must be in double quotes. So only one of your examples is valid first,""second"",third I'll have to fix that one. No, it's invalid. Apply to " the same rules that apply to ' for

Re: [sqlite] is SQLite the right tool to analyze a 44GB file

On 6 May 2012, at 3:03pm, "Black, Michael (IS)" wrote: > Not sure I buy your test cases. > > Fields containg double quotes must be in double quotes. So only one of your > examples is valid > > first,""second"",third > > I'll have to fix that one. Sure. The rest

Re: [sqlite] is SQLite the right tool to analyze a 44GB file

Not sure I buy your test cases. Fields containg double quotes must be in double quotes. So only one of your examples is valid first,""second"",third I'll have to fix that one. I could add the CR/LF...but I've never seen that used in a CSV format. Then again, may as well use the standard.

Re: [sqlite] is SQLite the right tool to analyze a 44GB file

On 6 May 2012, at 1:59pm, "Black, Michael (IS)" wrote: > I modified my csvimport to allow for quoted fields. Still automaticallhy > detects the # of columns. > If quoted fields also contain internal quotes they must be escaped by > doubling them. > e.g. > col1,"this

Re: [sqlite] is SQLite the right tool to analyze a 44GB file

I modified my csvimport to allow for quoted fields. Still automaticallhy detects the # of columns. If quoted fields also contain internal quotes they must be escaped by doubling them. e.g. col1,"this is, a ""quoted"" field",col3 It's not fully RFC4180 compliant as it doesn't allow for CF/LF

[sqlite] Implement autocomplete with fts4aux

With fts4aux, the term table would be a perfect candidate to implement an autocomplete function in our application. However a query SELECT term FROM ft_terms WHERE term LIKE 'descr%' is quite slow as no 'index' is used (indexes are not possible on virtual tables). With checkin

[sqlite] FTS simple tokenizer with custom delimeters

While looking around in the source of the simple tokenizer I found code that suggests custom delimeters can be specified (I want to exclude the underscore). http://www.sqlite.org/src/artifact/5c98225a53705e5ee34824087478cf477bdb7004? ln=76-87 An indeed: CREATE VIRTUAL TABLE ft USING

Re: [sqlite] Multi-lingual support?

Richard, bash scripts, command-line shell and vim. I discovered that I was missing the -H option on vim. More than likely it is a vim problem, not sqlite3. vim seems to work flawlessly with one particular text, but some aren't standardized. My bad. Other Hebrew texts were/are working