3 ms·
Show HN: A Pure SQL Raytracer
- deleted 5y ago[deleted]
- qeternity 5y ago> Mainly, I'm just buggering around with the wrong tool for the job Is there a list of these types of projects? Or a competition for the most wrong tool for a given complex job? (DAFTCON?) I don’t know why I find these things so interesting, but I’d love to see more (the PowerPoint Turing machine comes to mind).
- chunkyks 5y agoI don't know of anything explicitly around the wrong tool to the job, although I think it's the same itch that gets scratched by Code Golf [eg 1, stack exchange] or IOCCC [2]? [1] https://codegolf.stackexchange.com/ https://codegolf.stackexchange.com/ [2] https://www.ioccc.org/ https://www.ioccc.org/
- tomnipotent 5y agoI've always called them abstract squared solutions. I worked with a programmer that inadvertently re-invented tf-idf in SQL, without being familiar with solutions in full-text indexing. He created tables mapping words to documents, kept counts, and came up with simple algorithm to rank documents based on word frequency weighted by overall word scarcity of the words across all documents. He also re-discovered stemming during this process, different heuristics for splitting words, and other pre-processing methods that come with experience. This would have been mid-2004, so Lucene wasn't omni-present and Apache Solr hadn't made it's debut. He was half-way to rediscovering n-grams when Solr was released and he stumbled upon it.
- chanpatorikku 5y agonot very sure why you want to write it in sql. But nice project.
- chunkyks 5y agoI get my jollies using sql for stuff, mostly. Partly keeping skills sharp, partly being deliberately obtuse
- jjice 5y agoWow, very concise and impressive, nice work!
- chunkyks 5y agoThank you!