Hi all,
I am adressing this email to this mailinglist due to the lack of some
address to post euphoric feedback to. Let me tell you my story:
This february I began working on a web-application using PHP and a
SQL-Database. My problem was to evaluate the right one:
Interbase was at the state of being developed then. There were only promises
to make open source of it. They did not really fulfill them.
Postgres (version 6.5) was known to be quite slow and unstable.
So I used MySQL and was quite happy with it; possibly because I didn't
really know all the features and possibilities of true SQL (not just that
crappy subset MySQL gives its users). Last September I deceided to get a
REAL database and I began looking araound a bit (I desperately needed UNIONs
and this stinking workaround with temp. TABLEs MySQL provides you with was
not really an alternative). I deeply looked at Postgres (I think 7.0.2 or
7.0.3) and deceided to give it a try.
And it was great: There is nothing you cannot do with it. My only problem:
The limitation of the row-size and the VACUUM-stuff.
After having read the article on Postgres at phpbuilder.com, I deceided to
use the current CVS-version. And this let me fully fall in love with your
database... What impressed me most: You seem to know all my thinkings: One
day, I needed a LIMIT within one subselect of a UNION. It did not work
(Although I used the brackets and there was no Syntax-Error; the query
simply did not return any rows). One day and a "cvs update" later, the
feature was implemented.
Another example: Jody, the guy that writes a searchengine for our database,
needed UNIONs in subselects. Somwhere on your homepage one can read about
this being implemented in PostgreSQL 7.2 but he just forwarded me a mail
from one of you that this feature acutally is implemented in 7.1dev.
And you cannot imagine the fun I had with compiling perl into the database
and with writing the stored-procedure to do a string-manipulation.
If only I had time to have a closer look at the PostgreSQL-Code: I would
spend my whole free time for helping you to make postgres even better.
Many thanks to you. You did and are doing a great job. Postgres is the best
OpenSource-Database out there (and better than many commercional products
(that ability to use Perl as language for stored procedures is uniqe)).
Thanks.
Pilif