Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Readers > Kobo Reader

Notices

Reply
 
Thread Tools Search this Thread
Old 07-28-2013, 02:06 PM   #916
Ken Maltby
Wizard
Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.
 
Ken Maltby's Avatar
 
Posts: 2,928
Karma: 3910173
Join Date: Dec 2009
Location: The Heart of Texas
Device: JetBook Lite, AuraHD, PDA, Eee Transformer
Quote:
Originally Posted by anacreon View Post
Dear Davidfor,

I already use your wonderful Kobo utilities to manage front page tile display and copy reading parameters between my preferred Aura and the "spare" Glo, but I hadn't noticed it could be used to compress databases.

I just used it for the Glo: the database was reduced from 126.7 to 111.8Mb. But it doesn't work for the Aura which is too big: I have an error

calibre, version 0.9.41
ERREUR : Exception non gérée: <b>OperationalError</b>:database or disk is full

Traceback (most recent call last):
File "calibre_plugins.koboutilities.action", line 833, in vacuum_device_database
File "calibre_plugins.koboutilities.action", line 1711, in _vacuum_device_database
OperationalError: database or disk is full


I did have an error "database full" the penultimate time I transferred books from calibre to the Aura, but it worked the last time. Following that, I explored the threads, and found a link to SQLite Database Browser 2.0 b1, but when I tried to use it (after backing up the database), I discovered there was no user's guide and don't know how to discard unused elements.

Regards, anacreon
I can't be much help on most of that but in SQLite if you Browse Data you should have two buttons: "New Record" and "Delete Record" to the right side of the listing.

Luck;
Ken
Ken Maltby is offline   Reply With Quote
Old 07-28-2013, 04:05 PM   #917
DNSB
Bibliophagist
DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.
 
DNSB's Avatar
 
Posts: 2,319
Karma: 6142827
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Aura HD, Glo, Nexus 7 HD, iPad Air
Quote:
Originally Posted by anacreon View Post
I did have an error "database full" the penultimate time I transferred books from calibre to the Aura, but it worked the last time. Following that, I explored the threads, and found a link to SQLite Database Browser 2.0 b1, but when I tried to use it (after backing up the database), I discovered there was no user's guide and don't know how to discard unused elements.
You might want to try SQLite Expert Personal edition. It does have a vacuum option on the database menu. A bit easier to use the SQLite Database Browser with a half decent help.

Download page is at: http://www.sqliteexpert.com/download.html

Regards,
David
DNSB is offline   Reply With Quote
Old 07-28-2013, 05:23 PM   #918
anacreon
Addict
anacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdom
 
anacreon's Avatar
 
Posts: 217
Karma: 117282
Join Date: May 2012
Location: France
Device: sony prs-t2, aura 6" + h2o
Quote:
Originally Posted by DNSB View Post
You might want to try SQLite Expert Personal edition. It does have a vacuum option on the database menu. A bit easier to use the SQLite Database Browser with a half decent help.

Download page is at: http://www.sqliteexpert.com/download.html

Regards,
David
Thank you. I decided to try compressing with kobo utilities again after deleting a couple of dispensable books (the database went down from 262 to 256 Mb), and checking it (ok): it worked, and the compressed database is now 239 Mb. It still needs slimming, so I'll try your expert version tomorrow.
anacreon is offline   Reply With Quote
Old 07-28-2013, 10:25 PM   #919
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: 5,888
Karma: 5704423
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo Touch, Kobo Glo
Quote:
Originally Posted by anacreon View Post
Thank you. I decided to try compressing with kobo utilities again after deleting a couple of dispensable books (the database went down from 262 to 256 Mb), and checking it (ok): it worked, and the compressed database is now 239 Mb. It still needs slimming, so I'll try your expert version tomorrow.
How much space do you have free on the devices disk? I am pretty sure the compress works by copying the database to another file and then compressing that. That means to work, it needs at least the size of the database file free on the devices disks.
davidfor is offline   Reply With Quote
Old 07-28-2013, 10:28 PM   #920
Mostly Math
Groupie
Mostly Math ought to be getting tired of karma fortunes by now.Mostly Math ought to be getting tired of karma fortunes by now.Mostly Math ought to be getting tired of karma fortunes by now.Mostly Math ought to be getting tired of karma fortunes by now.Mostly Math ought to be getting tired of karma fortunes by now.Mostly Math ought to be getting tired of karma fortunes by now.Mostly Math ought to be getting tired of karma fortunes by now.Mostly Math ought to be getting tired of karma fortunes by now.Mostly Math ought to be getting tired of karma fortunes by now.Mostly Math ought to be getting tired of karma fortunes by now.Mostly Math ought to be getting tired of karma fortunes by now.
 
Mostly Math's Avatar
 
