The following program creates an SQLite database in the memory. If you pass the file name as :memory: to the connect() function of the sqlite3 module, it will create a new database that resides in the memory (RAM) instead of a database file on disk. If you skip the folder path c:\sqlite\db, the program will create the database file in the current working directory (CWD). Let’s run the program and check the c:\sqlite\db folder. Note that the prefix r in the r"C:\sqlite\db\pythonsqlite.db" instructs Python that we are passing a raw string. Second, we pass the path of the database file to the create_connection() function to create the database. It is a good programming practice that you should always close the database connection when you complete with it. If everything is fine, we display the SQLite database version. In case an error occurs, we catch it within the try except block and display the error message. By using the Connection object, you can perform various database operations. It returns a Connection object that represents the database. The Python Standard Library includes a module called 'sqlite3' intended for. It is used in a lot of applications as internal data storage. It is very fast and lightweight, and the entire database is stored in a single disk file. It is self-contained, serverless, zero-configuration and transactional.
The connect() function opens a connection to an SQLite database. SQLite3 is a very easy to use database engine. Inside the function, we call the connect() function of the sqlite3 module.
Def create_connection (db_file): """ create a database connection to a SQLite database """Ĭreate_connection( r"C:\sqlite\db\pythonsqlite.db")įirst, we define a function called create_connection() that connects to an SQLite database specified by the database file db_file.
0 kommentar(er)
