Week 5 – 11/03/19 – Looking into SQLite commands

For this week, I have been assigned the task of looking into commands for the database. We have decided on using SQLite as it is the most appropriate form of database software for the creation of android bases databases. I have been researching SQLite commands that pertain to the geolocation of the pubs, pulling towns and pubs from their respective lists and being able to view separate images. So far, I have created a rough schema of how the database should look and the various values inside of it. I have been looking into ways of pulling the pubs/towns, such as using the cosine law to sort by longitude and latitude. So far, I am finding some good sources on SQLite, which will be useful as the database is developed.