I know it’s been a light posting day. I’ve been buried in code.

I’m an application programmer. I tend to write most of my stuff in Objective-C and C++ (and Objective-C++ and sometimes straight C). Sometimes I do some work in Python. A few other bits of dabbling now and again.

I haven’t looked at serious database work in almost a decade.

But today I needed to consider using SQLite as a solution, so I had to pull out my SQL book and remind myself just how it all worked.

Of course by the end of the day I came to the conclusion that going straight to a relational database wasn’t going to be the best avenue to solve my problem. Instead, I think I’m going to use Core Data. I’ve used it numerous times in the past but didn’t feel it was the right fit for the work at hand (given Apple’s design intent/constraints on Core Data). But the more I thought through things, the more I think it’s going to be the way to go. At least, that’s my thinking right now. Could change tomorrow when I start prototyping.

Yeah, this probably doesn’t make a lot of sense to most of you. But I’ve been nose-down in that all day, thus minimal blogging.