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]>





Reply via email to