Working with Databases - Revision history

Michaudm at 17:45, 2 December 2012

2012-12-02T17:45:17Z

2012-12-02T17:44:41Z

2012-12-02T17:37:00Z

2012-12-02T17:34:06Z

2012-12-02T14:51:35Z

2012-11-30T23:49:57Z

2012-11-30T23:48:57Z

2012-11-30T23:45:52Z

2012-11-30T23:40:02Z

2012-11-30T23:34:17Z

@@ Line 34: / Line 34: @@
 Compared to the previous plugin, this one creates read/write layers. It is not dynamic (does not reload data after each zoom/pan) and it lets the user create any SQL query (queries involving several tables for example).<br>
 The three buttons on the right side (view, fence, selection) makes it possible to create queries which are sensitive to OpenJUMP context. It is a powerful way to make DataStore Queries more '''dynamic'''.<br>
-See the [[Run DataStore Query]] page to learn more about how to use this plugin.<br>
+See the [[Run DataStore Query]] page to learn more about how to use this plugin. (to be written)<br>
 [[File:RunDataStoreQuery.png]]

@@ Line 19: / Line 19: @@
 [[File:ConfigureConnection.png]]
-To get more details about connection configuration, go to [[Configure a DataBase Connection]]
+To get more details about connection configuration, go to [[Configure a DataBase Connection]] (to be written)
 === '''Connecting a layer to a table''' ===
@@ Line 31: / Line 31: @@
 === '''Creating a layer from a query''' ===
-The plugin '''Run DataStore Query''' is found directly uneder the '''File''' menu.
+The plugin '''Run DataStore Query''' is found directly uneder the '''File''' menu.<br>
 Compared to the previous plugin, this one creates read/write layers. It is not dynamic (does not reload data after each zoom/pan) and it lets the user create any SQL query (queries involving several tables for example).<br>
 [[File:RunDataStoreQuery.png]]

@@ Line 40: / Line 40: @@
 Of course, refreshing a layer issued from a DatStore Query will loose the modifications you may have done on this layer (see Saving as PostGIS table)
-=== '''Saving a Layer into a PostGIS table''' ===
+=== '''Saving a Layer to a PostGIS table''' ===
 Since OpenJUMP 1.6, a new plugin replaces the old PostGIS extension to upload data from OpenJUMP into a PostgreSQL/PostGIS database.
 To get it, right click on the layer, then choose '''Save Dataset As...''', and select the '''PostGIS table''' format.

@@ Line 23: / Line 23: @@
 === '''Connecting a layer to a table''' ===
 To connect a Layer to a DataBase (AKA DataStore layer), choose the '''DataStore Layer''' option, in Files > Open... menu.
-Once a connection has been selected (see previous chapter), you can choose a table name and the database column containing the geometry to load as the feature geometry (a database table may have several geometries per feature).
+Once a connection has been selected (see previous chapter), you can choose a table name and the database column containing the geometry to load as the feature geometry (a database table may have several geometries per feature).<br>
 [[File:OpenDataStoreConnection.png]]
-Note that the plugin creates a dynamic layer. It means that each modification made in the view (zoom, pan...) will reload the data consequently.
+This plugin creates a dynamic, read-only layer : each modification made in the view (zoom, pan...) will load the data intersecting the viewport.<br>
-It also means that only data intersecting the viewport is loaded, an the OpenJUMP layer does not represent the whole table but only the part visible in the viewPort.
+Warning : OpenJUMP layer does not represent the whole table but only the part visible in the viewPort. Making a query against the layer in OpenJUMP is not equivalent to making a query against the whole table in the database.
 === '''Creating a layer from a query''' ===
 == Other resources ==

@@ Line 5: / Line 5: @@
 === '''Database connection''' ===
-There are several plugins in OpenJUMP, making use of DataBase connections
+Several plugins, in OpenJUMP, make use of DataBase connections
 * '''DataStore Layer''' available in Files > Open...
 * '''Run DataStore Query''' available in Files
@@ Line 22: / Line 22: @@
 === '''Connecting a layer to a table''' ===
 === '''Creating a layer from a query''' ===

@@ Line 13: / Line 13: @@
 [[File:SelectConnection.png]]
-The right icon representing a DataBase open the Connection Manager<br>
+The right blue icon representing a DataBase open the Connection Manager<br>
 [[File:ConnectionManager.png]]
-Creating a new connection open the following dialog box to configure the connection<br>
+Adding a new connection open the following dialog box to configure the connection<br>
 [[File:ConfigureConnection.png]]

@@ Line 10: / Line 10: @@
 * '''Save As PostGIS''' available in the layer contextuel menu : write click on the layer, then choose '''Save Dataset As...''' and select the '''PostGIS table''' format
-All these plugins use the same Connection selector
+All these plugins use the same Connection selector<br>
 [[File:SelectConnection.png]]
-and the same way to configure a new connection
+and the same way to configure a new connection<br>
 [[File:ConfigureConnection.png]]

← Older revision		Revision as of 23:34, 30 November 2012
Line 5:		Line 5:

	=== '''Database connection''' ===		=== '''Database connection''' ===
		+	There are several plugins in OpenJUMP, making use of DataBase connections
		+	* '''DataStore Layer''' available in Files > Open...
		+	* '''Run DataStore Query''' available in Files
		+	* '''Save As PostGIS''' available in the layer contextuel menu : write click on the layer, then choose '''Save Dataset As...''' and select the '''PostGIS table''' format
		+
		+	All these plugins use the same Connection selector
		+	[[File:SelectConnection.png]]
		+
		+	and the same way to configure a new connection
		+	[[File:ConfigureConnection.png]]

	=== '''Connecting a layer to a table''' ===		=== '''Connecting a layer to a table''' ===