Postgres Pro
Downloads
Home   >   mailing lists

Thread: What is the advantage

What is the advantage

From
"Ivan"
Date:
As I am new in the world of PostgreSQL I would like to know what are the
advantages of using it.

Bye,
Ivan

--
Trebate bolji pristup internetu?
Nazovite IskonInternet na 0800 1000 ili pogledajte
http://www.iskon.biz/individualni/usluge/dialup/

Re: What is the advantage

From
"William ZHANG"
Date:
""Ivan"" <zenzo@net.hr> Writes news:3fbfbbfe.2dd6.0@net.hr...
> As I am new in the world of PostgreSQL I would like to know what are the
> advantages of using it.

PostgreSQL is a open source ORDBMS, with many great features.
Sugguest you read its document for details.

>
> Bye,
> Ivan
>
> --
> Trebate bolji pristup internetu?
> Nazovite IskonInternet na 0800 1000 ili pogledajte
> http://www.iskon.biz/individualni/usluge/dialup/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>

Re: What is the advantage

From
Gémes Géza
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

William ZHANG írta:
| ""Ivan"" <zenzo@net.hr> Writes news:3fbfbbfe.2dd6.0@net.hr...
|
|>As I am new in the world of PostgreSQL I would like to know what are the
|>advantages of using it.
|
IMHO:

Stored procedures
Triggers
Views
Rules

With them you can embeed your aplications logic right in the database,
instead of implementing it on the (database) client application, in this
way no mather how you connect to the database, from psql, a webap, or a
GUI application you will "see" the same thing.
E.g. if for a payment are allowed sums between $100 and $1000 you could
prevent inserting other values by defining a trigger. Or if modifying
some data in a table should happen when you insert something in an other
table, you could write a rule, for it.

Best Regards,

Geza Gemes
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/wivv/PxuIn+i1pIRAs/iAJ9lEdNe0CfXYw15zLuuLS+LBdkqcgCfQ3cU
h9yVsRMWTX7F99zLd/PoV1o=
=FP5A
-----END PGP SIGNATURE-----

Re: What is the advantage

From
Christopher Browne
Date:
zenzo@net.hr ("Ivan") wrote:
> As I am new in the world of PostgreSQL I would like to know what are
> the advantages of using it.

That cannot be evaluated in the absence of some set of metrics
indicating your preferences and needs, and which would allow comparing
PostgreSQL to some other option.  (Whether that be Oracle, MS Access,
Berkeley DB, or storing data as text records in the style of Rand
RDB.)

To do a comparison requires comparing to something [some other way of
storing data], and requires having some "functional" basis for having
a preference.
--
"cbbrowne","@","ntlug.org"
http://cbbrowne.com/info/multiplexor.html
"We English-speaking peoples should   keep hold of the essential  fact
about foreign languages: They exist to make us laugh."
-- John Derbyshire