[postgis-devel] 答复: [SoC] Proposal for geospatial data viewer inpgAdmin4 for PostGIS

[Frikan Erwee]

Dear 董林,


Thank you. I am the co-mentor on this GoSC project. The comments are all
valid, and we will take them into account when we plan out the viewer with
Xuri.


Regards
Frikan Erwee

On Thu, Mar 22, 2018 at 8:09 AM, 董林 <dl at whu.edu.cn> wrote:

> If you have started the work, I can help you. If you want to get a viewer
> right now, you can use QGIS, Grass GIS, Udig or use GeoServer and its layer
> previewer. The most urgent work I think is to rewrite functions to enable
> Postgres 9.6+’s parallel query feature (and for Postgres on Hadoop in the
> future).
>
>
>
> Our company uses Postgres+PostGIS as the main spatial database, most of
> our products rely on them. It seems strange that a GISer complain about
> these things (pgAdmin4):
>
> No hint on invalid SQLs (version 2.1 is much better)
>
> Can not export query results(copy to)
>
> Can not import/export table data from/to text files(copy from/to)
>
> Can not backup/restore specified tables(pg_dump/pg_restore)
>
>  No psql and shp2pgsql short cut
>
>  A huge installer (150M+.  PostgreSQL 9.5 with pgAdmin 3 is 60+M,
> PostgresSQL 10.3 with pgAdmin4 is 160+M)
>
> Starts slow (pgAdmin4.2 cost 30 seconds vs pgAdmin3 cost 5s)
>
>
>
> pgAdmin4 must change greately in the future or it will be a failure, I
> guess. May be an independent viewer is a good choice, but it must be small
> and smart.
>
>
>
> *发件人: *Xuri Gong <xurigoong at gmail.com>
> *发送时间: *2018年3月21日 22:19
> *收件人: *postgis-devel at lists.osgeo.org
> *主题: *[postgis-devel] [SoC] Proposal for geospatial data viewer
> inpgAdmin4 for PostGIS
>
>
>
> Hi,
>
>
>
> My name is Xuri Gong, undergraduate student in Peking University, Beijing,
> China. My project idea is to implement a geospatial data viewer for postGIS
> in pgAdmin4. Here is the draft of my proposal: https://docs.google.
> com/document/d/1MH54gIlQpbx56uVx5e_QNP4MWp9NoFdsCcWUFRGBESo/edit?
> usp=sharing
>
>
>
> It would be great if you could review it and provide your valuable
> feedback. You can comment directly on my proposal.
>
>
>
> Regards,
>
> Xuri Gong
>
>
>
>
>
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20180322/a74bcfb2/attachment.html>