[Xastir] Feature idea for Xastir

[Gerry Creager]

Despite Microsoft's claims to the contrary, SQLServer doesn't have a 
real spatial capability.  Neither does MySQL.  SDE/SQLServer does, but 
SDE isn't cheap.  PostgreSQL plus PostGIS (PostGIS is actually a patch 
to the schema mechanism) yields a spatial database on a par with Oracle 
and even acknowledged to be that good BY Oracle at times, usually when 
Oracle has released an update to beat features in place already in 
PostGIS.  And did I mention that PostGIS hasn't been out of beta but a 
couple of years and is still that good?

I think that, for most installs, we could have a PostgreSQL package that 
could drop in and then a script that puts PostGIS on top, then import 
the basic schemas.

I don't see it as more than a drop-in.

gerry

Jason Winningham wrote:
> 
> On Oct 4, 2007, at 7:03 PM, Tate Belden wrote:
> 
>> Is that even possible? To standardize on a generic 'SQL' so a specific 
>> set of features offered by any one SQL server don't dictate that 
>> server and only that server can be used?
> 
> I seem to recall that postgres has some specific GIS-type extensions 
> (PostGIS?) that would be desirable for an xastir implementation.
> 
> <queue Gerry>
> 
> I wouldn't worry too much about portability issues - I would expect the 
> database engine to be at least as portable (if not more so) than the 
> rest of the xastir support packages.
> 
> -Jason
> kg4wsv
> 
> 
> _______________________________________________
> Xastir mailing list
> Xastir at xastir.org
> http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir

-- 
Gerry Creager -- gerry.creager at tamu.edu
Texas Mesonet -- AATLT, Texas A&M University	
Cell: 979.229.5301 Office: 979.458.4020 FAX: 979.862.3983
Office: 1700 Research Parkway Ste 160, TAMU, College Station, TX 77843