This is Why You Save Everything Locally!

So earlier this week I was googling something related to SQLite databases, and came across a rather interesting topic on reading them locally using Javascript. At the bottom of the ‘answer’, I found a link to a blog with more information: http://blog.developeronhire.com/create-sqlite-table-insert-into-sqlite-table/

And what did I find when I went there? This:

An unhappy message saying that the owner of the blog had exceeded their bandwidth. A google Cache of the page seemed to be a good alternative, until you realize it doesn’t contain anything useful. So in other words, I have no idea if the content on that page would be useful or not in my quest!

This is why these days, when I do find content that’s useful, I immediately fire up Evernote. I’ve written before about how I use Evernote for scanning, and other neat things, and if you weren’t convinced then, just wait till you hit a 509 error in the future – then you might want to either start using Evernote or, at the least, the “Save page” feature of your browser to grab an HTML copy!

#26 Flash

It had been 6 months since the day when Mark found the list in an old hoodie he was putting on for the first time that September. It wasn’t too remarkable – just a list of chores for the day, 11 months ago.

call insurance agent
buy eggs
call Kelsey’s school
drop off Jo’s car
print resume

Mark paused as he recalled the day he wrote the list. He’d just been in an accident the day before, hence the call to his insurance company. Jo was having her boss over for dinner, and needed the eggs. Kelsey had been caught smoking in the bathroom at school, and her principal wanted to speak to her father. Jo’s car was acting up, and he was tasked with getting it fixed. On top of that, he had been told a few days earlier that his temporary assignment, which he hoped would be made permanent, was ending. He’d have to get his resumé out there once more. It was just another rough day after a series of rough months in the life of the 43 year-old divorced father of 1 troubled teenager, who was trying to make it work with his fiancé of two years. The previous 6 months had been hard on her as they struggled with her parent’s deaths. Kelsey could care less, but Mark had grown to think of Jo’s parents as the ‘good’ in-laws he’d never had with his first wife.

But all of that was before he got the call that changed everything. He remembered that his phone rang while he was buying the eggs listed on the note. He could barely hear the voice on the other end as he stood in the supermarket, and he didn’t recognize the number. Finally after a few moments of exchanging whats and huhs, he figured out it was Jo. She was at the doctor’s office, and needed him to pick her up. He didn’t understand – she had his car while he drove Kelsey’s old beater. Why couldn’t she drive home? When he reached the doctor’s office, Jo’s doctor took him into her office. They exchanged pleasantries, and while they talked for at least 30 minutes, Mark couldn’t remember anything after he heard the word “cancer”.

She hung on for 5 months, but it was aggressive and it took her. Today, six months after the funeral, he found himself thinking how 11 months ago, dozens of tiny annoyances kept him aggravated and upset.  In a flash, all of that changed. Somehow during her struggle, he found a job that was sympathetic to what he was going through, allowing him to start a few weeks after the funeral. Kelsey came out of her ‘rough’ period and tomorrow he was scheduled to drop her off at school. It was hard without Jo, but he was getting through. He crumpled up the old list and threw it out as he replaced it with the shopping list of things to buy for Kelsey’s dorm. Life wasn’t less hectic now, but given the alternative he experienced in those 5 months, he was happy to have a mile-long list.

“Ready to go, Dad?”, Kelsey said as she came bounding down the stairs. “The stores might be crazy busy today!”.

“Yep, I’m ready for anything”, Mark said in reply.

[SSDay]

The Bookmarklet Combiner is Awesome – and So Are These Bookmarklets

A bookmarklet is a small piece of javascript code that is run by clicking on a bookmark on your browser’s toolbar. Lots of sites have them, and I use a bunch in my daily life. One thing that’s annoying is the requirement that each has it’s own bookmark on your toolbar – so after 3-4 bookmarks, you’re out of space! Thankfully there is a really cool tool named Bookmarklet Combiner which allows you to copy the javascript code from each of your bookmarklets into one “super” bookmarklet.

Here’s how it works. Load up the Bookmarklet Combiner and put in the Title and URL of each Bookmarklet you want to combine. You can get the Bookmarklet’s URL 1 of 2 ways.

  1. Open up your browser’s bookmark manager, locate the bookmarklet, and copy the code. It probably starts with ‘javascript:’
  2. I was able to drag the bookmarklet directly from the toolbar to the URL field in my browser (Chrome). It kept the “URL” text in the box, so you’ll want to remove that so that ‘javascript:’ is the first thing in the URL box.

Now add in all of your Bookmarklets and use the rest of the page to customize the combiner to your liking. Finally you’ll drag your new bookmarklet to the toolbar. Clicking on it should produce a full menu of bookmarklets you can then choose to run! Better yet, the Bookmarklet Combiner will give you a special link you can use to come back and edit your bookmark in the future!

