uCamper

Camp where you love!

Comment

Inspiration

I love to get outside and enjoy nature. Whether it's hiking, backpacking, or camping I always want to see more, but I don't know where to start. There are so many options, but so few tools to narrow them down to something I like.

What it does

Creates user profiles that store preferences. Then uses those preferences to recommend camping trips across the United States.

How I built it

I wrote java code and connected it to an SQL database. I used Google's Cloud SQL platform to store an SQL database remotely. This freed up space on my local machine, made the database accessible 24/7 to all my users, and instantly gave uCamper security it would otherwise lack.

Challenges I ran into

Connecting to Google's Cloud SQL platform proved complicated. I had to enable settings on my Google account, tinker with the firewall of my database and my computer, download an SDK, download a proxy, run the proxy, and ensure the version numbers of all of my programs were up to date so everything would be compatible.

Accomplishments that I'm proud of

I have never worked with Google's Cloud SQL before. I'm proud I tried something new and it paid off.

What I learned

I learned how to integrate a Google cloud service into my code.

What's next for uCamper

Expanded user preferences, more detailed search functionality, more camping destinations in the database, and an android app client.

// Run the Google proxy to connect! // Use the following command to start the proxy // start cloud_sql_proxy.exe -instances=primeval-pixel-238221:us-west1:h014=tcp:3306

Share this project:

Updates