privatesquare | simple web application to record and manage a database

privatesquare is built on top of Flamework which means it's nothing more than a vanilla Apache + PHP + MySQL application. You can run it as a dedicated virtual host or as a subdirectory of an existing host. You will need to make a copy of the config.php.example file and name it config.php. You will need to update this new file and add the various specifics for databases and third-party APIs.
Get the code from GitHub. Decide on whether you'll host this on a sub-domain (something along the lines of privatesquare.example.com) or in a subdirectory (maybe something like www.example.com/privatesquare).
That you'll be hosting on a subdomain called privatesquare on a domain called example.com, or, to put it another way privatesquare.example.com. Just mentally substitute your domain and sub-domain when reading, and physically substitute your domain and sub-domain during the installation process. Unless you actually own the example.com.
That you'll be using Flickr for reverse-geocoding and not an instance of the reverse-geoplanet web-service.
That you want the URL for privatesquare to be privatesquare.example.com and not privatesquare.example.com/www
That you want privatesquare to be on a public facing web service. You can install it on a local machine that isn't publicly accessible but to do this needs some careful copying-and-pasting of database settings from a public facing machine to your local, private machine. See the Here-Be-Dragons Locally Hosted Version Below if you want to get your hands dirty.
That <root> is the path on your webserver where your web server has been configured to find the sub-domain.
That you have shell access (probably via SSH) to your web server.
Set the Application name to privatesquare (or something that means something to you)
Set the Application web site to http://privatesquare.example.com
Set the Callback URL to http://privatesquare.example.com/auth
Note the Client id and Client secret the registration process gives you (it's a good idea to save this in a new browser window or tab so you can copy-and-paste)
Apply for a non-commercial key
Set the App name to privatesquare (or something that's meaningful to you)
Set the App description to something meaningful, such as An instance of https://github.com/straup/privatesquare
Tick both boxes!
Note the key that the registration process gives you.
If you really want to hack and play around with privatesquare, it's best to do this on a private, locally hosted machine, like your laptop or your desktop machine. But as a starting point you need to have followed the installation instructions above as you need to have a public facing installation first and then clone this to your local machine. The reason for this is that you need to authenticate with Foursquare, Foursquare uses OAuth to authenticate and OAuth authentication needs a publicly accessible web server to authenticate with. With that said, roll up your sleeves, grab a cup of your caffeinated beverage of choice and follow along.
That you're running MAMP on a Mac. MAMP is a nice convenient way to run MySQL, Apache and PHP on a Mac. There's also a Windows version called WAMP. Or most Linux distros come with all of this installed. YMMV so you may need to change some paths and file names.
That you'll set up a local host name called privatesquare
That your MAMP installation is running Apache on port 8888 and MySQL on port 8889.