data sanitization

Sanitize: Good for Beer, Good for Data

Jeremy Gard Databases, Design, JavaScript, Programming Leave a Comment

When it comes to brewing, one of the most critical considerations is sanitization. The same fact can be said for development. In brewing you can introduce unintended flavors, create a lesser end product, or completely ruin your hard work. With development, you can introduce inaccuracies or bad data, errors can be caused or exposed to attack, and security holes can be created.

With best practices in sanitization, we can all enjoy better applications and better beer. In this blog, I discuss the importance of data sanitization in development (with tips for success), with parallels to sanitization in brewing.



Web Development Business

SQL for Application Developers

Mark Adelsberger Databases, Programming, Technology Snapshot Leave a Comment

“SQL? Isn’t that just something my ORM tools use?” Often application developers can and should remain at least one level removed from SQL. JPA and the Entity Framework each provide more abstract (and OO-friendly) query languages, and it’s often unnecessary to write any queries at all. If you ever diagnose production support issues, though, being proficient with SQL can greatly …



Rethinkdb

Real-Time Applications With RethinkDB

John Hoestje Databases, JavaScript, Microservices, Node.js, Technology Snapshot 1 Comment

In the last several years, there have been new requirements and expectations placed on enterprise applications that have dramatically increased application code complexity. Users want dynamic websites that provide instant data feedback or to have multiple users work on the same document concurrently. New frameworks and ideas have also evolved along with the requirements to help cope with the new …



XML Manipulation With XML Copy Editor

Robert Rice Databases, Technology Snapshot 2 Comments

The XML document format, created in 1996, is still widely used to facilitate communication between disparate systems (though for certain implementations is somewhat being replaced by JSON). As a Java developer, I generally interface with data in an XML document via a DOM parser, but there are occasions where being able to manipulate an XML document directly is advantageous or …



Real-Time Website Data Using SignalR

John Holland .NET, Databases, Technology Snapshot 2 Comments

When I was tasked with using SignalR to implement the real-time updating of data on a project I was working on, I was excited. Namely because it is a newer technology and I have always welcomed learning new technologies – especially when there is an immediate need to implement it, as opposed to reading about the technology and then never …



Using PouchDB for Offline/Data Sync

Dave Jackson Databases, JavaScript, Technology Snapshot 3 Comments

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 – “Offline First.” As much as you may be online with your mobile phone or tablet, inevitably there will be times when you’re not connected, but still need …



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 [http://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 …