#Sqlite client install
#Sqlite client driver
#Sqlite client android
#Sqlite client code

$ npm install sqlite3 -save Install sqlite Most people who use this library will use sqlite3Īny library that conforms to the sqlite3 ( API) Use generics to get better typings on your rows.

#Sqlite client driver

Specify typings for a specific database driver.Note v4 of sqlite has breaking changes compared to v3! Please see CHANGELOG.md for more details. Removes hard to debug cross platform issues.A wrapper library written in Typescript with ZERO dependencies that adds ES6 promisesĪnd SQL-based migrations API to sqlite3 ( docs).Allows writing a single application that runs on many platforms with identical results.

Provides a clear high level API that is quick to install, understand and use.

Enables using SQL for application state.

The SMPI JS Client has a clear transaction based API. SMPI enforces a single runtime mode (WAL) so the meaning of locks and transactions never changes.

The SMPI Binary is written in Rust and cross compiled for each platform, which means behavior and state transitions are identical on every platform.

SMPI bundles SQLite into the binary and does not try to use the system SQLite.

The same SQLite version and extensions on all platforms.

#Sqlite client code

This is especially true when the SQLite operations are being made from JS with async function calls, and differing native code for each platform may order/process the operations differently.Įxpo has transaction in their SQLite API, but never actually starts a transaction leaving your application state possibly incorrect as read/writes are not isolated and/or atomic.Ī.This means effort must be spent to ensure both programs behave the same, and is a possible source of hard to understand bugs.īecause SQLite has many runtime modes which change the meaning of locks and transactions, it can get complicated to understand the behavior of your app.

#Sqlite client android

Android and iOS both implement the same state machine with two different code bases.

Two or more implementations of one program.

SQL language features and extensions may be missing from some platforms, resulting in your app not working.ī.

Different SQLite versions and extensions. Issues with current React Native SQLite libraries:Ī. There is no TCP/IP or Unix socket communication in the SMPI Binary, but you could use networking libraries in your Host process to route SMPI messages over the network for some custom use case. The Host process that embeds the SMPI FFI is the parent of this background thread, they communicate over the FFI. Instead of sending all requests for all users of an application to a single central remote database, each user has their own local database.Īlso the SMPI runtime is a single background thread, not a standalone process. Yes in the sense that is passes messages, there is a client and a server.īut No in the sense that SMPI is designed to be used in the same context as SQLite (but in a single local application that uses many OS processes/threads).Į.g. Only Javascript is supported as a Client currently. The Client is the code API used in the application that uses SQLite. The IOP generally does not parse the JSON messages, it only passes strings between the Binary and the Client.Ĭurrent IOPs include React Native and Node.js. IOPs implement specific code for these general abilities, and encapsulates them so that the Client only has to expect a const outputMsg = await send(inputMsg) interface. IO Providers pass messages between the Binary and Client.ĭifferent platforms, run times and languages will require different implementations of IOPs.Įach environment has the general ability to:

JSON is used to represent messages, and allows data to be passed between processes. This converts the standard SQLite C FFI into a an IO stream - where events can flow in both directions. Takes a C pointer to a callback function, that is called with a JSON string as an argument representing output.The Binary essentially wraps the standard SQLite FFI functions, and exports a FFI with the functions: SMPI consists of 3 components that work together: It allows you to use SQLite in cases when the client is not the same process that embeds the SQLite FFI. SMPI stands for SQLite Message Passing Interface. SMPI is a React Native library that allows you to use SQLite from your Javascript code with identical behavior across platforms. Note: binaries are built and bundled with IOPs.