I’m in the process of learning Objective C with the goal of making iOS apps. I’ve come across some great resources so I figured I’d share them here as I go. Today I’m working with Sqlite databases.
I used the tutorial here to get started: SqliteView.zip (.mm): iOS example of using the SQLite framework for writing and reading data from a database on the iPhone.
However, I was having problems making queries and i didn’t like the amount of code that was required to query the database so I went looking for something better and found a wrapper class called FMDB . Ok, so why am I mentioning SqliteView then? It includes good directions on how to add the Mach-0 dynamic library called “libsqlite3.dylib” to your project that you will need anyhow for interacting with Sqlite db’s.
Instead of using command line to create the initial database, I’m using this handy utility: SQLite Database Browser. It’s also helpful for testing and verifying your code is actually updating the database.
All of that got me pretty far along, except when it came to deploying the first time. FMDB’s docs have you create your database with sql queries each time you load. There wasn’t anything that I could find that explained how to use a pre-built database that you include in your resources folder. I ended up finding a solution here: sqlite database initialization issues. It’s a forum thread, but the solution is at the end.
I’m not going to explain how to stitch it all together, mainly because this is still really foreign to me, but it should give a good starting point.
Edit: Forgot one. Didn’t need to use it, but a ton of info: 12 SQLite Resources for iPhone Developers.
Web 3.0 will be defined by the next newly minted billionaire.
Speculating what that will be before it happens is simply a mental floss exercise.
When most people see panhandlers on the side of the road, we condescendingly think “Why don’t they get a job? You’re not going to get anywhere begging for money. Get to work!” Yet, this is what so many people do with their ideas – they put their fate in the hands of passerby’s hoping someone cares enough to give them a chance. It’s the equivalent of standing on an off-ramp holding a cardboard sign that reads “I have good ideas. Please pay me for them.”
via Stop Panhandling your Ideas – The Daily Drip.
I’ve run into a lot of people that tell me they should start a business or move somewhere else or try this or that sport but never do.
An article related to the Skeleton world.
It’s part of the continuing fad of tight-fitting compression garments… which many athletes wear on the presumption that they improve performance and reduce muscle soreness.
But there’s not much evidence for that. Shots did a quick PubMed scan on sports performance and compression garments, and it looks like the benefits are largely psychological. Of course, there’s nothing wrong with feeling like you can run faster and jump higher, and look cool while you’re doing it. But it shouldn’t send you to the neurologist.
via Doctor To Teen Athletes: Skip Spanx : Shots – Health Blog : NPR.
While I’ve seen studies that say compression improves recovery, the jury still seems to be out on actual game time performance.
Posted in Skeleton, Sports
The absolute bedrock of capitalism is competition.
The whole essence of our free market system lies in consumer choice.
That’s why it’s okay that companies charge what they like, and offer the products and services they like. Ultimately, if the consumer is unhappy, they can take their business elsewhere.
Take away that choice and the consumer is powerless.
Goodbye, free market.
via Why AT&T’s deal for T-Mobile must be blocked Brett Arends ROI – MarketWatch
I think the “free market” and “laissez faire” capitalists too often forget these points.
Capitalism is good for society when it creates competition to improve the products and services we use. It is bad for society when it is used solely to enrich itself.
Apple’s iPad was the first post-PC device that people took seriously. Microsoft, Nokia and countless manufacturers have tried to find the right balance between a tablet and a computer for the last 10 years, but the iPad was the first device to get it right and now Apple owns the space.
Reminds me of how Apple entered and won the MP3 player market. I think we’ll see the tablet market parallel the MP3 player market, not the cell phone market.
I caught up with John while we were both in the Swiss Alps, at a secret bestselling author chalet where we heat our jacuzzis by burning stacks of hundred dollar bills.
While the quote above is in jest, I think the publishing industry is on the verge of seeing itself reinvented by the internet to an even greater extent than what the music industry went through. It sort of has that wild west, mid 90’s internet feeling of chaos and opportunity. Self publishing seems to have the desire to become the revolution in media that the music industry never fully realized.
Last month during the introduction of the new Apple TV and iPods, Epic Games showed a demonstration of the Unreal Engine 3 running on an iPhone 4 that looked amazing. At the time I wasn’t able to test it out because I had an iPhone 3G so I kinda forgot about it. However, last week Kimber and I upgraded to new iPhone 4’s and while looking for apps to put the new phones through their paces with, I remembered it and finally was able to check it out.
It short, I found it to be one of the most amazing things I’ve seen on a phone before. All the effects and animations are real time. It’s best to download the app and check it out yourself. Be sure to check out the courtyard with the trees blowing in the wind.
Epic Citadel for iOS