Web hosting top - PostgreSQLYou might find that MySQL or even simple
PostgreSQLYou might find that MySQL or even simple text files meet all yourdata storage and retrieval requirements. Nothing about a simpleflat data structure in a small quantity demands a relational databasemodel. However, as we mentioned earlier in this book, you dohavechoices when it comes to databases. In the next chapter, we ll look ata commercial offering, Oracle. In this chapter, we ll look at what ispossibly the granddaddy of the free/open source database alterna- tives, PostgreSQL (pronounced post-gress-q-l ). Why Choose PostgreSQL? This is the part where the open-source purists start waving theirhands in the air and yelling with uncontrolled excitement! And theexcitement is easy to understand PostgreSQL is a true open-sourcedatabase, made available under the simple and portable BSD license. You can read the almost vanishingly short text of the license atwww.postgres.org/licence.html. Are you back yet? See, we told you it was short. So reason numberone is not so much the license itself as the freedom from an 85 pageEULA laced with sneaky provisions that nobody alive really under- stands, and that, in many cases, you can t even see until you get thebox open. By then it s too late all the money s gone. Which bringsus to reason number two: PostgreSQL is free. We don t mean free onMondays, Wednesdays, Fridays and the vernal equinox, nor do wemean free to the right people, nor even the more conventional andarguably understandable free for non-commercial use. PostgreSQLis completely and totally free (unless the developers change theirminds). The term free applies to more than just the cost. Like the GNUGeneral Public License, you can alter, repackage, and redistributePostgreSQL as a standalone product or with your own applications. Arguably better than the GPL for businesses, using and distributingPostgreSQL will not infect all your code with the copyleft. Finally, PostgreSQL supports some nifty special features and ele- ments of the ANSI SQL92 and SQL99 standards that simply aren tavailable or fully developed in other databases, as well as the abilityto work with object and hierarchical data. Of course, there are some disadvantages as well. First, considerPostgreSQL s ability to work with object and hierarchical data. Wait aminute; didn t we just sell that one as a feature? To the PostgreSQL3434CHAPTER …In This ChapterWhy PostgreSQLInstallation and setupAdministrationPostgreSQL …
Note: If you are looking for cheap and reliable webhost to host and run your mysql application check mysql web server services.