Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Ray Tracer in SQL

github.com

Post reply on HN
Print view View original

1–10 of 24 posts

Re: Ray Tracer in SQL

#2

Post by cma256 »

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.

Re: Ray Tracer in SQL

#4

Post by laszlokorte »

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/

Re: Ray Tracer in SQL

#6

Post by agustechbro »

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.

Re: Ray Tracer in SQL

#8

Post by tills13 »

agustechbro wrote: post #6

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.

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.

Re: Ray Tracer in SQL

#9

Post by sublinear »

agustechbro wrote: post #6

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.

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

Post reply on HN