bx-sqlite

|:------------------------------------------------------:|
| ⚡︎ B o x L a n g ⚡︎
| Dynamic : Modular : Productive
|:------------------------------------------------------:|

Copyright Since 2023 by Ortus Solutions, Corp
www.boxlang.io | www.ortussolutions.com

 

This module provides a BoxLang JDBC driver for SQLite.

Examples

See BoxLang's Defining Datasources documentation for full examples on where and how to construct a datasource connection pool.

Here's a few examples of some SQLite datasources:

Connecting to an In-Memory Database

You can specify an in-memory database using this connection string: jdbc:sqlite:memory:{MyDBName};create=true where {MyDBName} is replaced with your database name of choice:

this.datasources[ "testDB" ] = {
	"driver"  : "sqlite",
	"protocol": "memory",
	"database": "testDB"
};

Connecting to a Database Directory On Disk

You can also work with an on-disk database:

this.datasources[ "AutoDB" ] = {
	"driver"  : "sqlite",
	"protocol": "directory",
	"database": "/home/michael/myApp/resources/AutoDB"
};

Ortus Sponsors

BoxLang is a professional open-source project and it is completely funded by the community and Ortus Solutions, Corp. Ortus Patreons get many benefits like a cfcasts account, a FORGEBOX Pro account and so much more. If you are interested in becoming a sponsor, please visit our patronage page: https://patreon.com/ortussolutions

THE DAILY BREAD

"I am the way, and the truth, and the life; no one comes to the Father, but by me (JESUS)" Jn 14:1-12