> 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?
> 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
> 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
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
-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
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
-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
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
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,
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
> ... 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
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 :=
14 matches
Mail list logo