7 ms·
Ray Tracer in SQL
- Jgoauh 3mo agoNice, but why ?
- jareklupinski 3mo agosir... this is hacker news
- __alexs 3mo agoGood stress test for your SQL parser I guess.
- srean 3mo agoTo know that it can be done.
- zX41ZdbW 3mo agoIt is needed to find bottlenecks in the engine and optimize customer queries. For example, it gives things like: https://github.com/ClickHouse/ClickHouse/pull/108757 https://github.com/ClickHouse/ClickHouse/pull/108757 You can read more about this approach in my presentation: https://presentations.clickhouse.com/2026-openhouse-sf/great https://presentations.clickhouse.com/2026-openhouse-sf/great... and video: https://www.youtube.com/watch?v=FmS7VopaqNg https://www.youtube.com/watch?v=FmS7VopaqNg
- jaymee 3mo agoWhy not?
- cma256 3mo agoVery cool project. Next they should create a database with SQL. Querying my database's database with my database's SQL's SQL would be trippy.
- nickpeterson 3mo agoSQL in SQL has never occurred to me.
- mmmlinux 3mo agoI love all the "But Why?!?" and "It's LLM so it doesn't count" comments.
- zX41ZdbW 3mo agoIt is needed to find bottlenecks in the engine and optimize customer queries. For example, it gives things like: https://github.com/ClickHouse/ClickHouse/pull/108757 https://github.com/ClickHouse/ClickHouse/pull/108757 You can read more about this approach in my presentation: https://presentations.clickhouse.com/2026-openhouse-sf/great/ https://presentations.clickhouse.com/2026-openhouse-sf/great... and video: https://www.youtube.com/watch?v=FmS7VopaqNg https://www.youtube.com/watch?v=FmS7VopaqNg
- laszlokorte 3mo agoVery cool! I did a similar (but much simpler!) experiment by implementing perspective projection via SQL, storing meshes (vertices, edges, faces), the camera position and the screen size in tables and building a single query that generates the SVG paths (including backface culling). Running via WASM SQlite inside the web browser. [1] SELECT project(...) as x, project(...) as y FROM model, vertex, camera, transform WHERE clockwise AND clipped IN BETWEEN -1 AND 1 [1]: https://static.laszlokorte.de/sql3d/ https://static.laszlokorte.de/sql3d/
- agustechbro 3mo agoIn the Age of AI coding, this lovely cool demos are no longer interesting anymore. I use to appreciate them by the craftsmanship and hacking aptitude they required, but now AI took away that joy of watch this for me.
- tills13 3mo agoYeah. Remember when that guy made Doom in TypeScript types? That was incredible. This feels shallow and dull. Interesting idea and cool that ClickHouse -- a primarily human made piece of software -- can even do this but I agree it no longer does it for me.
- sublinear 3mo agoThat feeling has nothing to do with AI. That's how art has always been. Most of these were bad at being art even before AI. A good reference for exactly what I mean would be the demoscene (both back then and now). You can watch a thousand of those and be totally underwhelmed, but every now and then you get one that totally blows your mind. There's nothing wrong with seeking novelty, but there is something wrong being jaded about it.
- Moosdijk 3mo agoWho are you replying to?
- bigmadshoe 3mo agoAbsolutely. These things are inherently pointless - what makes them cool is the human ingenuity required to achieve them. Remove that and it’s totally uninteresting.
- dileeppandiya 3mo ago[dead]
- mghackerlady 3mo agoLook, I love a good hack, but just. No. Why would you ever want to do this. The intersection of skill and masochism needed for this shouldn't exist and yet it does
- JSR_FDED 3mo agoHow do I join this awesome project?