07-28-2013, 01:06 PM | #916 | |
Wizard
Posts: 4,465
Karma: 6900052
Join Date: Dec 2009
Location: The Heart of Texas
Device: Boox Note2, AuraHD, PDA,
|
Quote:
Luck; Ken |
|
07-28-2013, 03:05 PM | #917 | |
Bibliophagist
Posts: 35,311
Karma: 145435140
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Forma, Clara HD, Lenovo M8 FHD, Paperwhite 4, Tolino epos
|
Quote:
Download page is at: http://www.sqliteexpert.com/download.html Regards, David |
|
Advert | |
|
07-28-2013, 04:23 PM | #918 | |
Guru
Posts: 959
Karma: 3475832
Join Date: May 2012
Location: France
Device: Elipsa, Sage
|
Quote:
|
|
07-28-2013, 09:25 PM | #919 | |
Grand Sorcerer
Posts: 24,907
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Quote:
|
|
07-28-2013, 09:28 PM | #920 |
Groupie
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?
|
Advert | |
|
07-28-2013, 11:17 PM | #921 | |
Wizard
Posts: 4,812
Karma: 26912940
Join Date: Apr 2010
Device: sony PRS-T1 and T3, Kobo Mini and Aura HD, Tablet
|
Quote:
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 |
|
07-29-2013, 01:14 AM | #922 | |
Guru
Posts: 959
Karma: 3475832
Join Date: May 2012
Location: France
Device: Elipsa, Sage
|
Quote:
Unfortunately, the vacuum button on sqlite expert only reduced it by 20 Ko! |
|
07-29-2013, 03:03 AM | #923 | ||
Grand Sorcerer
Posts: 24,907
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Quote:
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:
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. |
||
07-29-2013, 03:37 AM | #924 |
Wizard
Posts: 4,465
Karma: 6900052
Join Date: Dec 2009
Location: The Heart of Texas
Device: Boox Note2, AuraHD, PDA,
|
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 |
07-29-2013, 03:43 AM | #925 |
Grand Sorcerer
Posts: 24,907
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
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.
|
07-29-2013, 03:58 AM | #926 | |
Wizard
Posts: 4,465
Karma: 6900052
Join Date: Dec 2009
Location: The Heart of Texas
Device: Boox Note2, AuraHD, PDA,
|
Quote:
But I don't claim to have any idea how this feature functions in SQLite. Luck; Ken |
|
07-29-2013, 04:13 AM | #927 | |
Grand Sorcerer
Posts: 24,907
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Quote:
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. |
|
07-29-2013, 04:33 AM | #928 | |
Wizard
Posts: 4,465
Karma: 6900052
Join Date: Dec 2009
Location: The Heart of Texas
Device: Boox Note2, AuraHD, PDA,
|
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? Luck; Ken |
|
07-29-2013, 06:55 AM | #929 | ||
Grand Sorcerer
Posts: 24,907
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Quote:
Quote:
|
||
07-29-2013, 07:13 AM | #930 |
Guru
Posts: 959
Karma: 3475832
Join Date: May 2012
Location: France
Device: Elipsa, Sage
|
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? |
|
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 03:40 PM |
$25 gift card w. purchase of Kobo Touch or Kobo Vox at Frys | sufue | Deals and Resources (No Self-Promotion or Affiliate Links) | 0 | 07-15-2012 10:39 AM |
Touch Kobo Touch defective after 3 months and Kobo Customer Support useless | shaf | Kobo Reader | 5 | 12-04-2011 05:10 PM |
Touch Kobo Touch not ejecting cleanly with Calibre OR Kobo Desktop - Windows 7 | JBlyth | Kobo Reader | 11 | 08-03-2011 05:38 PM |
Kobo Touch not disconnecting properly from Calibre OR Kobo Desktop - Windows 7 | JBlyth | Devices | 1 | 08-03-2011 06:50 AM |