Android Question SQLite advice to get me learning what I need

Discussion in 'Android Questions' started by schemer, Jan 23, 2015.

  1. schemer

    schemer Active Member Licensed User

    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? :D
    Thanks,
    schemer
     
  2. NJDude

    NJDude Expert Licensed User

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

    schemer Active Member Licensed User

    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
     
    RandomCoder and susu like this.
  4. inakigarm

    inakigarm Well-Known Member Licensed User

    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..)
     
  5. schemer

    schemer Active Member Licensed User

    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
     
  6. KMatle

    KMatle Expert Licensed User

    schemer likes this.
  7. schemer

    schemer Active Member Licensed User

    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. :D 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
     
    KMatle likes this.
  8. klaus

    klaus Expert Licensed User

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

    schemer Active Member Licensed User

    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. :oops: 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.
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice