Podcast: Play in new window | Download
Subscribe: iTunes | Android | RSS
Justin and Jason discuss the suspension of Justin’s 600 calorie per day diet and whether his plan to move to Ireland is such a s good idea, the process of finding a designer for AnyFu and the progress on the site mockups, the incredible rise in the value of Bitcoins and whether Bitcoins will ever really go mainstream and threaten the dollar, how the Japanese character set cracked Pluggio and made Justin confused, the importance of momentum in just about everything, Justin’s crazy work schedule and how Jason is juggling five client contracts, why Jason is considering open sourcing some of his code, whether the Singularity is near or far, the possibility of a CrunchFund, the worrisome addiction of drawing Anime, “black ops” in Pakistan, whether the world economy is near collapse and whether following the news is worth the effort, using Qwerly to clout rank your email list, why working for startups is a smart career move, how MemSQL offer’s a 30x performance enhancement over MySQL and the coolness of Google Web Fonts.
Hey.
Many fields in MySQL have a character set / collation. How character count and byte count relate depends on that.
CHAR and VARCHAR differ on the way they are stored.
CHAR(10) will always consume a constant amount of memory, where _ is clean (wasted) memory:
__________An empty CHAR(10)hi________hi stored in a CHAR(10)abc_______abc stored in a CHAR(10)So use CHAR when your values basically have the same length. Language codes, hashes …
VARCHAR(10) will look like this in memory:
0|An empty VARCHAR(10) field2|hihi stored in a VARCHAR(10) field3|abcabc stored in a VARCHAR(10) field(Ofcourse that prefix are two reserved bytes and there is no |)
That means that VARCHAR(200) wouldn’t require more memory for the same values. Use VARCHAR for text that differs in length, such as tweets.
TEXT depends hugely on the storage engine. Text isn’t (of course it is, but it can be loong) limited in length. Text will be stored outside of your actual table and referenced from there. Use VARCHAR if you can.
Yours,
Niklas
Since Niklas beat me to the SQL question, I thought I’d make a quick point about the fixed number of total heartbeats, and being lazy vs working out. (Just killing some idle time on vacation, I know this is silly).
A person in shape will have a lower average resting pulse for the 22-23 hours not spent working out, than a person not in shape.
A quick DuckDuckGo search (http://bit.ly/aOesyy) suggests that a resting heart rate of a fit person is between 50 and 70, and the resting heart rate of an unfit person is between 80 and 90.
Unfit, no exercise:
(80 to 90) bpm * 24 hours = between 115 200 and 129 600 heartbeats/day
Fit with 2 hours aerobic exercise per day:
(50 to 70) bpm * 20 hours + 152 bpm * 2 hours = between 78 240 and 102 240 heartbeats/day
Assuming constant heart rate for the whole period when not exercising (climbing a flight of stairs or doing other similar daily activities would increase the unfit persons heart rate more than that of the fit person). 152 bpm for exercise is 80% of maximum heart rate for a 30 year old person (http://bit.ly/qM9ee6).
So I guess I’ll be seeing you in the gym then Justin.. 😛
Another great show guys!
Since it looks like SQL is well covered, I thought I’d chime in on the idea of “the Singularity” as I find it really interesting and can’t help myself.
The main thing that I have picked up about the Singularity (and whence the name is derived from) is that accurately predicting what will happen beyond the singularity is impossible. It is a point in time where something allows technology to advance at such a rapid pace that the implications for human society are impossible to predict. There are many different potential triggers for the Singularity, but they all involve the arrival of super intelligence. Things like the development of the first real Strong AI, genetic enhancing humans, neural interfaces to computers, ET landing (I’m looking at your Jason!), time travel and nanobots spring to mind.
The name Singularity is derived from using a black hole as a metaphor to describe this event. With a gravitational singularity (effectively black hole) there is an event horizon beyond which it is impossible to see anything and the traditional laws of physics break down.
So, whilst our technological progress in our understanding of biology may be linear, there are other options that might bring it about.
Fascinating to think about, but also very frustrating because by it’s very definition you can’t think about it too much! 🙂 Something your touched on is whether or not it’s going to be a good thing for humanity or bad. Should we be trying to delay it or rush towards it? I think it is inevitable, either that or we end up destroying ourselves completely with no resulting output.
@Jason, something I am curious about WRT to Japanese tweets. Are people able to tweet in Kanji? With each glyph representing a word, 140 words is quite a long message instead of the short message that a tweet is meant to be.
If that’s the case twitter would really have a different dynamic for Japanese people. I mean this blabbering comment is under 80 words :-p
What’s the story morning glory?
Interesting show, especially the web development discussion.
@Stian – Wow thanks for the calculations! @James McGrath – Great question 🙂 My suspicion is that it is the phonetic alphabet, but I would need someone in the know to answer for sure.
A quick correction to my post.
Fit with two hours of aerobic exercise is between 84 240 and 110 640 heartbeats/day. (Previous post used 20 hours not exercising instead of 22)
@justin: Looks like you can tweet in Kanji: http://twitter.com/#!/kanjidaily/status/93490583439540226
This gave me an idea: anyone want to create a url shortener that uses Kanji and other glyphs? You could make much shorter URLs 🙂 Mind you, it seems that twitter has introduced its own shortened into the web interface now, so I wouldn’t want to be competing against that!
p.s: what’s with the lack of links in this blog post? Methinks you must have been telling the truth about being super busy!
@James – Jason’s being slack as usual! 😉
@James – Yeah, sorry about the missing links in show description. I’ve been really busy trying to get caught up on client work, so I kind of punted on the links. But I’ll try to find some time today to get that done.
@Niklas – Thanks so much for writing up a clarification on the difference between storing char, varchar and text fields. That’s pretty much what I thought, but it’s nice to get it settled and have it clearly explained.
@Stian – Your heart rate calculations are very interesting. You should right it up as a blog post. If you don’t have a blog or want to take the time to write it then let me know and I’ll write it up and give you attribution.
Any chance of the song from this podcast being available for download? Much like Pokemon, I am trying to catch ’em all.
Perhaps you could put together a Techzing Sountrack cd as a fundraiser? (Maybe you could guilt Alex into contributing some tracks as well). I would buy a couple.
@James – Okay, I added links to the show description. Now I can knock that off my to-do list. 😉
@justin I really liked the song at the end. You had a lot of talent!
Great song at the end, I could definitely see listening to that on a consistent basis. 🙂
@jason I hope you aren’t suggesting you have more important things to do than putting up links to save me from wasting 10s of seconds at google? 😉
Thanks for the links! Looking forward to the next episode 🙂
Hey guys, Another great episode.
Looking forward to the next interview show, especially since you made some connections at Micro Conf.
My main takeaway from this show: “The best job stability you can have is constantly developing and evolving your skills with the latest and greatest technologies. ” – Jay Rob
Hey guys,
I was thinking you could try using stackoverflow.com points as one indicator of rep on anyfu. They have an api and it could prove helpful especially in the early stages when people haven’t got reviews yet. [**just an idea, I don’t have any association or even very many points on stackoverflow/stackexchange]
PS: I have been listening to your podcast since episode 50 or there about’s, Keep up the great work!
@alanlarkin
@Rory – Yep, I think that would be the best takeaway for sure and I like the way summarized it 😉
@Alan – Yep, that’s definitely something we’ll take into consideration in our expert approval process.
Gah! I need my TechZing fix, where are you guys! 🙂
@Matt S – Sorry about the delay. We’ll be back in action this coming weekend.
I am disappointed that Jason continues to denigrate Perl.
Stay classy Jason.
@Len Jaffe – I don’t recall. What exactly did I say bout Perl?
@jason – “… becuase you don’t want to write your web sites in Perl.”
@Len Jaffe – Are you sure it wasn’t me who said that? I have issues with Perl because of all the dependencies. I can’t recall. How many mins seconds in is it? (Don’t want Jason to have a bad rap if it was something I said!)
@justin – nope, it was Jason. It was kind of a throw away line, and you guys didn’t dwell on it. It was in the context of keeping up with all of the new developments in languages and tools, and was the last word on the topic.
I’m interested in hearing your about your dependency issues, either via PM or here in public. Maybe I can offer some insight or succor, or get something fixed.
L.