Closed sojharo closed 7 years ago
@sojharo should we use Postgres as it would integrate with marketing website better?
yes, the more light-weight the better.
I am picking this today. Kindly, let me know should I go with Postgres? In this case we can go with as much light-weight database as we want.
Yes. Please go ahead
I have been working to install postgressql database on our droplet. However, I am successful to install it, but I am having some problems to connect to it using its client. It shows that database server is running but when I connect it gives the error that server is not running.
However, Mongodb database is working fine on the droplet. I am looking more into this issue as why postgresql is not connecting.
Please ask questions on digital ocean or some other forum. It is a very common install
I have successfully installed the server. After this, I went on to read some tutorials and documentations to understand how to create database and users with passwords. I also understood how to define roles and permissions.
After this, I found and studied library for nodejs which connects it to postgresql. Here are the links I went through:
http://mherman.org/blog/2015/02/12/postgresql-and-nodejs/#.WJx66RJ96Rs https://github.com/brianc/node-postgres https://www.postgresql.org/docs/9.4/static/tutorial-accessdb.html https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-14-04 https://www.digitalocean.com/community/tutorials/how-to-use-roles-and-manage-grant-permissions-in-postgresql-on-a-vps--2
Inshallah, tomorrow, I would write the code to connect our application to database. Also, I would create the database and tables.
Thanks Sojharo
I had completed the work on this and integrated the postgresql with our nodejs application.
As discussed in document, we would create and integrate mongodb database in our marketing website so that customer can register from there.