Create DB, New Table with XAMPP

Just a little update about that CPSC304 project.

Okay, so this is me messing with XAMPP.

Once you start the XAMPP mySQL database go to: localhost/phpmyadmin/

You will be directed to the MySQL setup page.

screen-shot-2017-02-10-at-2-20-58-pm

 

So right now I have 5 databases in mySQL. I only created test; the others I’m sure are defaults from the XAMPP program itself.

To create a new database, click New. I added a gTheatre database and started to add a table for theatre halls.

screen-shot-2017-02-10-at-2-26-45-pm

This actually gives me way more options that I even know what to do with. This seems like an easy enough UI for working locally but the problem is that I need to deploy to a remote database hosting service and make sure that I can work collaboratively with my group members.

I have experience with SQL and Ruby on the backend but during my work term I jumped onboard after the databases were set up and all I did was update and work on new features. I’m still not sure how to do it for this project.

I also have experience with non-SQL databases which is probably the opposite of helpful at this moment in time. My CPSC 310 project hosted its remote database on MongoDB.

I think, and I’m not sure if this is making things more complicated or less, but we will need a separate API repo and a front-end application repo. I’m not sure though and we also don’t have that much time left for the project.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s