Blog
  • devcrisis
  • 🔮Software atoms
    • Validating code Architecture with dependency cruiser
    • Actionable ways to use ChatGPT
    • Most courses aren't worth it
    • SQLite is❤️
    • Stabilizing Tests without fixing them
    • Interviews should copy Advent of Code
    • Rust is nice
    • Agile fatigue is rising
    • Documentation is needed after all
    • The Direction of the JS ecosystem is good
    • Zero configuration == <3
    • Make small pull requests
    • Good practices fade out
    • Rushing !== unmaintainable
    • Commit message readability
    • Universal Practices
    • More functions == good
    • Mocking Private Functionality
    • Lines of code != feature count
    • Different Software - Different Quality
    • junior2mid
    • Book alternatives
    • Courses
    • Type Driven Development
    • Latest and Greatest
    • Real Developers
    • 10x Developer
    • Books for beginners 1
    • Parkinson's Law
    • nest-cli architecture is nice
    • Incremental Feature Delivery
    • Self Healing Software
      • Typed Configuration
  • 💡Memos
    • 2022 Holiday code report
    • Complexity
    • Software Development Fundamentals
  • 🧱foundation
    • Junior2Mid
    • Books and resources for new developers
    • 🏔️Now
Powered by GitBook
On this page
  1. Software atoms

SQLite is❤️

PreviousMost courses aren't worth itNextStabilizing Tests without fixing them

Last updated 2 years ago

SQLite is an amazing solution and you can read some of it's.

You can also see some of it's popular users .

The point of this software atom is to point out that it is likely an amazing choice for nearly all your side projects. Don't be worried about scaling or replacing it.

Using adequate software development techniques and a good ORM will let you replace SQLite with Postgres or MySQL with ease.

Why is SQLite a great choice ?

  • It is just a library - you can have a single container deployment that includes your service and db. Less complexity, pipelines, monitoring and backups.

  • It's performance is great, especially since it is in the same machine and your pet projects won't have hundreds of gigabytes of data.

  • Testing is easier - seeding your database and creating new instances is trivial since sqlite is a single file per db. This can give you a lot of cheap, fast and reliable solutions.

🔮
use cases here
here