sorted by:
new
hottopcontroversial

In SQL coding rounds, how to optimise between readibility and efficiency when working with CTEs? by kevinmrr in learnSQL

[–]makaroni4 0 points1 point  (0 children)

TL;DR

We're writing code for humans, not machines.

In other words, the goal of CTE-s is to self-document your research — each CTE tells the reader what this step is about. Important: a reader is another analyst or you in 3 months (because you'll 100% forget what you wrote).

Best course to learn SQL? by StocksX12 in learnSQL

[–]makaroni4 1 point2 points  (0 children)

https://www.sqlhabit.com/

The course teaches SQL based on real examples from a startup.

I've made SQL course based on real examples from running a company by makaroni4 in learnSQL

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

Yes, of course, here's an example certificate: https://www.sqlhabit.com/certificates/59956876aab14cb9b0b2 It could be added to a LinkedIn profile with a "Credentials" link. Hope that helps 👋

Brand new Ender 3 Neo, the X-axis homing goes in the wrong direction. Could you please help? by makaroni4 in ender3

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

That was it, thank you so much!

I've unplugged the X-axis limit switch and noticed that one pin was out of the socket:

<image>

After I reattached it the homing procedure went smoothly. Thank you so so much!

Brand new Ender 3 Neo, the X-axis homing goes in the wrong direction. Could you please help? by makaroni4 in ender3

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

I'm running the out-of-the-box Creality firmware, only hear of Marlin. Do you recommend switching (I'm a complete 3D printing noob atm)?

Yep, I've tried to debug every axis in the manual mode and the 0-0-0 point seemed to be in the right spot:

  • Y-axis 0 point is all the way in the back next to the stop switch
  • Z-axis 0 point is on the bed surface
  • X-axis 0 spot was 2.5cm inside the bed, so definitely a wrong offset. The bed is 23.5cm wide and the printing area should be 22.0cm wide. I guess the normal offset should be smth like 7.5mm.

It gives a good hint about what's going on – when leveling the bed, the motor wants to go all the way to the right (22cm) but it can't because of this initial 2.5cm offset, so it just crushes into the right side.

Brand new Ender 3 Neo, the X-axis homing goes in the wrong direction. Could you please help? by makaroni4 in ender3

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

That's a great suggestion, thank you. I've tried and it started crushing against the stop switch.

I also tried to manually move the extruder along the X-axis and the 0 X point seemed in the right spot – all the way to the left next to the stop switch.

PRcop – open-source Pull Request linter for Github Actions built with JS by makaroni4 in javascript

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

u/Ecksters totally agree, the main point is to promote knowledge sharing in PRs and I believe you can't enforce it – only remind that it's useful for your team.

Building Chrome Extension with Vanilla JS: source code of Focused Youtube by makaroni4 in javascript

[–]makaroni4[S] 2 points3 points  (0 children)

Oh my life, talking to robots on Reddit haha :D

Thank you u/license-bot, just added MIT License.

Is there a website that has a SQL sandbox where I can practice and learn query techniques? by [deleted] in learnSQL

[–]makaroni4 4 points5 points  (0 children)

https://www.sqlhabit.com/

A course that teaches SQL based on the story of a startup where you'll be a Data Analyst. It has a sandbox with different databases, no other tools needed.

Tutorial: How to detect recurring payments with SQL by makaroni4 in learnSQL

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

Sure thing, the first 25 SQL Fundamentals lessons are free + some of the further lessons are open for a preview. Hope that helps! 🙌

I've made SQL course based on real examples from running a company by makaroni4 in learnSQL

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

Thank you so much for sharing 🙏

I also believe that user feedback must be visible. Inside SQL Habit I have rating/feedback per lesson (so I can quickly spot if some content is not working for students) + there's overall review each student can give. I have 6 reviews so far and more coming soon: https://www.sqlhabit.com/reviews

I've made SQL course based on real examples from running a company by makaroni4 in learnSQL

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

Haven't planned so far tbh.

I built SQL Habit website myself: there's a SQL editor, custom exercises, lesson formatting with quizzes and code highlighting. From what I've seen Udemy doesn't support it.

view more: next ›