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.

  • const void*@lemmy.world
    cake
    link
    fedilink
    arrow-up
    3
    ·
    1 year ago

    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()