Using PouchDB for Offline/Data Sync

Dave Jackson Articles, Databases, Development Technologies & Tools, JavaScript 3 Comments

Attention: The following article was published over 11 years ago, and the information provided may be aged or outdated. Please keep that in mind as you read the post.Recently the term “Mobile First” received additional notoriety as the new CEO of Microsoft proclaimed the company’s shift in focus. As I’ve been researching mobile frameworks lately, I’ve run across another term …

Proof-of-Concept Using Spring Roo

Brice McIver Articles, Databases, Development Technologies & Tools, Spring 1 Comment

Attention: The following article was published over 12 years ago, and the information provided may be aged or outdated. 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 while retaining their existing database. Sometimes it helps …

An argument against defaulting to auto-increment primary keys

Shannon Griswold Articles, Databases, Java 11 Comments

Attention: The following article was published over 12 years ago, and the information provided may be aged or outdated. 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 for the table and uses the new value …

What’s up with WITH?

Scott Peters Articles, Databases, Development Technologies & Tools, Python 1 Comment

Attention: The following article was published over 12 years ago, and the information provided may be aged or outdated. 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. It was easy to use and could save …

MongoDB Geo-Spatial Mobile Demo

Lou Mauget Articles, Databases, Mobile, MongoDB 2 Comments

Attention: The following article was published over 12 years ago, and the information provided may be aged or outdated. 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 written about NoSQL DBMS [https://keyholesoftware.com/2012/10/01/is-nosql-the-sql-sequel/]. We know that …