Hello!
I see the storing of pictures inside the database as problematic - due
to the pure file size to be expected, especially if it also possible to
store RAW-files: Just an example from my own work (ecological study):
In a project I have 16 plots studying the development of vegetation,
working there for three years, just if I make 5 photos per year (which
is almost nothing), we end up with 16 * 3 * 5 = 240 pics. I own an
Olympus E1, so a relatively old camera with "just" 5 Megapixel, the
RAW-file has 10.2 MB, so that would be around 2.5 GB of Data overall in
this theoretical case. Small project, old camera, meaning relatively
small resolution...
Even if we take just the jpg (for me and my camera, most of the time
something between 0.5 - 1.2 MB) still around 200 MB... so specially for
mobile devices or portability between devices not ideal I'd say... Maybe
storing just a thumbnail and defining a root-directory were the pictures
are would be an option?
I hope, not being a developer, my thoughts are not taken as an offense!
The features discussed are great and I would be very pleased if they are
implemented, but storing big binary data in a database could be
problematic, as I said...
Thank you all for your efforts!
Greetings,
Albin
Am 04.07.2016 01:34 PM, schrieb Matthias Kuhn:
Hi Mark
On 07/04/2016 12:35 PM, Mark Johnson wrote:
Work is being done in this area, intended to be an extension of the
RasterLite2 library (of the spatialite project), which will hopefully
come out this year.
The Raster-support in RasterLite2 supports Georeferenced images called
Raster-Coverage's.
The idea would be to add support for Geotaged images in the form of an
'Album'
- one Album containing images
- each Album could belong to another Album
Will it easily be possible to extract such a photo from the spatialite
file?
Thinking about QField (mobile application), I like the in-database
approach for its portability but fear that the photos will be locked in
there and that it will be quite hard to use them for a report written
in
an application that does not support RasterLite2.
Matthias
_______________________________________________
Qgis-developer mailing list
[email protected]
List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
--
| Dr.rer.nat. Albin Blaschka
| Etrichstrasse 26, A-5020 Salzburg
| * www.standortsanalyse.net *
| * www.researchgate.net/profile/Albin_Blaschka *
| - It's hard to live in the mountains, hard but not hopeless!
_______________________________________________
Qgis-developer mailing list
[email protected]
List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