Posts: 170
Karma: 1154013
Join Date: May 2010
Location: Toronto
Device: Kobo (loaned out), KoboTouch (given away), KoboVox, KoboGlo, AuraHD
I have had my Aura since the were released and I love it but... I am noticing the screen is getting terribly scratched. This didn't happen on any of my other Kobo readers (original, touch and glo). Has anyone else noticed this happening?
Mostly Math is offline   Reply With Quote
Old 07-29-2013, 12:17 AM   #921
speakingtohe
Wizard
speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.
 
Posts: 4,601
Karma: 25170940
Join Date: Apr 2010
Device: sony PRS-T1 and T3, Kobo Mini and Aura HD, Tablet
Quote:
Originally Posted by Mostly Math View Post
I have had my Aura since the were released and I love it but... I am noticing the screen is getting terribly scratched. This didn't happen on any of my other Kobo readers (original, touch and glo). Has anyone else noticed this happening?
Mine looks okay. Seems unlikely that you are doing terrible things to it if none of your other readers are scratched.

Only suggestion I can think of is to clean it several times in case there is something (coating) on the surface that is scratched but again not too likely.

Helen
speakingtohe is offline   Reply With Quote
Old 07-29-2013, 02:14 AM   #922
anacreon
Addict
anacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdom
 
anacreon's Avatar
 
Posts: 217
Karma: 117282
Join Date: May 2012
Location: France
Device: sony prs-t2, aura 6" + h2o
Quote:
Originally Posted by davidfor View Post
How much space do you have free on the devices disk? I am pretty sure the compress works by copying the database to another file and then compressing that. That means to work, it needs at least the size of the database file free on the devices disks.
I have 1038 Mo available on the Aura this morning, 495 on the Glo. I have always wondered how much space I MUST leave available when I'm on a downloading frenzy, and I guess I'll leave at least 100 above the database - which means I'd really like to slim it down.

Unfortunately, the vacuum button on sqlite expert only reduced it by 20 Ko!
anacreon is offline   Reply With Quote
Old 07-29-2013, 04:03 AM   #923
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: 5,888
Karma: 5704423
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo Touch, Kobo Glo
Quote:
Originally Posted by anacreon View Post
I have 1038 Mo available on the Aura this morning, 495 on the Glo. I have always wondered how much space I MUST leave available when I'm on a downloading frenzy, and I guess I'll leave at least 100 above the database - which means I'd really like to slim it down.
That should be enough space. I just checked the SQLite manual and for the vacuum, it says "up to twice the size of the original database file". So, for a 250MB database, you should be OK with 500MB.

Because of something unrelated, I have been wondering how much space should be left free. Other than the database, there is also the firmware files when they are downloaded. They are about 130MB, so leaving enough for that would be a good idea.
Quote:
Unfortunately, the vacuum button on sqlite expert only reduced it by 20 Ko!
That isn't much, but it depends on what has happened recently. If you had just deleted a lot of books, I would expect a lot of space to be returned. But if you had just added a lot, there probably isn't much extra space in the database.

One thing I didn't check on: You didn't try to do the compress while calibre was still syncing or while you where sending books? It won't work if the database is open in some other way. The error should be something else, but it seems sometimes it shows as a disk full error.

To get around any issues on the device, you could take a backup of the database to the PC and do the compress there. That will show you how much space was freed and you can restore the file to the device.
davidfor is offline   Reply With Quote
Old 07-29-2013, 04:37 AM   #924
Ken Maltby
Wizard
Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.
 
Ken Maltby's Avatar
 
Posts: 2,928
Karma: 3910173
Join Date: Dec 2009
Location: The Heart of Texas
Device: JetBook Lite, AuraHD, PDA, Eee Transformer
I only have the free "SQLite Database Browser", it has a "File" option: "Compact Database" with this description: "Compact the database file, removing space wasted by deleted records." I assume the "vacuum" feature is something more than that.

Luck;
Ken
Ken Maltby is offline   Reply With Quote
Old 07-29-2013, 04:43 AM   #925
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: 5,888
Karma: 5704423
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo Touch, Kobo Glo
Quote:
Originally Posted by Ken Maltby View Post
I only have the free "SQLite Database Browser", it has a "File" option: "Compact Database" with this description: "Compact the database file, removing space wasted by deleted records." I assume the "vacuum" feature is something more than that.
Sorry, I'm swapping between different terms for the same thing. "vacuum" is the SQLite statement to compress the database. "Compress" is the more generic term that is used in most other database and in the various menus. Choosing this option will just run the vacuum statement.
davidfor is offline   Reply With Quote
Old 07-29-2013, 04:58 AM   #926
Ken Maltby
Wizard
Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.
 
Ken Maltby's Avatar
 
Posts: 2,928
Karma: 3910173
Join Date: Dec 2009
Location: The Heart of Texas
Device: JetBook Lite, AuraHD, PDA, Eee Transformer
Quote:
Originally Posted by davidfor View Post
Sorry, I'm swapping between different terms for the same thing. "vacuum" is the SQLite statement to compress the database. "Compress" is the more generic term that is used in most other database and in the various menus. Choosing this option will just run the vacuum statement.
I an just a little more confused. My non-expert SQLite is using the term "Compact", not "vacuum". The term "compress" is most often related to what the Zip programs do. I would expect a process named "vacuum" to be finding and removing un-needed bits, duplicates and orphans, within the database.

