![\"PostgreSQL](\"https:\/\/mberlove.com\/blog\/wp-content\/uploads\/2016\/05\/postgresql-logo.png\"){kind=logo}
<\/p>\n<\/p>\n
The PostgreSQL variant of SQL is pretty popular these days, and its adopters are quick to point out a number of advantages<\/a>. Like any system, though, it does take some getting used to, perhaps more so than other, more popular systems like MySQL.<\/p>\n Choosing between the two for a project can have a lot of competing factors<\/a>, but if you’re developing with NodeJS, you’ll often end up using the Sequelize package<\/a>, which by default uses postgres (though it can handle other dialects, too).<\/p>\n If you’ve chosen postgres, but have never used it before, you’ll need to learn to install it. On CentOS, this process is fairly straightforward, but rather picky — as I discovered to my frustration, there are a lot of ways to do it incorrectly. I finally settled on this guide<\/a>, which worked for me.<\/p>\n If you’re coming from another version of SQL, setting up new users, databases, etc, can be a somewhat foreign process. Following these general instructions<\/a> should serve to get you on the right path.<\/p>\n Once you’ve gotten your database up and running, Sequelize, should you choose to employ it, is not too difficult to get initialized<\/a> (don’t forget to npm install<\/em> it first)!<\/p>\n One common problem that I also ran across is authentication failure, so in most cases you’ll need to set up the connection configuration file<\/a>.<\/p>\nPostgreSQL<\/h1>\n
Sequelize<\/h1>\n