/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

1 vote210 views1 answer
Pip uninstalled itself
Python
2 votes237 views3 answers
Check nan values in a np array
Python
1 vote182 views1 answer
Read pdf py
Python
0 vote222 views1 answer
Drop-trailing-zeros-from-decimal python
Python
5 votes264 views2 answers
Python write a dictionary to file
Python
7 votes193 views3 answers
How to delete migrations in django
Python
0 vote239 views2 answers
Draw bipartite graph networkx
Python
0 vote207 views4 answers
AttributeError: 'Database' object has no attribute 'remove'
Python
2 votes196 views2 answers
Fibonacci series using for loop in python
Python
0 vote177 views1 answer
Pandas crosstab function(counting) frequencies
Python