Yeah, someone was telling me they need big data for a million rows. I laughed and said SQLite handles that...
SQLite does all of that and more with every release (https://sqlite.org/testing.html). There's a reason I consider their test coverage impressive...