Ray Tracer in SQL

(github.com)

29 points | by kbumsik 3 hours ago ago

7 comments

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