Roger Binns wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stef Mientki wrote:
Uptill now the dbase is small so no performance problems yet.
Wait until you have performance problems and then solve them :-) It is
almost always the case that performance issues don't crop up
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stef Mientki wrote:
> Uptill now the dbase is small so no performance problems yet.
Wait until you have performance problems and then solve them :-) It is
almost always the case that performance issues don't crop up where you
think they will.
> I
On 2/23/07, Stef Mientki <[EMAIL PROTECTED]> wrote:
hello,
I've started with SQLite, because it's one of the first dbases with a
local filessytem without authenciation.
It looks great, compared to ini-files.
Now I've a basic problem:
I've a table, with 10 simple fields and 1 blob field,
How about using one table -
- Name TEXT
- Birthdate REAL
- Mimetype TEXT
- Image BLOB
The mimetype column tells you the image type (jpeg etc).
One access would be SELECT Name Birthdate Mimetype FROM Yourtab. It
would not access the BLOB.
Stef Mientki wrote:
Cesar Rodas
This is a design question really so here are my recomendations.
Persons
- ID( an integer primary key )
- Name
- Birthday
- Picture Type ( your two digit type).
Picture
- ID (An integer Primary Key that matches the ID of persons).
- image (blob)
Cesar Rodas wrote:
Save into a blob.
thanks but that's not what I meant.
I'll try to explain with an example:
I want to create this database
Persons
- Name
- Birthday
- Picture
Now when I want to view this database with a general database browser /
manager,
I'll first find out what
Save into a blob.
here is a C example http://www.sqlite.org/cvstrac/wiki?p=BlobExample
On 23/02/07, Stef Mientki <[EMAIL PROTECTED]> wrote:
hello,
I've started with SQLite, because it's one of the first dbases with a
local filessytem without authenciation.
It looks great, compared to
hello,
I've started with SQLite, because it's one of the first dbases with a
local filessytem without authenciation.
It looks great, compared to ini-files.
Now I've a basic problem:
I've a table, with 10 simple fields and 1 blob field, containing a
(possibly large) image.
Uptill now the
8 matches
Mail list logo
