actually, liteSQL really isn't an embedded database in itself, rather it is mainly an object persistence framework based on relational databases, that is you can use various different relational databases as backends and basically use them as if they were object oriented databases.

Of course you CAN use an embedded database such as SQLite together with liteSQL, however ultimately liteSQL adds of course some overhead to your code and to the overall project due to the templating stuff and OODBMS/RDBMS mapping. So, while it is indeed very powerful and intuitive to use, if you're looking for using embedded databases, liteSQL probably isn't all that interesting. If however, you have a programming/database problem that lends itself to be accomplished in an OO fashion, but cannot afford the requirement for a a fully object oriented database (engine) (such as db4o), then using liteSQL is indeed an excellent option as it is highly interoperable (support for various backends, easy to add new backends) and extremely easy to get started, also the license is very liberal.