You do not need to configure the database in any way. You use SQLite more like a library which helps you to access the database files. There is no SQLite process running at all. I will delve into each of these points a bit deeper - and add another one that's only relevant if you want to support older Android versions. SQLite uses cross-platform database files.SQLite uses manifest typing instead of static types.SQLite stores data in one database file.
Though SQLite offers quite an impressive feature set given its size, it differs in many aspects from a conventional database system: Android for example uses ever newer versions in its SDKs to make use of these improvements. The project is maintained actively so one can expect further imrpovements as well as optimizations in the future. And it is used in many, many products and open source projects. SQLite has a huge commercial backing by the likes of Google, Adobe, Mozilla or Bloomberg.
SQLite's source code is released under the public domain Those systems must run out of the box without forcing the user to manually configure anything or forcing the developers to consider additional constraints. You definitely do do not want these on mobile systems. No need for configuration files or complicated commands. I will detail what this means in the next section, but it makes handling of the database that much easier. Gladly SQLite should not add too much burden to the memory consumption of your app. Keep in mind: In the mobile world the memory per process as well as total usage of memory is limited compared to desktop systems.
While SQLite's memory footprint starts at about 50 kilobyte it's remains low even for bigger projects with more complex data structures (at about a few hundred kilobytes). SQLite in Android consumes very little memory Of course there is a reason why SQLite is so dominant in the embedded and also the mobile world. This database was developed with embedded environments in mind - and is used not only by Android but also by Apple's iOS and Blackberry's system as well as lots of other systems with low memory footprint and comparatively little CPU horsepower. SQLite is at the heart of Android's database support.
0 kommentar(er)
