Skip to content

edugarrick/sqlitesoul

Β 
Β 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

A SQLite REST and Realtime server

justforfunnoreally.dev badge All Contributors

Installation

Install Soul CLI with npm

  npm install -g soul-cli

Usage

Soul is command line tool, after installing it, Run soul -d sqlite.db -p 8000 and it'll start a REST API on http://localhost:8000 and a Websocket server on ws://localhost:8000.

Usage: soul [options]


Options:
      --version             Show version number                        [boolean]
  -d, --database            SQLite database file or :memory: [string] [required]
  -p, --port                Port to listen on                           [number]
  -r, --rate-limit-enabled  Enable rate limiting                       [boolean]
  -c, --cors                CORS whitelist origins                [string]
  -S, --studio              Start Soul Studio in parallel              [boolean]
      --help                Show help                                  [boolean]

Then to test Soul is working run the following command

curl http://localhost:8000/api/tables

It should return a list of the tables inside sqlite.db database.

Documentation

API documentation is available while the project is running at http://localhost:8000/api/docs

There's also a list of all endpoints examples at docs/api-examples.md

For websocket examples, check docs/ws-examples.md

Extending Soul

Soul is able to be extended (e.g. Adding custom APIs) via extensions, you can find a list of extensions at docs/extensions-examples.md

Soul Studio

Soul Studio provides a GUI to work with your database.

Right now Soul Studio is in early stages of development and not useful to work with.

Development

git clone https://github.com/thevahidal/soul # Clone project

Core API

cd core # Move into the core directory

cp .env.sample .env # Duplicate sample environment variables
nano .env # Update the environment variables

npm install # Install dependencies
npm run dev # Start the dev server

Studio

Make sure that Soul Core API is up and running and then

cd studio # Move into the studio directory

cp .env.sample .env # Duplicate sample environment variables
nano .env # Update the environment variables

npm install # Install dependencies
npm run dev # Start the dev server

Community

Join the discussion in our Discord server and help making Soul together.

License

MIT

trackgit-views

Contributing

Contributions are always welcome!

See CONTRIBUTING.md for ways to get started and please adhere to CODE OF CONDUCT.

Contributors ✨

Thanks goes to these wonderful people (emoji key):

Vahid Al
Vahid Al

πŸ’»
Abenezer Melkamu
Abenezer Melkamu

πŸ’»
Ian Mayo
Ian Mayo

πŸ’»
Hanz
Hanz

πŸ’»
Koen De Groote
Koen De Groote

πŸ’»

This project follows the all-contributors specification.

About

πŸ•‰ A SQLite REST and realtime server

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • JavaScript 86.6%
  • Svelte 12.4%
  • Other 1.0%