Re: Changing from openbaseSql to MySql
Re: Changing from openbaseSql to MySql
- Subject: Re: Changing from openbaseSql to MySql
- From: Marek Wawrzyczny <email@hidden>
- Date: Thu, 3 Jul 2003 10:58:34 +1000
We haven't had any troubles with WO as far as MySQL is concerned. I
think you should be comparing databases on their own merits, what sort
of record locking do they support, transactions, distributed databases,
etc. WO uses a very basic subset of SQL that I think pretty much all
SQL databases will support. So whether you go with MySQL, FrontBase,
SyBase... etc, it shouldn't matter.
Look up prior discussions on MySQL in the archives if you need to find
out what it does and doesn't support with respect to WO (you should do
that for any database you might be considering).
The only thing you need to do is, in EOModeler make sure you prefix
your database URL with:
jdbc:mysql://xxx.xxx.xxx.xxx/myDatabase
Oh, and database administration MySQL is pretty poor (command line). We
use an open source alternative phpmyadmin (http://www.phpmyadmin.net/).
It's a web based admin tool.
On Thursday, Jul 3, 2003, at 09:57 Australia/Sydney, email@hidden
wrote:
Thanx, that is good to know.
is MySQL a good solution for working with WebObjects or should i
prefer another database?
is there any documentation on how to set up an WebObjects application
with MySql?
cheers Christian Telepski
Hello,
i am just trying to change from openbaseSql to MySql because it
doesn't cost anything at all and also installed MySql and the driver
for it.
now how can i generate the sql code for Mysql? does the EOModeler do
that as well?
i tried to set up an app' but did not work at all.
is there any help for WebObjects with MySql??
Thanx in advance
When porting WO apps with an OpenBase back-end to MySQL you need to
be aware of the following:
a) The eomodel will need to change, all the field types are different
in MySQL, ie Integer becomes INT or LONGINT, etc. EOModeler won't do
it automatically.
b) Some data types are not supported, so if you used a Boolean type
in OpenBase, you'll now have to live with INT or TINYINT.
Hope this helps.
Cheers,
Marek Wawrzyczny
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
Marek Wawrzyczny
software engineer
-------------------------->
ish group pty ltd
7 Darghan St Glebe 2037 Australia
phone +61 2 9660 1400 fax +61 2 9660 7400
http www.ish.com.au | email email@hidden
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.