>>60604166 (You)#
>We need to convert them to sqlite format as well.

I used to worked with GIS applications and we used something called ogr2ogr to dump our database to sqlite

ogr2ogr -f SQLite -dsco SPATIALITE=false myfile.sqlite PG:"dbname=mydb user=myuser password=mypass" myschema.mytable



spatialite is set to false because the nyaa db won't have geospatial data type in it

although there are other alternatives using python or other scripting languages.