Need help with franchise?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

HVF
3.8K Stars 263 Forks MIT License 82 Commits 53 Opened issues

Description

🍟 a notebook sql client. what you get when have a lot of sequels.

Services available

!
?

Need anything else?

Contributors list

Franchise

a sql notebook

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

Franchise is pretty cool

  • 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

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:

  1. If you don't have

    npm
    or
    yarn
    , install
    yarn.

  2. Open up a terminal and run

    git clone --depth 1 https://github.com/HVF/franchise.git
    
  3. cd into the project directory

    bash
    cd franchise
    
  4. Install the project dependencies

    bash
    yarn install
    

    (you can also run

    npm install
    )
  5. Start the dev server

    bash
    yarn start
    

    (you can also run

    npm start
    )
  6. Open up a browser and go to

    http://localhost:3000
  7. Edit some files in

    franchise/src
    .

    When you save your edits, and the browser will automatically reload.

  8. (optional) Add a bunch of great functionality and send a PR!


Running in Docker 🐳

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

Using Docker Hub image

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

Build your own image

  1. Build a docker image:
docker build -t franchise .
  1. Run a container with image:
docker run \
    --name franchise \
    -p 3000:80 \
    -p 14645:14645 \
    -d franchise

Build electron app

Linux:

yarn build:electron:linux

macOS:

yarn build:electron:mac

Windows:

yarn build:electron:windows

After build check out

dist
folder.

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.