Python has a “batteries included” philosophy. This is best seen through the sophisticated and robust capabilities of its larger packages.
Feel free to share with us your experience in handling jobs with one or Built-in modules that will help in day-to-day work.
Top comments (3)
I'll start with,
The sqlite3 module is a wrapper for the SQLite database library, providing a persistent database that can be updated and accessed using slightly nonstandard SQL syntax.
The code needed to make a database connections:
import sqlite3con = sqlite3.connect('example.db')
create a cursor:
cur = con.cursor()Now we can excute SQL statment:
cur.execute('''CREATE TABLE stocks(date text, trans text, symbol text, qty real, price real)''')
Don't forget to close db connection
cur.close()Full code:
import sqlite3
con = sqlite3.connect('example.db')
cur = sqlite3.curser()
cur.excute("")
cur.close
For further reading Here are sqlite3 official docs
This does provide a more consistent set of core functionality rather than being scattered in dozens of other packages
Itertools is one I use often and I consider it the most underrated standard library module.
The most common function I use is product to get all combinations of a few lists.