Re: Ever thought about using PostgreSQL? Ever wonder what it is all about?

Jeferson Oliveira wrote:

Maybe I (and some PostgGre DBAs) have not used PG 8 with the most
appropriated configurations. But since Firebird is becoming a better
DBMS after each version, and attending my needs even with large (for
me 4GB) database files, I don't have motivations to make a profound
study of the features of other databases. Please note that I'm not
trying to reduce the PostGre's value. I'm exposing the Firebird's
capabilities of associate the easiness of develop, deploy and manage
with the stability and speed.

I also thought like this once. but when I realized with PostgreSQL I
didn't have to search for a 3rd party UDF for common functions my
productivity went up, not to mention the ability to us Procedural
languages such as PLperl to solve issues not possible with the firebird
proc language. It's also very easy to port Firebird/Interbase procs to
PostgreSQL's PLpgsql language.

Not to mention that PostgreSQL has Schemas and things like DBI_link
which allow you to bring in data from just about any other database and
use it like a native table. There is also TDS_link which allows you to
pull in data from M$ SQL server using the native TDS protocol.

So in the end you get the same ease of
development,deployment/management and probably better stability but
with the enhanced enterprise features
that PostgreSQL provides.



All I am saying is as Delphi developers we need to keep our eyes open
for better technologies that can make our applications better.

Later,


--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best option for Postgresql Administration

--

.

Relevant Pages

  • Re: Postgresql 8.1 released
    ... > Can you compare Postgresql with Firebird? ... The database itself is more feature rich, ... ability to use more than one stored proc language, ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Ever thought about using PostgreSQL? Ever wonder what it is all about?
    ... The whole single file thing is only a good thing if you are using Firebird as a embedded database. ... I converted the whole thing to use Zeos and PostgreSQL back in 2004 and the database would stay right around 100mb and only grow when new data was added. ... If you are using Firebird for it's embedded features, then more power to you it does work great in that role. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Interbase Turbo?
    ... Man no offense but you certainly don't know what you are talking about when it comes to a Enterprise class database. ... If you are happy with Firebird great, but when you need Enterprise class features and don't want to spend a ton of cash on Oracle or MS SQL server you will be happy PostgreSQL has all that "useless" junk! ...
    (borland.public.delphi.non-technical)
  • Re: Interbase Turbo?
    ... and Firebird is a much better database. ... PostgreSQL: Rich set of built in functions including ones for GIS. ... The database I used before Firebird didn't have them, ... And this is from the customers, support and the developers own mouth. ...
    (borland.public.delphi.non-technical)
  • Re: Need input from Firebird users for a PostgreSQL vs Firebird comparison.
    ... The problem with using a domain is it's not out of the box support. ... There is TONS of new and cool features I could add from the upcoming ... PostgreSQL 8.3 but I wont do that because it's not a released version yet. ... When Firebird 2.1 is released I will update the comparison showing CLOB ...
    (borland.public.delphi.thirdpartytools.general)