others

Python 4.0

The will probably never be a Python 4.0 and if there was it would be backward compatible with 3.0.

The Python community hugely underestimated the impact of the break between version 2.7 and 3.0 and will avoid this in the future. 

SQLite beginner crash course

A helpful course on SQLite...

sqlite3 is a Python module that provides a Python interface to the SQLite database engine. It is a part of the Python Standard Library, so you do not need to install it separately.

The sqlite3 module allows you to integrate SQLite database functionality into your Python programs. You can use it to connect to a SQLite database, execute SQL queries and commands, and perform other database operations.

Here is an example of how you can use the sqlite3 module to connect to a SQLite database and execute a simple SELECT query:

import sqlite3

# Connect to the database

conn = sqlite3.connect('example.db')

# Create a cursor

cursor = conn.cursor()

# Execute a SELECT query

cursor.execute('SELECT * FROM my_table')

# Fetch the results

results = cursor.fetchall()

# Iterate over the results

for row in results:

    print(row)

# Close the cursor and connection

cursor.close()

conn.close()

Convert .py to .exe

This is a useful method that enables the user to make an exe with a visual gui as opposed to command line.

How to make code run faster

Below is a useful video on the dis module and how we can use it to "disassemble" and understand the bytecode that the Python interpreter produces.

A link to the code is here: py to exe project