Salvete omnes! This blog is primarily about ColdFusion, SQL queries, and searching (as the subtitle says), with a particular focus on integrating ColdFusion with the Apache Solr/Lucene search engine. When I started working with ColdFusion 9 in 2010, I noticed that there was a dearth of information available on the Internet about migrating from Verity to Solr. And there is still a dearth of information. This is not to say that the Solr documentation itself is lacking, only that there is not a lot out there for developers who are using ColdFusion and who are frustrated with the rigidity of Verity or of ColdFusion 9′s bare-bones implementation of Solr. So this is my attempt to fill in that gap, and maybe make some comments about some other odds and ends along the way. I’ve been working with ColdFusion for at least 13 years, and SQL databases even longer than that, so hopefully I’ll have something of value to say.