Quote:
Originally Posted by trocchietto
HI Sorry for the delay,
I mean, sqlite has some limits? I see has 140 Tera limits, that is more than 300 reincarnations. But I am puzzled that such a small db, with less than 1k code can store all these data without performance issues, also probably there is a content provider inside that should optimize with loaders patterns the velocity, so I was wrong in asking these questions, but still
why java developers use normal SQL, or reframing why SQL lite is not so popular outside android for desktop applications?I knew has some limitation like it has one JOIN instead of the three o more of SQL, but most of the databases do not need really advanced features i guess
|
I'm not sure what you mean by "one JOIN". I've written SQL against the SQLite database in the Kobo ereaders that has joined more than two tables and used INNER and OUTER. SQLite does have some short comings compared to a full relational database. But, it's big feature is that it is self-contained. It doesn't need a separate process running for the database and is relatively lightweight in resources used. That's probably why it is popular for small devices. But, calibre is using it for its database and Firefox uses it for the several things.