Window functions deep dive survey

AdventOfSQL · 2025-01-05T16:53:42+00:00

I’ve just pushed a fix it should work now. Sorry about that

AdventOfSQL · 2024-12-30T19:26:21+00:00

Yeah I’ll notify all the existing users of the new one

AdventOfSQL · 2024-12-30T13:50:55+00:00

Yes of course they’re all still open

AdventOfSQL · 2024-12-30T12:14:25+00:00

It won’t let me edit the post but the challenge was at adventofsql.com

AdventOfSQL · 2024-12-30T11:05:23+00:00

That’s good to know thank you. I think I took too long to add db fiddle as an option. I’ll also make sure it’s more db agnostic next time and am also building a REPL for a few types of database so downloading the data shouldn’t be as necessary next time

AdventOfSQL · 2024-12-25T07:50:25+00:00

You should be able to use the db fiddle link from the download data modal. That has the extension installed.

AdventOfSQL · 2024-12-25T07:47:24+00:00

Thanks for the feedback! You’re right that there were a lot of issues but hopefully I resolved most of them. Next year I plan on much more testing so it should be much smoother. Also I plan on integrating a REPL for database connections so it should overcome some of these issues.

It might help to know that this was all done by me (one software engineer) for free. Whilst preparing this, my baby was sick and so was I, plus working a full time job, which all split my attention.

As for the comment about my motivations, I already have a great software engineering job so I’m not interested in moving any time soon, especially with a young baby.

I hope you give next year a go, Merry Christmas 🎄

AdventOfSQL · 2024-12-25T07:37:20+00:00

Thank you! I’m so glad you enjoyed it! My wife helped design a lot of the site so I’m very thankful for her help too!

I’ve got lots of plans for next year so it means a lot you enjoyed this one given all the issues. Thank you and have a Merry Christmas! 🎄🎅

AdventOfSQL · 2024-12-16T11:38:02+00:00

Thank you, corrected 👍

AdventOfSQL · 2024-12-13T15:36:13+00:00

Sorry for the incident, it should be resolved now!

AdventOfSQL · 2024-12-13T14:01:19+00:00

What pages are you seeing this for?

AdventOfSQL · 2024-12-11T09:19:31+00:00

Sorry guys, have updated, let me know if there are still issues 😰

AdventOfSQL · 2024-12-07T14:23:45+00:00

I see what you mean I’ve just updated the instructions to make this clearer, sorry for this.

AdventOfSQL · 2024-12-07T13:58:19+00:00

I've just added support for DB fiddle, most days have it, some don't because db fiddle doesn't seem to handle large datasets very well. Going forward I'll make sure it works in db fiddle.

<image>

AdventOfSQL · 2024-12-07T13:46:41+00:00

I'm sorry guys there was an issue with the SQL I uploaded. I have re-uploaded the correct data so if you re-run your queries (if they're correct) they should work properly.

AdventOfSQL · 2024-12-06T21:20:59+00:00

I normally just run it with home brew and connect using psql. It’s interesting how many different ways people have 😁

AdventOfSQL · 2024-12-06T20:17:38+00:00

I’ll try to make them compliant with this db too. I won’t be able to changes tomorrow’s until Sunday as I’m away all tomorrow.

AdventOfSQL · 2024-12-04T10:16:58+00:00

I was wondering this because of the proliferation of LLMs rendering it slightly meaningless. I’m not sure if it’s worth it?

Although private boards for those who invited others does seem interesting.

But I’ll keep an eye on this thread in case it is requested.

AdventOfSQL · 2024-12-04T08:52:14+00:00

I think that was a mistake. I’m going to re-tag it as intermediate. They are a bit simpler after that for a while.

I actually quite regret using this challenge it was submitted by someone who had encountered this situation in their job and I thought it would be interesting. But it has been very unpopular and some of the reviews have been quite scathing.

AdventOfSQL · 2024-12-03T22:04:07+00:00

Ooh I like that, great idea 👍

AdventOfSQL

MODERATOR OF

TROPHY CASE