SQLite tutorial in the works

[myersn024]

Some of you may me happy to hear that i've been spending some of my free time learning the in's and out's of SQLite. I'm still trying to figure out the best way to present the info, but I also wanted to know if there was anything specific that any of you might want to see in an SQLite tutorial. So post up your ideas and questions and I'll do my best to incorporate as many of them as I can without making things overly complicated.

[mek]

i would greatly appreciate an sqlite tutorial

I am designing/ more like fumbling through an app that will retrieve a lot of data out of an sqlite3 database i created

basically the user would browse a table view of names (the primary key), click on a name, and it would display information about the name, address, etc

a lot like the contact app that apple has

if you could make a tutorial on this, that would be amazing

thank you

[myersn024]

Like the UITableView tutorials I'm working on, this may be a multi-part tutorial as well. There's soooo much that you can do with SQLite, and several ways to do everything.

[ChriB]

Originally Posted by myersn024

Like the UITableView tutorials I'm working on, this may be a multi-part tutorial as well. There's soooo much that you can do with SQLite, and several ways to do everything.

Yeah, the multi-part idea is great, so if you want to watch something again it's easier to find it. Also, it makes more fun to learn step by step.

[hikari]

I've been trying to write something with SQL that has multiple UIpickers that will Save to SQL

but any thing with SQL would be a big help

[mek]

do you think incorporating the TableSearch features into the sqlite3 tutorial could eventually be an advanced tutorial

im actually more interested though in getting a functional sqlite database that i can read from and display table data

i understand the add and delete from the sqlite book sample
I just cant get my own database running from scratch...i must be doing something wrong -lol-

[myersn024]

I hadn't seen the TableSearch sample code until just a few minutes ago, and that's far simpler that I thought it would have been.

[brendand]

I would LOVE to see a tutorial on how to sync an sqlite3 database from the iPhone to the Mac. What's the best technique to use? Are there third-party solutions for this already?

[mek]

SO i've been using this tutorial,

iPhone Programming Tutorial - Creating a ToDo List Using SQLite Part 1 | iCodeBlog

and learned how to set up a sqlite3 database
except that i dont want to make a to do app,
i've been tweaking it so it falls more in line with the SQLiteBooks design
where you click on something, and it loads up more details about it.

I have 5 errors that i can't figure out

has anyone made or released a good tutorial on a sqlite3 database that is more like a contacts app then a todo app

Edit: i was actually able to fix all the errors, but the program loads successfully to a blank screen
[its a modified ToDo App with a custom built sqlite3 database]
by blank screen, i mean it loads a black screen with no controls, and you see the carrier logo and power and cell tower strength, and thats it