and SQLite C extensions. Support for the closure table [http://charlesleifer.com/blog/querying-tree-structures-in-sqlite-using- python-and-the-transitive-closure-extension/] extension, which allows efficient example, if you’ve compiled the closure table extension and wish to use it in your application, you might write: db = SqliteExtDatabase('my_app.db') db.load_extension('closure') unload_extension(name): transitive closure [http://www.sqlite.org/cgi/src/artifact/636024302cde41b2bf0c542f81c40c624cfb7012] table. Closure tables are VirtualModel subclasses that work with the transitive closure SQLite extension

level in transactions. • Support for virtual tables and SQLite C extensions. • Support for the closure table extension, which allows efficient querying of heirarchical tables. sqlite_ext API notes class example, if you’ve compiled the closure table extension and wish to use it in your application, you might write: db = SqliteExtDatabase('my_app.db') db.load_extension('closure') unload_extension(name): a model class suitable for working with a transitive closure table. Closure tables are VirtualModel subclasses that work with the transitive closure SQLite extension. These special tables are designed to

example, if you’ve compiled the closure table extension and wish to use it in your application, you might write: db = SqliteExtDatabase('my_app.db') db.load_extension('closure') transaction([lock_type=None]) sqlite_ext includes even more SQLite features, including: Full-text search JSON extension integration Closure table extension support LSM1 extension support User-defined table functions Support for online backups relation. Returns a VirtualModel for working with a closure table. Factory function for creating a model class suitable for working with a transitive closure [http://www.sqlite.org/cgi/src/artifact/636024

example, if you’ve compiled the closure table extension and wish to use it in your application, you might write: db = SqliteExtDatabase('my_app.db') db.load_extension('closure') attach(filename, name) filename sqlite_ext includes even more SQLite features, including: Full-text search JSON extension integration Closure table extension support LSM1 extension support User-defined table functions Support for online backups relation. Returns a VirtualModel for working with a closure table. Factory function for creating a model class suitable for working with a transitive closure [http://www.sqlite.org/cgi/src/artifact/636024

example, if you’ve compiled the closure table extension and wish to use it in your application, you might write: db = SqliteExtDatabase('my_app.db') db.load_extension('closure') attach(filename, name) filename sqlite_ext includes even more SQLite features, including: Full-text search JSON extension integration Closure table extension support LSM1 extension support User-defined table functions Support for online backups relation. Returns a VirtualModel for working with a closure table. Factory function for creating a model class suitable for working with a transitive closure [http://www.sqlite.org/cgi/src/artifact/636024

example, if you’ve compiled the closure table extension and wish to use it in your application, you might write: db = SqliteExtDatabase('my_app.db') db.load_extension('closure') transaction([lock_type=None]) sqlite_ext includes even more SQLite features, including: Full-text search JSON extension integration Closure table extension support LSM1 extension support User-defined table functions Support for online backups relation. Returns a VirtualModel for working with a closure table. Factory function for creating a model class suitable for working with a transitive closure [http://www.sqlite.org/cgi/src/artifact/636024

example, if you’ve compiled the closure table extension and wish to use it in your application, you might write: db = SqliteExtDatabase('my_app.db') db.load_extension('closure') attach(filename, name) Parameters includes even more SQLite features, including: • Full-text search • JSON extension integration • Closure table extension support • LSM1 extension support • User-defined table functions • Support for with a closure table. Factory function for creating a model class suitable for working with a transitive closure table. Closure tables are VirtualModel subclasses that work with the transitive closure SQLite

example, if you’ve compiled the closure table extension and wish to use it in your application, you might write: db = SqliteExtDatabase('my_app.db') db.load_extension('closure') transaction([lock_type=None]) includes even more SQLite features, including: • Full-text search • JSON extension integration • Closure table extension support • LSM1 extension support • User-defined table functions • Support for with a closure table. Factory function for creating a model class suitable for working with a transitive closure table. Closure tables are VirtualModel subclasses that work with the transitive closure SQLite

example, if you’ve compiled the closure table extension and wish to use it in your application, you might write: db = SqliteExtDatabase('my_app.db') db.load_extension('closure') attach(filename, name) Parameters includes even more SQLite features, including: • Full-text search • JSON extension integration • Closure table extension support • LSM1 extension support • User-defined table functions • Support for with a closure table. Factory function for creating a model class suitable for working with a transitive closure table. Closure tables are VirtualModel subclasses that work with the transitive closure SQLite

example, if you’ve compiled the closure table extension and wish to use it in your application, you might write: db = SqliteExtDatabase('my_app.db') db.load_extension('closure') attach(filename, name) filename sqlite_ext includes even more SQLite features, including: Full-text search JSON extension integration Closure table extension support LSM1 extension support User-defined table functions Support for online backups relation. Returns a VirtualModel for working with a closure table. Factory function for creating a model class suitable for working with a transitive closure [http://www.sqlite.org/cgi/src/artifact/636024