[LUNI] database question

[Eric Michalsen]

I built a document control system with php/mysql,
where all the documents are links in the database.
I have thought about inserting as blobs, but I wanted
to keep it simple.
of course it means I need two different backups,
one for the database and one for the directory
of files, but I'm willing to live with the small 
hasle for keeping the database small and quick.
just a point of view...

Eric


-----Original Message-----
From: Richard Reina [mailto:Richard at rushlogistics.com]
Sent: Tuesday, August 06, 2002 6:49 PM
To: luni at luni.org
Subject: [LUNI] database question


I have a document that coresponds to each record in a table in a MySQL 
database.  In the future I am planning to image the each document ( 
ussually 1 to 5 pages) and store them on my server.  Would it be best to 
store them as a files in a directory or to or is their some data type 
that can store them that I can add a colum in the table itself? 
Any help would be appreciated as I am no expert in SQL.

Richard

______________________________________________________________________
Linux Users Of Northern Illinois - Technical Discussion 
luni at luni.org
http://luni.org/mailman/listinfo/luni