A simple web-app with a connected database ! banner

A simple web-app with a connected database !

5 devlogs
4h 45m 49s

At my school there is a so called "Turnwettkampf" which translates roughly into "gymnastics competition" and we need to put all the names and the scores into a manual EXCEL-File, which was very time-consuming and not very nice to do… So for this…

At my school there is a so called “Turnwettkampf” which translates roughly into “gymnastics competition” and we need to put all the names and the scores into a manual EXCEL-File, which was very time-consuming and not very nice to do… So for this year I am making a web-app with a connected and self-hosted database… and trying to make things simpler !

Jolomolokolo

I added to the calculation script, the calculation of the certificate which is connected to the total amounts of points and the age. Had to add also some very unsafe edge cases. Learned that “match” and “case” exists in python and it is very nice !

Attachment
Attachment
Attachment
Attachment
0
Jolomolokolo

Wrote two new files ! The first for writing points into the DB and the second file reads the points, calculates the over all points, calculates the birthday and also compares some other stuff ! This work is a very big progress !!!

Attachment
Attachment
Attachment
0
Jolomolokolo

A big milestone ! Import of CSV-File into the DB works now ! Took a relative long time, because it is my first time working with a CSV-File and a DB. Also every new user created/imported gets a unique ID with the implementation into the DB.

Attachment
1

Comments

Hridhaan
Hridhaan 2 months ago

unique

Jolomolokolo

Switched from PostgreSQL to SQLite, because of better control and easier workloads. I created the Database creation and wrote samples for testing. Also learned a lot about DBs and SQL-Language. Also cleaned up the repository. Will now work on the import of data into the DB.

Attachment
0
Jolomolokolo

Started with creating a Postgresql database and trying it ! Then I made a simple and basic python script, which creates a table for a user ! Also wrote the basics for a website and learned about .gitignore and how to not show a password in the github repo !

Attachment
0