View Single Post
Old 03-16-2015, 10:53 PM   #12
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by trocchietto View Post
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.
davidfor is offline   Reply With Quote