Managing user accounts can be tricky, especially when you allow users to login using different social platforms (i.e. Twitter, Google, GitHub). In this article we will take a look at how you manage the various ways a user might authenticate with an application that allows for additional social …

If you’re using Postgres and need to make an update to a row OR create a new row if one doesn’t exist, new versions of PostgreSQL make this a lot easier. In other databases this concept is usually referred to as upsert which is short for update / insert. Let’s see a full example, …

From the Command Line: Connecting to a Postgres server psql -h < host > -U < username > Connect to Database (Once connected to server) \c < database name > Read File into Database psql -h < host > -U < username > -f < filename > Listing Commands List Databases \l …