Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail From: Tim Watts Newsgroups: comp.databases.mysql Subject: Re: Can MySql database store images? Followup-To: comp.databases.mysql Date: Mon, 25 Apr 2011 08:43:58 +0100 Organization: A noiseless patient Spider Lines: 34 Message-ID: References: <6YWdnUDDU6lkCinQnZ2dnUVZ5hSdnZ2d@giganews.com> Mime-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 7Bit Injection-Info: mx02.eternal-september.org; posting-host="6oIlEBqCjOm0MjsSUEk5CA"; logging-data="21572"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19Rwi74YkEl8x5hK/9fdfhoc3dZF5D2TRk=" User-Agent: KNode/4.4.6 Cancel-Lock: sha1:gtKnZgqsl2dk6XbwlO/4Zy28u2g= Xref: x330-a1.tempe.blueboxinc.net comp.databases.mysql:644 Axel Schwenke wrote: > "Robert Crandal" wrote: >> "Axel Schwenke" wrote > >>> There are already applications for that. Unless you tackle this >>> problem for educational purposes, you'd better use one of them. >>> >>> i.e. this one: http://gallery.menalto.com/ >> >> Do you mean that I should store my images on web sites like this? > > Have you read this? > > "gallery" is a software packet that you can install on your own web > server. It's written in PHP and uses MySQL (at least MySQL is one > option for the database engine to use). Full source available. While we're on the tangent, I've been running Gallery2 for a while. It's nice enough, except for one brain damaged limitation - it does not easily allow for arranging photos in arbitrary virtual galleries (a prefectly reasonable request). Gallery2 fudges it with "Create Replica" which clones the metadata *once* but does not maintain the link after that. Gallery3 seems to have no such facility at all. I've been looking at Zoph http://www.zoph.org/ which is the same basic idea as Gallery but, on paper, looks rather better. Haven't had a chance to try it yet. Cheers Tim -- Tim Watts