/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 vote196 views1 answer
Python cv2 canny overlay on image
Python
-1 vote226 views1 answer
Fro flask import Flask, request, render_template, url_for, redirect, session
Python
2 votes201 views2 answers
Print the number of times that the substring occurs in the given string
Python
0 vote183 views1 answer
Call item from dictionary python
Python
0 vote202 views2 answers
Set operators
Python
0 vote226 views1 answer
Error 302 heroku django
Python Django
1 vote192 views1 answer
Python display text in label on new line
Python
0 vote207 views2 answers
Python if not none in one line
Python
0 vote213 views1 answer
How to extract integers from string python
Python
0 vote191 views2 answers
How to read excel with multiple pages on pandas
Python