So you say you’d love to combine some Bookmarklets but you don’t have many of them? Well here are the ones I use, they’re pretty awesome

There you go – a great collection to get you started!

#25 Road Warrior

He settled into the seat with the drink.

“That kinda tastes like chocolate milk”, she said as she glanced over at him. He nodded in reply, and she went back to her papers.

He opened up the lid of the laptop and connected the wireless. A few dozen new emails poured into his inbox just as quickly as the coffee had poured into his cup moments earlier. He braced himself – it was going to be a long afternoon.

That morning, he’d visited several clients, each more demanding than the last. He found himself with several different notes from the morning, waiting to be entered into the customer database he was logging in to. A quick scan of the emails revealed three that would need immediate attention, the rest could wait until the notes were entered. Given the loud complaints of two of the clients he’d met this morning, the faster the notes were in the system, the better. They were the type that would call up this afternoon and demand access to the perks he had recently capitulated to. No notes meant the representative on the phone would have no idea what they were talking about.

A quick sip of the drink and a long grimace as he found that Client number 1 had already called, and met with resistance by an uninformed rep. The coffee grew cold as he wrote three quick emails of his own to put out the fire he knew was starting.

He had been in this position for far too long, driving his life away, visiting clients who couldn’t care less about his life, immersed in their own struggles. About two hours into his work, he looked up at his surroundings. No one who he had seen when he arrived at the coffee shop were still there. The attendants were different, shift change had happened an hour ago. He had lost himself in the world of his work, unaware of the changes. Honestly, this coffee shop, in the middle of his territory, was more familiar to him than his own office, which he only saw in the mornings during the meetings.

“Hey Rob, back here again?”, the night manager said as he wandered out from the back.

“Yea, I suppose I should leave a bigger tip!”, he man said wearily to the manager, Joe.

“Eh, you’re not the one we wish would leave!”, Joe said with a smile. “You at least buy something, or several things, depending on how long your work keeps you here. And you do tip, which is very much appreciated by my staff”.

“Everyone has to make a living, right Joe?”, Rob said. He had just written the last email of the day, and was packing up his laptop.

“You want a refill for the road?” Rob gave Joe his cup in an appreciative manner. Joe knew that Rob seldom asked for a refill, even though his loyalty card, punched religiously, entitled him to a dozen or more if he asked.

“Joe, do you mind if I ask a question about your work?”, Rob said as he walked up to the counter.

“Sure Rob, you’ve hung around here long enough to notice how everything works though – not much I could tell you about!”, Joe said as he handed Rob the coffee.

“How many emails do you write a day?”, Rob said, half jokingly and half serious.

“Oh, I don’t know, maybe 4 or 5 – just stuff to the day manager, emails to our regional guy, nothing major, more FYI stuff”, Joe said.

“Really… and how often do you have to deal with difficult people in a day?”, Rob asked. He assumed that retail must be a special sort of hell, given his experience in business to business sales. People must be even worse to cater to, especially those seeking their daily caffeine rush.

“Actually not too many”, Joe replied with a smirk, “1 less if you leave”.

Joe’s grin made Rob laugh as he started walking out. As he got to the door, Joe called out

“Have a good night Rob, see you tomorrow!”. Rob waved back as he left.

Over the course of the next few weeks, the man spent his usual hours at the coffee shop, working and drinking enough coffee to keep him awake through the drive home. He was growing more and more tired of his job, but honestly couldn’t conceive of doing anything else. He’d been in sales for a long time, had an income to maintain, and while it wasn’t perfect, there wasn’t anything else he could do.

Until the day Joe came up to him around closing time. It had been a pretty bad day email wise, and Joe could see that the man was emotionally destroyed by the demands of his job.

“You know Rob”, Joe began “Our day guy is leaving next week – he’s going off to become a regional manager somewhere. Want to apply for his job?. Rob was surprised by the invitation. He’d never managed anything in retail before, never even worked in food service or retail in his entire life. Why would Joe ask him this.

“Oh you can’t be serious”, Rob said in reply. “I don’t know anything about this job”. Joe smiled.

“Actually, I think you do. I’ve been watching you and realized that you spend probably 90% of your time doing just one thing – trying to make your client’s happy”. Joe said.

“Well, a happy client is one who will stick around, and not darken my email door quite so much”. Rob said in reply.

“This job is really no different – managing this place is just about keeping people happy, employees and customers. There’s a small amount of corporate junk to deal with, and some annoyances, sure, but it’s not as bad as one would think.”, Joe said as he walked over to the door to lock it.

Rob looked at Joe, and for the first time realized that he wasn’t just a kid working here till he got a real job. Joe was a man, about the same age as Rob.

“You have any kids, Joe?”, Rob asked.

“Three”, Joe replied, “One in college, two in high school”.

Joe could see the skepticism in Rob’s eyes.

