@Alloy

Made a second better version of the PCB with a rotary encoder and the OLED screen added, also made the case in fusion 360.

Finally finished the PCB (this is not very beginner friendly…)

Changed the tuning parts on setups and search page to icons, reversed the order of setups on the setups page so recently added ones are shown at the top, added a max time limit (32 bit integer limit). Tons of bug fixes: the search filters now handle more than one value, checking “World Records” doesnt wipe other filters, filters arent wiped when the page reloads after searching for a setup, rows per page defaults to 50, fixed the settings returning the error statement if rows per page is empty.

Small tweak to the backend validation for the settings inputs, database path is now relative instead of absolute, added a second SQLAlchemy error catcher on top of the python ones, removed the .venv so a new one is made when the repository is cloned. (now it should be runable)

Changed most of the lists to now use list comprehension, made the error handler handle every error code from 400 to 599. Updated the error page to not break the flow. The app is now fully runable (hopefully) with instructions on the readme.

Added a clear filters button to the insert form, added a shadow to the home page title. Changed the backend for time to not allow times > 32 bit int limit, changed the rows per page setting to be able to type custom amounts while still suggesting 5,10,20,30,40,50 with back end validation. Added a small section in information about insert field parameters. The setups table order is now reversed so new inserts are shown at the top. Settings errors are now shown on pages. Cleaned up some backend validation, the error messages now dont show for empty fields, created a requrements.txt and a readme on how to run the app.

Added a 404 error handler and images of tuning parts to replace the text.

Finished most of the home page, added a information section with a video, added 3 containers with quick navigation links, statistics, and fastest times on the home page, also added a background.

Made the button borders brighter to be more visible, changed the content backgrounds to a gradient. Changed the setups table to look identical to search. Added a delete button to the all setups table to easily delete specific setups.

Big Update:

Moved links to the right and added a settings menu, added a title, made all inputs and filters have hover effects.

Settings menu has a toggle for light/dark theme, and a way to select how many rows are shown in all tables (default is 10).

Changed all of the css colors to variables for the settings.

Search bar now fully supports searching for more than one word.

The player, vehicle, and track filters can all take more than one filter so the search page can now show results from multiple players, vehicles, and tracks.

Revamped the css again, the insert and delete forms are being moved to the setups table. No screenshot until the next devlog because its a mess right now.

Added a leaderboard for the most used part setups, Changed how the parts are submitted, they are now sorted so there cant be multiple setups of the same parts combination but different orders, duplicates will just reuse an already existing one.

Added a script that counts how many wrs every single player has and displays on the leaderboard page.

Made the player field autoselect a name if you type it with wrong capitalization, for example ndwg will autoswitch to Ndwg.

Completely finished styling the search page, also changed the filters to details instead of select so i can use checkboxes inside.

World records filter is fully finished

Finished the backend of the wr filter, the fastest time with x vehicle and y track is highlighted in yellow.

Finally found out about back_populates, players that arent currently in a setup now get deleted.

Styled the filters section, added hover styling for links, buttons, and table data.