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
Fitzpatrick, Bill (MS) wrote:
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
[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:
>
> lem
Hello,
I am loading a large file to a SQLite database table.
The file has a proprietary format that does not lend
itself to the COPY command. So, I am parsing the file
and doing insert statements. While there are around 2
million records, I am doing them in blocks of a few
thousand at a time.
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 max
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 -DSQLITE_OMIT_ALTERTAB
> 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
sqlite_compile/sqlite_bind/sqlite_ste
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 t
[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 (
On 5/16/06, Dennis Cote <[EMAIL PROTECTED]> wrote:
> SELECT c1, c2, c3 FROM a JOIN b USING(c1);
>
> Preparing this returns SQLITE_ERROR with message "ambiguous column name:
c2".
>
This is wrong. Column c2 only exists in table b and so it can't be
ambiguous. I suspect you are using different
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
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 = sqlite_mprintf(STATEMENT,
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
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' where
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.
I'v
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 th
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 p
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) s
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 the best way? Would it be better to form
your array
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) -
>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 va
[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 que
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 ass
Ralf Junker <[EMAIL PROTECTED]> writes:
> Drawbacks on sqlite3_column_rowid?
>
> I can not see any negatives on 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
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. question: Is there any Really-Goo
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?
> I have found 4 Admin-Pr
"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:
http:
I am writing as the author of SQLiteSpy:
SQLiteSpy does not currently does not allow editing field values in the display
grid. However, this is planned for a future version.
You have asked "How is it so complicated? *hmmm*" Well, because SQLite does not
have an interface to save values back to
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 table
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
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
--
[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 -DOS_WIN
32 matches
Mail list logo