Discussion Forums  >  Suggestions, Ideas, Wish List

Replies: 1    Views: 108

CodeMeNot
I hate code!
Profile
Posts: 92
Reg: Aug 02, 2012
Sydney
1,720
09/27/12 09:53 PM (13 years ago)

Querying, using, writing etc with Databases.... how?

So I was just wondering... How to use a query and write to a database through an app. I know all about tables, PK, FK's etc. I know HTML (a bit), SQL and have know basics of programming, I.e. first year uni using C. I come unstuck on hosting the DB and how it integrates into the app. I am not asking for a detailed guide. Just a high level overview to get me started. All help appreciated! Cheers, Ben
 
moreillynz
Aspiring developer
Profile
Posts: 1
Reg: Aug 24, 2012
auckland
1,160
like
11/06/12 01:00 AM (13 years ago)
Hi Ben, I found this site extremely useful for creating DBs, add/delete & viewing records in a DB. selecting data... http://www.iphonesdkarticles.com/2008/10/sqlite-tutorial-selecting-data.html deleting data... http://www.iphonesdkarticles.com/2008/10/sqlite-tutorial-deleting-data.html inserting data... http://www.iphonesdkarticles.com/2008/10/sqlite-tutorial-adding-data.html loading data as required... http://www.iphonesdkarticles.com/2008/10/sqlite-tutorial-loading-data-as.html updating data... (download the code for this one as it includes everything above) http://www.iphonesdkarticles.com/2008/11/sqlite-tutorial-updating-data.html This site has hugely helped me move my app forward! Also includes downloads of the code so you can see for yourself how it works. Happing databasing!
 

Login + Screen Name Required to Post

pointerLogin to participate so you can start earning points. Once you're logged in (and have a screen name entered in your profile), you can subscribe to topics, follow users, and start learning how to make apps like the pros.