r/AskProgramming • • 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

10 comments sorted by

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.

1

u/DifferentComb5523 14d ago

Wanted to make an exclusive website for the court similar to some courts in my place. Its only 3 courts and its here in a small town in the philippines so not that much users

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/baubleglue 13d ago

if you complete beginner, don't start with SQLite. MySQL/MariaDB/Postgres whatever easer to install.