In this chapter, we started by focusing on the Android OS and by looking at what types of query methods are at your disposal. We saw that there are three well-known ways to interact with the SQLite database, some more 'convenient' than the others, and some more flexible and powerful than the others.
However, we also saw that though each method had its pros and cons, all three query methods could ultimately perform the same kinds of queries, just using different sets of syntax or using different sets of parameters. This is when we moved away from the methods themselves and focused more on the query itself, starting with simple queries, which ranged from the most basic SELECT
queries to more involved queries that allowed you to specify specific columns and rows. And later, we talked about more advanced queries, which ranged from ORDERBY
and GROUPBY
queries to the most complex and involved JOIN
statements.
And lastly, being the curious and performance-minded programmers that we are, we...