Re: [sqlite] sqlite3: .import command handles quotation incorrectly

When confronted with this problem I implemented a virtual table that could read and write CSV like files. This is for export/import purposes only so it does not implement UPDATE or DELETE. The first line of the text file is reserved for field names. In my case, I treat everything non-numeric

Re: [sqlite] Bug: on opening the same database twice

Ok, Then let me explain my problem to see if I done the best solution! I have an replication system using sqlite where: - I have 2 databases: one for output* and other for input*; - I have 2 process accessing booth: The first is the replicator: - Get the data on server and write on input

Re: [sqlite] sqlite3: .import command handles quotation incorrectly

On Wed, Jun 26, 2013 at 6:23 PM, RSmith wrote: > I have done ludicrous amounts of testing and evaluating imports for and > from CSVs > I made a go at improving the CSV importer for the upcoming SQLite 3.8.0 release. Please see the latest trunk check-in. Your expert

Re: [sqlite] sqlite3: .import command handles quotation incorrectly

On 6/26/2013 11:21 AM, RSmith wrote: I meant if a real csv interpreter conforming to RFC4180 were to read the garbage I posted, it would come up with the result specified. How do you know what a standard-conforming interpreter would do when presented with input that's invalid under that

Re: [sqlite] sqlite3: .import command handles quotation incorrectly

