Skip to content

Best Python packages for SQLite? #4

Description

@badlydrawnrob

Always ask: what is my purpose? My goals?
"To prototype web apps in the simplest way possible"

  1. By default SQLite does not use async (plugin required)
  2. Be careful when you use raw SQL (easy for malicious injection)
  3. Make sure an ORM is super easy to understand and implement (Peewee + FastApi is not)1

This is also an important consideration if you're considering migrating from Python to some other language. How easy is its language to understand?

Footnotes

  1. If the ORM is harder to understand than your average SQL statement, why would you even consider using it?! FastApi allows using any SQL database (or ORM) but now suggests to use SQLModel which is designed by the author of FastApi and extends SQLAlchemy.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions