Back again! I came across an interesting YouTube video about DuckLake. If you want to know about DuckLake, watch/read that content; I’m not going to regurgitate it here (I simply cannot do it justice). The gist can be summarized by this snippet from the manifesto “Once a database has entered the Lakehouse stack anyway, it makes an insane amount of sense to also use it for managing the rest of the table metadata! "

Hello friends! Today’s post is going to be about window functions (specifically with Postgres).

Here’s the docs and tutorial. Give them a read. Like most Postgres docs, they’re quite good.

Hot damn, I think I have the PERFECT workflow to building an application!!! Ok, probably not, BUT I have settled on what I think is a pretty straightforward process that lets you build things real fast. In the end, you be able to build: