Posted on Leave a comment

SQL Query Conundrum

Here’s a interesting SQL challenge:

Say you have a query returning a result set that in some cases one row cancels out another. For example, let’s say there are 5 columns: A B C D E. One result possibility is: row 1- A B C 4 E with row 2- Z Y X 9 E Naturally those are completely separate data elements. But when row 1 is A B C 4 E and row 2 is A B C -4 E row two is a data correction to row 1 (think double entry accounting) and row 1 and row 2 need to be excluded from the result set. So, right now if the result set returned 20 rows and had the situation above, we really only want to be returning 18 rows. What’s a good approach to this?

Here’s a better representation of the problem:

Row Name Account Rank Value Status

  1. G H I 5 J
  2. A B C 4 E
  3. A B C -4 E
  4. Z Y C 4 E
  5. A B C 7 E
  6. Z Y C 22 E

We really want to return rows 1, 4, 5, and 6.

Posted on Leave a comment

This NSA thing is old news

Can’t believe I forgot about this! I watched this story with great interest in the wayback. This started in 2003 and was publicly outed in 2006:

"the NSA built a special room to receive data streamed through an AT&T Internet room containing “peering links,” or major connections to other telecom providers. The largest of the links delivered 2.5 gigabits of data — the equivalent of one-quarter of the Encyclopedia Britannica’s text — per second,"

[Source, The Washington Post, A Story of Surveillance]

Google "Room 641A" for more information.

Posted on Leave a comment

Wired claims Google Reader killed because RSS delivers news old school

Wired makes a good point in this article but they write from a newscentric view…it reads like someone in "the industry" writing about "the industry" and screams that Wired has lost touch with the non-industry Internet user who doesn’t view everything as news. I blog. Is that news? In essence yes but you don’t need one of my blog posts flashing across your breaking news app. I write stuff that, according to my stats, people read three months after I write it. My flickr rss feed? Not news. But it is news. Yes, we could lump all media into news but that’s not really what Wired is talking about. Wired is claiming that as content is produced (they call content news) that people want it immediately. Frankly, that’s the Facebook model. And the Facebook model irritates me to no end. I miss things. Granted, there are not enough minutes in the day for me to consume everything but with an RSS reader I can selectively choose what I skip. Wired’s approach would deem that because I was in meetings in the morning, content that was published in the morning is not relevant to me.

Back in 2007 I would tell my clients that people come to the Internet for three things:

  1. Information
  2. Utility
  3. Entertainment

