/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 vote104 views2 answers
Python how to extract a string from another string
Python
0 vote111 views1 answer
Download video to from pytube with a special name
Python
2 votes123 views1 answer
Scrapy get current url
Python
0 vote63 views1 answer
Python tri alphabetique
Python
3 votes109 views1 answer
Spark df shape
Python
4 votes113 views1 answer
Return python meaning
Python
0 vote61 views1 answer
Python word encode asci
Python
4 votes106 views1 answer
Circle python programe
Python
8 votes111 views3 answers
Python add variable to function dynamically
Python
0 vote118 views1 answer
What is the correct way to sort the list 'B' using a method, the result should not return a new list, just change the list 'B' in python
Python