Android with good highlight managements

[trocchietto]

HI,
i posted recently on the wrong subforum here it is in short what i need.
as i use ereaders mainly to study I highlight and make notes, my sony is too old now to support the thousands of highlights I did it.

1)I need to search all the notes highlights on a global level( all the book togheter),
2)and when i consult them I want to see the highlights entire in all their lenght without cut,
3)so that I can eventually click one highlight/note go to the page and go back exactly to the highlight notes index to proceed my study.
I have a sony prs t2 not rootable that do this, but..
4)I want also google play,
5) and a smoother experience( more ram and a processor faster that is not afraid of thousands of notes),
6)also i would love dutch-english and english- italian dictionaries,
7) if the screen is with light inbuilt even better

thank you

[cybmole]

Mantano premium reader app on android tablet does all of that

[susan_cassidy]

Does it support multiple dictionaries, as the OP requested?

[trocchietto]

Originally Posted by cybmole

Mantano premium reader app on android tablet does all of that

thanks for the reply but will mantano support a lot of highlights? because if is based on sqlite will not be robust and consistent as i need..

[cybmole]

to both question. I am pretty sure: yes, but to be 100% go to mantano support site and ask them directly.
https://mantano.desk.com/
from that link you can download the user manual which shoudl provide more answers.
PS only the premium version allows you to see all notes/highlights across all books in a single view.
I know that you can add dictionaries & thesaurus, it's a bit geeky 1st time around but well documented if you google how:
you get the free colordict app from google play then use that to index additional dictionaries
https://play.google.com/store/apps/d...rdict&hl=en_GB

there is also an old MR thread here, but the mantano app has had 3 years to eveolve since this thread was created:
https://www.mobileread.com/forums/arc.../t-156749.html

[cybmole]

Amazon kindle fire is your other shortlist option. Amazon put all your reader notes onto a personal web page for easy access, and they have lots of optional dictionaries. But you are now moving to azw / mobi formats to use the amazon world. You also get their unique x-ray facility for most, not all books.
They may limit size of any one highlight, note....
you can actually run mantano premium on KF but it needs a geeky maneuver of buy on some other tablet, then sideload to get around amazon store restrictions ( they don't like the competition). they don't allow google play store either - another potential showstopper for you. I'ts a lovely tablet though.

and there's this: ( link to evernote)
http://lifehacker.com/send-your-kind...-to-1603016995

[susan_cassidy]

Kindle.amazon.com does not do #2, from what I've heard. It shortens some highlights on the main display, I've heard.

[DuckieTigger]

Originally Posted by susan_cassidy

Kindle.amazon.com does not do #2, from what I've heard. It shortens some highlights on the main display, I've heard.

I just looked at my own kindle.amazon.com/your_highlights and I see one rather lengthy highlight that has approximately 600 words. I am sure it was not intentional, but one of those "fall asleep and highlight a bunch before Kindle goes to sleep" kind of things.

Maybe it used to be truncated at one point, but don't see it or have not reached the limit.

[HarryT]

Originally Posted by DuckieTigger

I just looked at my own kindle.amazon.com/your_highlights and I see one rather lengthy highlight that has approximately 600 words. I am sure it was not intentional, but one of those "fall asleep and highlight a bunch before Kindle goes to sleep" kind of things.

It's truncated in the "myclippings" text file, but not in the actual highlight itself.

[cybmole]

i'm confused by the OP wanting full database control over notes & highlights then saying it must not be built in sqlite (post #4) ?
Surely that IS the defacto tool for databases, and has been around long enough to be pretty robust ?
What is he expecting his ideal solution to use instead ?

[trocchietto]

Originally Posted by cybmole

i'm confused by the OP wanting full database control over notes & highlights then saying it must not be built in sqlite (post #4) ?
Surely that IS the defacto tool for databases, and has been around long enough to be pretty robust ?
What is he expecting his ideal solution to use instead ?

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

[davidfor]

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.

[trocchietto]

Originally Posted by davidfor

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.

Thank you David, hope will be possible in future KOBO version to import the SONY highlights, I have thousands of notes and do not buy KOBO, just because does not support importing sony highlights, well also i do not like PDF dictionary and the lack of android open, but I had bought it if could export the highlights, considering they took over sony ereaders.

anyway thank you again, this is what i mean:
http://www.tutorialspoint.com/sqlite...sing_joins.htm
SQL standard defines three types of OUTER JOINs: LEFT, RIGHT, and FULL but SQLite only supports the LEFT OUTER JOIN

[davidfor]

Originally Posted by trocchietto

Thank you David, hope will be possible in future KOBO version to import the SONY highlights, I have thousands of notes and do not buy KOBO, just because does not support importing sony highlights, well also i do not like PDF dictionary and the lack of android open, but I had bought it if could export the highlights, considering they took over sony ereaders.

There are no tools to copy annotations from one brand of ereader to another brand. It wouldn't be that hard to do as both are RMSDK based readers and store the annotations in a database. It just needs someone with a desire to do it.

I don't know what you mean by "PDF dictionary" and "lack of android open". If you are referring to Kobo ereaders, neither make any sense to me.

anyway thank you again, this is what i mean:
http://www.tutorialspoint.com/sqlite...sing_joins.htm
SQL standard defines three types of OUTER JOINs: LEFT, RIGHT, and FULL but SQLite only supports the LEFT OUTER JOIN

OK, I hadn't noticed that. I have to admit I haven't noticed the lack. I can't think of the last time I had to use either a RIGHT or FULL OUTER JOIN against any database.

[trocchietto]

Originally Posted by davidfor

I don't know what you mean by "PDF dictionary" and "lack of android open". If you are referring to Kobo ereaders, neither make any sense to me.

I like android with google play so that i can install my favorite apps,
then i need the dutch-english dictionary, as I read dutch, and as most of my books are pdf, if i well recall when I avoided to buy the h20 the reason was i could not find a way to lookup words from Dutch to English in pdf documents, whereas with a Mantano app I have huge possibilities.
All in all the default way to manage the highlights and notes especially combining them in their own fragment/activity is gorgeous on the last Kobo, you David and your team did a great job, and the home UI is so attractive and enjoyable, and the navigation was flaweless. I am really honored to speak with one of the Kobo developers indeed, the customization of the fonts with preview is a really cool feature, especially because as Italian i feel honored to see the benchmark with the old latin text, really bibliophil mktg choice, really smart. As soon as I will have android I will buy, if i well remember there was a root possible to make a dual boot, but is quite inefficient for me, as ereaders are still sluggish compared to my ipad and i7 reading experiences and waiting for a reboot could kill me. Although I would buy it if the device would have been open and with guarantee( i theorically can root my sony rt2 to put android, but I do not do because I am afraid i can brick it, and also is maybe time to have a more performing device.
thanks again for your attention