Обсуждение: What is the advantage

Поиск
Список
Период
Сортировка

What is the advantage

От
"Ivan"
Дата:
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

От
"William ZHANG"
Дата:
""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

От
Gémes Géza
Дата:
-----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

От
Christopher Browne
Дата:
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