Skip to Content
Raspberry Pi 3 Cookbook for Python Programmers - Third Edition
book

Raspberry Pi 3 Cookbook for Python Programmers - Third Edition

by Steven Lawrence Fernandes, Tim Cox
April 2018
Beginner content levelBeginner
552 pages
13h 58m
English
Packt Publishing
Content preview from Raspberry Pi 3 Cookbook for Python Programmers - Third Edition

Using MySQL instead

SQLite, which is used in this recipe, is just one of many SQL databases available. It is helpful for small projects that only require relatively small databases and minimal resources. However, for larger projects that require additional features (such as user accounts to control access and additional security), you can use alternatives, such as MySQL.

To use a different SQL database, you will need to adjust the Python code that we used to capture the entries using a suitable Python module.

For MySQL (mysql-server), we can use a Python-3-compatible library called PyMySQL to interface with it. See the PyMySQL website (https://github.com/PyMySQL/PyMySQL) for additional information about how to use this library.

To use PHP ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Raspberry Pi for Python Programmers Cookbook - Second Edition

Raspberry Pi for Python Programmers Cookbook - Second Edition

Tim Cox

Publisher Resources

ISBN: 9781788629874Supplemental Content