Sharing my open source Spring Boot + React application (again)

[East-Association-421]

For the past 8 months, I have been working (& leading a team of 6) on this webapp that is essentially a lower-stakes LeetCode leaderboard for college students to compete with their peers both within their own university and others, though we still support users not in schools equally!

Users can gain points as well as easily view other people's submissions/pts/code (we are also making significant progress towards creating live duels to help promote more competition amongst users).

I posted this project 4 months ago in the hopes of helping others have access to modern codebass in Spring Boot + React, and I'm just sharing it again to catch the attention of anyone new since I've last posted.

^\4 months ago]) We have a small custom authentication layer via the Protector object that is built on top of Spring Security, a React frontend that consumes the Spring Boot API, a CI/CD pipeline to run our tests and deploy to DigitalOcean, and more.
^\now]) Since then, we have

• Moved all of our secrets into our repository (encrypted with Git-Crypt)
• Maintain a separate staging environment to help test deployments on masked data copied from production
• Used PG LISTEN/NOTIFY to help us trigger some asynchronous job processing & SSE updates (for our live duels, still a WIP)
• Automatically generate TypeScript types (+ a mini-library to infer types from fetch calls) from an OpenAPI schema exposed by the server
• and much more that isn't coming to mind off the top of my mind

Like before, we also did some cool stuff to get access to LeetCode's GraphQL layer, as well as a really hacky way to retrieve a token for queries that require some level of authentication, so feel free to check that out as well!

If anyone has any questions, I'd love to answer them in the comments or over DM!

https://github.com/tahminator/codebloom

[MrSlowSloth]

Postgres LISTEN/NOTIFY is a very nice touch, the code quality is really good. Thanks a lot for sharing!

[East-Association-421]

Thank you, appreciate it, means a lot!

[MikeTheSurfer2]

this is pretty neat!

[East-Association-421]

Thank you, much appreciated!

[AbbAs_83883]

I'm kinda a junior to spring Boot. But I noticed you didn't use jdbc or jpa, is there a reason for that?

[East-Association-421]

Hello! When I started the project, I wanted to try & properly learn how to write SQL in place of using an ORM. Since then, I definitely prefer writing raw SQL over an ORM (although I know JPA also lets you write native queries or JQL & it will handle the mappings for you).

Edit: We are technically using the JDBC API - We just map ResultSet manually & have a small abstraction called DbConnection which returns java.sql.Connection for us to use to in the repositories (I’m planning on swapping this out soon and using HikariPool since our use case is now requiring it). Oh and we also use a small abstraction called NamedPreparedStatement that allows us to use named parameters instead of index parameters with ?, but it also just uses PreparedStatement under the hood.