Full CRUD API (Flask + SQLite)

A complete backend API using Python Flask with SQLite database. See zh-cn version for the full Python code.

Quick Start

mkdir flask-api && cd flask-api
python3 -m venv venv && source venv/bin/activate
pip install flask flask-cors
python3 app.py

Features

  • ✅ Full CRUD (Create, Read, Update, Delete)
  • ✅ SQLite database (zero configuration)
  • ✅ Parameterized queries (SQL injection prevention)
  • ✅ CORS support
  • ✅ JSON input/output
  • ✅ Error handling with HTTP status codes