Ever wondered if real-time physics simulations in SQL were possible?
Imagine doing everything: the physics, the simulation loop, the rendering state and even a secret mechanic, all inside a simple database.
Well, look no further and enjoy my suffering as I try to implement this completely useless but kinda satisfying project.
Link to the repo: https://github.com/icitry/SQLSandSim
Video chapters:
0:00 Intro
1:03 Why SQL?
2:11 The first big improvement
2:59 Sand vs. water sims
4:19 Gravity
5:15 Lateral micro-steps
6:53 Client / Server
7:51 Time-travel
9:21 Finishing up
