|
Size: 753
Comment:
|
Size: 1435
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
| #rev 2020-09-02 davidsch #rev 2018-08-28 davidsch |
|
| Line 2: | Line 5: |
| If you want to learn about database design and programming you can get an account on our MySQL database server. Get in touch with us and let us know what your plans are. The Address of our database server is {{{mysql.ee.ethz.ch}}} where mysql runs on the default port (3306). For database configuration and setup tasks you can also make use of our [[http://mysql.ee.ethz.ch|phpMyAdmin]] setup. | * If you want to do practical exercises on database design and programming you can obtain an account on our MariaDB (a MySQL open source fork) database server. Get in touch with ISG.EE (e-mail to support@ee.ethz.ch) and let us know what your plans are. The URI of our database server is {{{remi.ee.ethz.ch}}} where MariaDB runs on the default TCP port 3306. Besides the basic MariaDB SQL service, we provide a [[https://mysql.ee.ethz.ch/|phpMyAdmin]] WebUI for database queries and management. [[https://mariadb.org/|MariaDB]] is a true multi-user, multi-threaded (mostly) MySQL-compatible SQL database server. It consists of the server daemon {{{mysqld}}} and of a bunch of different client programs and libraries. ANSI-SQL, a declarative language, is the standard for most relational databases and it is the most popular database language in the world. |
| Line 4: | Line 7: |
| * [[http://sunsite.cnlab-switch.ch/ftp/mirror/mysql|Swiss MySQL mirror site]] MySQL is a true multi-user, multi-threaded SQL database server. SQL is the most popular database language in the world. MySQL is a client/server implementation that consists of a server daemon mysqld and many different client programs and libraries. | * As an alternative to relational databases, ISG.EE also offers MongoDB, a NoSQL (nonrelational) JSON-/ object-based database especially suitable with software written in JavaScript. The service is reachable on mongodb01.ee.ethz.ch, on tcp/27017. * Note: All database services are accessible from the internal ETHZ networks only. The only exception is the [[https://mysql.ee.ethz.ch/|phpMyAdmin]] web interface, which can be used globally after user authentication. ---- [[CategoryDB]] |
Database programming
If you want to do practical exercises on database design and programming you can obtain an account on our MariaDB (a MySQL open source fork) database server. Get in touch with ISG.EE (e-mail to support@ee.ethz.ch) and let us know what your plans are. The URI of our database server is remi.ee.ethz.ch where MariaDB runs on the default TCP port 3306. Besides the basic MariaDB SQL service, we provide a phpMyAdmin WebUI for database queries and management. MariaDB is a true multi-user, multi-threaded (mostly) MySQL-compatible SQL database server. It consists of the server daemon mysqld and of a bunch of different client programs and libraries. ANSI-SQL, a declarative language, is the standard for most relational databases and it is the most popular database language in the world.
As an alternative to relational databases, ISG.EE also offers MongoDB, a NoSQL (nonrelational) JSON-/ object-based database especially suitable with software written in JavaScript. The service is reachable on mongodb01.ee.ethz.ch, on tcp/27017.
Note: All database services are accessible from the internal ETHZ networks only. The only exception is the phpMyAdmin web interface, which can be used globally after user authentication.