I was inspired by XKCD to draw this cartoon for a recent presentation on the Semantic Web. We have this habit of dismembering data when we use relational modeling. Consequently, we spend a lot of our development time figuring out how to reassemble entities to use them in our applications, Read more »
Category Archives: SQL
Using Neo4j Graph Databases With ColdFusion
After last week, I decided to put off picking a new frontend platform for my Semantic Web rubric project and focus a bit on the server backend. Since this is just a proof-of-concept project at this point I can afford to take some risks in choosing technologies. I’ve been following Read more »
CFQUERY and autonumber primary keys
After reading a post by Ben Nadel, it occurred to me that I should write up my technique of getting new autogenerated primary key values back from the database. It’s very common for database designers to use columns that generate a unique, artificial primary key value for every row inserted Read more »