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. What are the advantages and disadvantages of working with SQLite? In short: In the realm of Edge Databases, despite such a dominant incumbent like SQLite, there is still room for innovation and advancements. While the database market is very crowded and indeed vibrant, the Edge Database market is still a small market with only few notable players. Note: DB-Engines lists 400+ databases as of 2023 the database of databases, which also includes hobby projects, counts 700+ databases. One has a lot more and typically faster options when choosing a local Edge Database nowadays. However, with SQLite being over 20 years old, the market has changed significantly and a large number of more modern solutions, more suitable for new markets like IoT and Mobile, have become available. On DB-Engines, SQLite is currently in the top 10 and its ranking has been rather stable in the last 10 years. In 2023, SQLite is still a widely used database. Data Privacy: personal data can be stored with the user, where some say they belong).Speed: fast and predictable performance independent from network availability.Manageable costs: Frugal on bandwidth for apps that depend on stored data.Always works: full offline modus for apps that depend on stored data. There are some advantages associated with using a local database (Edge Database): We just updated the comparison table in June 2023. Therefore, we followed up with an overview of the local database landscape (Edge Databases), which we maintain ever since. Many people weren’t aware of SQLite alternatives and the differentiation between databases and Object-Relational Mappers (ORMs). UPDATED 2023 A long time ago at Droidcon Berlin, we noticed a lot of questions around databases.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |