Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!e56g2000cwe.googlegroups.com!not-for-mail From: pramsey@refractions.net Newsgroups: comp.databases.oracle.server Subject: Re: Python vs. PL/SQL for Oracle work Date: 2 Mar 2006 22:04:04 -0800 Organization: http://groups.google.com Lines: 45 Message-ID: <1141365844.849079.64160@e56g2000cwe.googlegroups.com> References: <1140263528.821122.323610@g43g2000cwa.googlegroups.com> <1140717030.094698.140420@g47g2000cwa.googlegroups.com> <1141306632.822815.308130@v46g2000cwv.googlegroups.com> <1141311464.456063.184200@t39g2000cwt.googlegroups.com> NNTP-Posting-Host: 24.69.19.233 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1141365850 10921 127.0.0.1 (3 Mar 2006 06:04:10 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Fri, 3 Mar 2006 06:04:10 +0000 (UTC) In-Reply-To: <1141311464.456063.184200@t39g2000cwt.googlegroups.com> User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en-us) AppleWebKit/417.9 (KHTML, like Gecko) Safari/417.8,gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: e56g2000cwe.googlegroups.com; posting-host=24.69.19.233; posting-account=ul2KTQ0AAADqmCcoYeCMB7YOvMl9Obez Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:262659 Dana, dananrg@yahoo.com wrote: > It's interesting that you bring up open source, because I have been > investigating an open source spatial database extension to PostgreSQL > called PostGIS, also being developed by http://www.refractions.net. I > wonder if it can do what you mentioned in your emergency contacts > example. Indeed it can. And all of Hans' points regarding the virtues of doing this kind of stuff at the database tier are totally correct. Once you get your head wired database-centric for spatial problems, you'll never go back to your GIS. > For what it's worth, I attended a presentation from a > refractions.net fellow, and he gave higher marks to Oracle Spatial vs. > ArcSDE, for Oracle Spatial being more of a "real" spatial database. As that fellow, I still think so! Hans said in an earlier post that SDE was a lock-in gambit, and he is so right! Ironic, given the "database neutral" marketing slant, but of course SDE is database neutral and GIS vendor specific. "But there are SDE client libraries!" you say. If your client is not Arc* you are restricted to 5 concurrent connections unless you purchase extra licenses! But Arc* clients can have infinite connections to your SDE. And of course once you use SDE you make the use of real spatial database internals like triggers and so on much more fiddley, because touching your data without telling SDE throws things out of synch and Tempts the Gods. I could go on and on. I often do. Anyhow, Oracle, DB2, Informix and PostgreSQL/PostGIS are "real" spatial databases. SDE is marketed as a "spatial middleware" and best understood as such. Paul > >I admit that my knowledge of ESRI is no longer 'current' and freely > >accept and invite updates. > > Let me know if I have your permission to quote you on the ESRI support > forums and I can report back here with any good replies. > > Dana