“The job pays enough – you’re not going to get rich, but you may add some years back on to your life in exchange for a little bit less money”, Joe grinned, “After all, what would you rather be, rich and dead or comfortable and able to attend your grandkid’s weddings?”.

The man started the new job a few weeks later. It was surprisingly easy to transition into, since he spent so much time there already. And it helped that the day shift remembered his generous tips, and were open to listening to his experiences while telling him theirs. After a few months, Rob noticed a man had started frequenting the shop in the early afternoons, sitting where he used to sit, and feverishly pounding away at his keyboard as Rob wiped the counter and counted the cash drawer. He couldn’t ponder the man for long though, a family he knew walked in the door and waved to him before they even reached the counter.

[SSDay]

#24 I Heard It From a Friend

All lines from this poem are lyrics, since songs are simply music and poetry. Each lyric is linked to the song’s YouTube video.

I heard it from a friend who heard it from a friend who heard it from another that I’m winning a hundred men or more‘s thoughts of you.
I’ve been searchin’ my soul, I took a little risk, with my fresh pressed khakis in a slingshot.
Never thinking of the future, I had sweet love but I lost it.
Neither you nor I’m to blame, it’s all about knowing what someone is feeling.
I’m a toddler with a complex toy, you always seem to give me another try.

Maybe you can remember yourself, together we’ll make history, that rebel moon is shining.
Don’t you want me?
I’m just a modern guy.
Feel it all with a willing heart. 

Forget all that, I’m on the right track.
To make it better, Baby get ready. 

Push me back to you.

I’m a hazard to myself. 

Alright, ride ’em

Bonus points if you can figure out the pattern I used to pick the next song.

[SSDay]

#23 Does Dinosaurs Wear Socks?

She sat there quietly, lost in her work. The keyboard clicked away as she wrote another email, the icons growing smaller and smaller on the screen, the more work she did. Pages of text, documents scattered about, and an overflowing table of material. She was working in the library, and seldom noticed even the slight distractions the workplace afforded. She worked for a few hours, then packed up, and headed out to the subway.

She had a 20 minute ride back to the small apartment she called home. It wasn’t much, and it wasn’t exactly where she wanted to be in her life, but it was where she was at that moment. She was resigned to that, and on the worst of days she longed to escape. The best of days were almost acceptable, and the absolute best of days allowed her to feel at home, even so far away from her family.

As she sat on the train, a rare luxury, she lost herself in her mind filled with work. Things still to be done tomorrow, things to be done tonight, things that should have been done weeks ago, and things that she realized wouldn’t get done despite her best intentions. These always fell into the ‘personal’ projects. Work paid the bills, and work got done.

“Does dinosaurs wear socks, mama?”, the little girl three seats down yelped loud enough for the entire car to hear. The mother was tired, a long day behind her, hoping that her daughter would stop asking questions about extinct animal’s footwear.

“I don’t know”, she mumbled to her child.

The little girl wasn’t happy with that response. She had recently learned about dinosaurs – these great big huge beasts that dominated all around them. They were magical in that they didn’t have to do anything all day other than look cool and eat things. They didn’t have parents to listen to, teachers to mind, or rooms to clean up. They weren’t bossed around to death, they were the boss. And their feet may have gotten cold, for all the little girl knew, and so would they have dinosaur sized socks or not? She had to find out.

So the little girl jumped up and wandered down the slim aisle of the train car. The woman, still pre-occupied with her thoughts, became aware of the little one’s presence approximately a second before she spoke.

“do you know if dinosaurs wear socks?”, the girl asked the woman.

Any other day, the woman would have smiled, but politely said “No” or “I don’t know”. But something in the girl’s eyes spoke to her. The girl, no more than 4, seemed to have nothing but excitement and wonderment in her eyes. No worries about the world, about asking people she didn’t know strange questions, or about spending her time on frivolous Jurassic explorations. No, the little girl just seemed innocently interested in the claw coverings of the T-Rex, or of Mosasaur mitts.  Something begged the woman to indulge her.

“I suppose they must have”, the woman began. “Dinosaur’s didn’t live in houses”.

The girl’s eyes lit up further. “Ya… they lived outside!”, she eagerly said. The mother looked slightly down the car to see whom had started speaking to her daughter. Seeing the woman, the mother nodded in tacit endorsement of the interaction, happy to have the child spend time bothering someone else for once.

“And do you know what it’s like outside?”, the woman asked.

“It’s COLD!”, squealed the girl.

“Yes, so they must have had socks to keep their feet warm”, said the woman. The little girl nodded in approval.

Ten minutes later they had parted ways, their chat expanding to all sorts of dinosaur clothing and lifestyle. The girl, tired from her long conversation, curled up in the stroller her mother pushed, and the mother smiled at the woman, thanking her for making the child a bit more manageable. The woman would never see the child or mother again, thus was life living in the big city. But as she walked away, she mused to herself about the interaction.

