[sqlite] SQLite openning a database

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 http://rafb.net/paste/results/jRFmZD25.html This is code from a package manager I'm writing based on SQLite. These two functions open a database, creating it if it doesn't exist. While most of this isn't of general interest, I'd like to point out that

Re: [sqlite] $ in table and column names

Ulrik Petersen wrote: I guess the next question is: Can someone verify that this is part of the SQL standard? Further inspection of the SQL and Unicode standards leads me to conclude that the '$' character is not allowed in standard SQL identifiers (at least using the SQL:2003 standard). The '$'

Re: [sqlite] add new column to table

EDIT The only working example I can see is the following. BEGIN TRANSACTION; CREATE TEMPORARY TABLE t1_backup(a,b); INSERT INTO t1_backup SELECT a,b FROM t1; DROP TABLE t1; CREATE TABLE t1(a,b); INSERT INTO t1 SELECT a,b FROM t1_backup; DROP TABLE t1_backup; COMMIT; I can not find any help or FAQ r

Re: [sqlite] add new column to table

The only working example I can see is the following. BEGIN TRANSACTION; CREATE TEMPORARY TABLE t1_backup(a,b); INSERT INTO t1_backup SELECT a,b FROM t1; DROP TABLE t1; CREATE TABLE t1(a,b); INSERT INTO t1 SELECT a,b FROM t1_backup; DROP TABLE t1_backup; COMMIT;I can see any help or FAQ regarding UP

Re: [sqlite] excessive malloc() calls

Le mardi 11 janvier 2005 à 08:13 -0500, Steve Frierdich a écrit : > Thanks Richard. We are using Sqlite on some military projects, and its > on the WinCE I am most concern on using Sqlite. I would similarly be concerned about using WinCE in military projects :-) ooops D.Morel signature.asc De

Re: [sqlite] $ in table and column names

> CREATE TABLE ex$1( col$abc INTEGER ); > > are legal and work fine in other database engines. > This seems very odd to me. Can anybody else > confirm the use of '$' in the middle of identifier > names in other database engines? Seems to work OK in both permanent and temporary tables in SQL S

Re: [sqlite] excessive malloc() calls

Thanks Richard. We are using Sqlite on some military projects, and its on the WinCE I am most concern on using Sqlite. Steve D. Richard Hipp wrote: Steve Frierdich wrote: I have been noticing all the email messages about excessive malloc calls. Is there a serious bug in Sqlite about malloc being

Re: [sqlite] V2.8 or V3.0 for embedded devices?

Markus Oliver Junginger wrote: Thanks for the answers so far; there have been some interesting suggestions ( for example, I didn't know about the SQLITE_OMIT). Still, I would like to know more about my main concern - memory consumption. Somewhere I read V2.8 holds the first 240 bytes or so of e

[sqlite] tcl-wrapper question

Hello sqlite users, i have a little question. How can i compile the tcl sqlite wrapper. I am using sqlite version 3.0.8 and want to use the tcl wrapper but the makefile don't say anything about it. In the source directory is a tclsqlite file but it is not compiled. Hope you can help me. Greeting