DEV Community πŸ‘©β€πŸ’»πŸ‘¨β€πŸ’»

Cover image for Battery Included Philosophy, python
YusufAdel
YusufAdel

Posted on

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.

Top comments (4)

Collapse
yusufadel profile image
YusufAdel Author

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

Collapse
waylonwalker profile image
Waylon Walker

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

Collapse
waylonwalker profile image
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.

🌚 Friends don't let friends browse without dark mode.

Sorry, it's true.