/Python/Python create sqlite db in memory

Python create sqlite db in memory

import sqlite3
from sqlite3 import Error


def create_connection():
    """ create a database connection to a database that resides
        in the memory
    """
    conn = None;
    try:
        conn = sqlite3.connect(':memory:')
        print(sqlite3.version)
    except Error as e:
        print(e)
    finally:
        if conn:
            conn.close()


if __name__ == '__main__':
    create_connection()
Code language: Python (python)

Source: sqlitetutorial.net

Similar codes

4 votes367 views1 answer
Change type of array python
Python
0 vote390 views1 answer
Python pipe select where
Python
1 vote361 views1 answer
Pandas resample backfill
Python
0 vote348 views1 answer
Ping all IP addresses in a network
Python
0 vote342 views1 answer
Check stl file for errors in pyvista
Python
0 vote366 views1 answer
Split pandas dataframe in two
Python
0 vote378 views1 answer
Bs.newtag() inner html
Python
61 votes361 views6 answers
Python classes
Python
1 vote338 views1 answer
Streamlit button to load a file
Python
0 vote375 views1 answer
Gtk label set label
Python