ICT, Database, Linux & eLearning

This blog tutorial is created to help you create a browser based (cloud) database application using MariaDB with CodeIgniter together with the Grocery-CRUD plugin that you can easily test through your localhost server on your desktop, on your LAN or via internet through your ISP. Download and install XAMPP on Windows OS or Apache, MariaDB (MySQL) and PHP on Linux. Download and install CodeIgniter3 in /xampp/htdocs or /var/www/html/ in Ubuntu under your website folder name. Download and install Grocery-CRUD application folders by merging them with the CodeIgniter3 folders in your proposed website. Use phpAdmin to create the MariaDB database for your website. Edit /application/config/database.php to point to your database as required. Edit /application/config/config.php to point to your database as needed. You can follow the following online tutorials or read the user manuals online to customise your site to work with CRUD. https://www.grocerycrud.com/ https://www.groceryc...

Introduction - What is a database? - Flat files vs RDBMS Desktop Cloud FOSS RDBMS Applications - Desktop - LibreBase - Cloud - MySQL (MariaDB), Postgres (PostgreSQL) CRUD - REST https://softwareengineering.stackexchange.com/questions/120716/difference-between-rest-and-crud CRUD means the basic operations to be done in a data repository. You directly handle records or data objects; apart from these operations, the records are passive entities. Typically it's just database tables and records. REST, on the other hand, operates on resource representations, each one identified by an URL. These are typically not data objects, but complex object abstractions. For example, a resource can be a user's comment. That means not only a record in a 'comment' table, but also its relationships with the 'user' resource, the post that comment is attached to, maybe another comment that it responds to. Operating on the comment isn't a primitive datab...