Database Development Articles
AWS DynamoDB Setup
DynamoDB is AWS’s NoSQL solution. While not the most robust NoSQL solution, DynamoDB offers low latency at scale and is a fully managed service. There are some features that are a bit odd, like pre-defining table throughput and a per index pay structure, but they’re relatively minor hurdles when compared to DynamoDB’s scalability and cost. […]
MySQL Query Profiling
MySQL query profiling is a useful technique when trying to analyze the overall performance of a database driven application. When developing a mid to large size application, there tends to be hundreds of queries distributed throughout a large code base and potentially numerous queries ran against the database per second. Without some sort of query […]
MySQL Data Types
When designing a database it is very important that you use the correct data types for your tables. Data types affect everything from overall size to querying efficiency. This is a great article to bookmark for reference as data types are a very important part of database design. I will be covering numeric, both integer […]