Recently I was tasked with the seemingly simple task of running an alter table to update the data type of a table. However, because the table had tens of millions of rows I soon discovered the task would not be so easy to solve. In this post, I'll explain the solution: creating an archive version of the table.
When building an application that develops a heavy dependency on database interaction, it's easy to start with some basic queries that eventually require refactoring due to performance reasons. In this post, I'll walk through an example query which leverages a SQL left join to improve database response time.
As part of learning more about programming applications for the blockchain, I have been using Solidity to build sample contracts on the Ethereum blockchain. In the process, I've discovered a number of interesting aspects of this programming language that would be of interest to any beginner. In this post, I'll explain 7 of them.
As a software developer, I thought it would be interesting to spend some time getting my hands dirty with creating blockchain applications in order to better understand the implications of this new technology. Here are 4 things I learned during my first experience, 2 tools to get started and 2 learning resources to help developers and non-techies alike learn more about Decentralized Applications (DApps).