5.15.2015

extracting my notes from drafts app database

well now. while digging into the content stored in my iphone, i found out the drafts app which I'm slowly abandoning by removing my content uses a sqlite3 database. previously I had no way to bulk-extract my notes.
# sqlite3 Drafts.sqlite
SQLite version 3.8.2 2013-12-06 14:53:30
...
sqlite> .tables

ZSPMANAGEDOBJECT  Z_METADATA        Z_PRIMARYKEY 

sqlite> .schema zspmanagedobject
...
CREATE TABLE ZSPMANAGEDOBJECT (
Z_PK INTEGER PRIMARY KEY, 
Z_ENT INTEGER, 
Z_OPT INTEGER, 
ZARCHIVED INTEGER, 
ZHIDDEN INTEGER, 
ZPINNED INTEGER, 
ZCREATED_AT TIMESTAMP, 
ZLAST_ACTION_AT TIMESTAMP, 
ZMODIFIED_AT TIMESTAMP, 
ZUPDATED_AT TIMESTAMP, 
ZGHOSTDATA VARCHAR, 
ZSIMPERIUMKEY VARCHAR, 
ZCOMPLETED_ACTIONS VARCHAR, 
ZCONTENT VARCHAR, 
ZLAST_ACTION VARCHAR, 
ZTAGS VARCHAR, 
ZUUID VARCHAR );
...
select z_created_at, z_content from zspmanagedobject;

produces the time-stamped draft notes, including notes that were deleted.
451329756.316168|supermarket notes, 2015: I find the selection of shaped,
filled, fried, baked, toasted, flavored, seasoned corn products entirely 
inadequate for a healthy diet.
451357888.003267|"what about the duck?"
"extra crispy!!"
-- looney tunes back in action

5.09.2015

ira glass's actual quote

never mind the abstract reader's digest quote poster that is going around. this is my transcription of what Ira Glass actually said in [ the first part of] his video. it is wonderful advice, especially about the discipline of producing work on a deadline. [ira glass on storytelling, part 3]:

"Nobody tells people who are beginners. I really wish someone had told this to me. Is that [if you are watching this video, you are somebody who wants o make videos right?] all of us who do creative work, we get into it. we get into it because we have good taste. you know what I mean? like you want to make TV, because you love TV. there is stuff you just like, love. ok so you got really good taste. you get into this thing … that i don’t even know how to describe it, but there is a gap. for the first couple of years you are making stuff, what you are making isn’t so good... ok, its not that great. it's really not that great. its trying to be good, it has ambition to be good, but not quite that good. but your taste, the thing get you into the game, your taste is still killer. your taste is good enough that you can tell what you are making is a kind of disappointment to you, you know what i mean? you can tell it is still sort of crappy. a lot of people never get past that phase. a lot of people at that point, they quit. the thing i would just like say to you with all my heart is that most everybody I know, who does interesting creative work, they went through a phase of years where they had really good taste, they could tell what they were making wasn’t as good as they wanted it to be. they knew it felt short. [some of us can admit that to ourselves, some of us less able to admit that to ourselves] we knew like, it didn’t have that special thing that we wanted it to have. [...] everybody goes through that. for you to go through it, if you are going through right now, just getting out of that phase, if you are just starting out and entering into that phase, you gotta know it is totally normal and the most important possible thing you can do is do a lot of work. do a huge volume of work. put yourself on a deadline so that every week or every month you know you’re gonna finish one story. you know what i mean? whatever its gonna be. you create the deadline. it is best if have somebody who is waiting work from you, expecting work from you. even if not somebody who pays you, but that you are in a situation where you have to turn out the work. because it is only by actually going through a volume of work that you are actually going to catch up and close that gap and the work you are making will be as good as your ambitions."