/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

20 votes116 views6 answers
Dict to list python
Python
66 votes124 views6 answers
Make directory python
Python
0 vote122 views1 answer
Combine for and if python
Python
0 vote129 views1 answer
Dataframe show to semicolon python
Python
1 vote121 views1 answer
Catch error data with except python
Python
3 votes138 views2 answers
Merge sort of two list in python
Python
225 votes330 views6 answers
Random number generator python
Python
0 vote164 views1 answer
Python Split list into chunks using itertools Method
Python
0 vote117 views1 answer
Making constructor in python
Python
1 vote128 views1 answer
How to convert ton to kg using python
Python