Opened 6 years ago

Closed 22 months ago

#1085 closed enhancement (fixed)

PostGIS Quickstart review - remove command line description?

Reported by: camerons Owned by: live-demo@…
Priority: normal Milestone: OSGeoLive8.0
Component: OSGeoLive Keywords: postgis, docs, 7.5


I've added the follow review comments into the PostGIS quickstart:

For this quickstart, which targets new users who might not be familiar with databases or SQL, I suggest we drop section describing command line control of Postgres. If we do keep command line information, I suggest it is moved to the end of the quickstart, possibly added into "Things you could try". Instead, I think the Quickstart should cover:

  • Keep Client/Server? overview
  • Create a database in pgAdmin
  • Load a dataset, probably from a shapefile
  • Do some SQL queries on the dataset
  • Use QGis to view data from PostGIS (using the existing Natural Earth data). We should be able to keep most of the existing QGis sections

Change history (11)

comment:1 Changed 6 years ago by darkblueb

Type: defectenhancement

I am of the opinion that eliminating the command line from quickstarts systematically is a mistake; that a GUI should be used for the quickstart whenever possible; and that existing materials that are sound, should not be thrown away

comment:2 Changed 6 years ago by camerons

I'm ok with keeping the Command Line section in the Quickstart, as long as it is comes in after the GUI description. (The Spatialite DB Quickstart has just been restructured into this format).

comment:3 Changed 6 years ago by hamish

Summary: PostGIS Quickstart review - remove command line descriptionPostGIS Quickstart review - remove command line description?

With respect to the command line stuff in PostGIS (if you could call it that, it's not arcane bash tricks or anything, just simple one liners in the psql environ which any SQL-literate reader will be right at home with) -- any sort of spatial query or equation is going to be done at that level.

pgadmin3 is a fine program, and a great way to visualize and explore how the DB is put together, but this isn't a tutorial on how to easily manage or tweak a DB -- it's a tutorial on how to do spatial analyses. pgadmin3 is just the nice data explorer along side.

If the command line is the best (i.e. most concise) or only place to perform some action then that is what should be presented. So I'm with Brian on this one, irrational fear of the command line [i.e. unknown] is something which should be actively and explicitly combated with the gentle introduction of (understandable) one liners. I'm not too worried about the order of the page where it doesn't harm the logical progression, but the content should remain where it is the best tool for the job.

best, Hamish

comment:4 Changed 6 years ago by kalxas


I just went through the PostGIS Quickstart and I think that it is of high quality. I agree that we should not remove all the CLI stuff. Perhaps we can just push the GUI part on the top of the guide.

Best, Angelos

comment:5 Changed 6 years ago by camerons

Keywords: 7.0 added; 6.5 removed
Milestone: OSGeoLive6.5OSGeoLive7.0

Agreed in IRC meeting (pre osgeolive 6.5 release) that we should move the Command Line text to the end of the Quickstart, so long as the story still flows. Moving this to be fixed for 7.0 release.

comment:6 Changed 6 years ago by darkblueb

I suggest we close this ticket for 7.0

comment:7 Changed 6 years ago by kalxas

Keywords: 7.5 added; 7.0 removed
Milestone: OSGeoLive7.0OSGeoLive7.5

moved to next release

comment:8 Changed 5 years ago by kalxas

Milestone: OSGeoLive7.9OSGeoLive8.0

comment:9 Changed 22 months ago by astrid_emde

comment:10 Changed 22 months ago by kalxas

I think we should close this ticket.

comment:11 Changed 22 months ago by darkblueb

Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.