Hi Matthew,
Good luck, I haven't tried that. Just for the record, nobody is against any
particular DB vendor (many of us likely grew up with mysql), its just that
it would take work to properly support another DB provider. Also, I don't
think that Postgres is a pain-point for anyone, its easy to use, and
performs well. OracleDB, however, is just a pain to get started with. To
support Multiple DB vendors it would be worth putting our chips into a data
provider tool that manages all the dialects for us. Currently to support
yet-another-DB-provider involves writing/duplicating too many Java classes.
I'm thinking something like JooQ or Kevin VDV's DSpace-Hibernate project
would be a good route to get there. They basically give you a Domain
Specific Language (DSL), that lets you write the dialect-agnostic query,
and then at runtime or something, the tool compiles/interprets the DSL to
make it work for each DB provider.
________________
Peter Dietz
Longsight
www.longsight.com
[email protected]
p: 740-599-5005 x809
On Wed, Jul 2, 2014 at 6:32 PM, Keir Vaughan-Taylor <[email protected]>
wrote:
> Be aware that MySQL was inherited by Oracle and Oracle may choose to
> dump it. Its future is uncertain. This would be a great pity since it is
> my favourite Database.
>
> MariaDB is the community based fork of MySQL and ships with various
> flavours of Linux
>
>
>
>
> On Wed, 2014-07-02 at 11:19 -0500, Tim Donohue wrote:
> > Hi Matthew,
> >
> > Just to clarify, DSpace currently does not actively support MySQL. We
> > currently only support PostgreSQL and Oracle. It's *possible* DSpace may
> > work on MySQL, but it's not actively being tested/developed on that
> > database backend.
> >
> > However, if you or your institution is interested in helping us improve
> > DSpace to support MySQL, we'd appreciate it if you'd contribute any
> > fixes you may apply to DSpace. Here's an overview of how you can
> > contribute to DSpace, if you are interested:
> > https://wiki.duraspace.org/display/DSPACE/How+to+Contribute+to+DSpace
> >
> > - Tim
> >
> >
> > On 7/2/2014 8:59 AM, Barry, Matthew wrote:
> > > Hi All,
> > >
> > > We are looking to move from postgres towards a MySQL backend. Is there
> > > any documentation for people who have successfully made this move?
> > >
> > > Regards
> > >
> > > Matthew
> > >
> > >
> > >
> > >
> ------------------------------------------------------------------------------
> > > Open source business process management suite built on Java and Eclipse
> > > Turn processes into business applications with Bonita BPM Community
> Edition
> > > Quickly connect people, data, and systems into organized workflows
> > > Winner of BOSSIE, CODIE, OW2 and Gartner awards
> > > http://p.sf.net/sfu/Bonitasoft
> > >
> > >
> > >
> > > _______________________________________________
> > > DSpace-tech mailing list
> > > [email protected]
> > > https://lists.sourceforge.net/lists/listinfo/dspace-tech
> > > List Etiquette:
> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
> > >
> >
> >
> ------------------------------------------------------------------------------
> > Open source business process management suite built on Java and Eclipse
> > Turn processes into business applications with Bonita BPM Community
> Edition
> > Quickly connect people, data, and systems into organized workflows
> > Winner of BOSSIE, CODIE, OW2 and Gartner awards
> > http://p.sf.net/sfu/Bonitasoft
> > _______________________________________________
> > DSpace-tech mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/dspace-tech
> > List Etiquette:
> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>
>
>
>
> ------------------------------------------------------------------------------
> Open source business process management suite built on Java and Eclipse
> Turn processes into business applications with Bonita BPM Community Edition
> Quickly connect people, data, and systems into organized workflows
> Winner of BOSSIE, CODIE, OW2 and Gartner awards
> http://p.sf.net/sfu/Bonitasoft
> _______________________________________________
> DSpace-tech mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
> List Etiquette:
> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>
------------------------------------------------------------------------------
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
