[sqlite] 3.7.9 Import problem

Hello, I upgraded from 3.7.7 to 3.7.9 and suddenly the import of character columns that contain commas from a comma delimited .csv file doesn't work. The character columns are enclosed in double quotes and may contain commas which are part of the data. Yet sqlite seems to take them as delimiters

Re: [sqlite] SSD with TRIM

On Mon, Jan 16, 2012 at 12:29 AM, Black, Michael (IS) < michael.bla...@ngc.com> wrote: > > On SSD with 16384 page size and no WAL mode: > > time sqlite3 gen.db > real4m4.816s ... > Note: Database is only 595M with this page size. Much more efficient > storage may explain most of the time

[sqlite] result set column names, when row count = 0

After a lengthy, fruitless search for an option to make the sqlite3 shell do this, I've modified shell.c to emit a column header row, (after .headers ON), even when the result set is empty. The reason for this is to facilitate creation of tab-separated-value, column-name-headed, text tables

Re: [sqlite] SSD with TRIM

You know, on some platforms, such as Solaris, /tmp can be configured to use memory instead of disk (called tmpfs on many unix variants). Are you sure your /tmp is actually using disk? It's the default in a lot of setups. Best Peter > -Original Message- > From:

Re: [sqlite] makefile for c

Tim Streater wrote, On 1/15/2012 3:00 PM: On 15 Jan 2012 at 20:44, Bill McCormick wrote: What is the problem with the shared lib stuff? Thanks!! Black, Michael (IS) wrote, On 1/15/2012 2:27 PM: A simple one -- and please compile sqlite3.c into your program and make

Re: [sqlite] makefile for c

On 15 Jan 2012 at 20:44, Bill McCormick wrote: > What is the problem with the shared lib stuff? > > Thanks!! > Black, Michael (IS) wrote, On 1/15/2012 2:27 PM: >> A simple one -- and please compile sqlite3.c into your program and make >> everybody happy. >> >> Forget the

Re: [sqlite] makefile for c

Sorry, I just joined the list so I'm not privy to anything "we have just been talking about". I quick peek at the archives didn't reveal anything either. Also, as I installed sqlite on Debian Squeeze with apt-get install (as opposed to compiling from source), I wouldn't have sqlite3.c to make

Re: [sqlite] SSD with TRIM

I also ran without WAL mode (about 3X slower than WAL mode) On SSD: (system spent a LOT of time in disk wait states) time sqlite3 gen.db wrote: > > Fast. Fasty fast. Speed is high. INSERT, UPDATE, and DELETE all > significantly faster. SELECT is a bit faster, but there's less difference. >

Re: [sqlite] makefile for c

A simple one -- and please compile sqlite3.c into your program and make everybody happy. Forget the shared library stuff as we have just been talking about. CFLAGS=-O OBJECTS=myapp.o sqlite3.o LIBS=-lpthread -ldl myapp: $(OBJECTS) $(CC) -o $@ $(OBJECTS) $(LIBS) Michael D. Black

[sqlite] makefile for c

I'm looking for an example c program makefile for compiling and linking in the SQLite lib to gcc compiled programs. I'm not sure which lib to include between libsqlite.so.0 and libsqlite3.so.0 and what options I should pass to gcc. Where is this documented? Thanks!!

Re: [sqlite] Incompatible versions of SQLite on same system

My point still standsyou can test the application compatibility by copying the DLL into the app directory and changing the search order as I recommended. Did you try that? The applications really need to compile sqlite in their app. That's the good fix here as has been pointed out (and

Re: [sqlite] Incompatible versions of SQLite on same system

> I don't really mind top or bottom post. I don't either, but it really should be one or the other; otherwise, you're jumping up and down to follow a thread. But that's because of the next point, where we disagree completely. > But the important thing is to trim anything you've quoted to

Re: [sqlite] SSD with TRIM

I ran your test on my SSD system with 1M inserts. I used WAL mode. pragma journal_mode=WAL; CREATE TABLE [TestTable] ( [Id] INTEGER PRIMARY KEY AUTOINCREMENT, [Text] TEXT ); begin; insert. end; On SSD: time sqlite3 gen.db wrote: > > Fast. Fasty fast. Speed is high. INSERT,