End Point Corporation
Services   |   Our Clients   |   Interchange   |   Ruby on Rails   |   PostgreSQL   |   Hosting   |   About Us   |   Contact
PostgreSQL FAQ
End Point Home > PostgreSQL > PostgreSQL FAQ
PostgreSQL FAQ

» What is PostgreSQL?
PostgreSQL is a mission-critical, reliable, scalable, and extensible relational database management system (RDBMS). PostgreSQL is used to store and manage all types of data for different storage and retrieval purposes.
» How much does PostgreSQL cost?
PostgreSQL is open-source software released under the BSD license. There are no licensing fees, maintenance fees, or subscription fees. The software is developed and maintained by a community of developers representing various companies and individuals collaborating for mutual benefit. End Point only charges for the time spent designing, building, and supporting applications running on PostgreSQL.
» Who uses PostgreSQL?
PostgreSQL is used in all sizes of businesses, from small mom-and-pop shops to major corporations and government agencies. Some major corporations that chose PostgreSQL include Sun, Cisco, Afilias, the American Chemical Society, and BASF. Government agencies that use PostgreSQL include United Nations Development Program (UNDP), United Nations Children’s Fund (UNICEF), US Department of Agriculture (USDA), US Department of Labor (USDOL) and US General Services Administration (GSA).
» How scalable is PostgreSQL?
The scalability of PostgreSQL is extensive and proven. PostgreSQL is capable of storing billions of records, terabytes of data, and processing thousands of transactions per second, all while keeping your data safe and secure.
» How long has PostgreSQL been around?
PostgreSQL has a long history of continual development. It began as Ingres at the University of California at Berkeley, where it was developed from 1977 to 1985. Ingres became a proprietary database product, while Postgres was spun off to continue development under the open source model. Since then, Postgres was renamed PostgreSQL and development has continued at an impressive pace.
» Why not MySQL?
MySQL has recently taken major steps to add optional support for true, ACID-compliant, extensible RDBMS features. However, the functionality MySQL only recently offered in production-ready capacity has largely been available in PostgreSQL for years, improved and extended in the meantime. Furthermore, PostgreSQL's ability to use DDL within transactions allows for great flexibility and far better control of changes to a given database -- something even Oracle does not offer.
» Why should I choose End Point?
We model your data rigorously and ensure that the database design gives consistently meaningful data and effectively enforces your core business practices. Furthermore, we have extensive experience with complex deployments under heavy load, and making use of in-database programming languages, including PL/pgSQL and PL/Perl, to extend the capabilities of the database. While other shops may build an application to handle the business logic, End Point develops software at a higher standard and uses the robustness, power, and extensibility of PostgreSQL to implement your business logic.
» How do End Point's clients use PostgreSQL?
  • Backcountry.com: PostgreSQL drives several large-scale e-commerce sites with a multi-master replication engine built by End Point, master databases managing transactional data, and data warehousing for reporting and application servers. This system handles their high load and provides needed availability and fast response times for the customer-facing storefronts as well as back-end customer service staff, accounting, and the warehouse.
  • National Braille Press: Uses PostgreSQL for their non-profit ecommerce site that sells braille books and accepts donations, with their internal personnel using the same application and database to process orders. Reports for fulfillment and accounting are done in-house directly against PostgreSQL via ODBC.
  • CityPass: Uses PostgreSQL to support constantly changing offerings on their website, manage orders for attractions around the United States and Canada, and allow self-service affiliate sales tracking and reporting.
  • Michael C. Fina: PostgreSQL drives a sophisticated content management system; a flexible, powerful product query-building engine; and a large wedding registry system.
PostgreSQL FAQ
PostgreSQL FAQ
What is PostgreSQL?
How much does PostgreSQL cost?
Who uses PostgreSQL?
How scalable is PostgreSQL?
How long has PostgreSQL been around?
Why not MySQL?
Why should I choose End Point?
How do End Point's clients use PostgreSQL?
© 2008 End Point Corporation. 920 Broadway Suite 701, New York, NY 10010 USA | Tel +1 212-929-6923 or 1-888-351-3239 | Fax +1 212-929-6927