<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi,<br>
<br>
I will post something, but now I'm not at home. So maybe today night.
But Dane wrote me about sqlite support in mapnik, so you can try that:<br>
<br>
----------------------------------------------------<br>
<div>Are you aware we have a postgres -> sqlite converter in mapnik?</div>
<div><a href="https://trac.mapnik.org/browser/trunk/utils/pgsql2sqlite">https://trac.mapnik.org/browser/trunk/utils/pgsql2sqlite</a></div>
<div><br>
</div>
<div>It requires the postgis and sqlite plugins:</div>
<div><br>
</div>
<div><a href="https://trac.mapnik.org/browser/trunk/plugins/input">https://trac.mapnik.org/browser/trunk/plugins/input</a></div>
<div><br>
</div>
<div>Just build mapnik with:</div>
<div><br>
</div>
<div>$ python scons/scons.py INPUT_PLUGINS=all PGSQL2SQLITE=True</div>
<div><br>
</div>
<div>I have been hand converting the XML, a scripted approach would be
cool.</div>
<div><br>
</div>
<div>Dane<br>
-----------------------------------------------------<br>
</div>
<br>
<a href="https://trac.mapnik.org/browser/trunk/utils/pgsql2sqlite"></a>I
don't thing that it is usable for me, because I do not like to convert
something many times to get the result. But I do not know about it (I
played with it half year ago, so maybe it did not exists yet).<br>
<br>
Tomas<br>
<br>
<br>
Christoph Eckert napsal(a):
<blockquote cite="mid:200904282101.37917.ce@christeck.de" type="cite">
<pre wrap="">Hi,
</pre>
<blockquote type="cite">
<pre wrap="">There is no reason to be sqlite slow. How much are you are using
transactions on your local db? What are you using for import? I'm
importing Czech republic (50Mb bziped) in one or two minutes. So for
5.4GB it takes 108 minutes (two hours). But I'm importig to modified osm
schema (something like mapnik schema in postgress). It is because of
query speed.
</pre>
</blockquote>
<pre wrap=""><!---->
sounds cool. Is the Script that does the conversion from osm.xml into sqlite
available somewhere?
Thanks & best regards,
ce
_______________________________________________
dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:dev@openstreetmap.org">dev@openstreetmap.org</a>
<a class="moz-txt-link-freetext" href="http://lists.openstreetmap.org/listinfo/dev">http://lists.openstreetmap.org/listinfo/dev</a>
</pre>
</blockquote>
<br>
</body>
</html>