lukasmartinelli / postgis-editor Goto Github PK

Hi,

thanks for this awesome project !!

My connection to Postgis need SSL support (can't connect over unencrypted channel), the driver doesn't seems to detect if the connection need ssl or not.

Provide SQL autocompletion in code mirror.

• Suggest tables (important)
• Column names (less important)

This does not work

SELECT st_centroid(linestring) geom,* FROM ways
-- where (ways.tags -> 'highway'::text) IS NOT NULL

This works

SELECT st_centroid(linestring) geom,* FROM ways

It seems the performance limit is actually limited by the size of the GeoJSON.
At around 110MB the Electron app might crash. I tried writing to a GeoJSON file directly and then load it but it turns out performance is not that much better than my in memory objects.

The problem is more that we parse the PostgreSQL result (only once we received all rows) into real GeoJSON which might also take 2seconds. But just making the 110MB query from the database takes 5s to 10s so it might be still ok.

Also there might be a clustering optimization for points.

You can show 350k points and it works. But according to Mapbox we should be able to display millions of points.

Hi - I ran into this error - not sure what it's referring to though?

on your code here:

    connect(connectionOptions) {
        this.db = pgp(connectionOptions);
    }

You should know that that code does nothing really. It doesn't connect to the database, merely creates a new database object, as this library uses lazy connection. This is why in all the examples db is created once, globally.

See also related: http://stackoverflow.com/questions/36120435/verify-database-connection-with-pg-promise-when-starting-an-app

And since event extend is triggered for each such object, it would only reduce the performance, trying to extend every new instance created, while quite pointlessly.

Most CSS resources inside resources could also be taken from npm. But how to do that?
Using webpack?

I did a select * from a big dataset of all Australian collector districts. This is, admittedly, a big, complex dataset. But it didn't work, so I thought I'd let you know.

Here's the data: http://www.abs.gov.au/ausstats/[email protected]/DetailsPage/1259.0.30.0022006?OpenDocument you need to get all the states.

When it finishes selecting, you can click on a row and the map shows the popup, but no graphics are rendered. On the image below it shows the previous area I was looking at.

I have no idea whether the release actually works on Windows 64bit.

The application stalls when you run a big query.

The query perhaps should be run in a background thread and a progress or some kind of spinner used to show that it's working.

Geometry columns which are not EPSG:4326 are not recognised. The solution is straightforward, just do
ST_Transform([geometrycolumn], 4326)
for any [geometrycolumn]. If it's already in EPSG:4326, it will not harm anything.

Allow to export a GeoJSON of the last query.

Allow moving the different panes to make them as big as you want.

PostGIS Raster geometry types (raster, geomval) will be great extension, as it's somewhat hard to use it in QGIS for example - need to create table with query results, no way to use query as new layer.

Now, if i try the most simple query

select * from ways on a osmosis loaded postgis DB, it will say that it did not find the geometry.

Maybe it's only my case, but I cannot see anything on the map, it's black-on-dark-grey.