SQLite Database Server

A portable SQLite Server

sqlite-database-server-win.exe  = Windows x64 standalone executable
sqlite-database-server-linux    = Linux standalone executable
sqlite-database-server-macos    = MacOS standalone executable

Installation

First download the following files into the same folder/directory,

1. sqlite-database-server-win.exe = Windows x64 standalone executable
   sqlite-database-server-linux = Linux standalone executable
   sqlite-database-server-macos = MacOS standalone executable
2. data/server.db = empty database
   data/AMS.db = Apartment Management System database (nigrated from AccessDB)
   data/rms.db = Records Management System database
   data/sop.db = SOP Manager database
3. settings.json = defines the host name, IP port, database file listings

Start the standalone executable

> sqlite-database-server-{platform}

The response should be similar to,

> localhost server running on port 3000

Now, open your browser to

URL: http://localhost:3000/about

List all routes

To list all routes available, use

http://localhost:3000/

Settings.JSON

Edit the settingsjson to specify the accdb database file

{
    "count": 4,
    "file_0": "data/server.db",
    "file_1": "data/AMS.db",
    "file_2": "data/rms.db",
    "file_3": "data/sop.db",
    "host": "localhost",
    "port": 3000
}

IMPORTANT! Whenever SETTINGS.JSON file is changed, the SQLITE-DATABASE-SERVER MUST BE RESTARTED in order for the new settings to take effect.

Release Schedule

Whenever the code base is updated, a new standalone executable is created and replaced with the existing executable.

Version    Date         Changes
1.0.0   9/17/2020   Initial commit
1.0.2   3/17/2023   Remove settings.json dependency; added command line arguments
1.0.3   3/18/2023   Fixed node_module reference errors; fromDir error;
1.0.4   3/20/2023   Add upload route to add new sqlite database files to system directory of .sqliteserver/data

Version 1.0.2+

Place the data files in the /home/[user]/.sqliteserver/data, add command line arguments,

--host=host name|ip address
--port=port number

EOL or End-of-Life

When a piece of software is useful, there should never be an EOL doctrine. The intention for this application is to achieve immoratlity ;).

At some point of time in the future, this project may appear to be dead and abandon. The opposite will be true!

When this project reaches that stage, this project has matured to a level where maintenance is minimal (mostly updating to latest version of Node).

Patrick Ingle
Developer
September 17, 2020