/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 votes208 views1 answer
Df.sort_values(by='col1',asending=True)
Python
2 votes215 views1 answer
Pandas dataframe aggregations
Python
0 vote260 views1 answer
Credential not provided when i try to sign up a new user django
Python Django
0 vote230 views1 answer
Convert string input into a nested tuple in python
Python
21 votes217 views4 answers
Flask quickstart
Python
38 votes216 views4 answers
Python color text console
Python
15 votes230 views6 answers
Matplotlib.pyplot
Python
-3 votes260 views1 answer
ValueError: With n_samples=0, test_size=0.2 and train_size=None, the resulting train set will be empty. Adjust any of the aforementioned parameters.
Python
0 vote225 views1 answer
Python intitialize a 2d matrix
Python
0 vote250 views1 answer
How to select the shortest item in a python list
Python