When I first got to know Android, I couldn’t believe it came with a built-in database. Okay, well, I’m a little out of touch. Since I came from the Web direction and had a particular preference for database technology, I was quite surprised when I learned this news. The built-in database in Android is SQLite, while MySQL is the database I used most frequently when I was doing Web development. After comparison, I found that these two databases are very similar, both supporting standard SQL syntax and following ACID transactions of database. So if you’ve worked with other relational databases before, you should be able to get your hands on SQLite pretty quickly.
However, I believe that there are still many Android programmers who are not very proficient in database programming, or who are simply using it, mainly because we as client programmers have much less exposure to databases than we do as server programmers. However, to be able to master all aspects of the use of database skills, for an Android programmer is still very important, so here I am going to write a “Android database expert secrets” column, take you step by step to become an Android database expert, this is the first article in this column.
Because it is a master secret book, the content of this column is mainly about advanced technology. It covers some of the hidden tricks of Android database usage, as well as a thorough look at all the uses of LitePal, the Android database framework. But at the same time in order to consider beginners’ reading, it will also involve some basic knowledge, the overall content is difficult to combine, suitable for gradual learning.
So without further ado, let’s move on to the SQLite command in the first article of this column.
Pay attention to my technical public number, every working day there are high-quality technical articles push.