Tag Archives: projects

Automated export of your goodreads library

Goodreads used to have an API but they stopped giving access and it looks like they are shutting it down. A real garbage move.

I like to be able to use my data that I put in so I wrote a script to automatically download my data regularly. Then I can do stuff like check to see if books I want are in the library or keep my own list or analytics, etc.

Here’s the python script to export your good reads library, hope it helps you. I’ll put it in the public domain.

Quick Project Names Demo

At work, I’m trying to convince people that we should auto-generate at least a suggested code name for our project names. It’s an important thing for compliance and secrecy. You’d rather someone is overheard talking in the elevator about “Project Icy Gneiss” than about “the restructuring of Acme Corp”.

I wanted to make the point that if you just have a small list of adjectives and nouns you quickly get a vast space of possible names – more than we’ll exhaust.  But a working demo is more persuasive than logic.

I knocked this together last night: Projects-a-Plenty.

projects-a-plenty

Used bootstrap & angular which is kind of overkill on something this tiny.

Quick TV Pillar Mount Project.

early assembly with TV

Now that Maximum Baby is crawling I wanted to get our huge tv off of the rickety cart it was sitting on. Sam had a tv fall on her as a child and one is enough for us.

The tricky thing here is that we wanted to mount the TV on a concrete pillar.

Trying to attach a flat thing to a curved thing is tricky.  My solution was this:

  1. Got a 2×8 of Douglas Fir from my local Home Depot. They usually have crappy wood, but I managed to find a piece that looked quarter-sawn, so that’s good.
  2. Cut it to length based on the height of my TV, the height of my soundbar and allowing room for attaching some shelves later.
  3. At the base trim each side 45°, then angle the saw blade to 45 and make a cross cut. Makes a nice beveled end instead of a dramatic right angle.
  4. Use some of the scrap at the top to increase the depth so the TV mount screws get a lot of purchase depth. I used wood glue and 8 screws.
  5. Prime and paint.
  6. Attach hardware.
  7. For attaching it all to the pillar I decided to go with a friction mount. I ordered 3 endless loop ratchet straps and ratchet them tight against the pillar.

Using a friction mount is a dicey thing. Materials have two kinds of stickiness – or friction coefficients. One is how sticky two things are when they are at rest (static friction coefficient) and the other is how sticky two things are when they are moving (kinetic friction coefficient). Friction works great right up until you overcome the static friction coefficient and then it works very poorly because the kinetic friction coefficient is always lower than the static friction coefficient.

Good news is we can calculate how much force our friction mount should support! Friction is dependent on the pressure between two surfaces (the normal force) and the stickiness between them (the friction coefficient). The frictive force is going to be our normal force times the static friction coefficient.

How much normal force do we have? I’m estimating that I can ratchet around 150lbs of pressure on one of those ratchet straps. Let’s cut that a little bit because I haven’t been working out and I am an optimist. Let’s call it 120lbs. I’m using 3 ratchet straps so that adds up to 360lbs of pressure.

There’s a table on that page with friction coefficients for common materials. Looks like they say the static friction coefficient between wood and concrete is 0.62. 360lbs * 0.62 = 223.2lbs.

I’m around 175lbs – I should be able to do a pullup on this!

me doing a pull up on a ratchet strapped wood.

And I CAN!

My TV weighs 50.8 lbs, the tv mount weighs 8lbs,  my shelves weigh 11lbs and they can support 22 lbs per shelf. I forget how much my soundbar weighs. Let’s call it 10 lbs.

50.8 + 8 + 11 + 22 + 22 + 10 = 123.8 lbs. I’ve got around 99 lbs of spare capacity before we hit the limit of  my static coefficient of friction!

I feel like I can trust this not to drop on Max for a while!  How long until Max might hang off of this and make it drop? Hmmm – when is he likely to be around 100lbs? Wolfram Alpha tells me a 10 year old American is around 94lbs. I should be able to teach him not to do it by then or get another ratchet strap.

Secret Project D – a Custom DIY Dresser

Secret Project B has been so on my mind that I totally forgot to write up my Secret Project D!

thin_hudson_dresser

Sam had been talking about wanting a dresser, but none of the ones we found really fit where we wanted to put one. We liked West Elm’s Hudson dresser. Clean modern style, but it was too deep to fit our space. Sounds like a job for me!

Screen Shot 2013-07-03 at 5.57.12 AM
I made measurements and decided that the best way for a nerd like me to proceed would be to make a sketchup design. I found a sketchup model of the thin hudson and made my dresser model based on that.
I started working on this last August on nights and weekends.

Screen Shot 2013-07-02 at 1.26.10 PM

Screen Shot 2013-07-02 at 1.27.52 PM

Afterwards, I dropped by a West Elm to see how they put theirs together. That’s when I realized that I didn’t have to make the stretchers in the carcass solid – I could make them a frame and they’d be just fine. Also – less weight in the furniture will be helpful when we move it around.

Then life gets in the way – the project was on hold for months. After figuring out what I wanted to do I bought tools, and got started in December.

