-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Dave Dyer wrote: > While discussing possible sqlite applications today, it occurred to > me that you could present a sqlite database as a mountable file > system.
That is relatively trivial to do using FUSE on systems that support it. > One of the major impediments to using sqlite to store images, for > example, is that you can't view or manipulate them using your standard > image tools. While SQLite is fully capable of storing large (up to 1GB) BLOBs, the general approach if you need to interoperate with other applications is to store the files seperately and store the filename in SQLite. > Has anyone done somthing like this? People choose a database over a filesystem for a reason :-) If something like images is your primary focus you can use the filesystem and store additional information in extended attributes. You can also base your system around the OS tool for searching and storing information about files (eg SpotLight on Mac, Beagle/Tracker on Linux). Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFIkVM7mOOfHg372QQRArwBAKDBB4BWoApbrO/umUAwRoymJksieQCffNRn ezIQx2R44NjGVhLKwynPRCA= =pYlm -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
