/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

2 votes142 views1 answer
How to get element from dictionary python
Python
2 votes117 views1 answer
How to launch jupyter notebook from cmd
Python
0 vote142 views1 answer
Ptyhton json respones
Python
5 votes187 views3 answers
How to run flask in port 80
Python Flask
5 votes116 views2 answers
Django password field
Python
0 vote122 views2 answers
Generate random password django
Python
0 vote158 views2 answers
Allow x_frame_options django
Python Django
1 vote91 views1 answer
Float to binary python
Python
-1 vote179 views1 answer
Sort pandas dataframe by specific column
Python
12 votes131 views4 answers
Merge three dataframes pandas based on column
Python