/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

1 vote207 views1 answer
Installing packages from requirements.txt file
Python
2 votes200 views1 answer
Pip vs anaconda venv
Python
0 vote194 views2 answers
Python divide array into n parts
Python
0 vote189 views1 answer
Computecost pyspark
Python
21 votes184 views6 answers
Pygame install
Python
125 votes185 views6 answers
Dataframe rename column
Python
34 votes374 views6 answers
Simple flask app
Python Flask
0 vote190 views1 answer
Multiple bar graph in python
Python
0 vote196 views1 answer
Pycocotools python3.7
Python
0 vote193 views1 answer
Multivariable traces f(x, y) = sin(x)cos(y)
Python