Franchise

a sql notebook

Franchise is a lightweight but powerful SQL tool with a notebook interface. You can use it online at franchise.cloud.

There's no sign up and no install
- For editing CSVs, JSON, XLSX files, we've integrated js-xlsx, and sql.js so you can query data entirely locally in your browser
- For connecting to PostgreSQL, MySQL, or BigQuery, just run a single command in your terminal to open a bridge that allows Franchise to directly connect to your database. Your data never touches a third party server.
Chart with a single click
Compare queries side by side
- With our unique notebook layout engine, you can drag and drop cells on the same line to compare views.

Running Locally (Development Mode)

There's an online version of franchise right here. There are also instructions for building franchise to static files here.

Otherwise, here's how to run franchise in development mode:

Open up a terminal and run

git clone --depth 1 https://github.com/HVF/franchise.git

cd into the project directory
```
cd franchise
```
Install the project dependencies
```
yarn install
```
(you can also run npm install)
Start the dev server
```
yarn start
```
(you can also run npm start)
Open up a browser and go to http://localhost:3000
Edit some files in franchise/src.

When you save your edits, and the browser will automatically reload.
(optional) Add a bunch of great functionality and send a PR!

Application will be available here: http://localhost:3000

docker run \
    --name franchise \
    -p 3000:80 \
    -p 14645:14645 \
    -d binakot/franchise

docker build -t franchise .

docker run \
    --name franchise \
    -p 3000:80 \
    -p 14645:14645 \
    -d franchise

Linux:

yarn build:electron:linux

macOS:

yarn build:electron:mac

Windows:

yarn build:electron:windows

After build check out dist folder.