If you need a database management system open, flexible, and easy to use, then you may want to look at Ralph. Ralph DBMS uses REST API to query documents using Python right out of the box. Building your apps using this database system should make your job using its intuitive web UI. For more about Ralph, please visit its homepage. If you want to test it in your lab environment before going out and using it in production, the steps below should be a great place to start. Follow the steps below to get Ralph installed on Ubuntu
Install Required Packages
To get the latest version of Ralph DBMS, you’ll need to add its official repository to Ubuntu. However, some required packages may be needed for the installation to work. First, run the commands below to install apt-transport-https.
Install MariaDB Database Server
Ralph DBMS also requires a database server to store its content… If you’re looking for a truly open-source database server, then MariaDB is a great place to start… To install MariaDB run the commands below: After installing MariaDB, the commands below can be used to stop, start and enable the MariaDB service to always start up when the server boots. Run these on Ubuntu 16.04 LTS Run these on Ubuntu 18.10 and 18.04 LTS Next, run the commands below to secure the database server with a root password if you were not prompted to do so during the installation… When prompted, answer the questions below by following the guide.
Enter current password for root (enter for none): Just press the Enter Set root password? [Y/n]: Y New password: Enter password Re-enter new password: Repeat password Remove anonymous users? [Y/n]: Y Disallow root login remotely? [Y/n]: Y Remove test database and access to it? [Y/n]: Y Reload privilege tables now? [Y/n]: Y
Now that MariaDB is installed, to test whether the database server was successfully installed, run the commands below… type the root password when prompted. If you see a similar screen as shown above, then the server was successfully installed… Next, run the commands below to open the MariaDB default config file… Then add the lines below and save. Restart MariaDB after that. After installing the package above, continue below to install Ralph.
Install Ralph
Now that some required packages are installed, follow the steps below to get Ralph DBMS installed and configured. To add Ralph’s repository and key, run the commands below. The first line imports the repository’s GPG key. the second adds Ralph’s repository into a new file called ralph.list. After the steps above, run the commands below to install them. When prompted where to use Ralph’s default settings, choose Yes After installing the commands below can be used to stop, start and enable Ralph’s service. To verify that Ralph is installed and running, run the commands below check its status. You should see similar lines as shown below: That should do it!
Setup Ralph Database and User
Set up Ralph MariaDB database and user. by running the commands below. When prompted, type in the MariaDB root password created above. Next, run the commands below to create a new database called ralph_ng Then run the commands below to create a new database user called ralph_ng Grant the account access to the ralph_ng database above. Next, save and exit The default username and password are configured in /etc/ralph/conf.d/database.conf file. If you didn’t use the default above, you must update the file with the correct account before continuing below. After that, run the commands below to create a database schema. After that, run the commands below to create Ralph’s admin account for its web portal. Output: Optionally, you can run the commands below to import demo data. Next, enable Ralph’s sync-apps and restart Ralph’s service.
Access Ralph Web Interface
Ralph also comes with a web interface for easy management in your web browser. You’ll have to install a web server to get a good web experience. For this post, we’re going to use the Nginx HTTP server. Run the commands below to install Nginx Then create a virtual host for Ralph. Copy and paste the content below into the file and save When you’re done, restart Nginx and browse to the server name you specified above. sudo systemctl reload nginx Login with the admin account you created previously. Congratulations! You have successfully installed Ralph DBMS on Ubuntu 16.04 and 18.04 You may also like the post below:
