January 2012
2 posts
Free SSL Certificates →
need to check this out…
Secure Authentication without SSL →
Article that talks about how to add some basic security to authenticating when SSL encryption is not available.
August 2011
9 posts
Pixel Union - skins for Tumblr →
Talk Dirty to Me, Paul Krugman →
drcairns:
So, Steve Jobs has left his role as Apple’s CEO. Like, for good this time. It’s a shame, but it was inevitable, and it sounds like everything’s running pretty well down in Cupertino anyway.
For the purposes of this anecdote, it’s worth noting that I grew up entirely surrounded by Macs. My mom is…
Reading Binary and XML PList files in PHP
For a generic solution to reading both XML PList files and Binary PList files check out Rodney Rehm’s CFPropertyList a PHP Implementation of Apple’s PList (binary and xml).
It has a nice object oriented API to read in, traverse, access, modify and save PList files.
Here’s a quick example that I used to read in the iPhoto binary PList file and get the directory where the iPhoto...
1 tag
rentzsch.tumblr.com: HOWTO Use UTF-8 Throughout... →
Wow I’m not the only one that has suffered though the pain of UTF-8… though I wonder why he suggests using —default-character-set=utf8 but fails to mention the use of SET NAMES ‘utf8’; after connecting to MySQL to set all of the related character set / collation for the connection, the client, etc. Doing so when using languages such as PHP is very helpful. See my...
More on iPhotoMain.db / iPhotoAux.db - Date...
There seems to be a dearth of information about the iPhoto SQLite3 database, so I am going to continue to post what I find out in hopes that it will help others. This is a follow up to my other posts about iPhotoMain.db SQLite3 database, which can be found here:
iPhotoMain.db Table Relationships
Finding the original photo file in the iPhoto Library database
Date Format used in iPhotoMain.db...
iPhotoMain.db Table Relationships
I’m currently working on a program that reads iPhoto’s (version 8.1.2 [424] aka iPhoto ‘09]) main SQLite3 database, iPhotoMain.db. As part of the development I needed to determine the relationships between the various tables. The following SQL query shows the relationships between the following tables:
SqEvent (list of events in your iPhoto Library)
SqPhotoInfo (the photos in...
how to determine the default character set of a...
To show the default character set of a MySQL database use this query: SHOW CREATE DATABASE `DB_NAME`
NTTP and Character Sets - News.GigaNews.com
I’m working on writing a news reading client in PHP and I use GigaNews as my nntp provider. My first hurdle came quite early in trying to get a list of the news groups.
One of the news groups groups returned was:
milf.dream.movie.german.komodie
and another was:
milf.dream.movie.german.komödie
only different by one character… problem was that I was using MySQL with a UTF-8 with...
May 2011
1 post
Text Editors for OS X →
All the major Mac text editors are mentioned in this blog article.
March 2011
1 post
Packetfence →
Make sure to go back and check this out…
January 2011
5 posts
Best looking stand for iPad yet →
Cake - A PHP Framework →
More on Hierarchical Data →
Here’s another article on how to manage hierarchical data using Nested Sets and the Modified Preorder Tree Traversal.
Just 3 little words...
Who would have thought that 3 little words could do so much, solve so many problems, accomplish so much…
No. Not “I love you,” silly. “set scan off;”
Good write up here about set scan off, which is now considered obsolete, set define off and set escape on.
Hierarchical Data in MySQL →
very good article on how to manage hierarchical data in MySQL, even includes example queries.
November 2010
2 posts
Opening a folder in Mac OS GUI from Terminal
In terminal navigate to the directory you want to open
Then just type
open .
This is useful for opening hidden folders that start with a dot (.) character.
Oooooos and Ahhhhs
Ooooooo…
Ahhhhhh…
FTW!
Some one just upgraded their iMac to 8GB of RAM!!!
May 2010
1 post
Adobe [hearts] Apple →
One word, “Dumb!”
April 2010
2 posts
Character Sets and MySQL command line client
FYI… if connecting to a MySQL database using the MySQL command line client (tool) where the database collation / character-set is set to utf8_general_ci / UTF-8, you need to issue a
SET NAMES 'utf8';
command prior to running any queries so that any special characters show up correctly.
Refer to the MySQL Reference Manual, section 9.1.4. Connection Character Sets and Collations and...
Character Sets and PHP Follow Up
Following up to my Feb 23, 2010 post on difficulties with charaster sets I’ve yet run into another example of how this can mess you up.
In PHP, I was using curl to fetch a page from a remote web server and then extract some data using regex and then inserting it into a MySQL database. The issue that I encountered was that my database was in was in UTF-8 but the text being retrieved from...
February 2010
2 posts
Ah, Language, isn't it wonderful. If you're not a...
Well I’ve spent a good part of the day reading the MySQL manual pages for Language support… and I’ve got to say, life would be so much simpler if everyone only wrote, spoke and used English… I know that’s not a very global attitude, but really, when you get into things like multilingual support (i.e., Unicode) in applications, programming languages, databases, web...
Did I mention my new blog? →
I’ve posted some new articles lately, check out:
Do you call it a Title or a Series
What Comic Book Cataloging software do you use?
How do you handle annuals from a cataloging perspective?
January 2010
1 post
Comic Book UPC Database →
As some of you may know or may not know I’m a IT guy that works for Motorola and I like to code for fun in my free time. And some of you may also know (or not) I’m a comic book nut… so my latest hobby is thinking up cool things I could code up to help comic book junkies like myself.
Well the other day I had an idea for a new web site that hopefully will help collectors get their...
November 2009
2 posts
Finding the original photo file in the iPhoto...
Using iPhoto’s SQLite3 database you can get the relative path to the original photo in the iPhoto library for any image in the sqPhotoInfo table. To do so you must join from the sqPhotoInfo table to the sqFileImage table and finally to the sqFileInfo table.
select pi.primaryKey, pi.archiveFilename, fl.relativepath
from SqPhotoInfo as pi
join SqFileImage as fi on pi.primaryKey =...
Date Format used in iPhotoMain.db database
Not sure how many of you know that iPhoto uses SQLite3 as its database engine. You can access the database files by right clicking on ~/username/Pictures/iPhoto Library and selecting Show Package Contents. Once you have displayed the package, the SQLite3 datbase files are:
iPhotoMain.db
iPhotoAux.db
face.db
face_blob.db
The main database file, as you might have guessed, is the iPhotoMain.db...
June 2009
10 posts
March 2009
10 posts
February 2009
14 posts
Xcode - Changing the Default Company Name
If you use Xcode to create your source code file, you’ll notice that it nicely places a comment block at the top of the file for you that contains the file name, project name, author, creation date and a copy write notice that contains your company name.
By default it takes the company name from your address book entry. But if this does not suit your tastes and would like to change it, but...
