Atomic Object Show Nav
Close Menu
< Blog Home
Atomic Object
  • AI Software Development
  • New Product Development
  • Product Enhancement
  • Product Modernization
  • Web App
  • Mobile App
  • IoT Software
  • Desktop App
  • Cloud
  • Agriculture
  • Automotive
  • Education
  • Entertainment
  • Financial Services
  • Government
  • Healthcare
  • Insurance
  • Logistics
  • Manufacturing
  • Retail
  • Utilities
Portfolio
Team
Culture
Contact
We're Hiring
Atomic Object Atomic Object
Services
  • Offerings
  • AI Software Development
  • New Product Development
  • Product Enhancement
  • Product Modernization
  • Platforms
  • Web App
  • Mobile App
  • IoT Software
  • Desktop App
  • Cloud
  • Industries
  • Agriculture
  • Automotive
  • Education
  • Entertainment
  • Financial Services
  • Government
  • Healthcare
  • Insurance
  • Logistics
  • Manufacturing
  • Retail
  • Utilities
Portfolio
Team
Culture
We're Hiring
Blog
Contact
Atomic Object
Services
Portfolio
Team
Culture
We're Hiring
Blog
Contact
← Back to Blog Home

database

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.
Web Apps

Do You Really Need Redis? How to Get Away with Just PostgreSQL

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.
DevOps & System Admin.

Using WebSockets in AWS to Stream DynamoDB Updates

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.
Platforms & Languages

Improve Performance Using SQL Functions in Postgres

Here two ways to use functions in Postgres to improve the performance of your application — applying predicates and computing derivative values.
DevOps & System Admin.

A Simple Approach to Complicated Database Defaults

Database tables rarely stay the same over the course of a project. Here is a simple pattern for migrating data into non-nullable columns.
TypeScript

Helper Functions for Testing a PostgreSQL Database

Writing tests for a node.js server? You should test the database too. Here are a few helper functions for testing a postgres database, using knex.

Posts navigation

← Older posts
Newer posts →

Want to see what Atomic can do?

Check out some of our work

Atomic's Portfolio

Atomic is a software design + development consultancy.

© 2025 Atomic Object LLC
Explore
  • Careers
  • Diversity
  • Resources
  • Atomic Blog
  • Developer Resources
  • Client Resources
Offices
  • Grand Rapids
  • Ann Arbor
  • Chicago
  • Raleigh-Durham
Details
  • Contact
  • Media
  • Privacy Policy
Certified B Corporation