Especially when database views are involved, maintainability may suffer with SQLiteĭesigned as a SQL database for the IoT edge however, due to the footprint it is no edge databaseĭatabase encryption with SQLCipher (256-bit AES).SQL queries can get long and complicated.The performance of SQLite is unreliable.Using SQLite means a lot of boilerplate code and thus inefficiencies (also in the long run with the app maintenance).Rock-solid, widely used technology, established since the year 2000.Debuggable data: developers can grab the database file and analyze it.SQL is a powerful and established query language, and SQLite supports most of it.Developers can define exactly the data schema they want.No dependencies, is included with Android and iOS.Based on this, we generated a more generic overview of advantages and disadvantages of using raw SQLite: advantages In our previous post, we presented advantages and disadvantages of using raw SQLite without any tools as we had gathered them with a group of developers. This may be due to SQLite being around since the year 2000 and being embedded with iOS and Android since the beginning. The most established mobile database – one could even say the only “established” – mobile database is SQLite.
0 Comments
Leave a Reply. |