Attention: This article was published over 12 years ago, and the information provided may be aged or outdated. While some topics are evergreen, technology moves fast, so please keep that in mind as you read the post.In my time with Keyhole, I’ve been involved in a number of projects where the client was asking us to rewrite a legacy system …
An argument against defaulting to auto-increment primary keys
Attention: This article was published over 13 years ago, and the information provided may be aged or outdated. While some topics are evergreen, technology moves fast, so please keep that in mind as you read the post.The de-facto โeasyโ primary key for ages has been the auto-incrementing integer. Upon insertion of a new record, the database simply increments a counter …
Whatโs up with WITH?
Attention: This article was published over 13 years ago, and the information provided may be aged or outdated. While some topics are evergreen, technology moves fast, so please keep that in mind as you read the post.Ah, the WITH statement. A (mostly) loved holdover from such languages as Python and VB(A) that still finds some questionable use today in JavaScript. …
MongoDB Geo-Spatial Mobile Demo
Attention: This article was published over 13 years ago, and the information provided may be aged or outdated. While some topics are evergreen, technology moves fast, so please keep that in mind as you read the post.Mongo: noun (pl mongo or mongos) โ a monetary unit of Mongolia. Equal to one hundredth of a tugrik. Origin from Mongolian โsilverโ Iโve …
Introducing Business Intelligence Reporting to a Software System, a Jasper Reports How-to
Attention: This article was published over 13 years ago, and the information provided may be aged or outdated. While some topics are evergreen, technology moves fast, so please keep that in mind as you read the post.Most software development teams spend all of their time and efforts gathering requirements, planning, testing, implementing and supporting large systems to be able to …




