SQL-TNT

Template(SQL + Typescript + Node) = an explosion of creativity.

MSSQL is not just for compiled code!

DB Template

Current template provided requires Docker running 4gb of ram.

Setup SQL DB

Note - this template uses .env to simulate environment variables at runtime. Warning - You should update the docker file with a strong password for sa. Warning - .sh files must be in unix format. Set your eol setting in vsc to /n or check docker logs is tnt db not created.

1. run npm run docker:build
2. run npm run docker:sql

Running the Code

1. Run DOCKER image as container from above.
2. npm install
3. npm run watch
4. run the VSC debugger or npm start

Optional

1. Launch SSMS, or RazorSQL
2. Enter in localhost,1433
3. Select sql login and use the credentials in the dockerfile.