“Life in the city is cold. But perhaps every so often, breaking away from the concerns of my life can make it warm. Just like the socks that the dinosaur’s wore”

Dedicated to a friend.

[SSDay]

#22 Jim the Bunny Learns to Knit

Jim hopped through the forest with a giant grin on his face. He’d just grabbed a bunch of files from Jabberpaw, and had covered his internet tracks by paying off Sylvester the snake. Now he just needed to get home and load up his found files.

On the way, he tripped, since he wasn’t the most coordinated bunny in the world. In doing so, his Lucky Rabbit’s Foot USB drive fell off of the tuft of fur he’d attached it to, and it fell into the mud puddle. For the next 3 days he spent most of his time trying to remove all of the mud from the contacts so that he could read the drive once more. This was annoying, so he decided he needed to buy a cover for his drive.

Unfortunately, Amazon doesn’t sell covers for Lucky Rabbit’s Foot USB drives. Jim was in a proverbial, thankfully not actual, pickle. His only solution was to make one. So that’s how it came to be that he hopped over to the sheep flock, and found Kay the sheep.

Kay was well known throughout the Woods as the premier knitting expert of all of the Animals. She used only the best yarn, which she stole off of her husband, Jay the Sheep. Jay had the best wool in the Woods, when he had a chance to grow it before Kay shore it off.

Kay was impressed to see Jim hop up.

“Here to learn to Knit”? She asked.

“No, I just want a cover for my USB drive”, he responded. Kay always wanted to teach people to knit.

“OK, that’ll be $400”, Kay responded without batting a sheep eyelash.

“WHAT?!?”, Jim’s bunny jaw dropped. Prices had gone up considerably since the last time he’d worked with Kay.

“Well, Jay’s charging more for the raw materials, but really the bulk of the price increase is that I’m just too busy to help you these days, Jim”, she said with a grin, “You see, I’ve become a world famous knitting sheep”.

Jim was incredulous. He’d been a customer of Kay’s for years. She’d knitted his tail cozy, his carrot-shaped shopping bag, and his winter coat.

“Can’t you cut me a break?”, he asked.

“Well, I might have a solution”, she responded.

So it happened that Jim the Bunny was compelled to learn to knit, to become Kay’s assistant, in exchange for a custom lucky rabbit foot’s USB cover. Initially reluctant, Jim was at least consoled by the regular pay. Plus he was able to trade his knitted work for access to Jabberpaw’s extensive media library. The bear might have been a loaner, but he did enjoy custom sweaters.

[SSDay]

#21 Probably, Maybe, Sorta, We’ll See

Probably, Maybe, Sorta, We’ll See
A parent’s first line of defense
Non-commitment in words to thee
Leave children’s nerves tense.

Perhaps, Might, If you’re lucky
Hauntingly dance through the little mind
Will I get the toy? Will I go see a friend?
My scattered desires all entwined

Remember dearest parents, the times when you
thought you just might burst while you wait
Help your young ones to get through
life until that far-off date!

[SSDay]

#20 Jabberpaw FAQ

Everything you’d want to know about our torrent loving bear friend.

Name: Jabberpaw T. Mezzyuup

Occupation: Scary bear in the woods

Age: 10

Favorite Color: Grey

Favorite Food: Bunny rabbits

Favorite Leisure Activity: Watching movies, chilling in his cave, terrorizing smaller animals.

Best Friend: Sylvester the Snake

Internet Service Provider: TurtleNet (For now… may be switching to RodentWire in the near future).

Jabberpaw, known as “Jabber” to his friends and soon to be eaten enemies, lives in the Woods along with the lovable cast we’ve already met in previous stories. Jabber spends most of his time sleeping, or wandering around looking for food. When he isn’t hungry or tired, he retires to his massive home entertainment set up, and watches various television shows (such as Jersey Shore, American Idol, and anything on Bravo), and a number of movies he’s downloaded or streamed. He has an active subscription to Netflix, Hulu Plus, Amazon Prime, and a variety of other lesser-known services. He frequently trolls usenet groups looking for various unsavory things. He also enjoys fishing, with his favorite rod being simply his ginormous paw. Jabber was born of Mr. & Mrs. Mezzyuup, who moved from the Woods to Florida a number of years ago. Jabber is an only child, introverted, and typically known as a loaner. He briefly dated Bob the Turtle’s cousin, Rita, but it didn’t work out.

[SSDay]

#19 Too Much Time

I was in a hurry, but now am not
Time is abundant, flowing, and hot
I sit and I wait, unaware of the time
Consumed by trouble, verse and rhyme

Switching perspective, it changes me so
When in a hurry, I always had to go
But now I’m calm, yet worried as well
I wish for moderation, to unlock the cell.

[SSDay]
Also, this is somewhat of a companion to #17, In A Hurry