/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 votes109 views1 answer
Accessing items of tuple in python
Python
0 vote112 views1 answer
Using rstrip() method to remove the newline character from a string
Python
8 votes115 views1 answer
Python transfer file
Python
0 vote114 views1 answer
Fetch python
Python
0 vote122 views2 answers
Pyttsx3 save to file
Python
0 vote105 views1 answer
Dataclass in python
Python
3 votes125 views2 answers
Extract one column from dataframe python
Python
0 vote130 views1 answer
How to check if user pressed enter in python
Python
0 vote136 views1 answer
"must be called with either an object pk or a slug in the URLconf"
Python
0 vote111 views1 answer
Subprocess the system cannot find the file specifie
Python