Posts

Showing posts from January, 2019

RDBMS FOSS Approach

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...