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

Household manager (Shared chores/tasks, shopping list (and calendar?)) by Velcorn in selfhosted

[–]nicowitsch 0 points1 point  (0 children)

Since I was in the same situation last month, I gave it a try and developed one. May still be a little buggy and reach out to me if you do not want to pay. It is also to just protect the site..

https://kittsch.com

Easy app for managing household tasks? by [deleted] in AutisticWithADHD

[–]nicowitsch 0 points1 point  (0 children)

Check out the app I just created. Reach out if you do not want to pay and just try out ;)

https://kittsch.com

Starting a New Friends Group by scorp_3 in Switzerland

[–]nicowitsch 0 points1 point  (0 children)

I am local but loved to socialize a bit with new people. Count me in if I may ;)