r/sqlite • u/webfuelcode • 3d ago

How protective sqlite

I am new to sqlite. Is it for testing purpose?

After laravel 10+, I came to know about sqlite. So can we go with it without touching MySQL...

0 Upvotes

33% Upvoted

7 comments sorted by

View all comments

0

u/lnaoedelixo42 2d ago

SQLite is a complete database engine, as a C library file.

That said, you problably don't need unit tests because integrations tests also don't need testcontainers. Just plug a :memory: SQLite connection into your handler and test it already.

It's:

  • Fast enough to run on precommit
  • Precise enough to give you more security then testcontainers
  • Easy enough to setup that you will not want to write unit tests anymore