Learn SQL and database design with Raspberry Pi


Studying Time: 3 minutes


SQLite’s web site is primary, however sqlitetutorial.web gives free interactive coaching. In addition to masking SQL for SQLite (all platforms have barely completely different implementations of SQL), there’s a Python-specific course. Right here, you’ll be able to discover ways to use PySQLite, the Python bindings for SQLite. Not solely is the SQL language lined, however create databases and tables in Python. This makes for a complete mixture of programs.



The following logical step from SQLite is to maneuver to a full relational database server. A preferred alternative is MariaDB, an open-source venture primarily based on, and totally suitable with, MySQL. MySQL might be some of the well-liked database servers of all time. Each variants are free, however MariaDB boasts a brand new ‘engine’ that gives vital pace will increase. Putting in the server is easy and it runs surprisingly quick, even on older Raspberry Pi {hardware}. As soon as put in, you’ve extra to consider than with SQLite, equivalent to customers and permissions. Fortunately, MariaDB gives on-line programs without cost – a nicer solution to study than ploughing by dry documentation. This can be a highly effective platform: it may take tables containing tens of millions of rows in its stride. It’s potential to make use of MariaDB/MySQL for something from your individual logging venture, to enterprise-grade purposes.



Sure purposes or initiatives require a unique sort of database. In case you’re taking a look at storing heaps and many easy information and don’t require the form of information extraction that relational databases supply, then a NoSQL (or doc) database could also be for you. This household of databases specialize in high-volume, quick information storage and retrieval. They’re particularly well-liked when the job is to ‘simply get the info and retailer it as rapidly as potential’. Somewhat than utilizing the normal mannequin of tables, columns, and rows, doc databases use schemas and key-pairs to retailer information. MongoDB is a well-liked open-source server. It’s very simple to put in, and you may undertake a full course.

The Definitive Information to SQLite

Grant Allen and Michael Owen’s e-book on SQLite is a complete take a look at this ‘micro’ database. Regardless of its small footprint, the authors reveal an extremely highly effective engine and a few shocking purposes together with embedded techniques.

MySQL for Python

Python being the popular alternative of language of the Raspberry Pi Basis, this e-book is an ideal introduction to utilizing Python’s MySQL wrappers. The MySQL for Python e-book is formatted as a collection of tutorials that improve with complexity.

MongoDB and Python

Just like the aforementioned MySQL for Python e-book, this one will get proper to the purpose. It makes use of the ‘recipe’ format, so you will discover a detailed match for the issue you need to remedy, and see how utilizing MongoDB can assist.

Udemy SQL Video courses

Intro To SQLite Databases for Python Programming

An excellent ‘again to fundamentals’ video course which takes you thru all of the steps of putting in and utilizing SQLite. Intro to SQLite Databases for Python Programming is 90 minutes of video in bite-size items.

Utilizing MySQL Databases With Python

Identical to for SQLite, Udemy gives a full nothing-to-something course on utilizing MySQL Databases with Python. The 2 hours of video usefully cowl set up of the server.

MongoDB and Python: Fast begin

Crucially, this MongoDB and Python: Fast Begin two-hour video course covers when to decide on a NoSQL (or doc) database and the important thing variations between this and conventional SQL engines.

Source link

Leave a Reply

Your email address will not be published.

Previous Post

Art Of War SEO Agency Getting Bigger and Better – Press Release

Next Post

Kingdom on Netflix: Does Seo-Bi have feelings for Crown Prince Chang? | TV & Radio | Showbiz & TV

Related Posts