From owner-freebsd-questions@FreeBSD.ORG Thu Jun 17 19:37:10 2010 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id B01891065673 for ; Thu, 17 Jun 2010 19:37:10 +0000 (UTC) (envelope-from svein-listmail@stillbilde.net) Received: from mail.stillbilde.net (unknown [IPv6:2002:51af:3dc3:0:20c:29ff:fece:79f3]) by mx1.freebsd.org (Postfix) with ESMTP id 0EB0B8FC0C for ; Thu, 17 Jun 2010 19:37:10 +0000 (UTC) Received: from [IPv6:2002:51af:3dc3:0:19f4:72db:b8ac:23a] (unknown [IPv6:2002:51af:3dc3:0:19f4:72db:b8ac:23a]) (Authenticated sender: svein-listmail) by mail.stillbilde.net (Familien Skogens mail) with ESMTPSA id 2797322 for ; Thu, 17 Jun 2010 21:37:21 +0200 (CEST) Message-ID: <4C1A795F.1080106@stillbilde.net> Date: Thu, 17 Jun 2010 21:37:03 +0200 From: "Svein Skogen (Listmail Account)" User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.9) Gecko/20100317 Lightning/1.0b1 Thunderbird/3.0.4 MIME-Version: 1.0 To: freebsd-questions@freebsd.org References: <20100617152237.GA68461@bewilderbeast.blackhelicopters.org> <4C1A576D.9090601@FreeBSD.org> <20100617185545.GA69469@bewilderbeast.blackhelicopters.org> In-Reply-To: <20100617185545.GA69469@bewilderbeast.blackhelicopters.org> X-Enigmail-Version: 1.0.1 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enigBFB363D9520871CB6F194D4D" Subject: Re: PDF storage software recommendations? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 17 Jun 2010 19:37:10 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigBFB363D9520871CB6F194D4D Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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 --=20 --------+-------------------+------------------------------- /"\ |Svein Skogen | svein@d80.iso100.no \ / |Solberg =D8stli 9 | PGP Key: 0xE5E76831 X |2020 Skedsmokorset | svein@jernhuset.no / \ |Norway | PGP Key: 0xCE96CE13 | | svein@stillbilde.net ascii | | PGP Key: 0x58CD33B6 ribbon |System Admin | svein-listmail@stillbilde.net Campaign|stillbilde.net | PGP Key: 0x22D494A4 +-------------------+------------------------------- |msn messenger: | Mobile Phone: +47 907 03 575 |svein@jernhuset.no | RIPE handle: SS16503-RIPE --------+-------------------+------------------------------- If you really are in a hurry, mail me at svein-mobile@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/ ------------------------------------------------------------ --------------enigBFB363D9520871CB6F194D4D Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.12 (MingW32) iEYEARECAAYFAkwaeWMACgkQODUnwSLUlKQ7+QCfZFHFESuk6+A9Ut9WrxlyBJF3 niQAn1FiaB6DZpsKgFBzAyE6kDY8lk3H =oWAe -----END PGP SIGNATURE----- --------------enigBFB363D9520871CB6F194D4D--