Ray Tracer in SQL (github.com)

29 points by kbumsik 3 hours ago

agustechbro an hour ago

In 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 22 minutes ago

Yeah. 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.

laszlokorte an hour ago

Very 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/

cma256 2 hours ago

Very 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.

Jgoauh 2 hours ago

Nice, but why ?

jareklupinski an hour ago

sir... this is hacker news

__alexs an hour ago

Good stress test for your SQL parser I guess.