/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 vote203 views1 answer
Django include all columns admin show
Python
13 votes220 views4 answers
Pandas groupby count as new column
Python
2 votes237 views2 answers
Django template array index
Python
0 vote231 views1 answer
Python permission denied on mac
Python
0 vote218 views1 answer
Python type hint class itself
Python
4 votes220 views4 answers
Interface graphique sur python
Python
0 vote221 views1 answer
ModelCheckpoint
Python
0 vote235 views1 answer
Insert single value in dataframe using index
Python
0 vote225 views1 answer
Print less than specific number in one row python
Python
4 votes212 views6 answers
Python variables
Python