- Why did you create this?
- What technologies did you use?
- How can I learn about SQL window functions?
- Does my database support this?
Why did you create this?
While there are several websites similar to PG Exercises that allow you to interact with SQL interactivly none of them focus on the post sql-92 window functions. Most databases got these awesome powerful functions a long time ago and most of us don't use them
What technologies did you use?
Rust & Postgres.
The code is on github It is written in Rust and uses Actix (formally Rocket), Tera. I wrote it partially to learn Rust.
How can I learn about SQL window functions?
Links to learn about window functions:
Links to learn more about Postgres
Does my database support window functions?
Probably, the only major one that doesn't is MySQL (which is superseded by Maria DB which does).
Try it and see!