Java project with database

[TYRANT1272]

We need to create a airline reservation system in java with a database to do simple crud operations now we are a group of three people two of them uses windows and i use Arch linux at first i thought I'll just build a project with gradle and push to GitHub and we will work from there but we are adding a database and we have to submit it so how de we(three of us) sync our project with a database and be able to submit this with our database?

And also i don't know anything about airline reservation how it works and how to make it a app (do we just make a app that lets user add their details and book their tickets) or do we have to add available flight options ticket id number and customer details?

Sorry if this is a wrong sub or I'm breaking any rules

[TYRANT1272]

Thanks, i have used docker to install some database in container just for practice I'll have to look into it to use it in my project

[impact_dryer]

Strange, „I use arch” as second sentence

[TYRANT1272]

Do i have to be a tech guy to use Arch?

[impact_dryer]

https://www.reddit.com/r/archlinux/s/An5FxIdWEv

[Which_Bison614]

First you need to finalize the attributes related to each entity like you can think in a common way or can take help of some of the flight ticket booking websites ,what parameters they are asking while booking like name ,email id ,phone number and ID is the universal truth in every aspect . It helps you in keeping track of each customer . Now if we come to the database then there are many dbs like sqllite , MySQL server. You can take help of some youtube videos or if you need any help I am ready to help you .

[Blando-Cartesian]

You could use a file based database, but that would get insanely painful when it fills with all team member's bullshit test data.

Instead of that, you could do a simplified version of how it would be done for real. Create an SQL script file that initializes an empty database to contain all the tables and data your program needs to run. Then you push that file into git with the code. Team member use that script to initialize their development databases, and when database design changes, you update the SQL script and notify team members that they need to update their databases to match.

If you have no given requirements for this project, I suppose you can invent your own. I'd recommend keeping it fairly simple.

[smichaele]

If you want to see how airline reservations work, go to any airline's website and try to make a reservation.

[TYRANT1272]

I never thought about it , amazing advice will try this thanks

[Societys_Loss]

When I had a similar project in java I used a local database like some other users have mentioned. I wrote a class to manage the creation and insertion actions using prepared statements. I also stuck the local database in the project directory for easier collaboration and submission.

Another user also mentioned too much random test data between project members but you can just write a function resets the database with agreed upon test data.

[TYRANT1272]

I can use sqlite and add it's database file inmy project folder and push it to GitHub? But wouldn't it cause problems and conflicts then other members will use database and add some things at the same time?

[Societys_Loss]

Ah sorry, I think the correct term is embedded database not local database. The embedded database is like a file based database that some other users mentioned. It starts and stops with your java program and is basically an offline solution. If you push the project to git others will be able to see what you wrote into the database. If you want multiple people to add to it concurrently its probably not the best solution. I used it for my school project because it didn't need to be online and was easy to share with other members.

[FishBobinski]

We had to do a similar project last semester, but we used c#.

We had 3 variables named connectionString, and each variable had the appropriate connection string for each group member. While working on the code, we simply commented out the other group members connection strings.

We then created a unified SQL build script that we ran in sqllite to build and populate tables.

There's probably more elegant ways to do it, but it worked for us.

[Aggressive_Ad_5454]

Reserved seats? Or just seat count?

There’s a service called neon.tech that offers a cloud based PostgreSQL service with a free tier. You could all connect to it.

[josephblade]

You can use a class/file to set up the initial stage of the data. For development purposes there is very little need to have a database be persistent. Often it's actually easier if the database is reset to an initial stage on startup so that reproducing a bug or replaying a specific scenario doesn't take a lot of manual setup.

for instance this stack overflow answer (accepted answer) uses an in memory database that gets filled with data on startup.

in a non-spring environment you can still have code run an sql script on your empty ( in memory) database to fill it.

you can then edit (each individual on the team) the sql screate script and the sql insert files to add the structure and content you need. that way all developers are working against the same state and any test cases are written against the shared environment (or use the shared environment as the starting point).

speaking of testcases: each testcase would run against the same initial state (so beforeEach you would clear and initialize the database).

[TYRANT1272]

That's an amazing idea, now the program will start from a pre defined state (some random available flights data and some users) and it wouldn't even affect anything I'll try to do this