Skip to content

Database Development Articles

Sep 03

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. […]

Apr 15

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 […]

Jan 27

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 […]

Blog Powered By Wordpress