The program I have been working on was originally written for Windows environment and it used BDE engine and Paradox table to display db data on a form. So, I was migrating it to run on Linux environment as a native program. SQLite almost seamlessly integrated into my project with few changes to my code, which was written for BDE engine. This was one of the main reason why I chose SQLite over others - being able to reuse 80% of my code with few changes.
I did try the others like Sqldb/Sqldblaz and found that they either required that I totally change my table structure and/or column datatype especially when it came to date and time. Needless to say, they gave me issues and problems, which I couldn't even workaround. However, I got SQLite to work for me, even though it took sometimes.