/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

0 vote198 views1 answer
Valueerror: must have equal len keys and value when setting with an iterable
Python
0 vote190 views1 answer
Python display name plot
Python
0 vote233 views1 answer
Django rest framework not getting form
Python Django
0 vote180 views1 answer
Unhexing floats
Python
0 vote187 views1 answer
Sns histplot nan values
Python
0 vote230 views1 answer
Threshold meaning in pandas dropna
Python
0 vote184 views1 answer
Spotify meist gespielte lieder sehen
Python
0 vote196 views1 answer
Custom jupyter notebook
Python
0 vote182 views1 answer
Dt.weekday_name
Python
0 vote215 views2 answers
Print specific key in dictionary python
Python