Re: Need suggestion - Mailing list pgsql-general

From tomas@tuxteam.de
Subject Re: Need suggestion
Date
Msg-id 20110603051540.GA16132@tomas
Whole thread Raw
In response to Need suggestion  (Carl von Clausewitz <clausewitz45@gmail.com>)
Responses Re: Need suggestion
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, Jun 01, 2011 at 10:08:14AM +0200, Carl von Clausewitz wrote:
> Hello Everyone,
>
> I got a new project, with 100 user in Europe. In this case, I need to handle
> production and sales processes an its documentations in PostgreSQL with PHP.

Something to consider too -- if you decide to store the big objects in
the database, that is -- is PostgreSQL's large object interface
<http://www.postgresql.org/docs/9.1/static/largeobjects.html>. The
problems with backup someone else mentioned in this thread would remain,
but you wouldn't have large blobs of data clobbering your "regular"
queries. You could pass the scans and pics piecemeal between client and
database without having to store them in the middleware (which may be an
advantage or a disadvantage, mind you).

Don't know whether PHP has bindings for that, though.

Regards
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFN6G38Bcgs9XrR2kYRAmOyAJwIGwk57tH5X8V4uEV5c3peQv7aKACfZ+Tm
9ogbAeWTKwxM2/o7aKz9kbc=
=MMDN
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: "David Johnston"
Date:
Subject: Hidden Risk w/ UPDATE Cascade and Trigger-Based Validation
Next
From: tomas@tuxteam.de
Date:
Subject: Re: Need suggestion