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...
Running SQL on CSV Data: Data Conversion and Extraction
A lot of tools output data as comma-separated values (CSV). It is a simple but common tabular data format of plaintext that can easily be processed. Each line of the file represents a single record. A record consists of the same number of fields, or columns. Usually, the delimiter between...
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...
Bookshelf.js: A Node.js ORM
One of the most common resources you'll interact with in a language like Node.js (primarily a web-focused language) are databases. And with SQL being the most common of all the different types, you'll need a good library to help you interact with it and its many features. Bookshelf.js...