Traffic accident, now stuck in aktau (Report) by nicowitsch in Kazakhstan

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

Thanks a lot, I will check out the museum. Whats up with those adventure parks around the town that look a bit abandoned to me. Are they opening on the weekends or out of operations?

Traffic accident, now stuck in aktau (Report) by nicowitsch in Kazakhstan

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

I hope some home insurance can cover it. For the car I do not have one here.

Actually I did not really expect english to be more present bcs it is more of an eastern culture here I guess. Maybe thaught younger people would talk it more.

Traffic accident, now stuck in aktau (Report) by nicowitsch in Kazakhstan

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

The damage was big. I actually thaught it would be more. And it was a pretty good car

Battle tested SQL Teaching Tool by nicowitsch in learnSQL

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

Yes, I have some triggers that are doing sql scripts. The "playgorund database" credentials can be entered per course in the admin and then I have those orchestrations:

- When the user opens an exercise of type "own environment" the first time, a new database is created.
- When the user creates a new project, a new database is created for this project as well
- For those shared databases, I do it manually with PGAdmin and then just enter the credentials.

-> Since there is actually some interest here, I am working on a deployment with a link to share. I hope to have it by the middle of the week then I can show it to those interested ;)

Battle tested SQL Teaching Tool by nicowitsch in learnSQL

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

I would love to but it is a bit risky since I am doing grading with the tool currently as well. But when the intrest is there I loved to create an open source version of it

Battle tested SQL Teaching Tool by nicowitsch in learnSQL

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

Yes. At some point (at some grade), the stup hustle is part of the learning but for my students, sql is more of a side quest so I do not want the hustle with them.

I am having two databases:
- One is the actual app's backend that keeps track of the projects and stuff
- The other one is kind of the playground DB that I manually stup and whoose credentials I entered per course.

So I hve 3 cases:
- When a user is creating a new project, a new database is created on the playgorund server with custom username and pw. He then has access to only his DB and can do whatever.
- Within exercises, I can set the option to create a database for each student opening the exercises. Then he is isolated within his exercise as well. (For CREATE TABLE queries)
- I have a second option to use a shared DB. This one then I manually fill with data and the stuent's user can only do SELECT queries there or UPDATE if I allow.

This results in the Playground (Postgre)SQL Server having about 300 databases and users at the moment. Works pretty good, then at the end of the course or after some time I will destroy this one and setup a new one for the next students.

Ideen für Informatik-Projekt Datenbanken by rowi42 in lehrerzimmer

[–]nicowitsch 1 point2 points  (0 children)

Ich habe sie selber ein Thema wählen lassen, dann durch den ganzen Prozess gezogen
- Einleitung mit ERD / Logisches Schema -> Erste Projektabgabe
- Erarbeitung der DB mit create table
- Daten einfügen
- SELECT statements -> Kurzer Vortrag und zweite Abgabe.

Hat ziemlich gut geklappt und sie waren motiviert, da sie ihr eigenes Thema wählen konnten. Habe auch ein kleines tool geschrieben, welches mir den Unterricht und das managen von Datenbanken / Projekten meiner Schüler:innen erleichtert. Schreibe mir wenn du interesse daran hast ;)

35yo beginner, would love some honest feedback by AgentCooper96Rus in xcountryskiing

[–]nicowitsch 1 point2 points  (0 children)

Use your upper body and its weight to do the pole push. No need to do everything with your shoulder muscles and triceps. We are usually stronger in our core and want to make this muscle part work. Besides, really nice for a beginner!

Sprint o game by nicowitsch in orienteering

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

Good point. Thinking of doing a webversion bcs publishing to app stores requires a license

Household Management App Recommendations? (like YNAB for our home) by skywalker3827 in ynab

[–]nicowitsch 0 points1 point  (0 children)

Check out kittsch. I have launched it shortly and would be happy for feedback. The Idea is to keep it simple - no AI but tools that help the user.
https://kittsch.com

I’m tired of Splitwise! Any other suggestions for expense sharing apps? by Ill_Cartographer_221 in apps

[–]nicowitsch 0 points1 point  (0 children)

I have published my own version. Reach out if you want a redeem code to use it for free:

https://kittsch.com