/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

24 votes178 views6 answers
Order dictionary by value python
Python
24 votes136 views4 answers
Return max integer from list
Python
2 votes189 views3 answers
How to set default python version linux
Python
0 vote185 views1 answer
How to remove repeated files from google drive in python
Python
1 vote180 views1 answer
Previous value list loop python
Python
5 votes178 views1 answer
How to get a dataframe column as a list
Python
0 vote170 views1 answer
Concat with zero array numpy
Python
0 vote191 views1 answer
Python ordering items in a list
Python
5 votes187 views3 answers
Update in django orm
Python
1 vote166 views1 answer
Google colab display entire array
Python