database

How to Build a Pokedex React App with a Slash GraphQL Backend

November 3, 2020

In this article, we’re going to walk through some of the basic setup for Slash GraphQL and then take a look at how I built a Pokémon Pokédex app with React and Slash GraphQL in just a few hours! Frontend developers want interacting with the backend of their web application to be as painless as possible. Requesting data from the database or making updates to records stored in the database should be simple so that frontend developers can focus on what they do best: creating beautiful and intuitive user interfaces.

Continue reading

Scaling Django/Postgres with PgBouncer on Heroku

June 9, 2020

Do you have an app on Heroku using Postgres? Are you running out of database connections? Maybe you’ve already tried setting CONN_MAX_AGE, but that only helped for a while. It’s time for PgBouncer, the de facto standard for Postgres connection pooling. In this article, we’ll look at how to use PgBouncer to scale your app on Heroku. We’ll use Django, a popular python web framework, as an example for the settings.

Continue reading

An Introduction to Graph Databases: The Power of Connected Data

May 21, 2020

In today’s economy, more and more companies exist primarily online. While there’s much discussion around the consequences of leaving behind the traditional brick and mortar business, one aspect that gets less attention is the significant change in how these companies are now managing their data. Increasingly, businesses seek to understand their customers and how best to meet their needs in a way that monthly reports and KPI charts just can’t address.

Continue reading

The Complete Tutorial on the Top 5 Ways to Query Your Relational Database in JavaScript - Part 2

April 29, 2020

Welcome back! In the first part of this series, we looked at a very “low-level” way to interact with a relational database by sending it raw SQL strings and retrieving the results. We created a very simple Express application that we can use as an example and deployed it on Heroku with a Postgres database.

Continue reading

The Complete Tutorial on the Top 5 Ways to Query your Relational Database in JavaScript - Part 1

April 28, 2020

If you’re developing web applications, you’re almost certainly going to be constantly interacting with a database. And when it comes time to select thewayyou’ll interact, the choices can be overwhelming. In this article, we’re going to look in detail at 5 different ways to interact with your database using JavaScript, and we’ll talk about the pros and cons of each. We’ll start with the lowest-level choice — SQL Commands — then move through to higher-level abstractions.

Continue reading

Fear database changes? Get them under control with CI/CD

December 17, 2019

Developers often fear database changes because a mistake by anyone on your team can lead to a major outage and even data loss. Let’s look at an example of how to include database migrations in your CI/CD process and push a non-backwards-compatible database change successfully.

Continue reading

Postgres Is Underrated—It Handles More than You Think

October 16, 2019

Thinking about adding another data store like Redis or Elasticsearch? Take a minute and think again. Postgres offers powerful features which are not obvious at first sight.

Continue reading