Create high-performance APIs with GraphQL and Postgres

Create PostgreSQL sql code quickly and in a streamlined, versioned workflow.

launchql is a wrapper around sqitch to enable a sane workflow for sane database management.

• write and deploy extensions that can be installed with CREATE EXTENSION
• optionally deploy same source as sqitch modules (since some managed db providers don't allow custom extensions)
• write/deploy a project full of many sqitch modules that cross-reference each other using dependency resolution for running deploy command in proper order, etc
• pulling modules down (currently via npm) to make re-usability super easy

Install psql without actually running the database. On mac you can use

brew install libpq

Or you can install the full-blown postgres locally, but it is recommended that you shut the service down. You'll be using psql to connect to the postgres that runs inside of a docker container.

https://sqitch.org/

mac users can use brew

brew install sqitch --with-postgres-support --without-postgresql

or for brew sqitch docs: https://github.com/sqitchers/homebrew-sqitch

sudo cpan Template

npm install -g @launchql/cli

https://github.com/pyramation/pg-utils

Initialize a project

lql init --bare
lql install

Now you should have a packages/ folder

cd packages/
mkdir myfirstmodule
cd myfirstmodule/
lql init

Now you can create some sql using sqitch!

lql generate schema
lql generate table

Deploy recursively, using all the required modules!

lql deploy --createdb --recursive

To create a test, first cd into a sqitch module

cd packages/myfirstmodule
lql maketest

Then you can use jest via yarn to test your logic.

yarn test:watch

• interactive shell
• naming conventions
• utility functions to create verify/revert functions for most types
• bundled with templates for most common things:

column
extension
fixture
foreignKey
fullPolicy
grantAllTables
grantExecute
grantRole
grantSchema
grantTable
index
policy
procedure
role
rowLevelSecurity
schema
table
timestamps
trigger
type
uniqueIndex
utility
view

You can install an npm module and then bundle it for plv8

yarn add my-awesome-npm-module
lql bundle my-awesome-npm-module awesomeThing

lql install skitch-extension-verify
lql install skitch-extension-jobs