But I don't claim to have any idea how this feature functions in SQLite.

Luck;
Ken
Ken Maltby is offline   Reply With Quote
Old 07-29-2013, 05:13 AM   #927
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: 5,888
Karma: 5704423
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo Touch, Kobo Glo
Quote:
Originally Posted by Ken Maltby View Post
I an just a little more confused. My non-expert SQLite is using the term "Compact", not "vacuum". The term "compress" is most often related to what the Zip programs do. I would expect a process named "vacuum" to be finding and removing un-needed bits, duplicates and orphans, within the database.

But I don't claim to have any idea how this feature functions in SQLite.
The SQLite browser will have somewhere to run an SQL statement. You can enter "vacuum" in that and run it. The menu simple is a shortcut to running the statement.

As to why they chose "vacuum" for the name of the statement, I don't know. From my DB2 and SQLServer days, I think of it as "reorganize". "Compress" is a good generic term.
davidfor is offline   Reply With Quote
Old 07-29-2013, 05:33 AM   #928
Ken Maltby
Wizard
Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.
 
Ken Maltby's Avatar
 
Posts: 2,928
Karma: 3910173
Join Date: Dec 2009
Location: The Heart of Texas
Device: JetBook Lite, AuraHD, PDA, Eee Transformer
Quote:
Originally Posted by davidfor View Post
The SQLite browser will have somewhere to run an SQL statement. You can enter "vacuum" in that and run it. The menu simple is a shortcut to running the statement.

As to why they chose "vacuum" for the name of the statement, I don't know. From my DB2 and SQLServer days, I think of it as "reorganize". "Compress" is a good generic term.
Right the free version has three major tabs "Database Structure" "Browse Data" and "Execute SQL". I ran "vacuum" as a query and it reported "No Error", but I don't think it did much. There was nothing in the "Data returned:" area.

So in the windows version of SQLite the "File" tab selection "Compact Database" means what? Is it not what you guys are talking about or do you only get that in the "Expert" version?

Luck;
Ken
Ken Maltby is offline   Reply With Quote
Old 07-29-2013, 07:55 AM   #929
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: 5,888
Karma: 5704423
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo Touch, Kobo Glo
Quote:
Originally Posted by Ken Maltby View Post
Right the free version has three major tabs "Database Structure" "Browse Data" and "Execute SQL". I ran "vacuum" as a query and it reported "No Error", but I don't think it did much. There was nothing in the "Data returned:" area.
That is the expected result. If it works, it produces that. If it doesn't, there will be an error. The only time I have seen an error was when the database was corrupt.
Quote:
So in the windows version of SQLite the "File" tab selection "Compact Database" means what? Is it not what you guys are talking about or do you only get that in the "Expert" version?
"Compact database" will run "vacuum". It is a short curt to running the vacuum statement. It might wrap it in checks and probably displays a message box at the end, but the only thing important is that it runs vacuum.
davidfor is offline   Reply With Quote
Old 07-29-2013, 08:13 AM   #930
anacreon
Addict
anacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdomanacreon is an endless font of wit and wisdom
 
anacreon's Avatar
 
Posts: 217
Karma: 117282
Join Date: May 2012
Location: France
Device: sony prs-t2, aura 6" + h2o
New try

I added and cancelled books today. So I retried the Kobo utilities "compress", checking that Calibre wasn't working, and I had again the database full message.

I then did it directly with sqlite expert, and it reduced the data base from 244.477 to 244.069 Mo. Not so impressive but better.

I remember reading it is not enough to reset the reader to have a pristine database, and since I noticed it very recently, I unfortunately didn't keep a copy of the original one.

Does anybody know where I can find one?
anacreon is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Glo How to import reading Life Statistics from Kobo Touch to Kobo Glo? the_m Kobo Reader 5 12-13-2012 04:40 PM
$25 gift card w. purchase of Kobo Touch or Kobo Vox at Frys sufue Deals, Freebies, and Resources (No Self-Promotion) 0 07-15-2012 11:39 AM
Touch Kobo Touch defective after 3 months and Kobo Customer Support useless shaf Kobo Reader 5 12-04-2011 06:10 PM
Touch Kobo Touch not ejecting cleanly with Calibre OR Kobo Desktop - Windows 7 JBlyth Kobo Reader 11 08-03-2011 06:38 PM
Kobo Touch not disconnecting properly from Calibre OR Kobo Desktop - Windows 7 JBlyth Devices 1 08-03-2011 07:50 AM


All times are GMT -4. The time now is 03:57 AM.


MobileRead.com is a privately owned, operated and funded community.