I have PostGIS database, which I am using to store raster image as raster datatype. A table has column date, raster, and other property. There are more than 30 tables in the database. The database tables are updated, where the raster for the particular time is replaced with the latest available and/or new rows are added.
I am doing little research on if I can use GeoServer to store the dynamic PostGIS DB and render as WMS/WFS for the web client. I need to be able to perform clipping, filter particular row based on date and style those data. What is the best approach to do this in geoserver? I followed postgis raster in geoserver, but it seems I need to generate pyramid and store them in a separate table using Image Mosaic JDBC. Since data are dynamic, is there another way without exporting the raster?