Re: [sqlite] Version 3.3.0 (alpha)

... But new databases created by version 3.3.0 will not be readable by older versions of SQLite. If this is a problem for your application, compile SQLite using -DSQLITE_DEFAULT_FILE_FORMAT=1 and then version 3.3.0 will create new databases in the legacy

Re: [sqlite] Two problems

> - insert the value "0E9" (and other variables that would look like numbers > if they were in numeric fields) into a varchar(10) field, and it gets > converted to the numeric equivalent. I think it might the perl wrapper doing the conversion. SQLite shouldn't do this. SQLite version 3.3.0

[sqlite] Two problems

I'm just testing out my http://navaid.com/ applications with SQLite. In the past, my scripts have worked with MySQL and PostgreSQL with minimal changes, but I'm getting two problems with SQLite in perl DBD::SQLite: - insert the value "0E9" (and other variables that would look like numbers if

Re: [sqlite] PRAGMA table_info oddness

There's no string type in SQL. Go to and read section 2.1. Regards

[sqlite] PRAGMA table_info oddness

Hi folks, I'm trying to create a composite view from multiple database files, with an extra field for the origin of a particular record. A sample scenario: There's a table, "foo," which exists in two database files, 'a.db3' and 'b.db3'. Let's define it as: CREATE TABLE foo (f1 integer,

[sqlite] Writing/reading blobs

Hi all, I'm using SQLite3 via the SQLite ODBC wrapper. Amongst other things I need to store large blobs. When using ODBC this means several calls to SQLPutData/SQLGetData. I've read the docs and it seems that SQLite doesn't support this. Is this in planning, and/or can someone well versed in

Re: [sqlite] RE: [RBL] Re: [sqlite] Sqlite and Java

Fred makes a good point. A well conceived software solution is a good investment and a slipshod, makeshift solution not an investment but an ongoing liability. We have some software which was carefully thought through initially and has been in constant national use for close to twenty years

Re: [sqlite] Version 3.3.0 (alpha)

Brett Wilson <[EMAIL PROTECTED]> wrote: > Does anybody know if there anything special we have to do to get the > new boolean optimization? Does it apply to any 0/1 integer values you > put in a cell, or does the column have to be declared as BOOLEAN? > If the column type is "TEXT" or "VARCHAR",

RE: [sqlite] Writing/reading blobs

> -Original Message- > From: Robert Bielik [mailto:[EMAIL PROTECTED] > Sent: Sunday, January 22, 2006 9:33 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Writing/reading blobs > > I think he has more or less abandoned that project. So I've > had to tweak > the ODBC driver to

Re: [sqlite] Writing/reading blobs

I think he has more or less abandoned that project. So I've had to tweak the ODBC driver to work with blobs anyway (because the 0.65 ODBC driver could only handle text). I've tweaked the SQLGetData to retrieve a blob correctly, haven't tried it yet with large data tho.. but not SQLPutData yet

[sqlite] Writing/reading blobs

Hi all, I'm using SQLite3 via the SQLite ODBC wrapper. Amongst other things I need to store large blobs. When using ODBC this means several calls to SQLPutData/SQLGetData. I've read the docs and it seems that SQLite doesn't support this. Is this in planning, and/or can someone well versed in

RE: [sqlite] RE: [RBL] Re: [sqlite] Sqlite and Java

You points are understood. But I've always attempted to use a hammer for a nail and a screwdriver for a screw. This extra effort always produces a much cleaner and professional result. Good clients know that response time is money and resources they spend every day and at every seat. Proper

RE: [sqlite] RE: [RBL] Re: [sqlite] Sqlite and Java

You're right to a certain extent, but the point I was trying to address was the ideal of being able to use an SQLite database from a variety of toolsets and environments natively. If you've ever written JNI you'll know why this is a pain and a Java only implementation would be sweet. Also, not