Using PostgreSQL with Node.js and node-postgres
Using SQLAlchemy with Flask and PostgreSQL
Databases are a crucial part of modern applications since they store the data used to power them. Generally, we use the Structured Query Language (SQL) to perform queries on the database and manipulate the data inside of it. Though initially done via dedicated SQL tools, we've quickly moved to using...
Adding a PostgreSQL Database to a Node.js App on Heroku
Heroku is a hosting service that supports Node.js applications. It is easy to use and its functionality can be extended with add-ons. There are add-ons for various things, including messaging/queues, logging, metrics, and of course, data stores. The data store add-ons support popular databases, like PostgreSQL, Redis, and...
Working with PostgreSQL in Java
PostgreSQL (which goes by the moniker Postgres) is famous for its object-relational nature. In contrast, other database systems are usually relational. Due to its nature, it's a great pairing with Java, which is heavily object-oriented. Accessing a Postgres database using Java requires you to rely on the JDBC API, as...
Working with PostgreSQL in Python
PostgreSQL is one of the most advanced and widely used relational database management systems. It's extremely popular for many reasons, a few of which include it being open source, its extensibility, and its ability to handle many different types of applications and varying loads. With Python, you can easily establish...
Backing up and Restoring PostgreSQL Databases
Making regular database backups is an essential maintenance task and fail point recovery strategy for anyone who is responsible for a database. A common misnomer for software developers is that there will be a database administrator who will take care of these things for us. Unfortunately, in my experience this...