WeвЂ™ll create a variable cur to hold our cursor object: cur = conn.cursor() Simply put, a cursor object allows us to execute SQL queries against a database. Now that weвЂ™ve created a database connection object, our next task is to create a cursor object. However, for the purposes of this tutorial, and for most use cases youвЂ™ll run into, youвЂ™ll use the method we described earlier. This is a great way to generate databases that can be used for testing purposes, as they exist only in RAM. In-Memory DatabasesДЄnother way of generating databases using SQLite in Python is to create them in memory. The connect function creates a connection to the SQLite database and returns an object to represent it. You can learn more about raw strings by checking out this link. This lets Python know that weвЂ™re working with a raw string, meaning that the вЂњ/вЂќ wonвЂ™t be used to escape characters. Note: Notice that we included the letter вЂњrвЂќ before the string that contains this path. If the file already exists, the connect function will simply connect to that file.

If you wanted to specify a specific directory, you could write: conn = nnect(r'PATH-TO-YOUR-DIRECTORY/orders.db') With this line of code, weвЂ™ve created a new connection object, as well as a new file called orders.db in the directory in which youвЂ™re working. WeвЂ™ll represent the connection using a variable named conn. db file, as this is a very standard way of actually maintaining a SQLite database. This object is created using SQLiteвЂ™s connect() function. In order to do this, weвЂ™ll create a Connection object that will represent the database. In this section of the Python SQLite tutorial, weвЂ™ll explore the different ways in which you can create a database in Python with SQLite.

LetвЂ™s move into actually creating our database. We can do this by using the following command: import sqlite3 LetвЂ™s start off the tutorial by loading in the library. Unfortunately, when using SQLite, youвЂ™re restricted to these data types. вЂ“ Includes a binary large object that is stored exactly as inputДЇrom this list, you may notice a number of missing data types such as dates.

REAL вЂ“ Includes a floating point (decimal) value.

LetвЂ™s take a quick look at the data types that are available: However, as youвЂ™ll see, SQLite makes a lot of other things easier. SQLite for Python offers fewer data types than other SQL implementations. Data Types Available in SQLite for Python

Db browser for sqlite guide