Our inspiration was to make an android app because we were all more comfortable using java rather than javascript or html. We were inspired my the recent rise in urbanization and the need for community gardens to be able to keep the city green. Managing a community garden seemed like a very complex process and we wanted to make it easier by making an app to help people manage their gardens by allowing people to use them to grow the plants of their choosing.

What it does

What it does is it allows people to request for a specified amount of land that they want to use. The app takes in the requests and assigns the plot of land to the person, while taking into account which plots of land were free and which were already being used.

How we built it

We created from scratch 4 different activities in android studios for the User Interface.

Challenges we ran into


  1. How to READ/WRITE JSON to a server and access it from android app


  1. How to host to a server
  2. How to pass Android fields into the mySQL database as different values to store in the table
  3. How to establish a secure mySQL database connection (GOT IT TO WORK : USED AMAZON AWS over creating own connection in mySQL workbench)
  4. How to add additional schemas (non duplicate to ones already existing) to the mySQL database (GOT IT TO WORK in mySQL workbench)
  5. Best field/variable type to use (GOT IT TO WORK : used VARCHAR() instead of mediumtext() in mySQL, and TIMEDATA over VARCHAR())

Web App

  1. How to update a variable in a web app when using PHP and HTML
  2. How to integrate a mySQL database into web app after hosting with Amazon (needed to use Amazon RDS's endpoint for the hostname)

Accomplishments that we're proud of

  1. WON THE STACKATHON! (Still didn't win a bluetooth speaker)
  2. Made a secure connection and hosted mySQL database with AWS RDS!!!!! (had to create 3 different instances until right instance --> had hard time trying to find endpoint for Hostname of database to securely connect it)
  3. Didn't linger too long on one approach --> very flexible.
  4. Incorporated HTML and CSS pages

What we learned

  1. How to use Github
  2. Android Studio tricks and tips
  3. Java OOP
  4. HTML + CSS
  5. mySQL
  6. PHP

What's next for CommunitySpacesRepo

  1. Get an online server to work
  2. Publish app on App Store
  3. Integrate mySQL into app
  4. Modular garden sizes and public spaces

Built With

Share this project: