Info sqlite-remote-db (npm)

npm install sqlite-remote-db

or

npm install sqlite-remote-db --legacy-peer-deps

Makes sqlite3 tables and queries useable in react.

Get started

Setup

const ExecQuery = require('sqlite-remote-db');

const {ExecQuery, UrlQuery, ScriptQuery, SetupTable, TableShow} = require('sqlite-remote-db')

const dbserver = "http://localhost/jsonengine.php"; default server.

or

upload : jsonengine.php : chmod 777

const dbserver = "http://yourhost/yourfolder/jsonengine.php";

Create a table

var queryCreate = await ExecQuery("single", "CREATE TABLE Pages (ID INTEGER PRIMARY KEY, Title TEXT, Html TEXT)", "react","react", dbserver);

Insert element

var queryInsert = await ExecQuery("single", "INSERT INTO Pages (Title, Html) VALUES ('', '')", "react","react", dbserver);

Edit an element

var queryUpdate = await ExecQuery("single", "UPDATE Pages SET Title = 'aa' WHERE ID == 1", "react","react", dbserver);

var querySingle = await ExecQuery("single", "SELECT Title From Pages WHERE ID == 1", "react","react", dbserver);

var queryresp = await ExecQuery("", "SELECT * From Pages", "react","react", dbserver);

please use an async function running the queries

Examples

//ExecQuery("single/array/empty", "DBQuery", "username", "password", "optional server address")

async function runquerys() {
	var queryCreate = await ExecQuery("", "CREATE TABLE Pages (ID INTEGER PRIMARY KEY, Title TEXT, Html TEXT)", "react","react", dbserver);
	or 
	const jsonArrb = await SetupTable('Pages', 'Title TEXT, Html TEXT', 'react', 'react', dbserver); //ID INTEGER PRIMARY KEY not necessary.
	
	var queryInsert = await ExecQuery("single", "INSERT INTO Pages (Title, Html) VALUES ('', '')", "react","react");
	var querySelect = await ExecQuery("", "SELECT * From Pages", "react","react");
	alert(querySelect);
	
	const jsonArr = await ExecQuery("array", "SELECT * From Pages", "react","react");
	var tabledata = "";
	for (let id = 0; id < jsonArr.length; ++id) {
	for (let index = 0; index < jsonArr[0].length; ++index) {
		tabledata += jsonArr[id][index]['key'] + ": " + jsonArr[id][index]['value'] + "\n";
	}
	}
	alert(tabledata);
	
	
	//Other functions
	var urlupdate = await UrlQuery("single", "INSERT INTO Pages (Title, Html) VALUES ('', '')", "react","react", dbserver);
	var scriptupdate = await ScriptQuery("single", "INSERT INTO Pages (Title, Html) VALUES ('', '')", "react","react", dbserver);
	var tableoverview = await TableShow('Pages', 'react', 'react', dbserver) 
	}

Example other db server: const querySelect = await ExecQuery("array", "SELECT * From Pages", "react","react"); alert(querySelect[0][0]['key'] + querySelect[0][0]['value']);

var queryCreate = await ExecQuery("", "CREATE TABLE Pages (ID INTEGER PRIMARY KEY, Title TEXT, Html TEXT)", "react","react", dbserver); or const queryCreateTable = await SetupTable('Pages', 'Title TEXT, Html TEXT', 'react', 'react', dbserver); //ID INTEGER PRIMARY KEY not necessary.

var queryInsert = await ExecQuery("single", "INSERT INTO Pages (Title, Html) VALUES ('', '')", "react","react", dbserver);

var queryresp = await ExecQuery("", "SELECT * From Pages", "react","react", dbserver);

var querySingle = await ExecQuery("single", "SELECT Title From Pages WHERE ID == 1", "react","react", dbserver);

var queryresp = await ExecQuery("", "SELECT * From Pages", "react","react", "http://localhost/jsonengine.php");

var querydrop = await ExecQuery("", "DROP Table Pages", "react","react", "http://localhost/jsonengine.php");