|Title||Body||Technical Expertise Required||Cost||Additional Information|
MySQL is a relational database system (RDBMS) that runs as a server providing multi-user access to several databases. All major programming languages include libraries to access MySQL. It comes with a command line tool, with many third party graphical user interfaces also available. Although not considered a full enterprise RDBMS like Oracle or PostgreSQL, it supports most RDBMS technologies like foreign keys, triggers, views, indexing, and backup. MySQL is easy to use, sufficient for most environmental data management applications and the choice of many web server hosting companies.
MySQL is included in several third party installation bundles, providing easy installation and configuration for the most popular combinations of programs for web development. E.g. LAMP, WAMP etc. which combine Apache webserver, MySQL and PHP for Linux and Windows respectively.
|Basic programming skills||Free|| |
MySQL Workbench is an open source, visual based tool for MySQL database design, creation and administration. It is separate from, but connects to MySQL, which is database software built on a version of Structured Query Language or SQL (see MySQL tool description in the DataONEpedia).
|Basic programming skills||Free|
The SQL Server is a relational model database server produced by Microsoft that provides a high performance database platform that’s reliable, scalable, and easy to manage. Its primary query languages are T-SQL and ANSI SQL. There are several Editions of the Server available, which differ depending on the services they provide.
|Basic programming skills||Cost-basis|| |