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 …

Mapping Shortest Routes Using a Graph Database

Lou Mauget Databases, Java, Technology Snapshot 11 Comments

We often model interconnected data by cramming it in and out of table structures. Why don’t we simply model interconnected data as … interconnected data? I recently wrote that there are several kinds of NoSQL database stores: key-value, column family, document-oriented, and graph database.  This article targets Neo4j, a Java-based graph DBMS. The open-ended problem domain of graph databases includes …

Is NoSQL The SQL Sequel?

Lou Mauget Databases, Opinion, Technology Snapshot 8 Comments

“Can’t we all just get along?”  I assert that the explosion of so-called NoSQL database management systems (DBMS) is not displacing the well-known relational DBMS (RDBMS) that we love and admire. There is room for each, sometimes within one application. Why? Visits by three spirits could enlighten us … 1. Spirit of DBMS Past The DBMS was invented before the …