Rather than using the traditional model of tables, columns, and rows, document databases use schemas and key-pairs to store data. They are especially popular when the job is to ‘just get the data and store it as quickly as possible’. This family of databases specialise in high-volume, fast data storage and retrieval. If you’re looking at storing lots and lots of simple data and don’t require the kind of data extraction that relational databases offer, then a NoSQL (or document) database may be for you. MongoDBĬertain applications or projects require a different type of database. It’s possible to use MariaDB/MySQL for anything from your own logging project, to enterprise-grade applications. This is a powerful platform: it can take tables containing millions of rows in its stride.
How to install sqlite on raspberry pi for free#
Thankfully, MariaDB offers online courses for free - a nicer way to learn than ploughing through dry documentation. Once installed, you’ve more to think about than with SQLite, such as users and permissions. Installing the server is straightforward and it runs surprisingly fast, even on older Raspberry Pi hardware. Both variants are free, but MariaDB boasts a new ‘engine’ that provides significant speed increases. MySQL is probably one of the most popular database servers of all time.
A popular choice is MariaDB, an open-source project based on, and fully compatible with, MySQL. The next logical step from SQLite is to move to a full relational database server. This makes for a comprehensive combination of courses. Not only is the SQL language covered, but how to create databases and tables in Python. Here, you can learn how to use PySQLite, the Python bindings for SQLite. As well as covering SQL for SQLite (all platforms have slightly different implementations of SQL), there is a Python-specific course.
SQLite’s site is basic, but provides free interactive training.