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 with MySQL, you will also need PHP MySQL (php5-mysql); for more information, see the excellent resource at W3 Schools (http://www.w3schools.com/php/php_mysql_connect.asp).

You will notice that although there are small differences between SQL implementations, the general concepts and commands should now be familiar to you, whichever one you select.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.222.164.141