Hi, my below answer was wrong -- my approach produces a different output. Am 26.06.2013 15:12, schrieb Nißl Reinhard: Your sample [123, 9" Nail, ", Caliper, "set, up 5"", hold", 8 ] gives currently the following column values (I used > and < to indicate the string bounderies, so that any

[sqlite] sqlite 3.8.0 -> autoconf/configure

Richard, The current trunk does not build at version 3.8.0 # ../src/configure --enable-load-extension --enable-threadsafe --with-pic configure: error: configure script is out of date: configure $PACKAGE_VERSION = 3.7.17 top level VERSION file = 3.8.0 please regen with autoconf Local

Re: [sqlite] sqlite3: .import command handles quotation incorrectly

On 6/26/2013 11:21 AM, RSmith wrote: I meant if a real csv interpreter conforming to RFC4180 were to read the garbage I posted, it would come up with the result specified. How do you know what a standard-conforming interpreter would do when presented with input that's invalid under that

Re: [sqlite] sqlite3: .import command handles quotation incorrectly

On Wed, Jun 26, 2013 at 10:53:38AM -0700, Roger Binns scratched on the wall: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 26/06/13 05:07, Jay A. Kreibich wrote: > > A year or so ago there was some effort to write a plug-in that would > > use the standard Python CSV module (at least,

Re: [sqlite] Bug: on opening the same database twice

On Wed, Jun 26, 2013 at 1:24 PM, Israel Lins Albuquerque < israelin...@yahoo.com.br> wrote: > I open an database twice times in same process and same thread one in > readonly mode, and the other read write. > With shared_cache enable. > Opening first the readonly mode and after readwrite mode,

[sqlite] Bug: on opening the same database twice

I open an database twice times in same process and same thread one in readonly mode, and the other read write. With shared_cache enable. Opening first the readonly mode and after readwrite mode, the second connection works as read only too. Then I looked to sqlite code and I see the problem in:

Re: [sqlite] Questions about exclusive transation

On 06/26/2013 02:08 PM, Woody Wu wrote: On Tue, Jun 25, 2013 at 10:21:51PM -0400, Igor Tandetnik wrote: On 6/25/2013 10:13 PM, Woody Wu wrote: 1. When a exclusive transation started and not yet commit, I found if I open another connection to the same database and try to access it (using

Re: [sqlite] GUI for SQLite

fyi http://www.barefeetware.com/sqlite/compare/?ml/ http://devtest.ws.utk.edu/tutorials/sqlite/gui/ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Rob Richardson [rdrichard...@rad-con.com] Sent: Wednesday, June 26,

Re: [sqlite] GUI for SQLite

Not all of us. Thanks for the list. RobR, SQLiteSpy user and about to find Navicat. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] GUI for SQLite

We have tried Firefox SQLite Manager, SQLite DB Browser and Navicat. They all seem fine and Navicat seems good as a paid option with more features than the other two. From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of

Re: [sqlite] GUI for SQLite

On 26 Jun 2013, at 4:42pm, RSmith wrote: > Well you need to "buy" a $0.00 registration key, for which you need to fill > in an inordinate amount of personal and contact information (just like buying > other things online). The sort of event that promises Inbox spam aplenty

Re: [sqlite] GUI for SQLite

Well I just simply downloaded my free copy from the Apple App store. I entered absolutely zero information (apart from Apple knowing everything about men anyway). Can't say I've been plagued by spam from other vendors who have provided free downloads but there's a first time for everything. It

Re: [sqlite] GUI for SQLite

Well you need to "buy" a $0.00 registration key, for which you need to fill in an inordinate amount of personal and contact information (just like buying other things online). The sort of event that promises Inbox spam aplenty and is too much hassle for most casual onlookers - but it does

Re: [sqlite] GUI for SQLite

So... no? It is gratis, but not open. thanks. On Wed, Jun 26, 2013 at 5:28 PM, Michael Black wrote: > Free doesn't necessarily mean open source > > http://www.valentina-db.com/en/get-free-studio > > > -Original Message- > From: sqlite-users-boun...@sqlite.org >

Re: [sqlite] sqlite3: .import command handles quotation incorrectly

On 2013/06/26 15:21, Igor Tandetnik wrote: For instance, what is the resulting fields from this CSV: [123, 9" Nail, ", Caliper, "set, up 5"", hold", 8 ] In REAL CSV terms that would be:123 | 9 Nail, | Caliper | set, up 5", hold | 8 If by REAL CSV you mean the format specified in

Re: [sqlite] GUI for SQLite

Free doesn't necessarily mean open source http://www.valentina-db.com/en/get-free-studio -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Paolo Bolzoni Sent: Wednesday, June 26, 2013 10:26 AM To: General Discussion of SQLite

Re: [sqlite] GUI for SQLite

Are you sure it is free? I cannot find the code... On Wed, Jun 26, 2013 at 6:28 AM, jorje wrote: > Take a look on a free gui tool -- Valentina Studio. Amazing product! IMO > this is the best manager for SQLite for all platforms. >

[sqlite] The next-generation query planner

The next-generation query planner (NGQP) is a rewrite of the query planner for SQLite that is faster (reduced run-time for sqlite3_prepare()) and generates better plans for queries (reducing the run-time for sqlite3_step()). More information about the NGQP is available here:

Re: [sqlite] sqlite3: .import command handles quotation incorrectly

Hi, BTW: I hate that TOFU posting, but Outlook doesn't allow me to do it any better. I'm sorry for that. Your sample [123, 9" Nail, ", Caliper, "set, up 5"", hold", 8 ] gives currently the following column values (I used > and < to indicate the string bounderies, so that any white spaces are

Re: [sqlite] sqlite3: .import command handles quotation incorrectly

On 6/26/2013 8:48 AM, RSmith wrote: Expanding on what Jay replied to: well we could discuss endlessly, what well formed CSV files are. Not really, the rules are pretty set in stone, it isn't open to interpretation. For instance, what is the resulting fields from this CSV: [123, 9" Nail, ",

Re: [sqlite] GUI for SQLite

Take a look on a free gui tool -- Valentina Studio. Amazing product! IMO this is the best manager for SQLite for all platforms. http://www.valentina-db.com/en/valentina-studio-overview -- View this message in context: http://sqlite.1065341.n5.nabble.com/GUI-for-SQLite-tp11673p69626.html

Re: [sqlite] sqlite3: .import command handles quotation incorrectly

Expanding on what Jay replied to: Hi, well we could discuss endlessly, what well formed CSV files are. Not really, the rules are pretty set in stone, it isn't open to interpretation. Given that we cannot fix the generation of the CSV file, why not making the importer a little bit smarter?

Re: [sqlite] sqlite3: .import command handles quotation incorrectly

On 26 Jun 2013, at 13:07, Jay A. Kreibich wrote: > We've been through this before a > half-dozen times. Everyone seems convinced it would be really easy > and really simple to make just one small change so that the importer > works with their version CSV. Not everyone; I may be in a

Re: [sqlite] sqlite3: .import command handles quotation incorrectly

On Wed, Jun 26, 2013 at 12:35:55PM +0200, Nißl Reinhard scratched on the wall: > well we could discuss endlessly, what well formed CSV files are. > Given that we cannot fix the generation of the CSV file, why not > making the importer a little bit smarter? The standard answer to this is, "Go

Re: [sqlite] sqlite3: .import command handles quotation incorrectly

Hi, well we could discuss endlessly, what well formed CSV files are. Given that we cannot fix the generation of the CSV file, why not making the importer a little bit smarter? The .import command already treats " as literal data, when it doesn't appear at the beginning of the cell, but it

Re: [sqlite] Questions about exclusive transation

On 26 Jun 2013, at 8:08am, Woody Wu wrote: > Thanks for the analyzing. After checked, I found it's the prepare_v2 > statement, previous to the step statement, returned SQLITE_BUSY. That > means, a prepare_v2 can even failure if the statement be preparing is an >

Re: [sqlite] Should I do analyze?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 25/06/13 22:46, Navaneeth.K.N wrote: > I am wondering should I do ANALYZE also as the last command? Will that > make the query planner happy and choose faster plans? Will that improve > the runtime performance? Since you know what your queries