I follow up this in a new thread so the original keeps focusing on statistical tools.

Gustavo Palminha: 18 Oct-08 19:57

About postgres support, i think that Manifold has to 'support better' the postgresql DBMS, so it's one of the 'milestones' to reach.

... "supported" DBMS where sql server and oracle, although mysql and postgresql were usable but not "supported".

This had been the case with older Mfd versions. With v. 1.2 (1.0?) PostGIS native geometries had been enhanced and the minimum of functions added to be support by Mfd and so - according to the homepage - PostgreSQL with PostGIS are supported and so is the Manifold part of native connection technics.

As a PostGIS user I'm always interested in 'better support'. But actually I don't get what it is exactly that you want to have. Database Console and Server Console must be general to all DBMSs (all supported and hopefuly but at your own risk all other like MySQL or SQLite).

Creating triggers, sequences, configuring access control, ... are rather DBMS specific tasks. I can use pgadmin III from every client. So I don't know what functions exactly you want to be added to Mfd.

I can think of (not DBMS specific):

- creating indexes

- creating server sided relations (views) including the necessary indexes.

1) Stored Procedures and/or triggers would be awesome.

2) Indexes and/or the ability to optimize queries better. An Explain Plan would be very helpful. Query 'Hints' would be helpful. Right now the database engine is too much of a black box so that query optimization becomes very difficult.

Distributed Geospatial Solutions -- makers of AtlasAlive Geo-Hosting Framework (Check out version 3.9!) www.distributedgis.com

i share the point of view of gustavo but refer to manifold documentation not postgis functionnalities support by manifold gis system :

because read documentation and wanted to make my own frenchdocumentation before reinstall newer version of postgres on my new xp home OS ; i see that the top chapter of DBMS contain subchapter of name oracle and MS SQL but no postgres title and when you go to index en choose the letter P then postgres/postgis goes to the same link http://www.manifold.net/doc/spatial_dbms.htm so goes to an not specific postgis html page !!. so when wanted to write a summary of problems /soluces about postgres for avoid already know problems, at this time i have to search in the forum rather than the documentation. I wait for the next release to see what's ll be new in the functionnalities side and documentation side .

there is very few project or hosting about postgres

www.bisonvert.net is a web server that use GeoDjango, postgis, proj gdal, Google Map Geonames prototype script.Aculo.us openlayer

this show a good way to anwser to a javascript question about how control circle size using slide or move circle using central point localt in a div ? that contain google map

Hello to all.

Klaus

...But actually I don't get what it is exactly that you want to have....

Well a few things crossed my mind when i mencioned...

that Manifold has to 'support better' the postgresql DBMS, so it's one of the 'milestones' to reach

For example:

atlasalive

Stored Procedures and/or triggers would be awesome.

... but this feature is already supported in manifold but i believe it's only available on ultimate edition or any high manifold's product license, if i'm not mistaken (please not that ''high manifold's product", does not stand for too 'expensive', so this terms refers to the more complete manifold version).

Another thing that crossed my mind when i refered the above, it was what i mencioned in post postgres & manifold strange connection issue (link: http://forum.manifold.net/forum/t65695.6) and i havent got the time to check if this was fixed after the latest manifold updates, but i believe that remains the same, and will be fixed in the next manifold release.

Regards.

Hello.

One thing that would be interesting feature to add is the Data shaping, some information can be found here http://www.4guysfromrolla.com/webtech/092599-1.shtml.

Regards.

SHAPE ... APPEND ... RELATE syntax indeed looks simpler than JOIN ... ON but it's restricted to ADO connections .

Let's see what comes out of the prommissed Query Builder in v9. It's likely JOINs are included in a visual and not in a connection specific way.

it's only available on ultimate edition or any high manifold's product license

Strictly speaking, you don't need DBA edition or Ultimate edition although the Triggers dialog that becomes available in those makes such things easier, especially when you are taking advantage of Enterprise facilities made available by Manifold. See http://www.manifold.net/doc/database_object_triggers.htm

The specialized DBMS facilities in Enterprise and above include the ability to utilize native spatial geometry types such as SDO_GEOMETRY in Oracle, multiuser conflict resolution through a version column and review pane, etc. It's true that Enterprise can use triggers, for example, to update the version column automatically when objects get changed.

But it's also true that every Manifold edition from Personal on up has formidable DBMS connection capabilities for use with "ordinary" (that is, not special spatial DBMS geometry types) attributes. If you are connecting to a DBMS using any other edition, even Personal edition, to do ordinary attribute things nothing prevents you from using the DBMS's own admin facilities to set up triggers, etc., that will react to changes made with Manifold.

I'd second the explain plan, it would be nice to be able to optimize queries intelligently, rather than just running them and seeing hold long they take-

Just found this to explain oracles Explain Plan. Yes, that would be great but a feature request could only refer to Manifolds internal SQL engine of cause.

well, yeah, i think thats the point here, to see how manifold is executing the query, what kind of joins are being performed, if its using indexes (I assume manifold uses indexes?), etc-