Android Question SQLite advice to get me learning what I need

[schemer]

I have tried to learn database programming many times but always got confused and never finished. But I have not thrown in the towel yet! Back in the MS Access days I kept getting confused on the relationships and keys. Anyhow, I am focusing on SQLite and realize my needs may be easier than I thought as my database will just be used in "read only" mode to store data that my app will access to get Strings for lists and numbers that will be further multiplied and divided etc for end results. My DB will have about 150 rows and about 10 columns of related data. That said, what approach should I take in learning SQLite? Anybody learn with a book or website that made it "click" easier than some books that didn't?
Thanks,
schemer

 

[NJDude]

There's plenty of documentation about SQLite on the net and code samples here in the forums, just browse away.

 

[schemer]

There's plenty of documentation about SQLite on the net and code samples here in the forums, just browse away.

I just realized as I have been reading the book I bought today on B4A that it has some chapters on SQLite. I started from the beginning and was at 10% read on my electronic version and the SQLite is later in the book. But I know it's there and will skip ahead. And I will browse here and the net and ask more specific questions when I get to that point. I think like anything else, it will take time. I do remember learning VB and getting stuck here and there even after reading and asking questions. Then one day while walking the dog I would say out loud, "I know what they mean now" and it just clicked. Don't know why, but it did!
Thanks,
schemer

 

[inakigarm]

Take a very introductory reading like https://www.udemy.com/blog/sqlite-tutorial/ and continue with searching b4x forum for examples (DBUtils is a great class for this) and Internet for sqlite syntax (http://www.sqlite.org/lang.html)

There're a several external tools to manage sqlite DB without B4A programming, like Sqlite extension on Mozilla Firefox and BD sqlite browser for Windows; this way, you can learn access programming to sqlite DB from B4A and execute sqlite commands directly on sqlite DB to test the sqlite statements (Querys, creating tables, etc..)

 

[schemer]

Take a very introductory reading like https://www.udemy.com/blog/sqlite-tutorial/ and continue with searching b4x forum for examples (DBUtils is a great class for this) and Internet for sqlite syntax (http://www.sqlite.org/lang.html)

There're a several external tools to manage sqlite DB without B4A programming, like Sqlite extension on Mozilla Firefox and BD sqlite browser for Windows; this way, you can learn access programming to sqlite DB from B4A and execute sqlite commands directly on sqlite DB to test the sqlite statements (Querys, creating tables, etc..)

Thank you for the reply. I will check the links you sent and followup with what I find. I have bought this SQLite Profeesional app a year ago and have started my db in there but need to finish it. It seems like a very good program but I need to learn the interface from db to code in my app. Here is a link to the app I have and I am not affiliated or make any money by promoting it.
http://www.sqliteexpert.com/
schemer

 

[KMatle]

There is absolutely nothing special with SqlLite. Did you see Erels tutorial? https://www.b4x.com/android/forum/threads/sql-tutorial.6736/#content

It's all about

Select (reading rows)
Insert (inserting rows)
Update (updating rows)
Delete (deleting rows)

Just play with it...

 

[schemer]

KMatle,
Thanks for the link to Erels tutorial. I did some browsing yesterday and found some good info and have been learning as fast as I can. I am going to read my new book some more this morning after I read the tutorial in the link you sent. My db will be read only so that may make it even easier to come to grips with.
Thanks,
schemer

 

[klaus]

Did you have a look at the User's Guide ?
Chapter 4 SQLite Database.

 

[schemer]

klaus,
Thanks for the reply. I did find your user guides after reading about them in one of my searches. Now I think I have enough info to keep me reading for a while. I wish I could comprehend as fast as I can read. I guess I am a little overwhelmed with all the excitement of this new software development tool. A few years ago someone asked me if I would make an app and I said no after seeing what was involved. Now I feel I have a chance. A good chance.
schemer

p.s. Thank you for making the guides. Great work.