/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

3 votes246 views2 answers
How to find the most frequent value in a column in pandas dataframe
Python
0 vote294 views1 answer
Tkinter attribute error
Python
0 vote247 views1 answer
Pandas remove item from dictionary
Python
6 votes258 views6 answers
Def python
Python
0 vote246 views2 answers
Convert pandas dataframe to spark dataframe
Python
1 vote254 views1 answer
Merged all dictionaries in a list python
Python
5 votes266 views3 answers
Sys python
Python
0 vote242 views1 answer
Changing instance variable python inheritance
Python
0 vote258 views1 answer
Pip.exe The system cannot find the file specified
Python
0 vote251 views1 answer
Python opens windows store
Python