corndel-swe / topsify

A global music streaming app
0 stars 1 forks source link

Java 24 Feedback #23

Open Charlie-robin opened 1 week ago

Charlie-robin commented 1 week ago

Hey,

Here is some feedback from delivering this repo to the Java 24 cohort.

The repo was good fun, and the group enjoyed it. I think that using the queries to write to JSON, which they could then see on the FE, was a nice touch, kudos.

A couple of the students had covered SQL before, so they raced through it. I had to give them an extension task. For the extension, I got them to focus on Java, but it might be worth having an extension for SQL as well.

The only thing that could be improved is with the third workshop. I am not sure if I delivered it correctly or not. We added the CREATE statements for the missing tables and also some INSERT statements to add some dummy data to each table. This was done within the first hour. Luckily, I had the extension I had given to a couple of learners in the morning for the others to work on for the rest of it.

It might be worth adding a view to the FE as well so they can do some sort of join on the tables they have created?

Alternatively, you could have some data they need to read and then use to populate the tables they created.

We used IntelliJ, which doesn’t have an equivalent to Live Server. You can open the HTML files using IntelliJ, but you need to update the HTML links to the scripts so that they are relative paths. See my repo chart html files.

We also used the DB Browser plugin, which was okay at first, but it could lock the database, which was strange. The solution was to disconnect from the DB and connect again and use the terminal to run queries rather than using the GUI.

Here is my repo and the extension. I did the workshops, exercises, and kept any code recaps in the queries/demo folder.

Charlie-robin commented 1 week ago

We have sacked the DB Browser plugin for IntelliJ and are using dbeaver as a DB GUI.