The binary package of SQLite 3.0.8 for Win32 only has the .def and .dll
files. While this is totally okay for MinGW (gcc) the lack of a .lib
import library creates problems for Visual C++ users.
Am I missing something obvious, or what should I do? Shouldn't this be
a FAQ item?
-ak
Hi,
The make test core dumps on a ia64 box (hpux), with sqlite 3.0.8./
gcc3.4.2/Tcl8.4.9
Here are the traces that I collected for the test attach2-3.1 ( all the
tests that use the tcl set command as set rc [ catch {sqlite3_prepare
$DB "ATTACH 'test2.db' AS t2" -1 TAIL} VM] ) would fail similarly.
> I have built sqlite3.lib from the source tarball, and
> when I try to create a statement in my 2.1 DB (created
> via SQLite Database Browser 1.01 from
> sqlitebrowser.sf.net) I get an error message that the
> file is encrypted. I've also used SQLite Control
> Center (v0.06) against the db, so I
> I have built sqlite3.lib from the source tarball, and when I
> try to create a statement in my 2.1 DB (created via SQLite
Two point one? Is that version not over three years old, or did you
mistype?
> What GUI tools do people use to manage their 3.x databases if
> that's the case?
Haven't
> Another trick you can pull is to create an index that
> contains every column in the table with the cluster index
> columns occuring first. That will double the size of your
> database. But when SQLite can get all of the information it
> needs out of the index it does not bother to consult the
On Wed, 2005-02-09 at 09:30 +1100, Chris Schirlinger wrote:
> > Doing a keyed search is no guarantee that you won't touch *every* single
> > page in the table, if the rows are inserted in random order. Try this:
> ...cut...
> > Assuming key is the key field you want, the records will be inserted in
> Doing a keyed search is no guarantee that you won't touch *every* single
> page in the table, if the rows are inserted in random order. Try this:
...cut...
> Assuming key is the key field you want, the records will be inserted into
> wibble in key order. Selecting by key will then touch the least
I have built sqlite3.lib from the source tarball, and
when I try to create a statement in my 2.1 DB (created
via SQLite Database Browser 1.01 from
sqlitebrowser.sf.net) I get an error message that the
file is encrypted. I've also used SQLite Control
Center (v0.06) against the db, so I know it's goo
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Christian Smith wrote:
> On Tue, 8 Feb 2005, John Richard Moser wrote:
>
>
> Does the sqlite3 command line interface program support BLOB data?
>
> I am thinking of feeding sql commands to sqlite3 (the command). In the
> course of this I'll proba
On Tue, 8 Feb 2005, John Richard Moser wrote:
>-BEGIN PGP SIGNED MESSAGE-
>Hash: SHA1
>
>Does the sqlite3 command line interface program support BLOB data?
>
>I am thinking of feeding sql commands to sqlite3 (the command). In the
>course of this I'll probably need to read from stdin or fr
On Tue, 8 Feb 2005, Chris Schirlinger wrote:
>> I did a small test to see if performance was linear with time.
>> I wanted to make sure it was suitable for my application.
>> It seems with both indexed and unindexed tables it doesn't take
>> significantly longer to do the 1,000,000th insert than i
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kurt Welgehausen wrote:
>>... feeding sql commands to sqlite3 (the command)
>
>
> The SQLite shell is not really designed for production
> work. It can be used as you suggest for routine queries,
> but for anything more complicated, you'll have few
Hi all,
I just notice that the new code I just check out from cvs repository is
total not work for compiled EXE, DLL, or LIB.
One of the error message:
Unhandled exception at 0x0040e209 in sqlite3.exe: 0xC005: Access
violation reading location 0x001f.
void sqlite3ExprDelete
Hi,
I've just gotten mozilla running with sql support, and I'm trying to
connect to a little sqlite3 database on the local machine. I can set up
an alias ok using the sample stuff from the distrib, but when I try to
getConnection I get a failure. I've tried several variations on the db
string, in
Take a look at the slide show from the PHP conference,
available at sqlite.org. It gives a good explanation of
how SQLite uses indices, starting around the 40th or
50th slide.
BTW, 'cluster index' is probably not the right term.
That usually means a common index on a cluster of
tables. SQLite does
> ... feeding sql commands to sqlite3 (the command)
The SQLite shell is not really designed for production
work. It can be used as you suggest for routine queries,
but for anything more complicated, you'll have fewer
headaches if you use a scripting language that you're
already familiar with (tcl,
List,
sorry about that. I misread Nathan's post, and so came up with a bogus
answer. Never try to answer technical questions when it's 03:45am for
you ;-).
Ulrik Petersen
Randall Fox wrote:
On Mon, 7 Feb 2005 18:14:42 -0800, you wrote:
Does this
var
pMsg: PChar;
..
pMsg := SQLite3_ErrMs
17 matches
Mail list logo
