Ask HN: Fuzzy Logic SQL select framework

Re:Ask HN: Fuzzy Logic SQL select framework by russell on Thursday January 29, 2009 @06:39PM (#457370)

I don't have a compelling need for a framework. If I had the need for such a query, I would probably write a simple query to gather a superset of the candidates, or not, if it looked like most of the records would be in the set. Then I would write a Python program that would rank the candidate according to whatever. It could all be done in SQL, but Python would be quicker in elapsed time to a solution.

If this were a frequent run, I might do it purely in SQL, but not a framework, SQL is sufficiently high level that I dont see much of a gain.

[ Parent | on HN ]

Re:Ask HN: Fuzzy Logic SQL select framework by brand on Thursday January 29, 2009 @06:51PM (#457382)

Agreed. You'd be simply creating a composite value; your statements might look messy, but there's nothing stopping you from doing this with SQL.

Additionally, you're still choosing arbitrary values, and there are still going to be data points 'just outside' your selection - it may be more smooth, but it's just a weighting of the same metrics.

[ Parent | on HN ]