Re: Re: Mysql
Posted by
Jeremiah Jahn-4 on
URL: https://discuss.orbeon.com/Mysql-tp1395395p1401348.html
I use Postgres for this currently, but that's just me. And as far as work goes, as long as your not trying to run the xqueries against the db, it isn't too bad, about 2 weeks. you just need to change the persistence layer. As for the comment about the xsl to sql, I use that on a very sizable project that handles a whole bunch of data that way it transforms LegalXML into SQL. It works quite well for the past 10 years. I'd suggest that you leave the original XML around somewhere though in it's pure form, as you will not want to rebuild it if you don't have to. You might even be able to run the xqueries against them, or even against the exists DB and push xml into the MySQL for sql queries, a little redundant, but probably quite functional, and would save you on development time.
-jj-
On Jan 28, 2010, at 2:35 PM, Hank Ratzesberger wrote:
Tom,
Would it be simpler to get the data out of eXist and update Mysql with "shredded" data and/or
the XML as text document?
This adds a layer to the form designer that would break with every new feature or control. On the
other hand, a process that, say, uses XSLT to create SQL statements would move this task
out of the FR persistence layer. I'm presuming it doesn't need to be real-time...
--Hank
On Jan 28, 2010, at 12:09 PM, Thomas Lynk wrote:
Hey,
We are looking for your support on an proposed upgrade to Orbeon.
We want to hire the team at Orbeon to replace the eXists with Mysql. That means when you create a form it will create a mysql database to store the form data. The issue is that it is a lot of work and expensive. I am looking for a group of users to cost share the project.
If you’re interested please contact me and we can discuss the details.
Tom
(519) 962-9974
--
You receive this message as a subscriber of the
[hidden email] mailing list.
To unsubscribe:
[hidden email]For general help: mailto:
[hidden email]?subject=help
OW2 mailing lists service home page:
http://www.ow2.org/wws
Hank Ratzesberger
NEES@UCSB
Institute for Crustal Studies,
University of California, Santa Barbara
805-893-8042
--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: [hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws
--
You receive this message as a subscriber of the
[hidden email] mailing list.
To unsubscribe: mailto:
[hidden email]
For general help: mailto:
[hidden email]?subject=help
OW2 mailing lists service home page:
http://www.ow2.org/wws