 | |
|
You Are Cordially Invited... To Participate in all that the Solaris Communities have to offer
Databases in SXDE 1/08SXDE comes with three databases, PostgreSQL, MySQL and Java DB (based on Apache Derby), all optimized for Solaris. All three are excellent developer databases—open source, free-to-use, and backed by highly active communities that provide information, practical advice and how-tos, and direct answers to questions-fast. They are also production-ready, with the option of 24 x 7 world-wide support from Sun and MySQL. Which Database for Which Application?SXDE provides three databases because applications have different needs and databases are not one-size-fits-all. So, which is the right fit for your application? Here's an overview of the three databases with links to more information. PostgreSQL—The most advanced open source database The most traditional "enterprise" open source database. It is ideal for applications that are highly transactional, write-intensive, and need to support large numbers of users. It is also very reliable, secure, and scalable, especially on large systems with many CPUs and/or cores. PostgreSQL is optimized to take advantage of Solaris' advanced features, among them:
See Getting Started With PostgreSQL. For further information visit the PostgreSQL Sun and PostgreSQL.org sites. MySQL—The most popular open source database MySQL is hands down the most widely used and the most "Web 2.0" open source database, with the largest number of tools and applications. It is fast and very easy to use, with many developer features. MySQL excels with rapid-fire, mostly read-only, non-transactional SQL queries. It's well-suited for large Web-sites on 1- 4 CPU systems scaled horizontally. MySQL Cluster adds scalability and high availability, making it a good fit for Telco applications that require fault-tolerance and performance. Similar to PostgreSQL, MySQL has also been integrated with SMF and can be used with Solaris' Containers for the same benefits detailed, above. The next release of MySQL will also have DTrace probes in its core code for improved observability and performance. MySQL has been optimized to perform well on Solaris and Sun platforms and is distributed by Sun under the open source GPL license*. See Getting Started With MySQL. For further information visit the MySQL and MySQL Developer sites. Java DB—The database for Java applications Java DB, Sun's supported open source distribution of the Apache Derby database, is the most "Java" of the three—in fact it's all Java. It is optimized for use as an embedded database, but is also quite good as an SMB or departmental client-server database. It is a full-featured SQL database, though only 2MB in footprint and easy to use, which make it ideal for rich Java application development, use on PDAs or laptops. When embedded, Java DB requires zero administration and can easily be used on the client- or middle-tier or back-end. The NetBeans IDE has a Java DB plug-in for easy development. Java DB is included with JDK 6, the Glassfish project, and the Sun Java System Application Server, PE. JavaDB is distributed by Sun under the open source Apache License*. See Getting Started With Derby. For more information visit the JavaDB and Apache Derby sites. *A White paper with an overview of open source licenses is available. |
|
| ||||||||||||
