Robert: Don’t forget the PostGIS project for Open GIS implementation.Ĥ. This seminal element of our design philosophy has already given us some community-contributed constructs that no other database, FOSS or commercial, has, such as our set of Networking data types and operators, or PL/R for advanced statistical analysis. And, paramount: our built-in-the-database extensibility, including custom Aggregates, Operators, Data Types, Domains, Functions, and other elements of Stonebreaker-style ORDMBS extensibility. For example, I believe that we have the only RDBMS that allows writing functions and procedures in 7 programming languages. While some of the other FOSS databases have some of these elements, none of them has the breadth and depth of support for all avenues of database automation and data integrity that PostgreSQL does. Extensive support of business logic building in the database, including Triggers, Rules, Functions, Views, and custom Constraints. ![]() SQL SCHEMA, which I believe that only SAP DB has among those mentioned. Very high level (90%?) of ANSI SQL 92/99 compliance and implementation, and getting better with each point release. Oh, and our native Windows version is due out this summer.įortunately, we have a *lot* of features that the other FOSS databases don’t have. The only features that we lack which some other FOSS databases have are the ones you mention in questions 1 & 2. I don’t know that much about SAP-DB and Firebird beyond their literature on their websites. Josh: You have me at a bit of a disadvantage, since I’m used to comparing PostgreSQL to proprietary-commercial databases, who I regard as our “real” competition. How do you view your competition in the free RDBMS market, that includes mSQL, mySQL, sapDB and Firebird? Which features does PostgreSQL still lacks that some of these DBs have and which features PostgreSQL has today that these DBs doesn’t? Clustering and load balancing are part of multi-master replication.ģ. What about clustering, load balancing and nested transactions?īruce: We have none of those, but we might have nested transactions this summer. Robert: Also, PostgreSQL Inc. has recently teamed up with Lanux Limited to offer a high-availability solution.Ģ. What’s the latest news regarding replication on PostgreSQL?īruce: We have several master-slave solutions, and are working on multi-master for the release after next. Josh = Josh Berkus, PostgreSQL Advocacy volunteer.ġ. ![]() Robert = Robert Treat, Advocacy volunteer and editor of the PostgreSQL Weekly News newsletter. Neil = Neil Conway, major PostgreSQL developer. “ PostgreSQL is one of the best-managed open source projects out there” a friend-in-the-know told me about 2 years ago, so today we feature a mini-interview with five members of the PostgreSQL team about their plans on the popular DB.īruce = Bruce Momjian, major PostgreSQL developer. PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS), derived from the Berkeley Postgres database management system.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |