If you like MySQL then try MariaDB http://mariadb.org/
If you are thinking of moving to something else altogether then try Microsoft SQL Server, the express edition is FREE. On Tue, Sep 27, 2011 at 12:01 PM, Richard White <rich...@j7is.co.uk> wrote: > > Thanks for the detailed responses. > >>Database vendors have specific solutions for multiple identical >>databases, one for each customer. > > I'm so used to using MySQL maybe its time to look at some more powerful ones > for this situation :) and the great thing about ORM as was mentioned is its > portability > > thanks for the help > > > >>> I wonder if I am over complicating this issue. Basically our application is >>> a Software as a Service (SaaS) and each client that accesses it really only >>> needs to connect to their own data source due to the type of data our >>> application processes... and regulations in the industry say their data must >>> be separated. >> >>I imagined that was the use-case :) >> >>Database vendors have specific solutions for multiple identical >>databases, one for each customer. A popular one is to have separate >>databases faked by a database server that uses just one database but >>shows different data based on the customer (login). I believe that is >>a reasonable approximation of the problem you are facing. >>One of the vendor buzzwords for that is Virtual Private Database and >>looking for that shows that the performance problem in having >>different classes for each customer is solvable if you use Hibernate >>directly: https://forum.hibernate.org/viewtopic.php?t=940748 >>I am unsure if ColdFusion exposes sufficient control over the >>Hibernate session to dynamically switch the datasource or login >>session in CFML, but if you want to use ORM this is the direction I >>would recommend exploring. >> >> >>> So, the actual objects in the database may vary but only *very* slightly. >> >>If you want this to work you are probably going to have to merge those >>differences into one standard schema. >> >>Jochem >> >> >>-- >>Jochem van Dieten >>http://jochem.vandieten.net/ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347738 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
