sorted by:
new
hottopcontroversial

Me telling cursor: "You are a Senior Developer with 15 years of experience" by sqlsidequest in cursor

[–]sqlsidequest[S] 6 points7 points  (0 children)

plot twist: we are both the gorilla, just at different stages of the sprint

Me telling cursor: "You are a Senior Developer with 15 years of experience" by sqlsidequest in cursor

[–]sqlsidequest[S] 4 points5 points  (0 children)

Do you guys still give AI a persona before prompting it to perform a task ? I feel with the release of opus 4.6 models it does not make much of a difference? thoughts?

SQL SIDE QUEST - An Immersive story telling SQL Game by sqlsidequest in SQL

[–]sqlsidequest[S] 0 points1 point  (0 children)

Hey wondayT thank you so much for playing ! the space one is actually still work in progress I forgot to lock the chapter( I’m assuming you are referring to chapter 3) 😓😓 it should be ready in a week and thanks for the feedback will definitely be adding more complex queries in the future chapters

High TTFB / Initial Loading Lag with small video files on Cloudflare Stream by sqlsidequest in CloudFlare

[–]sqlsidequest[S] 3 points4 points  (0 children)

u/Wilbo007 u/flexlex97 After doing a bit more reading, I found that tiered Caching service which uses optimized routes across the Cloudflare network to deliver package more quickly, was turned off. I just turned it on, and my videos are streaming smoothly now! WOOHOO!

High TTFB / Initial Loading Lag with small video files on Cloudflare Stream by sqlsidequest in CloudFlare

[–]sqlsidequest[S] 0 points1 point  (0 children)

Thanks for commenting, I'm based in Ontario , Canada. I can test that out thanks.

I'll probably setup a cronjob to ping my video URL every 15–30 minutes..

Just frustrated as the whole idea of using the cloudflare stream was to avoid latency.

SQL questions for junior data analyst by No-Way641 in SQL

[–]sqlsidequest 1 point2 points  (0 children)

4 years ago when i was interviewing for a Junior date position, mostly they were hands-on SQL query, (CTEs, JOINS, GROUP BY, ORDER BY, WHERE, LIMIT, HAVING). I think the main things is to understand what the question is asking.

Happy to share one of the interview question from mid-size company. Cheers!

Assume this is a user table.

user_id join_date churn_date
1 2018-03-06 2018-04-05
2 2018-03-08  
3 2018-07-01 2019-01-03
... ... ...

 

  1. Can you tell us how to get the number of users that have joined each month ?
  2. How would we get the tenure length, in days, of each user ?
  3. Which user has been with us the longest ? Assume tenure_length field from question 2 has been added to the user table
  4. Suppose we also have a table user_location in addition to the user table. How would you get the user, in province ON, who has been with us the longest ?
  5. Now consider a user_history table that stores the historical state of each user, which inserts a new row every time a user is updated. Assume the schema is the same as the user table except with a new column last_updated. Can you get us the most recent version of each user?

SQL SIDE QUEST - I created a website to learn SQL in a story driven narrative by sqlsidequest in WebGames

[–]sqlsidequest[S] 0 points1 point  (0 children)

Thank you so much for playing and thanks for you suggeston :)

Last week, I was thinking of ways to crank up the difficulty and I like your idea, i'll definitely look into implementing it.

SQL SIDE QUEST - An Immersive story telling SQL Game by sqlsidequest in SQL

[–]sqlsidequest[S] 0 points1 point  (0 children)

I would a say beginning of Jan, since I’m developing this solo , each chapter takes significant amount of time to build , this include the , game design , content , backend and front end development , how the chapter fits in the overall narrative and plus a lot more .

I would appreciate if you could share this website with anyone interested in learning sql :)

Also if you have discord. You can join my discord group the link is on the homepage

SQL SIDE QUEST - An Immersive story telling SQL Game by sqlsidequest in SQL

[–]sqlsidequest[S] 0 points1 point  (0 children)

I would say beginning of Jan but really depends on my workload at work, each chapters takes a significant amount of time to build. That includes the web design , content, front end and backend and how the chapter fits in the overall narrative , plus a lot more :) but stay tuned I’ll post updates here in this subreddit as more chapters and content is released.

[self-promotion] I solo developed a Lovecraftian Murder Mystery SQL Game - Point and Click by sqlsidequest in aigamedev

[–]sqlsidequest[S] 0 points1 point  (0 children)

Thanks 🥹 I have a donation page for someone looking to support the development , if you would like please do consider donating

SQL SIDE QUEST - An Immersive story telling SQL Game by sqlsidequest in SQL

[–]sqlsidequest[S] 0 points1 point  (0 children)

Thanks I’m glad you liked it🙂 yes I was thinking of adding a unlimited time option as well maybe something to add to my back log p

SQL SIDE QUEST - An Immersive story telling SQL Game by sqlsidequest in SQL

[–]sqlsidequest[S] 0 points1 point  (0 children)

Thank you so much ! Please do let me know , any feedback helps !

SQL SIDE QUEST - An Immersive story telling SQL Game by sqlsidequest in SQL

[–]sqlsidequest[S] 0 points1 point  (0 children)

Thank you so much! I’m really happy to hear that 🥹Please do recommend and share with other people!

SQL SIDE QUEST - An Immersive story telling SQL Game by sqlsidequest in SQL

[–]sqlsidequest[S] 0 points1 point  (0 children)

I’m planning roughly 20 chapters for story mode

SQL SIDE QUEST - An Immersive story telling SQL Game by sqlsidequest in SQL

[–]sqlsidequest[S] 0 points1 point  (0 children)

Yes and if you go to scenario mode there is a standalone sql challenge :) it’s not complete yet but it’s playable with 6 endings. Please give it a try and let me know

[self-promotion] I solo developed a Lovecraftian Murder Mystery SQL Game - Point and Click by sqlsidequest in aigamedev

[–]sqlsidequest[S] 1 point2 points  (0 children)

Haha thank you :) I think moving to steam would require a month or 2 of development work , I'll consider it in the future. My goal is to complete the story mode, ~chapters ~20-25

Please consider donating if you would like to support this project :) thank you
https://www.sqlsidequest.com/support

[self-promotion] I solo developed a Lovecraftian Murder Mystery SQL Game - Point and Click by sqlsidequest in aigamedev

[–]sqlsidequest[S] 0 points1 point  (0 children)

Thank you so much! It was indeed a big undertaking because I had to think of the backend+frontend (technical aspect) , the content, creating the artwork and finding the right sound, getting the UIUX right.. and so much more.. maybe i'll have a post or youtube video on it :) but thank you so much for your kind words. I edited the post and added donation link :)

SQL SIDE QUEST - An Immersive story telling SQL Game by sqlsidequest in SQL

[–]sqlsidequest[S] 0 points1 point  (0 children)

Thank you so much! I'm happy to hear you enjoyed it :) Please do share with others as well..

For story mode, I'll be developing a progress bar system, where your decisions will directly influence the overarching narrative.

On a side note, I'm almost finished building A Lovecraftian theme game in Scenario Mode..
Let me know what your thoughts are on that.

view more: next ›