Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Artifact ID: | e9f80d57bbe5979c02f3a0297c5ec5c246034986 |
|---|---|
| Page Name: | version-1.8.0 |
| Date: | 2014-07-22 10:02:28 |
| Original User: | sandro |
| Parent: | 4b6bea944aaebb4229a6c43fa4e44f203492b18c (diff) |
| Next | c04f9668012f06227090564e8680b963233ee0c4 |
Content
Back to main Wiki page
Changes introduced starting since version 1.8.0
1 - Executing more SQL statements in a single shot
The execution of multiple SQL statements in a single pass is now supported:
- execution will immediately stop when some SQL error is eventually found; this practically means that some statements could be effectively processed, while other statements could be ignored due to premature termination.
- only the resultset (if any) returned by the most recent SQL statement being successfully executed will be shown in the panel.
- explicitly terminating each single SQL statement by inserting a semi-colon (;) is an always suggested good practice when executing multiple statements.
2 - DB connections and Security modes
As you probably remember, there are few SQL functions supported by SpatiaLite that could eventually pose some security concern because they implement some kind of direct data exchange between the DB and the local file-system.In the worst possible scenario an hypothetical hacker could eventually attempt to attack an external system by offering for download a purposely forged SpatiaLite DB containing maliciously forged Triggers, and the user will then be completely unaware of such a potentially dangerous threat.
The standard approach implemented by libstpatialite is the one to always keep completely disabled all these potentially harmful SQL functions, unless the environment variable SPATIALITE_SECURITY=relaxed is explicitly set by the user.
Now spatialite_gui support a smarter and easiest approach, completely based on internal actions and no longer requiring any explicit user action.
Please note: now a small icon always shows the status of the current DB Connection.
case A) connecting to a sane DB
spatialite_gui will now always perform a preliminary sanity check before connecting any already existing DB.
- if no actual threat is found, then spatialite_gui will automatically enable SPATIALITE_SECURITY=relaxed
- thus allowing the user to freely invoke all security-related SQL functions without any restriction.
- in this case the connection icon will be the one shown in this figure.
case B) starting a READ ONLY DB connection
- anyway whenever a READ ONLY connection is established the ordinary security restrictions will always be enforced.
- in this case the connection icon will be the one shown in this figure.
case C) connecting to a potentially harmful DB
In the unlucky case that the preliminary security check would identify some problematic Trigger, an appropriate security alert will be immediately raised.
- in this case the ordinary security restrictions will always be enforced.
- the connection icon will be the one shown in this figure.
- Please note well: anyway an external (i.e. from the command shell) SPATIALITE_SECURITY=relaxed declaration will still continue to be honored.
3 - RasterLite2 integrated support
Starting since version 1.8.0 librasterlite2 becomes integral part of spatialite_gui (i.e. it will become a not configurable mandatory dependency).3.1 - Raster Coverages
All RasterCoverage-related tables will be hierarchically grouped on a distinct branch of the Tables Tree.
Administering all SLD/SE Styles for each single Raster Coverage will now be directly accessible via the corresponding context menu.
3.2 - SLD/SE Styles administration
3.2a - Adding a new Raster Style for a given Coverage
You can access this feature from the context menu directly supporting each Coverage.
First of all you should select from the file-system the XML document containing the SLD/DE Style you intend to load.
Then you simply have to definitely confirm. The XML document will be parsed and formally checked for full Schema validation under the expectation that it should contain a valid SLD/SE RasterSymbolizer.
If no error is found then the Style will be immediately added to the Coverage.
3.2b - Listing all Raster Styles for a given Coverage
You can access this feature from the context menu directly supporting each Coverage.
- this dialog box will report all SLD/SE Styles already defined for each single Raster Coverage.
- the same dialog could be used in order to add more SLD/SE Styles.
First of all you should select from the file-system the XML document containing the SLD/DE Style you intend to load; but differently from the above case you can now select multiple files in a single pass.
Then each single XML document will be loaded (exactly as we've already seen in the previous step).
You could eventually remove some already defined Style; just left-click on the corresponding row.
After final confirmation the selected Style will be definitely removed from the Coverage.
3.3 - Coverage Tiles Preview
For each <coverage-prefix>_tile_data table (the one effectively containing raster tiles) a preview feature is supported.
Each tile will be shown accordingly to the Coverage's default style.
In the special case of tiles adopting some exotic pixel format (e.g. UINT32, FLOAT or DOUBLE) a default grayscale rendering will be adopted.
In the very special case of multi-band pixels only the first band (Band #0) will be shown.
Back to main Wiki page