Am Samstag, 28. Juni 2014 16:45:39 UTC+2 schrieb Tobias Besemer: > Am Samstag, 28. Juni 2014 14:42:40 UTC+2 schrieb David Rajchenbach-Teller: > > > See bug https://bugzilla.mozilla.org/show_bug.cgi?id=956713 for details > > > on the proposed Journaled Storage mechanism. This should bring down the > > > number of writes by an order of magnitude. > > > > I had a look at this bug ... it's in the example a backup of bookmarks ... > > > > My profile: > > places.sqlite ~20.5MB > > bookmarks-2014-06-28_21184_S86TKrc5SaHhq8DRLSUTkA==.json ~6.5MB > > > > My solution: > > https://stackoverflow.com/questions/75675/how-do-i-dump-the-data-of-some-sqlite3-tables > > https://stackoverflow.com/questions/75675/how-do-i-dump-the-data-of-some-sqlite3-tables/1938480#1938480
OK, I made a short test with: sqlite3.exe places.sqlite ".dump" >places.dump It creates in my case a file with ~9.5MB. But it is really fast !!! :D Also it is much better readable with an editor then JSON and can be used in any other program that can handle SQL ... I think 3MB more for each backup is OK ... Better - if HD is a prob - just make 10 backups then 15 ... IMHO ... _______________________________________________ dev-platform mailing list dev-platform@lists.mozilla.org https://lists.mozilla.org/listinfo/dev-platform
