Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases

Matt Wolfe
Matt Wolfe
1,496 Points

Which database solution to use for project

Hi all

this isn't entirely related to the training here. But I was thinking about making a database for some information we currently keep, kind of like a 1099 database. I want to include date, photos, how much they were paid, location, copies of contracts etc, folder location on server, info such as dob, social, and any other info needed.

I was tossing up options as to how to do this, and i know something like filemaker would be ideal. But I was thinking I could turn this into a learning exercise and do it with PHP/html front end and MYSQL.

I also want this to be local only, not hosted online.

My question is, (should I) can i get this done with php/mysql or is it way more trouble than just using filemaker or another solution?

Im primarily mac, but everything else is windows so needs to be accessible from either computer.

If i do go with php/mysql then im sure ill be back with a lot more questions!

Thanks!