PostgreSQL

PostgreSQL is a powerful, open source relational database system. PostgreSQL has been in active development for more than 15 years with a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.

Often referred to as the "Poor Man's Oracle", don't let the reference fool you, PostgreSQL is a powerful open source tool to use in web application development under the right circumstances.

When to Use Postgre:

  • When Developing Complex database designs
  • When Moving away from Oracle, Sybase, or MSSQL
  • Complex rule sets (i.e., business rules)
  • Use of procedural languages on the server
  • Transactions
  • Use of stored procedures
  • Use of geographical data
  • R-Trees (i.e., used on indexes)
  • High volume environments  

UnitedSol likes the rich functionality of the PostgreSQL’s SQL command set as well. One of the most notable differences between MySQL and PostgreSQL is the inability to do nested subqueries of subselects in MySQL. PostgreSQL follows many of the SQL ANSI standards, thus allowing for the creation of complex SQL commands.

UnitedSol has been developing web applications using PostgreSQL since 2001, and understands it's complexity, but more important the correct business situations in which to recommend it as a development platform.

 

UnitedSol can develop the tables & rules needed as well as define the complex SQL commands required to allow your web based application to run as efficiently as possible at all times.

If you would like to discuss your project to see if PostgreSQL is the correct Database structure in which to use please click here.