Language Extensions

Summary

This has been a brief survey of several different language extensions and how they work with SQLite. While using SQLite with the C API is quite straightforward, using SQLite in language extensions is considerably easier. Many of the concepts are very similar. As you can see, there are many things in common even in cases where an extension conforms to a language-specific database API. All queries ultimately involve a connection object of some kind, which maps to an internal sqlite3 structure, and a statement or cursor object, which internally maps to a sqlite3_stmt structure.

These extensions, developed by the open source community, make using SQLite convenient and easy, making it accessible to many more applications ranging from system administration to website development. There are plenty more extensions for these and more languages with which to use SQLite. As mentioned earlier, you need only to look on the SQLite Wiki to find them: www.sqlite.org/cvstrac/wiki?p=SqliteWrappers.