Proof-of-Concept Using Spring Roo

Brice McIver Databases, Spring, Technology Snapshot 1 Comment

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 while retaining their existing database. Sometimes it helps to give a quick demo on how using current technologies can make it easier to develop, test, and maintain their code. One way I’ve found to get a …

An argument against defaulting to auto-increment primary keys

Shannon Griswold Databases, Java 11 Comments

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 for the table and uses the new value for the primary key of the inserted row. It’s simple to setup, requires no maintenance, and guarantees a predictable key. For my own purposes, I was under the …

MongoDB Geo-Spatial Mobile Demo

Lou Mauget Databases, Mobile 2 Comments

Mongo: noun (pl mongo or mongos) – a monetary unit of Mongolia. Equal to one hundredth of a tugrik. Origin from Mongolian “silver” I’ve written about NoSQL DBMS [https://keyholesoftware.com/2012/10/01/is-nosql-the-sql-sequel/]. We know that there are several categories of NoSQL DBMS. MongoDB is a scalable NoSQL document-oriented data store that has built-in geo-spatial indexing. Let’s look at its characteristics and then check …

Introducing Business Intelligence Reporting to a Software System, a Jasper Reports How-to

Adi Rosenblum Databases, Java, Technology Snapshot Leave a Comment

Most software development teams spend all of their time and efforts gathering requirements, planning, testing, implementing and supporting large systems to be able to do the one thing they are all in business to do: make money! Rightfully so, the core efforts of their business and development teams need to focus on making the software work for their business and …