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

Get Raspberry Pi 3 Cookbook for Python Programmers - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.