Breaking News: Grepper is joining You.com. Read the official announcement!

load SQLite db into memory

Thankful Tamarin answered on May 13, 2022 Popularity 5/10 Helpfulness 1/10

answer load SQLite db into memory

load SQLite db into memory

Comment

import sqlite3
from io import StringIO

def init_sqlite_db(app):
    # Read database to tempfile
    con = sqlite3.connect(app.config['SQLITE_DATABASE'])
    tempfile = StringIO()
    for line in con.iterdump():
        tempfile.write('%s\n' % line)
    con.close()
    tempfile.seek(0)

    # Create a database in memory and import from tempfile
    app.sqlite = sqlite3.connect(":memory:")
    app.sqlite.cursor().executescript(tempfile.read())
    app.sqlite.commit()
    app.sqlite.row_factory = sqlite3.Row

Popularity 5/10 Helpfulness 1/10 Language python

Source: stackoverflow.com

Tags: load memory python sqlite

Link to this answer
Share Copy Link