Battery Included Philosophy, python

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.

Comments

[YusufAdel]

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 sqlite3
con = 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

[Waylon Walker]

This does provide a more consistent set of core functionality rather than being scattered in dozens of other packages

[Waylon Walker]

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.