Hi all,

​

I'm pondering using SQL at work to store data (I'm in a non-tech field that usually uses excel or google sheets to store data, so this would be a huge step forward). I'm trying to wrap my head around how the whole thing works.

​

I've taken a bootcamp on PostgresSQL and loved it, and I either want to use that to make a database to store GPS data from athletes, or sqlite.

​

1) since there would be 2-3 people accessing the data regularly, would postgres be better? I'm guessing if the data is on a server we can all get to it, whereas a sqlite file would be local to my computer.

​

2) how would I go about creating the database/server to ensure my coworkers would access it?

​

3) how would my coworkers go about accessing it? would they just need the server name, port, my username and password?

​

Obviously my understanding of the technical side is clear as mud, but some guidance would be very much appreciated!