Hmm, the latter might have sounded a bit harsh.
It must be seen as reminder, no pointing finger or so :)
----- Original Message -----
From: "Edwin Knoppert" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Monday, August 22, 2005 11:12 PM
Subject: Re: [sqlite] Why can i open a textfile?
Hmm, but every known file format has an header.
Sqlite has a string, not really a header as it seems.
Maybe for v4 to implement a real header (if not yet)
A header doesn't need to be encrypted.
(A bit for testing if it's encrypted might have it use as well)
Sqlite seems to be created espec. for c programmers.
c programmers are truly a different breed :)
But it's not always handy to follow these directions or doings.
Iow, i never looked at the sqlite source how it works.
I guess at least 50 percent over here does not really care and would never
explore how to solve these kind of things.
I hope examples and such will eventually get more polished towards other
languages as well.
Examples for instance show *sqlite as hstmt and there is really no use to
understand it's internally a pointer to a structure or so.
hstmt as Long would do.
Well long story but understanding functions (and even using it as cdecl)
is not that trival due conversion and such.
----- Original Message -----
From: "D. Richard Hipp" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Monday, August 22, 2005 9:23 PM
Subject: Re: [sqlite] Why can i open a textfile?
On Mon, 2005-08-22 at 20:58 +0200, Mark de Vries wrote:
I must say I agree. Perhaps there is some verry good reason to delay
actually opening the DB untill the first real access.
There is a good reason, actually. SQLite has the ability
to read and write encrypted databases. The hooks to do this
are there in the public-domain code, though the encryption
code itself is missing. Nevertheless, it is a capability
of SQLite.
The encryption key is specified after the database is
opened. But without an encryption key, SQLite has no
way of knowing if the file it opened is a valid database.
It might *look* like a text file, but that just might
be because the database is encrypted in a way that makes
it appear so. Hence, SQLite cannot pass judgement on
a file until you actually try to do something with it.
--
D. Richard Hipp <[EMAIL PROTECTED]>