/tag/databases

  • Introduction to Databases

    There are two main families of databases: Relational and NoSQL. Relational databases store information in an orderly, column, row, and table schema. They “relate” the tables together to present different views of the data. NoSQL databases are much less structured. This means they can store different data alongside each other – which makes things both easier to store but harder to query across. There are additional types of databases, such as ledger, time-series and others. Those are beyond the scope of this introduction. Relational Databases (RDBMS) Most users have at least heard of relational databases such as:
  • Database Software on Ivy Linux VM

    The following database software are available on the Ivy Linux Virtual Machines MySQL Is the most popular open-source relational database, used in academia and industry worldwide. It has been in use for over 20 years and is backed by a large developer community. It is available in both free and proprietary versions. MariaDB MariaDB is a community developed version of MySQL, and is highly compatible with MySQL and other relational databases. Existing databases can be easily migrated between MySQL and MariaDB, and vice versa. PostgreSQL Unlike MariaDB and MySQL, PostgreSQL is an object relational database, and can be used in a manner similar to other relational databases.