Hi All,
I came across Palm OS port of Sqlite wiki at:
http://www.sqlite.org/cvstrac/wiki?p=SqlitePalm
I am interested in porting Sqlite to Palm OS 6. The
code of the Palm port will be very useful during this
port. However, I cannot find the code at either Sqlite
site or in yahoo group(the old Sq
Christian Kienle wrote:
SQLite version 3 is currently under development. sqlite3_open() will
have a flexible mechanism to specify options. It will not have the
second parameter currently found on sqlite_open().
Will the API change much? What do you think -> do we need to rewrite much code
if we
Hi,
at first thank you for the information you gave us.
> There are no plans to ever do anything with the second argument to
> sqlite_open().
Ah okay...
> SQLite version 3 is currently under development. sqlite3_open() will
> have a flexible mechanism to specify options. It will not have the
>
Christian Kienle wrote:
"Use the sqlite_open function to open an existing SQLite database or to create
a new SQLite database. The first argument is the database name. The second
argument is intended to signal whether the database is going to be used for
reading and writing or just for reading. B
Hi all,
at the moment we (a few other gus and I) are developing a cgi library with
C++. We have choosen SQLite as the first dataase to integrate into our
library. I quote from the documentation:
"Use the sqlite_open function to open an existing SQLite database or to create
a new SQLite databas
Chris Sebrell wrote:
Though I'm not using the source code to SQLite directory (I'm
using the win32 DLL version), I suppose the source code could
be modified without too much trouble to use stricmp() instead of
strcmp().. would just have to make sure you do it in all the right
places (and none of th
Hi,
I've got corrupted database file. PRAGMA integrity_check result is:
*** in database main ***
On tree page 4957: initPage() returns error code 11
On page 344 cell 9: 2nd reference to page 4947
On page 2810 cell 2: 2nd reference to page 4957
On page 4820 cell 2: 2nd reference to page 5451
On page
I think, for simplicity, I would just add the additional columns required to
store a duplicate field in upper or lower case for each search field
required, then just index on those fields (columns.) The table update could
have a trigger to automatically update the duplicate fields (columns.)
Fred
Thanks for the idea. I hadn't thought about doing it that way..
Unfortunately, I am trying to keep my database size as small
as possible, and the field I want to have indexed case-insensitively
represents the bulk of the actual data. My current testing shows
about 800MB for the database, +130MB
> From: "Chris Sebrell" <[EMAIL PROTECTED]>
>
> I'm trying to figure out if it's possible, using SQLite 2.8.13 (latest
version), to do
> case-insensitive ordering on a column.
Chris,
You can do what you want with an auxillary table and an index on that table.
In the example below your table would
Hi,
I'm trying to figure out if it's possible, using SQLite 2.8.13 (latest version), to do
case-insensitive ordering on a column.
I read in an earlier message to try something like this:
CREATE INDEX IDX ON MYTABLE (lower(FIELD));
Then SELECT * FROM MYTABLE ORDER BY lower(FIELD);
But the CREAT
I have a database that consists of about 13000 rows of about 20 fields.
The fields are all integers, doubles, and timestamps. What's puzzling
me is that the database is about 16M. I've looked at the file itself in
a hex editor and I see that the 1k pages are all mostly empty. It looks
like SQLi
±èâ¿ø ´ë¸® wrote:
> Can I use SQLite that embedded in commertial Software and Device of our
> company?
>
yes
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additiona
13 matches
Mail list logo