In VS Code, I used plantUML to describe a database schema. I defined the schema in text, and then the tool generated database diagrams.
A database dump can be tedious, and I asked myself, "Where can I get better hardware for cheap?" Enter: AWS EC2 On-Demand.
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.
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.
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.
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.
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.
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.
It's a common architecture to have PostgreSQL and Redis serve as the backbone of your app, but PostgreSQL may be capable of everything you use Redis for.
Building WebSocket APIs to stream events in AWS is straightforward. I was able to utilize WebSockets to stream DynamoDB changes on one of my projects.
Here two ways to use functions in Postgres to improve the performance of your application — applying predicates and computing derivative values.
Database tables rarely stay the same over the course of a project. Here is a simple pattern for migrating data into non-nullable columns.