Configuring SQLite and saving the markers
Persisting all the necessary data is the fundamental use case for any good software. Android SDK provides an SQLite storage solution built in. It has a very small footprint and is very fast. If a is familiar with SQL queries operations, SQLite is going to be easy and delightful to work with.
Schema and contract
Essentially, for a database, we need to create a data schema, which is a formal declaration of how the is organized. The is reflected in the SQLite query statements. A contract class is a for constants that define names for URIs, tables, and columns. The class allows the use of the same constants across all the other classes in the same package.
For the scope of WearMapDiary
, we will create all the instances in the DBHelper
class. Now, let's create the DBhelper
class, which opens and connects the application to SQLite and processes the query:
public class DbHelper extends SQLiteOpenHelper { private static final String DATABASE_NAME...