The database used in SoSporty
There are many database systems to be used such as LevelDB and Couchbase Lite but they are compatible with android systems only. Since we are using both platforms and operating systems (android-IOS) for developing our application for the benefits and the convenience of our users. As our previous post mentioned. We will choose to produce and use SQLite as our database system since it is available in most mainstream programming languages. In addition, SQLite is included in both iPhone and Android operating systems.
SQLite has many additional advantages since it is an open-source C library for managing relational databases that can be stored both on disk and in memory. It supports transactions, full-text search, single-writer/multiple-reader access, efficient range queries (useful when storing geographical data), and shared caching (across connections opened by a single thread to the same database).
Ā
you can create an SQLite database on one machine and then use it on another machine with an entirely different architecture by simply copying the corresponding file. It is believed that it is āthe most widely deployed SQL databaseā.
our database diagram is introduced in another blogpost.
https://www.developereconomics.com/five-popular-databases-for-mobile