/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

45 votes312 views2 answers
String to datetime convert
Python
0 vote282 views1 answer
How to make python script run forever
Python
40 votes316 views6 answers
Count nan pandas
Python
0 vote295 views1 answer
Robust scaler
Python
24 votes312 views2 answers
How to check a string is empty in python
Python
0 vote288 views1 answer
How to sort the order in multiple index pandas
Python
0 vote317 views1 answer
Statistique in python
Python
2 votes308 views2 answers
Php echo shorthand
Python
-1 vote357 views1 answer
Class views django slug
Python Django
1 vote313 views2 answers
Django create multiple objects
Python