flask
  1. flask-sqlite
PreviousNext

SQLite - Database Integration in Flask

SQLite is a lightweight database that can be easily integrated into Flask applications. It is a popular choice for small to medium-sized applications due to its simplicity and easy setup. In this guide, we will discuss the syntax, example, output, explanation, use, important points, and summary of SQLite integration with Flask.

Syntax

To use SQLite with Flask, you need to import the SQLite module and initialize a connection to the database. Here is the syntax:

import sqlite3

conn = sqlite3.connect('database.db')

Example

Here is an example of creating a table and inserting values into it using SQLite in Flask:

from flask import Flask, render_template
import sqlite3

app = Flask(__name__)

@app.route('/')
def home():
    conn = sqlite3.connect('database.db')
    cursor = conn.cursor()
    cursor.execute('CREATE TABLE IF NOT EXISTS Users (id INTEGER PRIMARY KEY, name TEXT)')
    cursor.execute("INSERT INTO Users (id, name) VALUES (1, 'John Doe')")
    cursor.execute("INSERT INTO Users (id, name) VALUES (2, 'Jane Doe')")
    conn.commit()
    conn.close()
    return render_template('home.html')

if __name__ == '__main__':
    app.run()

Output

Running the above Flask application will create a table named "Users" in the database.db file and insert two rows into the table. The home page of the application will be rendered with a message "Hello World".

Explanation

In the above example, we have initialized a connection to the SQLite database using the sqlite3 library. We have created a table "Users" with two columns "id" and "name". Then, we have inserted two rows into the table using the execute() method of the cursor object. Finally, we have committed the changes and closed the connection.

Use

SQLite is a suitable choice for simple Flask applications that do not require a large amount of data storage or complex querying. It is easily integrated into Flask applications and requires minimal setup.

Important Points

  • SQLite does not require a separate database server to be installed as it is a serverless database.
  • SQLite is lightweight and has a small memory footprint.
  • SQLite is not suitable for large and complex applications that require high levels of concurrency.

Summary

SQLite is a simple and lightweight database that can be easily integrated into Flask applications. It requires minimal setup and is suitable for small and simple applications. However, it may not be the best choice for large and complex applications that require high levels of concurrency.

Mail ExtensionSQLAlchemy
Published on: