And you can write desktop or web applications in just about any programming language, because MariaDB/MySQL is a widely known and supported database.īase can be used to provide a graphical front end to a MySQL database, complete with table design, forms, and reports (similar to Microsoft Access).
You can also write perl, python, or bash scripts to interact with your database. Run man mysql for more detailed help information. If you do not specify a user the user that you are logged in as will be used. The command above will connect you to the host you specify (-h) as the user you specify (-u) and will prompt you for that user's password (-p). You should be able to connect to the database using the mysql client from any CLASSE computer. And finally, DBeaver is a database administration tool that falls between the mysql client and Base that provides a GUI interface to the database but doesn't offer form or report creation, for example. The mysql client is for users familiar with writing SQL queries on the command line. Users familiar with software like FileMaker or Microsoft Access will find the same types of functionality in Base. There are a variety of ways to connect to a database at CLASSE.ĭepending on your database experience, we recommend using the mysql client, DBeaver (Community Edition) or LibreOffice Base. To request a database, please email and include a description of how you intend to use the database.ĬLASSE IT will provide you with database connection information including: Also MariaDB is ready to be used either strictly on a desktop and/or as a back end database for a web site. And it offers a lot of flexibility.įor example, you could update or build the database with one type of software, continue developing it with another, or write your own application to interact with the data. It's not locked into any vendor's format requiring a specific piece of software to access it. It's centrally located so anyone on the network can access it. Putting your data in a MariaDB database at CLASSE means you do not have to worry about losing it. The MariaDB database, like MySQL, is widely supported by programming and scripting languages. The CLASSE MariaDB server is centrally located, backed up regularly, and accessible by anyone on the CLASSE network or beyond when used as the back-end of a web application. For general database requirements, CLASSE supports MariaDB, an open source version of MySQL.įor practical purposes, MariaDB is interchangeable with MySQL, and any instructions referencing MySQL will work for MariaDB, which is meant to be a drop-in replacement.
0 kommentar(er)
