/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 vote153 views1 answer
Start models
Python
1 vote162 views2 answers
How to read any random rows in csv
Python
1 vote158 views1 answer
How to convert adjacency list to adjacency matrix
Python
2 votes107 views1 answer
Sqlalchemy check if db exists
Python
0 vote141 views1 answer
Sort true
Python
12 votes140 views6 answers
Python hello world program
Python
3 votes175 views4 answers
Fb
Python
1 vote98 views1 answer
How to get sheet names in pandas
Python
4 votes140 views1 answer
Knn sklearn
Python
0 vote143 views1 answer
Plotly reverse y axis
Python