aldrichvalentino / node-postgres Goto Github PK

This project is way too old for 2021. The purpose of this project is to make a batteries-included web project template, consisting of frontend and backend with docker. With all the interesting updates from node, react, and express, this project will be updated as follows:

1. React: use the latest version of react with webpack and typescript. There should be little to no libraries installed other than the core react-related libraries, as this is not a react boilerplate project.
2. Node: update to the latest lts version with the latest expressjs version as well.
3. Docker: upgrade all images for starter. Then, we should split the app side into two separate containers. As far as developing with docker goes, we know that hot reloading with libraries such as nodemon and webpack-dev-server does not work in some platform (Windows machine in particular). So, I am planning to use 2 docker-compose.yml files, 1 for development and 1 for production.

• Dev: only spawn the database and database admin. Frontend and backend application development should be done outside of docker (e.g.: frontend in port 8000 and backend in port 3000 running in 2 terminals). This way, hot reloading will work normally.
• Prod: build all the images that is necessary for production and use an nginx to load balance the frontend application and hide the backend application from the public network.

4. ORM: Drop sequalizejs ORM and change to knex. Over the years, I had a somewhat back-and-forth and ongoing pain while developing with ORMs. Some queries are easy, others are hard, complex queries are impossible. Having said that, a lot of developers out there swear by knex in order to have the flexibility but also the abstraction to write complex yet elegant queries.
5. CI and tests: TBD, but I will particularly test the part of spawning the dev and prod environments.

PR's and maintainers are always welcome.