Judging from a quick glance, this particular library (Isso) does not seem to be the case of "many client programs sending SQL to the same database over a network". There is only one server as a "client" program, sending SQL directly to the database, not over a network. If so, I'd tend to agree that SQLite is suitable for its purpose.