Skip to content

Latest commit

 

History

History
45 lines (28 loc) · 1.15 KB

README.md

File metadata and controls

45 lines (28 loc) · 1.15 KB
Raw

SQL Manager

This project is an experiment in adding an API of sorts over your SQL.

  • A CLI to retrieve your SQL from the server by table / env
  • Group you SQL by project

SQL Manager also has some helper features for generating SQL

  • Leverage Golang Templates in SQL
  • Reference other SQL scripts from a given script

SQL Manager also has a migration manager, but provides some extra features I've not seen, namely:

  • Access metadata on migrations which have been run on specific tables in you SQL scripts
  • Full control of what migrations should be run from the CLI - you can add and rollback migrations as needed

These two things allow a data analyst or scientist to almost think of migrations as feature flags which can be switched on and off depending on a given environment.

What is this comparable to?

dbt - use dbt in prod. It's much better than this project.

Running the server

Step 1 - clone auth-manager

This is used by the server for permissioning

Step 2 - run the auth-manager server

cd ~/auth-manager
make ENV=dev run-server

Step 3 - run the server

cd ~/sql-manager
make ENV=dev run-server

Tutorial

See docs/