/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

4 votes141 views1 answer
Np.random.float
Python
1 vote162 views2 answers
Python alphabetical order
Python
0 vote144 views1 answer
Find the path of python executable
Python
0 vote113 views1 answer
Output multiple LaTex equations in one cell in Google Colab
Python
110 votes152 views4 answers
How to tell python to create a random numer
Python
1 vote143 views1 answer
What is ycor in python turle
Python
0 vote95 views1 answer
Savefig image size
Python
24 votes131 views2 answers
How to get the year and month in python
Python
0 vote182 views1 answer
Huggingface dataset from pandas
Python
0 vote126 views2 answers
Remove nans and infs python
Python