Making a Password Manager, Should I Use MySQL or SQLite 3?

• litestream

  165 9,964 7.5 Go

  Streaming replication for SQLite.

Source for "SQLite 3 ...may not be as reliable"? It's pretty dang reliable and has effectively no size limit (~281 Terabytes max database size). Services like LiteStream (https://litestream.io) also allow you to replicate SQLite. Unless OP specifically wants MySQL experience they'll likely be able to build an MVP more quickly with SQLite and could scale easily. Of course, as a resume project, MySQL might be better but I don't think it's necessarily technically better for a small project like this.

• DiskCache

  6 2,157 4.5 Python

  Python disk-backed cache (Django-compatible). Faster than Redis and Memcached. Pure-Python.

Based on your question about SQLite, it seems like you want to store the database inside of the program as opposed to on the internet. Furthermore, your data doesn't seem to be super relational to my knowledge. You might be better off using something like diskcache to store the data instead.

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

Suggest a related project