ark + postgres
44 views
Skip to first unread message
domenico giusti
Oct 5, 2012, 7:56:12 AM10/5/12
to ark...@googlegroups.com
dear ark devs,
first of all I would like to apologize for my english...
I am an Italian student and I am migrating archaeological data from proprietary software to postgres/postgis database.
archaeological gis has been set for my master thesis (https://github.com/dncgst/pirronord.p13) and now i would like to build a web-gis for the data entry and management.
i think ark is a great project and i would like to use it, but i don't know if it's possible to use postgres instead of mysql.
so i'm here... is it possible to install ark in postgres and integrate data tables in postgres/postgis?
thank you very much and good job!
dome
first of all I would like to apologize for my english...
I am an Italian student and I am migrating archaeological data from proprietary software to postgres/postgis database.
archaeological gis has been set for my master thesis (https://github.com/dncgst/pirronord.p13) and now i would like to build a web-gis for the data entry and management.
i think ark is a great project and i would like to use it, but i don't know if it's possible to use postgres instead of mysql.
so i'm here... is it possible to install ark in postgres and integrate data tables in postgres/postgis?
thank you very much and good job!
dome
Guy Hunt
Oct 24, 2012, 3:58:25 PM10/24/12
to domenico giusti, ark...@googlegroups.com
Hi Domenico,
Firstly, very sorry for the slow reply. We have all been really busy over the last few weeks.
The standard ARK package has been built to work with MySQL. All the database functions are relatively well abstracted out from the code into functions and these core functions should be fairly easy (but time-consuming) to rewrite for Postgres should you wish to do that. We don't have any plans at this time to support Postgres in house, but we are always interested to receive submissions of code.
The way that ARK stores data is quite different to typical relational databases and essentially relies on having an ARK standard set of database tables into which data is imported. This structure is the fundamental reason for ARKs great flexibility for different types of data. It would not be simply a case of correlating your database tables with tables inside ARK.
If your main aim of using Postgres is to make use of it's spatial features, it might be worth considering other approaches. ARK works with WFS, WMS servers. Most of the projects that we work with use a map server to server up the data. ARK is then able to read this data and to some extent query it. I could ask a colleague to give you some more detailed information about this.
If you'd like more detailed information, or perhaps some further discussion about how you could integrate ARK into what you are doing, please let me know.
All the best,
Guy
--
Guy Hunt
guy....@gmail.com
Firstly, very sorry for the slow reply. We have all been really busy over the last few weeks.
The standard ARK package has been built to work with MySQL. All the database functions are relatively well abstracted out from the code into functions and these core functions should be fairly easy (but time-consuming) to rewrite for Postgres should you wish to do that. We don't have any plans at this time to support Postgres in house, but we are always interested to receive submissions of code.
The way that ARK stores data is quite different to typical relational databases and essentially relies on having an ARK standard set of database tables into which data is imported. This structure is the fundamental reason for ARKs great flexibility for different types of data. It would not be simply a case of correlating your database tables with tables inside ARK.
If your main aim of using Postgres is to make use of it's spatial features, it might be worth considering other approaches. ARK works with WFS, WMS servers. Most of the projects that we work with use a map server to server up the data. ARK is then able to read this data and to some extent query it. I could ask a colleague to give you some more detailed information about this.
If you'd like more detailed information, or perhaps some further discussion about how you could integrate ARK into what you are doing, please let me know.
All the best,
Guy
--
You received this message because you are subscribed to the Google Groups "arkdev" group.
To view this discussion on the web visit https://groups.google.com/d/msg/arkdev/-/WUHtM1fp0tsJ.
To post to this group, send email to ark...@googlegroups.com.
To unsubscribe from this group, send email to arkdev+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/arkdev?hl=en.
--
Guy Hunt
guy....@gmail.com
Guy Hunt
Oct 30, 2012, 10:53:23 AM10/30/12
to domenico giusti, ark...@googlegroups.com
Ok, no problem, give me a shout if you need anything further.
Good luck with your project.
Guy
--
Guy Hunt
guy....@gmail.com
Good luck with your project.
Guy
On Mon, Oct 29, 2012 at 8:26 AM, domenico giusti <gui...@gmail.com> wrote:
Hi Guy,
thank you for you reply.
Currently I'm writing very simple and stupid Html/PHP code for entry data in my PostgreSQL database, cause I have no more time to close a project... But in the next future I would like to play with ARK and try using WFS, WMS servers for another archaeological project.
Of course I will come back on this ML to ask help :)
Thank you very much.
Best regards
Dome
--
<NEW MAIL ADDRESS NOTIFICATION>
Hi, I'm switching from my old mail/im address <gui...@gmail.com> to <dnc...@autistici.org>.
Please update your contact information to make sure we can keep in touch!
Thanks!
--
Guy Hunt
guy....@gmail.com
Reply all
Reply to author
Forward
0 new messages