/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 vote197 views1 answer
Tkinter listbox delete all items
Python
0 vote174 views1 answer
Pandas where
Python
0 vote222 views1 answer
Invalid Python Environment: Python is unable to find Maya's Python modules
Python
4 votes171 views1 answer
F-string ponto decimal python
Python
1 vote235 views1 answer
How to filter queryset with foreign key in django
Python Django
0 vote195 views1 answer
Python output parameter
Python
0 vote203 views1 answer
Ipython list command history
Python
6 votes282 views6 answers
Fibonacci python
Python
0 vote188 views1 answer
Sound alerts in Jupyter for code completion and exceptions
Python
3 votes191 views1 answer
Python split lines
Python