[Source, RealityMe, Why do people web?

I contend people go to the Internet in that order but you can go back to 2007 for that explanation. Getting back to Wired’s article, my point is that even as a very connected person, most of my day is not spent consuming media. I spend my day doing my job. Once home, I want to catch up on things. I peruse the content I enjoy on the Internet which might be an audioboo by Christian Payne, or a podcast by Jason Jarrett, or an insight from Cathy McCaughan. I don’t need it shoved at me as it happens and if that is why Google killed Reader, they made a poor decision.

Posted on Leave a comment

Query of queries reports runtime error

So are you pulling your hair out because your query of queries is returning an error "Query Of Queries runtime error."? The solution is rather simple. In your query that is feeding your QoQ, you probably have a column that is of datatype nchar. Cast that to a varchar and life will be good. Do the cast in the source query not the QoQ. eg. "CAST(foo AS varchar) AS bar" You’re welcome.

p.s. Yes, you can cast it to the same column name eg. "CAST(foo as varchar) AS bar" Case doesn’t matter.

Posted on Leave a comment

Programmer/Artist

As a programmer, I often feel like an artist reusing the same canvas over and over and no one ever looks at the painting. As I make modifications and improvements to a program, my previous creation vanishes often without having been appreciated by another programmer. I write tomes of code and a vast percentage of that writing ends up in the fire.

Posted on Leave a comment

The Crux of the Apple iTunes Problem with Multiple Devices in One Household

This sums it up nicely:

Prior to iOS 5, sharing an Apple ID wasn’t really a problem because its main purpose was for purchasing content on iTunes, using it for support purposes and purchasing items on the online Apple Store – all tasks that worked fine when sharing an ID.

[Source, macstories, iOS 5 & iCloud Tips: Sharing an Apple ID With Your Family]

That sums up our approach pretty much to date. But here is the problem:

Now that Apple ID is tied to a bunch of services, a lot of which involve personal and private data that you don’t necessarily want to share with others – even family members.

[Source, macstories, iOS 5 & iCloud Tips: Sharing an Apple ID With Your Family]

And because paranoid society is paranoid, children under 13 cannot have an Apple ID.

Additionally:

The other issue is that iCloud involves a lot of data synchronization and this doesn’t work well with multiple people as it results in data conflicts and devices syncing data (such as calendar events) that are meant for another person in the family.

*emphasis added [Source, macstories, iOS 5 & iCloud Tips: Sharing an Apple ID With Your Family]

Naturally, each owner of an iDevice wants to be able to use services specific to that user. As parents, we want to control when the children purchase, how much they spend, and we want to simplify the syncing of their devices without having to put a Mac in each room of the house. There are six services that use an Apple ID:

  1. iCloud
  2. FaceTime
  3. iMessage
  4. iTunes Home Sharing
  5. iTunes (includes App Store and iBookstore)
  6. Game Center

Read section 3 from this great article

Posted on 4 Comments

Why does Apple make this so confusing?

Goals

  • Get beyond setup so the children can play on their iPods.
  • Sync their iPods through a shared Macbook Air without compromising my wife’s iPhone and iPad settings.
  • Allow the children to Facetime and iMessage their friends without compromising my wife’s contacts and without using her account.

Situation

We have one Macbook Air in the house. My wife syncs her iPhone with iTunes on this Macbook Air. For Christmas, the 7 year old and 10 year old received iPods. Yes, I understand DRM. Rovio Entertainment would much prefer I buy Angry Birds 3 times instead of one. I have no problem with that although I do feel like the model for DRM for music fails when compared to the physical world of records and CDs.

Possible solutions

As best I can tell, there are four ways to manage multiple devices with iTunes.

  1. Individual User Accounts
  2. Multiple iTunes Libraries
  3. Management Screen
  4. Playlists

Each of these has their respective pros and cons.

Individual User Accounts

Since each user account is its own space, that means each user has their own iTunes library and sync settings for their iOS device. Easy to understand, (relatively) easy to set up, and easy to maintain–it’s a good approach!

[Source, About.com, 4 Ways to Use Multiple iPods on One Computer]

The problem with this approach is Apple doesn’t allow children under 13 to have an AppleID. So you are faced with lying and apparently Apple permanently associates the age first entered with the email address. Sharing of apps and music is difficult or impossible (DRM…and I’m okay with that).

Multiple iTunes Libraries

With this method, each person who uses the computer has their own iTunes library and sync settings. This way, you won’t get music, apps, or movies mixed across iTunes libraries (unless you want to) and won’t end up with someone else’s content on your iPod by mistake.

The downsides of this approach are that parental controls on content apply to all iTunes libraries (with user accounts, they’re different for each account) and that each user’s space is not as cleanly separate. Still, this is a good option that’s easy to set up.

[Source, About.com, 4 Ways to Use Multiple iPods on One Computer]

Although promising, this approach seems burdensome and ripe for making errors since iTunes launches the last used library by default.

Management Screen

With this approach, you choose what content from each of the tabs in the management screen you want on your device. Other people using the computer do the same thing.

The downsides of this technique include that it only allows one setting for parental control of content and it can be imprecise (for instance, you might only want some music from an artist, but if someone else adds more of that artist’s music, it could end up on your iPod).

So, even though it’s messy, this is a very easy way to manage multiple iPods.

[Source, About.com, 4 Ways to Use Multiple iPods on One Computer]

I believe this is how my wife has been managing multiple devices in the past. It does allow for sharing of certain apps and music but if a child starts syncing with a different iTunes library, your personal device will start prompting you for their password in addition to yours in certain circumstances. I am also not sure that this approach will allow the children to use Facetime, iCloud, and iMessage the way we want. Instead the 5GB of space on iCloud may end up being shared between all the devices while the iMessages intended only for my wife (nudge nudge) could inadvertently be seen by the children.

Playlists

Downsides of this approach include that everything each person adds to the iTunes library is mixed together, the same content restrictions for all users, and the possibility that your playlist could be accidentally deleted and you’d have to re-create it.

[Source, About.com, 4 Ways to Use Multiple iPods on One Computer]

I am afraid this will also have the problem noted above with Facetime, iCloud, and iMessage.

Conclusion

Apple has made this unnecessarily confusing. It’s as if Apple is adult techie centric and in no way thinking about the way a family might use their devices. For instance, the iPad does not support multiple logins or even a level of control that would allow your child to safely use the device. Cathy is constantly having to rename folders and put applications back in the correct spot because she cannot hand the iPod to the child in a locked down mode. A simple second password with attached restrictions such as "cannot view certain applications" or "cannot rename folders." With such an approach Apple could allow unlimited screen lock passwords that would allow settings for the adult, the teen, the child, or even the toddler (and yes, toddlers use iPads).

So, how do you manage multiple iDevices in your house? And with children under 13?

Posted on Leave a comment

Preservation of species

It has long been said that to ensure the survival of the human species, we must migrate from Earth. Right now, if something catastrophic happened to our planet, our human race would be extinct. However, if we can spread out, and inhabit other planets and particularly other galaxies, if something happened to Earth, our species continues to exist. But what if we are wrong? What if it is not the planet we must escape to preserve human life? I conjecture that to preserve the human species, we may need to escape the universe.

Posted on Leave a comment

RIP Plazes.com

Every so often I get an email like this:

Hi djuggler,

Just a quick reminder that Plazes.com is going out of service on July 1.

After that, your personal Plazes data (including your account info) will be erased. So why not move your plazes to Nokia Maps today? Simply visit Plazes.com and follow the easy instructions.

If you have any questions, please contact Nokia Support.

Kind regards

Your Plazes Team

I don’t even remember being a part of plazes.com but sure enough, I have an account albeit very unused.

Posted on 11 Comments

WordPress 3.4 limited to 90 menu items

I’m working on a WordPress site. The site is to have roughly 106 pages all accessible via the WordPress menu system so that the enduser can add and remove pages from the menu as they like. Unfortunately, WordPress currently only allows 90 nodes (ie. 90 menu items) per menu. I have not figured out if this is a memory limitation, a hard coded limitation, or a setting yet. This must be overcome!

Reference:

Possible solutions:

  • Use add descendants as submenu items plugin
  • Check error logs and make sure max post vars was not exceeded. If so, increase in either .htaccess or php.ini
  • See if suhosin.post.max_vars and suhosin.request.max_vars are used with Dreamhost