Re: difference between all RDBMSs

Поиск
Список
Период
Сортировка
От Chris Travers
Тема Re: difference between all RDBMSs
Дата
Msg-id 42DD848C.3050505@travelamericas.com
обсуждение исходный текст
Ответ на difference between all RDBMSs  (Dhanashree <dhanashree_05@yahoo.com>)
Список pgsql-sql
Obviously on this list you will mostly get info on PostgreSQL.  With 
regard to PostgreSQL, I would highly suggest familiarizing yourself with 
the online documentation.  I won't cover the weaknesses of MySQL here, 
but will give you a quick overview on how PostgreSQL is different from 
other RDBMS's so you can refine your search a bit.

PostgreSQL is designed to be extremely extensible.  This means that one 
can easily write code to add data types, procedural languages, and more 
with very little work.  Other database managers may allow for data types 
to be added, but I am not aware of any others that allow you to define 
your own procedural langauges in any arbitrary way (Even the recent 
enhancements to MS SQL to give it access to .Net are not this advanced).

The PostgreSQL development team has made data integrity and stability 
(assuming working hardware) a top priority.  It is certainly a higher 
priority than any other open source RDBMS I have ever worked with.

If you want to understand other factors that make PostgreSQL different 
than other RDBMS's you may want to look into differences regarding:
ISO compliance (which features of SQL-99 are supported), the trigger vs. 
rule systems in PostgreSQL (warning MS SQL uses something they call 
rules but it is something different), and features like inherited 
tables.  Again, read the online documentation.

Best Wishes,
Chris Travers
Metatron Technology Consulting


В списке pgsql-sql по дате отправления:

Предыдущее
От: Chris Travers
Дата:
Сообщение: Coalesce() in outer join between views
Следующее
От: John DeSoi
Дата:
Сообщение: Re: echo/printf function in plpgsql