25 posts tagged with "database"

September 29th 2022 by Will Gant

Many developers are rightly nervous when dealing with databases. Not only is the database absolutely critical to proper functioning of the…

Read More
April 21st 2022 by Will Gant

Your application's data is probably one of the most valuable and longest-lived pieces of your application. When your application goes to the…

Read More
September 23rd 2021 by Will Gant

Database performance issues are the scourge of any large application, especially as load increases. They can be hard to understand, happen…

Read More
June 10th 2021 by Will Gant

Database migrations are a complicated topic. While easy solutions exist for simple migrations, trivial implementations can fail…

Read More
May 13th 2021 by Will Gant

While the typical user of your application probably won't be interested in your audit trails, that doesn't mean that you can get by without…

Read More
July 30th 2020 by Will Gant

Document databases are becoming increasingly common. Not only do they offer a lot of advantages over relational databases in certain…

Read More
May 7th 2020 by Will Gant

The rule: Normalize until it hurts; denormalize until it works. That's what you typically get taught early on. While normalizing a database…

Read More
August 2nd 2018 by Will Gant

White-Label applications offer an additional level of challenges over "normal" application development. Due to some of these constraints…

Read More
July 26th 2018 by Will Gant

There are a lot of things that are treated as a given in modern software development. Things like continuous deployment, having direct…

Read More
March 22nd 2018 by Beej Burns

Database normalization is the process of organizing data in a relational database. It was first proposed by Edgar F. Codd in his 1970 paper…

Read More
March 15th 2018 by Will Gant

Command/Query Responsibility Segregation (CQRS) is a way of designing the code in an app that talks to a database. It creates a logical…

Read More
November 23rd 2017 by Beej Burns

"A database object is not a programming object." CRUD stands for Create, Read, Update, Delete. These are the major functions you'll see in…

Read More
October 5th 2017 by Will Gant

Your database is often the most important part of your application in terms of actual value to the business. The value of the database will…

Read More
September 28th 2017 by Beej Burns

Generally speaking a data type is either primitive or composite. A primitive data type can either be a basic type that provides the basic…

Read More
January 19th 2017 by Will Gant

"I've discovered a lot of JavaScript Promises issues because if you throw in a debugger it works." Logging provides routine diagnostic…

Read More
December 15th 2016 by Will Gant

"Once you know you're in the Dunning-Kruger club, you're no longer in the Dunning-Kruger club" There are many reasons that you might not…

Read More
November 24th 2016 by Will Gant

Typically, when someone uses the term efficiency, they are describing how much effort is required to achieve a result. The term is…

Read More
September 22nd 2016 by Beej Burns

The single tier design comes from the time of the "mainframe" computers. Everything is done on a single computer with all resources attached…

Read More
May 19th 2016 by Will Gant

Soulbound by Bethany Adams available on Amazon "Why does your database administrator (DBA) hate your object relational mapping (ORM)?" Many…

Read More

Complete Developer Podcast