Actually I believe that could be implemented as a storage engine? The database would be the par of the file system that mysqld can access for both read and write. Each table in it would be a folder and every distinct value a file. A few additional syntactical constructs would be needed (but lots of storage engines already have such). And such tables could be restricted to one column (an 'array of files' does not make sense here I think).
example:
CREATE TABLE webportals ENGINE FILESYSTEM AT /var/lib/mysql; -- will create a folder named 'webportals' if not exists.
INSERT INTO webportals 'myfunnywebsiteportal.html' VALUES ('a string');-- will create file
'myfunnywebsiteportal.html' if not exists and populate it with 'a string'. LOAD DATA could be used to populate the file too.
:-)
It has some security concerns though to access file system like that! Indexing of data is an issue too - but such tables will probably have few records - most often a few files only - so maybe not really an issue. But such engine could also have an equivalent to the .MYI file.
(Just one half cent from a non-coder. And maybe PBXT 'Blob-streaming engine' does something of the kind already? And the Microsoft text-ODBC driver actually already does something similar in considering a folder in file system a table equivalent)
Peter
(Webyog)
On Thu, May 19, 2011 at 16:51, Tõnu Samuel
<tonu@jes.ee> wrote:
(
1. Sent this mail few days ago to Monty but no answer yet. I know, he is busy man.
2. I use name "MySQL" because this is real name for me. Oracle still sucks:P
)
Hi!
We all have seen cases where people try to use SQL for something what
does not fit there. Reason is simple - file system itself is very good
database for some type of objects and queries.
One common MySQL usage scenario is web portal. Often portal has some
sort of news and photos accompanying it. My idea is to make some sort of
clever way to store images within MySQL making their read/write as fast
as possible and meanwhile giving extra value to user who shouldn't care
about data integrity keeping data in and out of SQL coherent. Also would
be cool to get all required data with single query.
I think best way to implement this is to introduce field type "file"
which is stored outside of usual data storage. Only his physical
location on disk is stored in MyISAM or similar. This is exactly same as
people keep file name in CHAR currently but we provide method to fetch
file contents with same query. Also we can implement cool replication to
keep same file on all servers consistent, way to backup things via
mysqldump etc....
Actually idea is bit wider but what you think generally?
Tõnu
_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp