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
ContainerSite
attribute: contentIdattribute: siteId
ItemManagement/addItemForContentService1SiteAccountManagement/addSiteAccount1
ItemManagement/getLoginFormForContentServiceItemManagement/getSiteLoginForm

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): http://sfbay.craigslist.org/sby/zip/4853319800.html
LEATHER OFFICE CHAIR (santa clara): http://sfbay.craigslist.org/sby/zip/4842745192.html
Philips High Performance Amplified Indoor (san mateo): http://sfbay.craigslist.org/pen/zip/4853319255.html
free couches (glen park): http://sfbay.craigslist.org/sfc/zip/4853317431.html
Free hand truck. (santa rosa): http://sfbay.craigslist.org/nby/zip/4853308752.html
Free Rosemary bushes (pittsburg / antioch): http://sfbay.craigslist.org/eby/zip/4853309196.html
Extra Sturdy Old-School Wooden Desk (hayward / castro valley): http://sfbay.craigslist.org/eby/zip/4853305443.html
FREE QUEEN MATTRESS (oakland east): http://sfbay.craigslist.org/eby/zip/4853304845.html
Free IKEA MALM chest (santa clara): http://sfbay.craigslist.org/sby/zip/4853302532.html
My Wonderful free items for you (foster city): http://sfbay.craigslist.org/pen/zip/4841220459.html
FREE Mid Century 3 Piece Sectional by Starline Furniture | Sam Belz (oakland rockridge / claremont): http://sfbay.craigslist.org/eby/zip/4853300002.html
Free 6-foot folding table (glen park): http://sfbay.craigslist.org/sfc/zip/4853297053.html
Free Jeldwen Window (millbrae): http://sfbay.craigslist.org/pen/zip/4853294992.html
Free TV (west portal / forest hill): http://sfbay.craigslist.org/sfc/zip/4853292185.html
ENTERTAINMENT CENTER / Bookcase (rohnert pk / cotati): http://sfbay.craigslist.org/nby/zip/4853293213.html
FREE BOOK GIVEAWAY AFTER SALE (palo alto): http://sfbay.craigslist.org/pen/zip/4853288648.html
Evenflo Jenny Lind crib (millbrae): http://sfbay.craigslist.org/pen/zip/4853291170.html
Free landscaping rock (vallejo / benicia): http://sfbay.craigslist.org/eby/zip/4853290353.html
White Christmas lights (san rafael): http://sfbay.craigslist.org/nby/zip/4853288209.html
stuffs:junk, grease, photo, , jewel case, bike seat (san jose west): http://sfbay.craigslist.org/sby/zip/4853256207.html
Oak dining table 4 chairs and ikea buffet (cupertino): http://sfbay.craigslist.org/sby/zip/4853287277.html
sofa, chair and ottoman (mountain view): http://sfbay.craigslist.org/sby/zip/4853282364.html
sofa, chair and ottoman (mountain view): http://sfbay.craigslist.org/pen/zip/4853280610.html
Free A/V LCD TV Cart and Scientific Glassware (for you or schools or w (south san francisco): http://sfbay.craigslist.org/pen/zip/4853261265.html
Ikea Stuva Bench DRAWER (san jose downtown): http://sfbay.craigslist.org/sby/zip/4853276958.html

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.