Simple API
Simple REST API with database (postgres) integration
HighLevel Agenda
- Integrating with postgres (few concepts)
- Live code walkthrough
Detailed
Check screencast video for more explanation which covers
- Context on base http ping code
- DB config
- DB connections / connection pool
- Migrations
- creating basic one
- running it along with deployment
- Query
- Transaction
- Using context
Gotchas
- connpool != threads
- 5-30 would suffice for 10k/s transactions responding in few ms
- ssl/md5 auth for connecting with DB
- never overwrite/edit older migration
- rollback should be tested
- migrate installation
- ensure env var sourcing is local to command
- Use transaction when you've more than one modification
Dependencies
Running
- create env file
.envwith following config and modify as necessary
export HOST="localhost"
export PORT=8080
export DB_HOST="localhost"
export DB_USER="postgres"
export DB_PASSWORD=""
export DB_NAME="simple_api"
export DB_SSL_MODE="disable"
export DB_PORT="5432"
- Ensure you've postgres up and running and run the following to setup the DB
make db.create db.migrate
- Run the service by running the following command
source local.env && make run
Disclaimer
This code was drafted quickly for a meetup session, and this is not production ready. You could use this as a base but still need to improvise.