database Archives

Extracurricular Activities

Using SQL and Your Chat.db File to Look Through All of Your iMessages

If you use iMessage, you can access and query the database where all of the messages are stored. All you need is a Mac and some basic SQL skills to begin!

Development Practices

Learn More About the Code Without Looking at Code, Part 1: Where to Look

Have you ever been tasked with modifying code you're not familiar with? Or integrating new features into an existing codebase?

Bridge the Gap: Applying Design Concepts to Database Design

I'll explore how coupling database design with design principles can result in databases with high performance.

Development Practices

The Discriminated Union: Writing Easy-to-Use Types in TypeScript

I’d encourage you to give discriminated unions a shot next time you find yourself needing to model subtypes.

Prisma

Translate a Graph Database Schema to a Prisma Schema

On a recent project, we chose to migrate data from an existing Amazon Neptune graph database to an Amazon RDS PostgreSQL relational database.

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.