March 2, 2015

How to Vote on my shared Links

This morning, I decided to let you lot vote on the many links I've shared with everyone. And the source code for this application:

February 20, 2015

How to Move Between Yodlee APIs

Yodlee is the 800-lb gorilla you've never heard of. It is a financial-data powerhouse. It also has an API, which is poorly documented and shows its age, being developed in 1999. Indeed, there are two distinct REST APIs on offer here -- site-based and container-based, not to mention the SOAP API. All do the same thing. While there seems to be a migration document from SOAP to REST However, there's no mapping between them. The table below seeks to fill that gap, such that, if you know one, you can quickly port to the other -- I plan to expand on it as I get further down this particular rabbit hole:

Mapping containers to sites, using Yodlee
attribute: contentIdattribute: siteId

February 10, 2015

How to Use eBay

This morning, I felt like I needed to simplify ebay. So I did... Gone is the dependency on any JDBC, gone is the combobox and search history. The ever-geeky statistics remain (thanks to commons math). Let me know if anyone aside from yours truly finds the interface useful.

January 31, 2015

How to Automate your Email

Anyone who has happened to look at my gmail account has seen the sheer volume of unread messages that I'll be lucky to get to from beyond the grave. I manage them by the copious use of label, filter, and routine cleanup. I've now put the latter code into the public domain and embedded the gist above. It is tied to Google's IMAP server. As always, if you have any ideas on how you want this improved, leave a comment and I'll get to it in due course.

January 24, 2015

How to Bulk-Import JSON to Postgres

The script above imports JSON into postgresql using the python library, pg8000. It scales, I just used it to import 589mb of JSON on a 1Gb netbsd virtual machine.

January 19, 2015

How to Find Out What's For Sale

The above code lists the latest for-sale items from craigslist. Demo run below:

Free Rice Cooker (san jose south):
Philips High Performance Amplified Indoor (san mateo):
free couches (glen park):
Free hand truck. (santa rosa):
Free Rosemary bushes (pittsburg / antioch):
Extra Sturdy Old-School Wooden Desk (hayward / castro valley):
FREE QUEEN MATTRESS (oakland east):
Free IKEA MALM chest (santa clara):
My Wonderful free items for you (foster city):
FREE Mid Century 3 Piece Sectional by Starline Furniture | Sam Belz (oakland rockridge / claremont):
Free 6-foot folding table (glen park):
Free Jeldwen Window (millbrae):
Free TV (west portal / forest hill):
ENTERTAINMENT CENTER / Bookcase (rohnert pk / cotati):
Evenflo Jenny Lind crib (millbrae):
Free landscaping rock (vallejo / benicia):
White Christmas lights (san rafael):
stuffs:junk, grease, photo, , jewel case, bike seat (san jose west):
Oak dining table 4 chairs and ikea buffet (cupertino):
sofa, chair and ottoman (mountain view):
sofa, chair and ottoman (mountain view):
Free A/V LCD TV Cart and Scientific Glassware (for you or schools or w (south san francisco):
Ikea Stuva Bench DRAWER (san jose downtown):

December 10, 2014

How to Expose Postgres Using REST

It's always a good idea to keep all unnecessary IP ports closed on a server. Indeed, there is a long list of them for every vendor (and if there isn't, it's not because the vendor is secure...). The code below lets you expose your database instance using webpy and pg8000, so it will run anywhere, including Windows. If I get a chance to enhance this, I'll be putting a help endpoint to the application.