The online ColdFusion / CFML community website
Derby vs mysql
Any thoughts on this - is it better, worse? I guess its somewhat objective giving an opinion - but just thought I'd see what people thought.
I don't run CF with Apache on my iMac, so am using mysql with my CF sites. Just noticed that this 'new' database system is available after receiving my new CFWack8 book - and noticed that Ben only provides the sample db file in Apache format. (speaking of which - anyone know how to convert this file to mysql format?)
I don't run CF with Apache on my iMac, so am using mysql with my CF sites. Just noticed that this 'new' database system is available after receiving my new CFWack8 book - and noticed that Ben only provides the sample db file in Apache format. (speaking of which - anyone know how to convert this file to mysql format?)
Replies to This Discussion
-
Permalink Reply by Charlie Arehart on
-
Brendon, sorry I didn't reply to this sooner. I must have missed the email notice that you'd written it. I'll say that I've addressed your question in the resource I've mentioned elsewhere here in the group. In my resource called, "Getting Started with the Apache Derby Open Source Database in CF8", I specifically address the question, "Why use Derby database verses using something like MySQL?".
As for converting data from Derby to MySQL, I don't know of a direct solution, though I wouldn't be surprised if such existed. Someone else would need to chime in (or you should ask in some of the many more generic Derby resource sites I mention in the page above). But I can tell you that I have another resource, listing several hundred tools and resources in over 100 categories, and in it I have a category called, "Database Migration Tools". Hope that helps.
Latest Activity
Dear
friends,
mso-ansi-language:EN-GB"">IBS Solutions develops 100’ web based applications.
Development team is expert on Adobe Coldfusion, PHP and Microsoft .NET technologies.
It gives the services of developing job solutions, web site design,
se…
Procom Services is currently seeking a Coldfusion Developer with SQL Server experience for a long term contract position with a great client based in Chapel Hill, NC. This position requires Coldfusion Development and SQL experience, along with excel…
you can concaternate with ## like
but I'm with Jane - why not use & it's much cleaner.
d
(via Huddle Workspaces)
Translate this page
© 2010 Created by Nick Tong
