/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 vote136 views1 answer
Fix certain parameters during curve fit python lambda
Python
1 vote126 views1 answer
Resto division python
Python
0 vote156 views1 answer
K.set_image_dim_ordering('tf') AttributeError: module 'keras.backend' has no attribute 'set_image_dim_ordering'
Python
0 vote158 views1 answer
Running mean
Python
0 vote135 views1 answer
Open python choose encoding
Python
-1 vote161 views1 answer
How to sort columns alphabetically in pandas
Python
13 votes154 views5 answers
Binary tree in python
Python
0 vote149 views1 answer
MyTestCase
Python
0 vote157 views4 answers
AttributeError: 'Database' object has no attribute 'remove'
Python
0 vote144 views1 answer
Python cv2 canny overlay on image
Python