Library to use SQLite in Fuse.
Currently supports ios, android and dotnet (Fuse Preview).
Issues, feature requests and pull requests are welcome.
$ npm install fuse-sqlite
Using fusepm (legacy)
$ fusepm install https://github.com/fuse-open/fuse-sqlite
Check out the example app for a complete project using TypeScript.
<SQLiteux:Global="SQLite" />`importsqlitefrom"SQLite";constdb=sqlite.open("file.sqlite");db.execute("create table if not exists ids (id integer primary key)");db.execute("insert into ids values (?)",2);constr=db.query("select * from ids");console.log(JSON.stringify(r));It returns an array:
[{"field1": "value1","field2": "value2"},{"field1": "value1","field2": "value2"}]importsqlitefrom"SQLite";constsqlite=require('SQLite');Opens a file that contains a SQLite database
constdb=sqlite.open(filename);Opens a file that contains a SQLite database, possibly from the bundle
constdb=sqlite.openFromBundle(filename);And in the unoproj:
"Packages": [
"Fuse",
"FuseJS",
"SQLite"
],
"Includes": [
"*.ts",
"*.ux",
"bundle.sqlite:Bundle"
]Executes a query. Does not return anything.
db.execute(sql_statement);db.execute(sql_statement,var1,var2,var3);Executes a query. Returns an array of hashes with the result.
constresult=db.query(sql_statement);constresult=db.query(sql_statement,var1,var2,var3);Prepares a query. Returns a prepared statement.
conststatement=db.prepare(sql_statement);statement.execute(var1,var2,var3);Closes the database.
db.close();- Cursor support
- Async support
- Bundled pre-made databases
- Error messages is a bit different between the targets
- The sqlite3.dll is downloaded from http://www.sqlite.org/download.html
- Mono.Data.Sqlite.dll is included from Mono.
Failed to load assembly . . . have caused the assembly to be sandboxed . . .You need to Unblock dll's that you downloaded.