/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 vote334 views1 answer
Hovering over canvas item tkinter event
Python
0 vote293 views1 answer
Append time complexity python
Python
1 vote344 views1 answer
Start index from 1 in python
Python
1 vote348 views1 answer
Python get last item in a list
Python
0 vote332 views1 answer
Packing and unpacking in python
Python
0 vote328 views5 answers
Medium seaaborn mathplot diesign styles
Python
1 vote316 views1 answer
How to construct simple timedelta in python
Python
0 vote301 views1 answer
1. write a program to multiply two numbers using function python
Python
0 vote352 views1 answer
"must be called with either an object pk or a slug in the URLconf"
Python
3 votes306 views2 answers
Run python notepad++
Python