Thread: Kobo Firmware 3.11.0
View Single Post
Old 11-10-2014, 09:11 PM   #359
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 JSWolf View Post
What is the best way to compress an SQL database?
That really depends on the "SQL database". You should use the tools supplied as part of the RDBMS. They all have them. Or a third party tool that does it.

And yes, that is me being a smart-arse (but it is a completely accurate answer). "SQL database" has almost no meaning in a question like that because there are a lot of different SQL databases. DB2, MySQL, Progresss, Oracle, SQL Server could all be called SQL databases.

Of course, the context does tell me that you are probably talking about the SQLite database that the Kobo devices use. In that case, the simplest way to compress it is using my Kobo Utilities plugin in calibre. Other than that, any SQLite database tool will have an option to do it or allow you to run VACUUM.
davidfor is offline   Reply With Quote