SQLite/C# Connection Pooling and Prepared Statement Confusion

It helps to remember that both connection pooling and prepared (compiled) statements are just tools that have their limits and no approach can be equally suitable to all possible situations. With this in mind, let’s remember when one might want to use connection pooling and prepared statements. Possible Reasons to Use Connection Pooling Connection pooling …

Read more

Where to download sqlitejdbc? [closed]

Original Post: They’ve since moved from Google Code to BitBucket. Here’s the BitBucket Repo: https://bitbucket.org/xerial/sqlite-jdbc Update 8-13-2015: Now they’re off to GitHub: https://github.com/xerial/sqlite-jdbc I’ve left the bitbucket link because there is a wealth of project information there, even though the code has moved to git hub.

SQLite vs HSQLDB

SQLite is implemented in C, HSQL is implemented in Java. It should be more seamless and easy to integrate SQLite with an application project written in C or C++, whereas I would expect the HSQL technology is easier to integrate with a project written in Java. No doubt there are numerous other more subtle differences …

Read more