For ExpressJS site change from sqlite db to Postgresql db with locking rows feature

Only apply for this project if you know ExpressJS (including [login to view URL](), express-session, ...), if are familiar with ExpressJS this project will be easy for you.


1. Switch from sqlite to Postgresql

2. Only in route /classify block articles when another user loaded that article already.

User names get assigned with variable user ([login to view URL]://localhost:3000/?user=user1).

Currently I used in /classify an sql query with "done != 1". Please change it so that user1 and user2 don't see the same article when they load the page at the same time. Hence, you need to block that article until that user submits OR after a timeout of 30 minutes. (Maybe one way to achieve that is psql FOR UPDATE and lock_timeout?)

How to start working on this project:

- Please use git (start the project with git init and send me the zip git repo at the end)

- npm install

- npm start

- The db stuff you will find in routes/[login to view URL]

Навыки: Node.js, PostgreSQL, Express JS

Показать больше: site change script layout, find site change photos, site change pictures, joomla site change colours, site change detection script, seo site change, can edit flash site change, dynamic site change web designer, google site change asp html, joomla site change click, site change color, alert site change android, site change, android alert site change, average fee to hire a blogger for your site, wordpress change font for entire site, change url for google site, wordpress change register for this site text

О работодателе:
( 3 отзыв(-а, -ов) ) Berlin, Germany

ID проекта: #28179182