PythonのO/RマッパーでSQLを操作できるSQLAlchemyを紹介します。他のPythonライブラリとの連動もしやすいため非常に便利なライブラリです。 O/Rマッパーのメリット／デメリットの記事を参考に貼っておきます。 なおサンプルデータは下記を使用していきます。

# Create a session instance with a session ID. # This example uses an in-memory SQLite database. # The `create_tables=True` flag is useful for development and testing.

As a software developer, I’ve recently started diving into the world python. Specifically, I’ve been exploring SQLAlchemy and SQLite3, two powerful tools for managing databases in Python. In this ...

Python で DB を扱うとき、こんな書き方をしていませんか？ sql = "SELECT * FROM users WHERE id = %s" % user_id といった問題を抱えてい ...

SQLite is a self-contained, serverless SQL database engine. It is lightweight and easy to set up, making it ideal for small applications, testing, and development. SQLite stores data in a single file ...

Esse repositório tem por objetivo guardar um exemplo de API Rest com Flask, SQLAlchemy e outros detalhes, como organização de código, melhor desenho e divisão de responsabilidades. O objetivo deste ...