On 17.06.2010 20:55, Michael W. Lucas wrote: > We get orders for services via PDF. We need to keep them, and call > them up months or years later. We'd need to find things like "all of > the PDFs for Customer X" or "all of the PDFs for circuit ID > such-and-such." Surely other people have had this problem, for > generic documents/files if not PDFs in particular...
Sounds pretty much like a database and a filestore. Database to store all the metadata, with pointers to some machine-readable filenames for the filestore. I seem to remember that one of my previous employers hired some code-for-hire guys from UK setting that up (and alas bringing Oracle salespeople inside the premises. I swear, those guys are harder to remove than cockroaches...), but I'm sure some of the more SQL-friendly guys than me could codify something for Postgres and give it a nice frontend. ;) //Svein -- --------+-------------------+------------------------------- /"\ |Svein Skogen | sv...@d80.iso100.no \ / |Solberg Østli 9 | PGP Key: 0xE5E76831 X |2020 Skedsmokorset | sv...@jernhuset.no / \ |Norway | PGP Key: 0xCE96CE13 | | sv...@stillbilde.net ascii | | PGP Key: 0x58CD33B6 ribbon |System Admin | svein-listm...@stillbilde.net Campaign|stillbilde.net | PGP Key: 0x22D494A4 +-------------------+------------------------------- |msn messenger: | Mobile Phone: +47 907 03 575 |sv...@jernhuset.no | RIPE handle: SS16503-RIPE --------+-------------------+------------------------------- If you really are in a hurry, mail me at svein-mob...@stillbilde.net This mailbox goes directly to my cellphone and is checked even when I'm not in front of my computer. ------------------------------------------------------------ Picture Gallery: https://gallery.stillbilde.net/v/svein/ ------------------------------------------------------------
signature.asc
Description: OpenPGP digital signature