I’ve seen two approaches which I’m going to post in the comments to see which one is considered best. Feel free to suggest others.
You are viewing a single thread.
View all comments 
3 points
Depends on the use case; the question is, do you need to construct and destroy the connection inside each method, or can you do it once, at the start of the program, and exit at the end?
db = Db(DB_FILE)
post_id = insert_post(db,"hello")
comment_id = insert_comment(db,post_id)
db.close()
