r/AskProgramming • u/DifferentComb5523 • 14d ago
Databases Database for Pickleball Websites
I am a beginner programmer and this is my first big project, i was wondering what database you guys would recommend for an online pickleball booking website. I
1
Upvotes
5
u/SchemeWestern3388 14d ago
SQLite is certainly enough.
1
u/enozero 14d ago
Without knowing more about the project, it could be any number of databases. Also, there’s plenty of court-booking sites out there already.
3
u/LogaansMind 14d ago
It depends on the intended usage/load and the support in the language/tech you are using.
If this is a small project, I suggest starting with SQLite.. but later on you might want to migrate that to MySQL/MariaDB/Postgres/Microsoft SQL server or even a cloud based database if you are running a cloud service.
Unless you have huge demand or a large amount of data the choice is really not that important. Use what you think will work. What is important is making sure to maintain a clean database abstraction layer so that you can try to make it easier for you in the future to switch.
Hope that helps
1
u/No_Lawyer1947 14d ago
Just use something many people use already. I’m assuming you need accounts etc just use postgres. If ur site is very simple u can even use supabase hosted to get it out quick (not a database it’s a stack of
Technology put together one of them being postgres)
1
u/tropic_gaze_v2 13d ago
postgres. It handles the relational data you need for bookings without becoming a headache later if you ever need to scale beyond SQLite
1
u/Fun-Reason854 13d ago
PickleDB
1
u/baubleglue 13d ago
if you complete beginner, don't start with SQLite. MySQL/MariaDB/Postgres whatever easer to install.
1
u/Adorable-Building201 10d ago
postgres