/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

18 votes282 views3 answers
Pil image from numpy
Python
2 votes350 views1 answer
Django template tag to display current year
Python Django
0 vote269 views1 answer
Powershell bulk rename and add extra string to filename
Python
0 vote269 views1 answer
Pandas remove item from dictionary
Python
0 vote342 views1 answer
How to write a script to display an image in python
Python
0 vote254 views1 answer
Python disable logging on unittest
Python
3 votes263 views2 answers
Install flask on linux mint for python3
Python
0 vote274 views1 answer
Tqdm 2 progress bars
Python
0 vote279 views1 answer
Concatenate strings of numpy array python
Python
71 votes278 views6 answers
Shuffle array python
Python