See http://sourceforge.net/tracker/index.php?func=detail&aid=1715618&group_id=19984&atid=319984
Postgres & MySQL syntax is so similar (more so since MySQL added support for nested queries in version 5) that I'm pretty sure you can use MySQL without too much work. Thanks to Graham Triggs for investigating this and providing the patch. cheers, Jim On Thu, Jul 19, 2007 at 02:58:57PM -0400, Blanco, Jose wrote: > I checked the tech archive to find out if there have been any > discussions about using MySQL in Dspace and found none, so I will pose > my question. > > I know Dspace is setup to be able to connect and work with either > Postgres or Oracle, but has any one tried using DSpace with MySQL? Or > are there any plans to make it work with MySQL? > > We have been using Postgres exclusively for our Dspace instance just > fine, but most of our expertise is in MySQL and all our other > applications use MySQL. It would be nice not have to maintain two DB > engines and develop expertise in both. So I know that if we could > transition to MySQL, we would. Are there any thoughts on this? > > Thank you! > Jose > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > DSpace-tech mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspace-tech -- James Rutherford | Hewlett-Packard Limited registered Office: Research Engineer | Cain Road, HP Labs | Bracknell, Bristol, UK | Berks +44 117 312 7066 | RG12 1HN. [EMAIL PROTECTED] | Registered No: 690597 England The contents of this message and any attachments to it are confidential and may be legally privileged. If you have received this message in error, you should delete it from your system immediately and advise the sender. To any recipient of this message within HP, unless otherwise stated you should consider this message and attachments as "HP CONFIDENTIAL". ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
