Closed wirthual closed 7 years ago
the data in sqlite is png to begin with - you need to use something like imagemagick to convert https://github.com/icetan/sqlitepipe
UPDATE images SET tile_data=pipe('convert -format jpg -quality 90% png:- jpg:-', tile_data); VACUUM images;
Thanks for the question! Since this is a common question, I've added it to the FAQ: can mbutil convert image formats?
mb-util ~/Desktop/Leaflet/hh.mbtiles ~/Desktop/Leaflet/Test2 --image_format jpg
Creates files with the extension .jpg but they are no jpegs.
If you rename the files to .png they work.