database Archives

Prisma

Prisma vs. TypeORM – Which is Right For You?

In my current project, we use two popular ORMs, TypeORM and Prisma. Each one has advantages and disadvantages. But which is right for you?

PostgreSQL

Improve Your Dev Experience with Dockerized Postgres

Working on a project with a local development environment and a Postgres database? Running Postgres in Docker can make life easier.

Detecting Errors in Entity Framework Code First Migrations

Add a 'validate migrations' step to your test pipeline to detect and prevent subtle errors in EF Code First migrations.

Prisma

2 Quick and Easy Ways to Set the Environment Database in Prisma

Here are two quick and easy ways to set the environment database in Prisma, methods that don't require writing scripts for dotenv.

Developer Tools

How to Create UML Database Diagrams in Visual Studio Code

In VS Code, I used plantUML to describe a database schema. I defined the schema in text, and then the tool generated database diagrams.

Developer Tools

Speed Up Your Database Dump and Restore Using EC2 On-Demand

A database dump can be tedious, and I asked myself, "Where can I get better hardware for cheap?" Enter: AWS EC2 On-Demand.

AWS

AWS Remote Database Management Without SSH

When it comes to AWS remote database management, if you can't install the agent directly on the private host, you can set up a bastion running the agent.

Personal Optimization

Your Brain is a Cache, Not a Database

I used to be anxious about my memory, but reframing my brain as a cache helped me worry less. If you’ve got memory anxiety, maybe this can help you too.

Exploratory Testing

Exploratory Testing: Take a Walk with the Data

Taking a tour of the data as it moves through the system can be useful and can highlight other areas that might be worth an exploratory testing tour.

Web Apps

Adding End to End Cypress to a Web Project Part 3: Getting Set Up with Cypress & Seeding the Database Between Tests

This post will cover the basics of getting Cypress installed and ready to go, writing a placeholder test, and resetting the test database between tests.

Platforms & Languages

FaunaDB: A Consultant’s Profile

FaunaDB was a great fit for our scrappy, fast-turnover, greenfield project. This post breaks down the developer-facing features we loved, and a few cons.

Development

Versioned Records – Part 1: Storing Variable Attributes in a Version Table

Records may have variable attributes that change over time. To find which variable attributes are effective for a given date, we maintain a few invariants.