Python: Create a SQLite database connection to a database that resides in the memory
Write a Python program to create a SQLite database connection to a database that resides in the memory.
Sample Solution:
Python Code :
import sqlite3
try:
sqlite_Connection = sqlite3.connect('temp.db')
conn = sqlite3.connect(':memory:')
print("\nMemory database created and connected to SQLite.")
sqlite_select_Query = "select sqlite_version();"
conn.execute(sqlite_select_Query)
print("\nSQLite Database Version is: ", sqlite3.version)
conn.close()
except sqlite3.Error as error:
print("\nError while connecting to sqlite", error)
finally:
if (sqlite_Connection):
sqlite_Connection.close()
print("\nThe SQLite connection is closed.")
Sample Output:
Memory database created and connected to SQLite. SQLite Database Version is: 2.6.0 The SQLite connection is closed.
Python Code Editor:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a Python program to create a SQLite database and connect with the database and print the version of the SQLite database.
Next: Write a Python program to connect a database and create a SQLite table within the database.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics