Обсуждение: i feel like compelled !

On 14/05/15 09:35, essam Gndelee essam wrote:
> hi
> i don't want to make this post long.  i just started to use PostgreSQL 
> and it is absolutely awesome . just want to say thank you very much
You're allowed to say more!!!  :-)

What particular features do you like best, and why?

What O/S, hardware, use cases (what are you using pg for), volumes of 
data, performance...

What other Databases have you used?

How much experience do you have?


Cheers,
Gavin

<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;
-qt-user-state:0;">Ohwell... then, THANKS GUYS!!!<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px;
margin-left:0px;margin-right:0px; -qt-block-indent:0; text-indent:0px; "> <p style=" margin-top:0px; margin-bottom:0px;
margin-left:0px;margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">I'm not the original poster,
btw.<pstyle="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0;text-indent:0px; "> <p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0;text-indent:0px; -qt-user-state:0;">I felt a bit 'abandoned' a while back, since I started using
Interbase/Firebirdsince, like, ~2000. But since Firebird never really took off, I felt I had to look for better
solutions.I worked with Oracle for a bit, and then MySQL. But I found Oracle to be expensive (obviously) and too
intrusiveinto my OS (Linux, many flavours, but mostly RedHat-based).<p style="-qt-paragraph-type:empty; margin-top:0px;
margin-bottom:0px;margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> <p style=" margin-top:0px;
margin-bottom:0px;margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">What I
reallyliked about Firebird, and then Postgres made me feel right at home, was standards-compliance with SQL and great
featureset. I find myself most-often-than-not guessing how something ought to work in Postgres, based on past
experiences,and finding that it works exactly (mostly) like it 'should'. Plus, I found many new things that I loved and
changedthe way I think about stuff, like using Python for SP, JSON fields and RegEx in WHERE. And a special mention to
theAsync NOTIFY stuff which <span style=" font-style:italic;">finally</span> works like it 'should' in a DB (Firebird
hadsomething like that, but with no payload).<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px;
margin-left:0px;margin-right:0px; -qt-block-indent:0; text-indent:0px; "> <p style=" margin-top:0px; margin-bottom:0px;
margin-left:0px;margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Also, how postgres is easy to
deployreally helps. For example, I use it with a Qt App, which is compiled in MinGW. So I recompiled libpq with the
samecompiler, thus avoiding extra DLLs. <p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px;
margin-left:0px;margin-right:0px; -qt-block-indent:0; text-indent:0px; "> <p style=" margin-top:0px; margin-bottom:0px;
margin-left:0px;margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Thanks!<p
style="-qt-paragraph-type:empty;margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0;text-indent:0px; "> <p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px;
margin-left:0px;margin-right:0px; -qt-block-indent:0; text-indent:0px; "> <p style="-qt-paragraph-type:empty;
margin-top:0px;margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> <p style="
margin-top:0px;margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;
-qt-user-state:0;">OnThursday 14 May 2015 09:48:35 Gavin Flower wrote:<p style=" margin-top:0px; margin-bottom:0px;
margin-left:0px;margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">> On 14/05/15 09:35, essam
Gndeleeessam wrote:<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0;
text-indent:0px;-qt-user-state:0;">> > hi<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px;-qt-block-indent:0; text-indent:0px; -qt-user-state:0;">> > i don't want to make this post long.
ijust started to use PostgreSQL<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0;text-indent:0px; -qt-user-state:0;">> > and it is absolutely awesome . just want to say thank
youvery much<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0;
text-indent:0px;-qt-user-state:0;">> <p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px;-qt-block-indent:0; text-indent:0px; -qt-user-state:0;">> You're allowed to say more!!! :-)<p
style="margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;
-qt-user-state:0;">><p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0;text-indent:0px; -qt-user-state:0;">> What particular features do you like best, and why?<p
style="margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;
-qt-user-state:0;">><p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0;text-indent:0px; -qt-user-state:0;">> What O/S, hardware, use cases (what are you using pg for),
volumesof<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0;
text-indent:0px;-qt-user-state:0;">> data, performance...<p style=" margin-top:0px; margin-bottom:0px;
margin-left:0px;margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">> <p style="
margin-top:0px;margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;
-qt-user-state:0;">>What other Databases have you used?<p style=" margin-top:0px; margin-bottom:0px;
margin-left:0px;margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">> <p style="
margin-top:0px;margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;
-qt-user-state:0;">>How much experience do you have?<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px;-qt-block-indent:0; text-indent:0px; -qt-user-state:0;">> <p style=" margin-top:0px;
margin-bottom:0px;margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">> <p
style="margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;
-qt-user-state:0;">>Cheers,<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0;text-indent:0px; -qt-user-state:0;">> Gavin<p style="-qt-paragraph-type:empty; margin-top:0px;
margin-bottom:0px;margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; ">  

On Wed, May 13, 2015 at 7:05 PM, Gianni <nasus.maximos@gmail.com> wrote:
> Oh well... then, THANKS GUYS!!!
>
> I'm not the original poster, btw.
>
> I felt a bit 'abandoned' a while back, since I started using
> Interbase/Firebird since, like, ~2000. But since Firebird never really took
> off, I felt I had to look for better solutions. I worked with Oracle for a
> bit, and then MySQL. But I found Oracle to be expensive (obviously) and too
> intrusive into my OS (Linux, many flavours, but mostly RedHat-based).
>
> What I really liked about Firebird, and then Postgres made me feel right at
> home, was standards-compliance with SQL and great feature set. I find myself
> most-often-than-not guessing how something ought to work in Postgres, based
> on past experiences, and finding that it works exactly (mostly) like it
> 'should'. Plus, I found many new things that I loved and changed the way I
> think about stuff, like using Python for SP, JSON fields and RegEx in WHERE.
> And a special mention to the Async NOTIFY stuff which finally works like it
> 'should' in a DB (Firebird had something like that, but with no payload).
>
> Also, how postgres is easy to deploy really helps. For example, I use it
> with a Qt App, which is compiled in MinGW. So I recompiled libpq with the
> same compiler, thus avoiding extra DLLs.

Thanks for the kind words ... and for your thoughts on why you like PostgreSQL.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On 5/13/15 6:05 PM, Gianni wrote:
> What I really liked about Firebird, and then Postgres made me feel right
> at home, was standards-compliance with SQL and great feature set. I find
> myself most-often-than-not guessing how something ought to work in
> Postgres, based on past experiences, and finding that it works exactly
> (mostly) like it 'should'. Plus, I found many new things that I loved
> and changed the way I think about stuff, like using Python for SP, JSON
> fields and RegEx in WHERE. And a special mention to the Async NOTIFY
> stuff which finally works like it 'should' in a DB (Firebird had
> something like that, but with no payload).

FWIW, numerous people made similar comments about Postgres at this 
month's AustinPUG meeting when someone mentioned they haven't used it 
yet. Basically, they said he'd love using it. :)
-- 
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com