I decided to go with a furniture grade plywood. Not all plywood is crappy – some looks really nice. I went with Baltic Birch. It’s good looking, the beveled edges on the drawers have a sweet pinstripe on them and I could get it nearby at the Brooklyn Dyke’s Lumber1.

bevel_drawers

Plywood has a couple of other sweet properties for small apartment woodworking. The cross-grain layering of plywood makes it very stable with regard to moisture. This means I don’t have to have a jointer or planer to flatten the wood. In addition, the sheet of plywood has a continuous grain veneer – so you cutting the drawer fronts from one sheet of plywood preserves that grain across the drawers.

drawer_fronts

When you buy lumber, you have to know how to order it, and you need to know how much you want. The sales folks are used to dealing with people who order very large amounts, so not knowing makes you an irritant. You won’t get what you need. Fortunately, if you build your model in Sketchup first, there’s a handy plugin that calculates how much lumber to buy and gives you a cutlist based on your model. It even gives you a plan on how to get the most out of the wood with the least waste. That’s so helpful!

Armed with my cutlist, I grabbed a truck from zipcar and brought back three huge 4’x4′ sheets back to my woodshop in the sky.
wodshop_in_the_sky

After many nights and weekends of cutting, swearing, panicking, gluing, screwing, sanding and shellacing I got the dresser done. My woodshop in the sky has turned into a baby room, so I’ll have to find a new place to make any future furniture. If any folks are interested in either how I made it or what I’ve learned about small apartment woodworking, I could write more about that.

1ks-see-ya-later

  1. I cannot imagine the creepy search terms those folks find in their server logs  (back)

New up on the wall

 

Just got two new things framed. When Sam was little, her mom made her a cross stitch pillow with a scene of animals calmly gathered around a lion. We’ve put it in a deep shadowbox so it can go up on the wall for Secret Project Baby‘s room.
Little pillow shadow box

We also have a memento from Japan that we’ve never figured out how to properly display.  We loved the idea of Furoshiki – little cloth wrappings that you can reuse. We bought a really nice one and, after trying some other approaches, found a way to really show it off.20130428_124122_Livingston St

I also just got some new panoramas from friends for above the dining table and I’m excited to try them out!

Save Crush3r – an open letter to Ericson de Jesus

Hi Ericson,
Crusher was my favorite invite service.  I used it once or twice a year for my parties and thought it was just dandy.  I want to avoid big services because I didn’t like the way they were monetizing me and my friends. They felt gross.

I am an open source developer.  Not a great one, but a persistent one. If you are shutting down crusher and you don’t have a way to make enough money off it to support it, why not get some credit for what you made? If you want to make it an open source offering from Particle, that would be awesome.  If, instead, you’d like some help, I’d be willing to offer some hours from my side to open source it and make it easier for other folks to self-host and contribute.

I think it would be a shame if the great work you did just went poof!  I’m willing to chip in some effort to make this usable to lots of other folks.  If you can’t open source it, I’d love any advice or patterns you can suggest if I want to take this on as a project after I finish up Wordprss – an feed reader for wordpress. I’d like to have an easy evite alternative that I can self host and trust with my friend’s info.

So I’d love to hear from you – any thoughts on how to do this?

WordpRSS Status Update: pretty sweet

Current image of wordprssI’ve been using my kaizen hack time to work on a social feed reader for WordPress. Right now, here’s what it can do:

  • Install itself and set up database tables
  • Put in a few sample feeds
  • Pull feed entries down into the database.
  • Display the list of feeds
  • When you select a feed, display the items

Continue reading WordpRSS Status Update: pretty sweet

Read feeds, when you see something you want to share, hit blog

A few Wireframes for Wordprss

I had an idea a while back that WordPress is missing  a good built in feed reader.  Seems to me that Blog+Microblog+Image Gallery + feedreader + email – Freedom = Facebook.  WordPress has built up the ability to do a blog, a microblog, and post your pictures.  Everybody already has email, Facebook just has your contact list more than everything else does.  What you need is a good feed reader where your write – for inspiration, and because the web is a conversation, natch.

Here’s a quick mockup, mainly coming from my experiences with TT-RSS and Google Reader. Now, I’d really appreciate some help here – the idea is that this would something for more than just me. So, if you want, you can download Pencil Sketching – the wireframe app that I’ve used to make these wireframes. It is free and open source! You can then open up this file with all the sketch information – or clone it on github!

Read feeds, when you see something you want to share, hit blog

Tags? Folders? All at once?

Project Idea – Syncing ebook reader

The bookworm logo

Here’s the setup. O’Reilly hosts a django based open source ebook reading website called bookworm.  You can run bookworm on your own server.  I opened a ticket on bookworm’s bugtracker to provide an api method to update where you are in a book.  Next you update Aldiko (Not open source, but perhaps we can write a plugin for it) and FbreaderJ to use that method when they exit to update where you stopped reading.

Upshot: You open a book on your phone and read it.  It syncs with your server with a bookmark of where you stopped reading.  Then you go to your website, and begin reading from where you left off.  And so on. Perhaps your phone also detects when it gets a new ebook and uploads that to your server or downloads a new book from your server when one shows up as well.