Hi > 1 - try to link the postgis writer to query-on-demand rather than > dynamic query > With query-on-demand, there is now the possibility to synchronise the > view with > the database on user-demand (RefreshDataStoreQueryPlugIn)
Made some progress with this idea. This is not as user friendly as it could be, but it is now possible to read/write postgis table from the same datasource. When a layer is saved in a table, OpenJUMP creates a DataStoreQueryDataSource on this layer (query on demand) with the following query : "select * from table limit 100000" This way, the layer will be saved in the project with this query, and it is possible to update the table from the database (refresh) or to update the database from the layer (save as). I uploaded a small video to show how PostGIS writer and Datastore table work together : http://geo.michaelm.free.fr/OpenJUMP/resources/video/ Next on the list is the identifier stuff (how to create a unique identifier in the database and use it for updates. Michaël > 2 - make editing more dynamic so that each user action > (creation/modification/deletion) is immediately and automatically > commited in the database 3 - create a more transactional mechanism > where edit can be saved in the context of a dynamic layer and > committed on demand I think the first one is the only one I'll be able > to work on before a final 1.6 release. Second and third one need > probably much work. I think kosmo use a transactionnal model. Would be > useful to study how they manage that. Thanks for your always valuable > inputs. Michaël -Jukka- Michaël >>> -Jukka Rahkonen- >>> ________________________________________ >>> Lähettäjä: Stefan Steiniger [sst...@geo.uzh.ch] >>> Lähetetty: 17. marraskuuta 2012 21:11 >>> Vastaanottaja: OpenJump develop and use >>> Aihe: Re: [JPP-Devel] Can not read PostGIS projects >>> >>> Hi Michael, >>> >>> sounds reasonable to me. But we would need to add a comment on that... >>> When the project is saved, it would mean to send a message to the user >>> at save time? >>> >>> thanks for working on this - on the weekend! >>> stefan >>> >>> Am 17.11.12 15:17, schrieb Michaël Michaud: >>>> Hi Uwe, others, >>>> >>>> I'd like to have PostGIS users feedback about the following question : >>>> Save as PostGIS table can save a layer as a new PostGIS table >>>> or update an existing PostGIS table with different options. >>>> >>>> IMHO, only the first option (create new table) should set the postgis >>>> table as the new Datasource for the layer (and save it in the project). >>>> >>>> In other cases, the layer may contain only a few features and >>>> the table we connect to maybe a huge table. Setting this huge table >>>> as the new datasource may freeze the application. >>>> >>>> Any comment ? >>>> >>>> Michaël >>>> >>>>> Uwe, Landon, >>>>> >>>>> I had forgotten Uwe's mail, but I now have added a bug report >>>>> and will tackle it before 1.6 final release. >>>>> >>>>> Michaël >>>>>> Hi Landon, >>>>>> >>>>>> no, I got no response. >>>>>> >>>>>> I tested it now again with the latest nightbuild >>>>>> (Version 20121111 snapshot rev.3073), but I have the >>>>>> same problem. >>>>>> >>>>>> Regards >>>>>> >>>>>> Uwe >>>>>> >>>>>> Am 12.11.2012 17:26, schrieb Landon Blake: >>>>>>> Uwe: >>>>>>> >>>>>>> Did you ever get a response or a solution to this problem? >>>>>>> >>>>>>> Landon >>>>>>> >>>>>>> On Mon, Sep 24, 2012 at 12:00 AM, Uwe Dalluege >>>>>>> <uwe.dallu...@hcu-hamburg.de> wrote: >>>>>>>> Hi, >>>>>>>> >>>>>>>> I can not read projects with PostGIS layer. >>>>>>>> OJ Version 20120924 snapshot rev.3004 >>>>>>>> OS: W7 (64 bit) and XP (32 bit). >>>>>>>> >>>>>>>> 1. Add A New Layer. >>>>>>>> 2. Draw a geometry. >>>>>>>> 3. Save the layer to PostGIS with Save Dataset As. >>>>>>>> 4. Save Project As... >>>>>>>> >>>>>>>> 5. When I open the project again the project is empty >>>>>>>> and the category System is deleted. >>>>>>>> >>>>>>>> Regards >>>>>>>> >>>>>>>> Uwe >>>>>>>> >>>>>>>> ------------------------------------------------------------------------------ >>>>>>>> Live Security Virtual Conference >>>>>>>> Exclusive live event will cover all the ways today's security and >>>>>>>> threat landscape has changed and how IT managers can respond. >>>>>>>> Discussions >>>>>>>> will include endpoint security, mobile security and the latest in >>>>>>>> malware >>>>>>>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ >>>>>>>> _______________________________________________ >>>>>>>> Jump-pilot-devel mailing list >>>>>>>> Jump-pilot-devel@lists.sourceforge.net >>>>>>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>>>> ------------------------------------------------------------------------------ >>>>>> Monitor your physical, virtual and cloud infrastructure from a single >>>>>> web console. Get in-depth insight into apps, servers, databases, vmware, >>>>>> SAP, cloud infrastructure, etc. Download 30-day Free Trial. >>>>>> Pricing starts from $795 for 25 servers or applications! >>>>>> http://p.sf.net/sfu/zoho_dev2dev_nov >>>>>> _______________________________________________ >>>>>> Jump-pilot-devel mailing list >>>>>> Jump-pilot-devel@lists.sourceforge.net >>>>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>>>> >>>>>> >>>>> ------------------------------------------------------------------------------ >>>>> Monitor your physical, virtual and cloud infrastructure from a single >>>>> web console. Get in-depth insight into apps, servers, databases, vmware, >>>>> SAP, cloud infrastructure, etc. Download 30-day Free Trial. >>>>> Pricing starts from $795 for 25 servers or applications! >>>>> http://p.sf.net/sfu/zoho_dev2dev_nov >>>>> _______________________________________________ >>>>> Jump-pilot-devel mailing list >>>>> Jump-pilot-devel@lists.sourceforge.net >>>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>>> >>>>> >>>> ------------------------------------------------------------------------------ >>>> Monitor your physical, virtual and cloud infrastructure from a single >>>> web console. Get in-depth insight into apps, servers, databases, vmware, >>>> SAP, cloud infrastructure, etc. Download 30-day Free Trial. >>>> Pricing starts from $795 for 25 servers or applications! >>>> http://p.sf.net/sfu/zoho_dev2dev_nov >>>> _______________________________________________ >>>> Jump-pilot-devel mailing list >>>> Jump-pilot-devel@lists.sourceforge.net >>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>> >>> ------------------------------------------------------------------------------ >>> Monitor your physical, virtual and cloud infrastructure from a single >>> web console. Get in-depth insight into apps, servers, databases, vmware, >>> SAP, cloud infrastructure, etc. Download 30-day Free Trial. >>> Pricing starts from $795 for 25 servers or applications! >>> http://p.sf.net/sfu/zoho_dev2dev_nov >>> _______________________________________________ >>> Jump-pilot-devel mailing list >>> Jump-pilot-devel@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>> >>> ------------------------------------------------------------------------------ >>> Monitor your physical, virtual and cloud infrastructure from a single >>> web console. Get in-depth insight into apps, servers, databases, vmware, >>> SAP, cloud infrastructure, etc. Download 30-day Free Trial. >>> Pricing starts from $795 for 25 servers or applications! >>> http://p.sf.net/sfu/zoho_dev2dev_nov >>> _______________________________________________ >>> Jump-pilot-devel mailing list >>> Jump-pilot-devel@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>> >>> >> ------------------------------------------------------------------------------ >> Monitor your physical, virtual and cloud infrastructure from a single >> web console. Get in-depth insight into apps, servers, databases, vmware, >> SAP, cloud infrastructure, etc. Download 30-day Free Trial. >> Pricing starts from $795 for 25 servers or applications! >> http://p.sf.net/sfu/zoho_dev2dev_nov >> _______________________________________________ >> Jump-pilot-devel mailing list >> Jump-pilot-devel@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >> >> ------------------------------------------------------------------------------ >> Monitor your physical, virtual and cloud infrastructure from a single >> web console. Get in-depth insight into apps, servers, databases, vmware, >> SAP, cloud infrastructure, etc. Download 30-day Free Trial. >> Pricing starts from $795 for 25 servers or applications! >> http://p.sf.net/sfu/zoho_dev2dev_nov >> _______________________________________________ >> Jump-pilot-devel mailing list >> Jump-pilot-devel@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >> >> > > ------------------------------------------------------------------------------ > Monitor your physical, virtual and cloud infrastructure from a single > web console. Get in-depth insight into apps, servers, databases, vmware, > SAP, cloud infrastructure, etc. Download 30-day Free Trial. > Pricing starts from $795 for 25 servers or applications! > http://p.sf.net/sfu/zoho_dev2dev_nov > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > > ------------------------------------------------------------------------------ Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
