Connection pooling in Flask - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

What is the main benefit of using connection pooling in Flask apps?

Connection pooling helps Flask apps by:

A Increasing the number of simultaneous database connections beyond server limits

B Automatically encrypting all data sent to the database

C Reducing the time to establish database connections by reusing existing ones

D Replacing the need for a database entirely

💡 Hint

Think about what happens when you open and close database connections repeatedly.

Connection pooling keeps a set of open connections ready to use, so the app doesn't spend time opening new ones each request.

❓ component_behavior

intermediate

What happens if the connection pool is exhausted in a Flask app?

Consider a Flask app using a connection pool with a max size of 5. What occurs when 6 requests try to get a connection simultaneously?

A The 6th request waits until a connection is released back to the pool

B The 6th request creates a new connection ignoring the pool limit

C The 6th request immediately fails with a connection error

D All requests share the same single connection

💡 Hint

Think about how pools manage limited resources.

When the pool is full, new requests wait for a connection to be returned before proceeding.

📝 Syntax

advanced

Which code snippet correctly sets up a SQLAlchemy connection pool in Flask?

Choose the code that properly configures a connection pool with max 10 connections using SQLAlchemy in Flask.

Flask

from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///test.db'
# Configure pool here

db = SQLAlchemy(app)

A app.config['SQLALCHEMY_MAX_POOL'] = 10

B app.config['SQLALCHEMY_POOL_SIZE'] = 10

C app.config['SQLALCHEMY_POOL_MAX'] = 10

D app.config['SQLALCHEMY_POOL_LIMIT'] = 10

💡 Hint

Look for the official SQLAlchemy pool size config key.

The correct config key to set the pool size is SQLALCHEMY_POOL_SIZE.

🔧 Debug

advanced

Why does this Flask app raise a 'TimeoutError' when using connection pooling?

Given this Flask app snippet, why might a 'TimeoutError' occur?

Flask

from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///test.db'
app.config['SQLALCHEMY_POOL_SIZE'] = 2
app.config['SQLALCHEMY_POOL_TIMEOUT'] = 1

db = SQLAlchemy(app)

@app.route('/')
def index():
    conn1 = db.engine.connect()
    conn2 = db.engine.connect()
    conn3 = db.engine.connect()  # This line causes TimeoutError
    return 'Hello'

A The app forgot to close the first two connections before opening the third

B SQLite does not support connection pooling, so all connections fail

C The pool timeout is too high, causing delays

D The pool size is 2, so the third connection request times out waiting for a free connection

💡 Hint

Check the pool size and how many connections are requested.

With pool size 2, the third connection waits but times out after 1 second because no connection is free.

❓ state_output

expert

What is the output count of active connections after these Flask requests?

Assuming a Flask app with SQLAlchemy connection pool size 3, what is the number of active connections after these steps?

1. Request 1 opens a connection and holds it.
2. Request 2 opens a connection and holds it.
3. Request 3 opens a connection and holds it.
4. Request 4 tries to open a connection but waits.
5. Request 1 releases its connection.
6. Request 4 acquires the released connection.

A 3 active connections

B 4 active connections

C 2 active connections

D 1 active connection

💡 Hint

Remember the pool size limits simultaneous active connections.

The pool size is 3, so only 3 connections can be active at once. Request 4 waits until one is released, then uses it, keeping active connections at 3.