Re: [sqlite] Charset-Confusions

Hi Ralf > --- Ursprüngliche Nachricht --- > Von: Ralf Junker <[EMAIL PROTECTED]> > An: sqlite-users@sqlite.org > Betreff: Re: [sqlite] Charset-Confusions > Datum: Tue, 16 May 2006 11:10:28 +0200 > You have asked "How is it so complicated? *hmmm*" Well, because SQLite > does not have an interface

Re: [sqlite] Optimizing SQLite footprint and my misadventure with Lemon

[EMAIL PROTECTED] wrote: > I got the basic features of SQLite to work on my project. Since I am > working with very limited flash and memory space I am trying to build the > library with as little as possible. Things work fine until I try to build > the parser with the following define: > >

[sqlite] maximum number of databases

We are considering SQLite to manage our data which is distributed over a number of ordinary directories (about a 1000 and growing). Is it feasible to create a separate SQLite database for each directory, totaling more than a 1000 databases each managed by the same SQLite server? What is the

[sqlite] Optimizing SQLite footprint and my misadventure with Lemon

I got the basic features of SQLite to work on my project. Since I am working with very limited flash and memory space I am trying to build the library with as little as possible. Things work fine until I try to build the parser with the following define: lemon.exe parse.y

Re: [sqlite] sqlite2 api question - updates

> I couldn't get parameters to work at all. I assume they're just not implemented > in 2.x sqlite. Prepared statements are implemented in SQLite 2.8.x. See sqlite.h for exact API and how to use it. Its very similar to SQLite3 API. Something along the lines of

Re: [sqlite] sqlite2 api question - updates

On 5/16/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote: I couldn't get parameters to work at all. I assume they're just not implemented in 2.x sqlite. Prepared statements are implemented in SQLite 2.8.x. See sqlite.h for exact API and how to use it. Its very similar to SQLite3 API. Something along

Re: [sqlite] Compiling Sqlite JDBC driver (Compiler question)

[EMAIL PROTECTED] wrote: > > Christian, > > I understand Windows is poor, but I do not fully understand the > compilation process. The mkopc3.exe is actually created- so this itself > cannot be the problem. Not having awk doesn't seem to be an issue for > compiling the 3.2.1-based driver either

Re: [sqlite] sqlite2 api question - updates

On 5/16/06, Craig Morrison <[EMAIL PROTECTED]> wrote: All it does is slurp input, concatenate it into one long string and then feed it to sqlite_exec(..). So it seems in theory the normal escaping mechanisms should work. It must be operator head space on my part... Thanks for looking though

Re: [sqlite] sqlite2 api question - updates

Jay Sprenkle wrote: > If version 2 does not support parameters what's the correct way to escape > the data? > I don't know about parameters, but here is one way: char *pszStatement; #define STATEMENT "UPDATE question SET qtext = '%q' WHERE qnumber=%d;" pszStatement =

Re: [sqlite] Proposal: sqlite3_column_rowid

Ralf Junker wrote: SELECT c1, c2, c3 FROM a NATURAL JOIN b; SELECT c1, c2, c3 FROM a JOIN b USING(c1); There is no way to know which table the c1 column value is associated with (technically the selected columns in such joins don't belong to either table according to the SQL standard) so no

Re: [sqlite] sqlite2 api question - updates

On 5/16/06, Craig Morrison <[EMAIL PROTECTED]> wrote: Jay Sprenkle wrote: > I'm trying to write a program using sqlite2.8. > > I've tried using the following sql from the command line tool and it > does not escape > the data correctly: >update question set qtext = 'this shouldn''t fail'

Re: [sqlite] sqlite2 api question - updates

Jay Sprenkle wrote: I'm trying to write a program using sqlite2.8. I've tried using the following sql from the command line tool and it does not escape the data correctly: update question set qtext = 'this shouldn''t fail' where qnumber=1; The escaped single quote is replaced by garbage.

Re: [sqlite] C++ Arrays in sqlite

On 5/16/06, John Stanton <[EMAIL PROTECTED]> wrote: Storing BLOBs in a database then acessing elements of them using other tools does not look like good design. The purpose of a database and its data manipulation language is to give access to all data elements. Are you really using the DB in

[sqlite] sqlite2 api question - updates

I'm trying to write a program using sqlite2.8. I've tried using the following sql from the command line tool and it does not escape the data correctly: update question set qtext = 'this shouldn''t fail' where qnumber=1; The escaped single quote is replaced by garbage. I've tried writing a c

Re: [sqlite] Proposal: sqlite3_column_rowid

Hello Dennis Cote, > SELECT c1, c2, c3 FROM a NATURAL JOIN b; > SELECT c1, c2, c3 FROM a JOIN b USING(c1); > >There is no way to know which table the c1 column value is associated with >(technically the selected columns in such joins don't belong to either table >according to the SQL standard)

[sqlite] How to write the makefile

hi everyone, recently I crosscompiled sqlite3.3.5 for my armlinux. I have got some basic knowlage of using it now. i wrote a c program which just open a database ,print table values and then exit. to write the Makefile, i use $(EXE):$(OBJS) ./libtool --mode=link $(CC) $(LDFLAGS) $(LIBS)

Re: [sqlite] Proposal: sqlite3_column_rowid

>What does it do with queries that are pulling data from multiple tables? How >about computed column data? > >Consider these queries: > > SELECT a.c2, b.c3 FROM a, b WHERE a.c1 = b.c1; For field a.c2: * sqlite3_column_rowid(0) returns RowID for field 'a2' in table 'a' from which the

Re: [sqlite] Proposal: sqlite3_column_rowid

[EMAIL PROTECTED] wrote: What does it do with queries that are pulling data from multiple tables? How about computed column data? Consider these queries: SELECT a.c2, b.c3 FROM a, b WHERE a.c1 = b.c1; SELECT c1 + c2 FROM a; Derrell, I don't see a problem with either of your problem

Re: [sqlite] C++ Arrays in sqlite

Large chunks of the array will be accessed. Very rarely (if ever) will just one value of the array be needed. From what you guys are saying, this makes it seem like a BLOB would be the way to go. Another thing i forgot to mention, each name will most likely have not one, but many arrays

Re: [sqlite] Charset-Confusions

I use sqlitebrowser and is very happy with it http://sqlitebrowser.sourceforge.net mvh Anders COS skrev: Anne, - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Monday, May 15, 2006 3:44 PM Subject: [sqlite] Charset-Confusions An the 2.

Re: [sqlite] Charset-Confusions

Anne, - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Monday, May 15, 2006 3:44 PM Subject: [sqlite] Charset-Confusions > An the 2. question: Is there any Really-Good-Admin-Tool to create > DB and Table, to browse and maybe edit Fieldvalues in a grid?

[sqlite] New Kexi 2006.1 for MS Windows released

"Kexi is an integrated data management application. It can be used for creating database schemas, inserting data, performing queries, and processing data. " Download demo of International "2006" Edition for MS Windows: http://www.kexi.pl/wiki/index.php/Kexi_for_MS_Windows List of changes:

[sqlite] Proposal: sqlite3_column_rowid

Hello to all, I would like to propose a new API function: long long int sqlite3_column_rowid(sqlite3_stmt*, int iCol); As the name implies, this function would return the RowID for a given column after sqlite3_step has returned SQLITE_DATA. The RowID would be valid for the database and

RE: [sqlite] C++ Arrays in sqlite

Jay is correct here, only use a blob if you do not want to search on that field. Your example may not be best suited to BLOB but that is for you to decide. We store medical test data as a blob. This is not much more complicated than an array of C structs. However we have a primary key field, a

RE: [sqlite] Compiling Sqlite JDBC driver (Compiler question)

Christian, I understand Windows is poor, but I do not fully understand the compilation process. The mkopc3.exe is actually created- so this itself cannot be the problem. Not having awk doesn't seem to be an issue for compiling the 3.2.1-based driver either (see 1). Sorry, I'm confused :( Andi

Re: [sqlite] Compiling Sqlite JDBC driver (Compiler question)

[EMAIL PROTECTED] wrote: > > After I've been able to overcome the initial compiler problem (missing > library installation), I'm faced with a new one: > > 1) Compiling JDBC wrapper for 3.2.1 works fine > > 2) Compiling JDBC wrapper for 3.3.5 fails: > > cl -Gs -EHsc -D_WIN32 -nologo -Zi