<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6001.18248" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=488301502-14062009><FONT face=Arial
color=#0000ff size=2>Jose,</FONT></SPAN></DIV>
<DIV><SPAN class=042583002-14062009><FONT face=Arial color=#0000ff
size=2> </FONT></SPAN></DIV>
<DIV><SPAN class=042583002-14062009><FONT face=Arial color=#0000ff size=2>Just
occurred to me that Schuyler Erle had submitted a patch for this very thing that
Leo was alluding to that would make chaining a little
easier.</FONT></SPAN></DIV>
<DIV><SPAN class=042583002-14062009><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=042583002-14062009><FONT face=Arial color=#0000ff size=2>Though
would be nice to have direct output compatibility without need for
chaining</FONT></SPAN></DIV>
<DIV><SPAN class=042583002-14062009><FONT face=Arial color=#0000ff
size=2></FONT></SPAN><SPAN class=042583002-14062009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=042583002-14062009><FONT face=Arial color=#0000ff size=2><A
href="http://trac.osgeo.org/postgis/ticket/123">http://trac.osgeo.org/postgis/ticket/123</A></FONT></SPAN></DIV>
<DIV><SPAN class=042583002-14062009></SPAN> </DIV>
<DIV><SPAN class=042583002-14062009> <FONT face=Arial color=#0000ff
size=2>Hope that helps,</FONT></SPAN></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=042583002-14062009>Regina </SPAN><SPAN
class=042583002-14062009> </SPAN></FONT></FONT></FONT><BR></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Jose
Gomez-Dans<BR><B>Sent:</B> Saturday, June 13, 2009 3:44 PM<BR><B>To:</B> PostGIS
Users Discussion<BR><B>Subject:</B> [postgis-users] Moving to SpatiaLite: best
practice<BR></FONT><BR></DIV>
<DIV></DIV>Hi,<BR>I'm doing some very simple PostGIS-related work: I store data
in a table, and from time to time, I do simple stuff with the stored data,
sometimes even actually using the geometry column!!! Anyway, PostGIS has been
very useful so far, but I now have to move away from my work computer, and I
would like to keep on working with my laptop. One way would be to install
PostGIS on my laptop, but I am also thinking of giving my program to other
people, who might not necessarily need or want to install PostGIS. To this end,
spatialite is very handy. It's just a file, and I can use the same PostGIS stuff
I've been using up to now. However, I need to move my tables to SpatialLite. In
essence, I do have a number of tables, most of which relate a field to a
geographical table. It should be trivial to dump schema and SQL and run it pass
sqlite/spatialite. I was just wondering whether anyone had any recommendations
or ideas on "best practice".<BR><BR>Thanks!<BR>Jose<BR></BODY></HTML>