Posted by "James" on 07/25/05 19:11

I don't know if this is of any help, but you can make a mysql field Unique
without it being an index/primary key.

----- Original Message -----
From: "Al" <news@ridersite.org>
To: <php-general@lists.php.net>
Sent: Monday, July 25, 2005 9:40 AM
Subject: [PHP] A strategy question about using mySQL for saving flat-file
stings?


> I've been creating a number of CM applications for a virtual-host website.
> One feature, of several applications, allows the editor [one of our
> people] to create simple text files. I've been using simple flat-files in
> a directory for saving the files.
>
> I've gotten tried of dealing with directory permission problems, etc., and
> am considering using a simple mySQL DB for storing the file strings.
>
> Obviously, for each file-string to be unique, its path must be included as
> part of the ID.
>
> Here is my question.
>
> I can use one table for all the path/files and use the following as the
> primary key "/home/some-dir/filename".
>
> fields: fullpath-filename | path | type | date | binary-string
>
> path is so the code can do an equivalent of scandir()
> type signifies whether data has been serialized() or not. This is so I
> can save arrays
> date is the equivalent of file last mod date.
>
> Or, I can create a separate table for each full-path used and then just
> use the filename for the primary key. In this case, since the table name
> is in effect the path, only the filename is needed.
>
> The first approach is obviously simplest; but, I'm concerned about getting
> myself into a trap later on. Anyone offer any suggestions?
>
> Many thanks.....
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php

[Back to original message]