/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 vote190 views1 answer
Spotify recommendations
Python
2 votes212 views2 answers
Flask 'export' is not recognized as an internal or external command, operable program or batch file.
Python Flask
0 vote168 views1 answer
Python remove second occurrence of character in string
Python
4 votes169 views4 answers
Download pdf python
Python
0 vote184 views1 answer
Adding new column to existing DataFrame in Pandas using concat method
Python
1 vote159 views1 answer
Python anagram finder
Python
0 vote203 views1 answer
Django require_POST body
Python
2 votes164 views1 answer
Python checking if something is equal to NaN
Python
0 vote195 views1 answer
Opencv contrib pillow
Python
3 votes168 views2 answers
Pathlib current directory
Python