Main

Hotspotr partners with LightPole for mobile

Mar 18 by Andre

Hotspotr -- my community-driven WiFi hotspot site -- announced a content-providing partnership with LightPole today. You can read the press release over at http://lightpole.net/press/index.html.

Hotspotr lists over 8,000 user-contributed WiFi hotspots. LightPole provides a mobile client you can use to browse Hotspotr from your mobile phone using an interactive, maps-based interface:


You can download the LightPole mobile client for free from the Hotspotr homepage.


Separately, Hotspotr is also taking advantage of the Google Maps streetview functionality. For locations where streetview is available, you will have the option to browse the 3-d streetview imagery:



See an example at the Dolores Park Cafe in San Francisco.

Continue reading "Hotspotr partners with LightPole for mobile

Mobile WiFi Maps with Hotspotr

Oct 04 by Andre

Hotspotr is now available as an interactive map on your cell phone. You can browse for WiFi hotspots on the go -- which is exactly when you need to find hotspots right? See the link on the home page, or jump right to the mobile download.

The mobile goodness is provided through a partnership with LightPole. I tried several similar mobile services, and LightPole is doing a fantastic job. I've been using the application for some time myself during development.

Note that you have to be on Sprint, AT&T, or T-Mobile, and that the app is free. give it a try.

Continue reading "Mobile WiFi Maps with Hotspotr

Montreal and Chicago step up!

Mar 04 by Andre

Montreal, Canada has boldly stepped into the #1 city on hotspotr with 107 cafes/hotspots listed! Chicago is trailing in 2nd place with 105 cafes, and San Francisco (hotspotr's hometown, if you will), is in 3rd place. Props to Montreal, who came out of nowhere on this -- their first listing was posted just six days ago.

Chicago was the first to overcome San Francisco, and they've traded the top spot with with Montreal a couple times over the weekend. Who will come out on top?

Continue reading "Montreal and Chicago step up!

Four mongrels, digg, and lifehacker

Feb 27 by Andre

Hotspotr had a record-breaking day yesterday, with a total of 61,000 pageviews according to Google Analytics. The peak hour was 5pm, shortly after it went onto the digg homepage, with just under 15,000 pageviews in one hour.

Since a frequently-expressed concern with Rails is it's ability to handle traffic, I'm happy to say the site survived without a hicup. If you are building a Rails app and wondering about scalability, here are some points of reference:

  • the backend is Apache 2.2 with mod_balancer going to a cluster of four mongrels.
  • the server is a Rimu hosting dedicated server, with a few other Rails apps running alongside it (none very highly trafficked yesterday though).
  • I don't have quantitative measurements on its responsiveness during the peak load times, but qualitatively it seemed pretty snappy -- I hit the site myself repeatedly during the peak time to see how it was holding up.
  • the hotspotr homepage has four database queries. The main map page (for any given city) has five queries.
  • I've done very little to optimize hotspotr. The basics are there: no iterative retrievals, appropriate indexes on tables, and sessions in the database.
  • beyond that, I haven't optimized much at all -- there's no caching of either ActiveRecord objects or HTML fragments.

You can see there is still quite a bit of room for improvement. The fact that the site survived a 15K hour certainly makes me more confident about deploying Rails in a high-traffic environment.

Thanks to Josh at Webware Rick at lifehacker for writing up hotspotr and sparking all the traffic yesterday!

Continue reading "Four mongrels, digg, and lifehacker

Wifi cafes, beyond San Francisco

Aug 24 by Andre
My community-driven wifi cafe site now takes listings outside of San Francisco. You can add a cafe in any city (in the US), and the city will automatically be listed in the sidebar. I also made a few UI enhancements, including different map icons to distinguish free from paid hotspots.

Feel free to start adding wifi cafes in your own city. The site is http://wifi.earthcode.com

Continue reading "Wifi cafes, beyond San Francisco

Presentation af SF Ruby meetup

Jul 11 by Andre
If you were there for my presentation at the San Francisco Ruby meetup this evening -- thanks for coming! I was impressed by the turnout and the thoughtful questions everyone was asking.

The final slide was some resources from the talk you may find useful:
  • SF Wireless: http://wifi.earthcode.com
  • jQuery tutorial: http://15daysofjquery.com
  • jQuery CSS selectors: http://jquery.com/docs/CSS/
  • jQuery interface library: http://eyecon.ro/interface
  • jQuery interactive documentation: http://visualjquery.com
  • JSLog: http://earthcode.com/blog/2005/12/jslog.html
  • Rails & geocoding: http://earthcode.com/blog/2006/04/rails_geocoding_and_google_map.html
I'll be putting up a detailed tutorial on the Google Maps Zoom Control soon.

Continue reading "Presentation af SF Ruby meetup

San Francisco Wireless Cafes

Jul 11 by Andre
Wireless Cafes in San Francisco

SF Wireless (http://wifi.earthcode.com) is a community-driven directory of cafes with wireless internet access here in San Francisco. This is a community effort, and the more listings it has the better -- so if you're in the San Francisco area, go ahead and add your favorite cafe.

SF Wireless is built in Ruby on Rails, and has served as a testing ground for my Rails/Google Maps development over the last couple months. I hope it will become a useful resource for others who enjoy getting out of the office and doing work in cafes.

Some things to note as you look around the site:
  • Open listings: anyone can add or update cafe listings
  • Google maps integration: the map view lets you see cafes citywide, or filtered by a specific San Francisco neighborhood
  • GMaps "Zoom" control: if you're using Firefox, there's a nifty "zoom" control on the main map view, which lets you outline a region on the map to center and zoom. Safari users -- this feature is coming soon
  • Ratings & collective opinion: there's a nice AJAXy rating system to aggregate collective opinion on important things like the availability of power outlets
Enjoy the site, and spread the word to others who might find it useful! http://wifi.earthcode.com

Continue reading "San Francisco Wireless Cafes