> I am not trying to start a ruckus or a flamewar, but I would like to know
> who's using Postgres out there. What's the application? How big are your
> databases? Are you using Visual Basic or C to connect to it through ODBC
> or are you using a Web interface?
I don't have huge databases by any means, but I really get a lot out of
postgresql's advanced features. I have used postgres from perl, php, python,
and C (C really only to test, I haven't made any major applications with
C/postgres). Some apps are web-interface and some are assorted other
interfaces. I like the way postgres handles things like triggers, sequences,
and stored procedures; the way those features work make it very easy to
organize your data very effectively (I don't find myself hacking around any
database limitations).
I mostly run a lot of smaller databases. I have tested with larger databases
and weird data (like inserting 20+ MB of data into one attribute of one
record with one query) and postgres doesn't run into any problems. I also
expect that I will be making some moderate-sized databases (couple hundred
MB) in the near future, for which I will depend on postgres (with little
doubt).
I don't know what network problems you were refering to, but postgres should
work fine unless you have very little bandwidth. For how much data are these
applications asking? Usually my applications only ask for small amounts of
data from a larger data set. After all, 15 users against a 50MB database
doesn't sound like heavy load from a networking standpoint or a hardware
standpoint.
Regards,
Jeff