SQLite is really a toy database... you can link with your app and use as you wish!
But if we compare alternatives... it's a huge mess. Borland comes with IDAPI/BDE and now dbExpress. Microsoft comes with - Jet, DAO, ADO, OLEDB, ODBC, LINQ, etc.
That's why this toy database outrun them. Because it's simply and multiplatform.