Fossil: A Coherent Software Configuration Management System (self hosted git & GitHub alternative)

Yes, SQLite is the most well known and likely biggest project using it.

I have used it for smaller projects and found it quite refreshing and useable