Hi Jim,
Here < http://www.sybase.com/mac> will you find the right one witch installs in minutes trough a cool gui under Mac OS X. As long as i did never setup it to work with Revolution, i will not be very helpfull. I would recommand to test the ODBC way first and the shell pipes beetwin Rev and the Sybase ASE transactions manager, as the second.
Else, you could test PostgreSQL 8.0.1 first. If interested, have an eye to the first class distribution packed by Mark Liyanage at <http://www.entropy.ch/software/macosx/postgresql/>
Best, Pierre :-)
I went to the Sybase site and found they have a "hot deal". Seems they are
selling "Sybase Enterprise Portal Information Edition 6.1" for Linux and
Windows for $99. What does this mean? Is this all one needs to use Sybase?
Then we use the standard db interface commands with Rev? There is a Linux
and Windows version but no Mac. We could still have a database on a Linux
server and a Mac client interfacing with it, right? Jim
on 4/14/05 6:34 PM, Pierre Sahores wrote:
As Len previoulsy said there, PostgreSQL 7 and 8 are realy very great
ACID compliant ORDBMS and i use them as the back-ends of all my
"n-tier" solutions since years with a very great confidence. In about
dozains of megaoctets to hundreds of gigaoctets of datas peer database
well designed, PostgreSQL rocks. In about more heavy solutions, i would
goes, directly, to a Sybase ASE solution instead of an Oracle one (a
little too java-centered for me - the linux installer included), even
if Oracle is, for sure, a powerfull tool and, yet, a less expensive
solution than it use to be until two years ago.
It will probably be a good idea to avoid, if possible, the less powerfull MS SQL-Server solution...
Best,
-- Pierre
Le 14 avr. 05, à 20:50, Oak Norton a écrit :
Hello all, I'm a total newbie to Revolution and I have limited
programming
experience. I'm one of those people I read about in a recent post that
needs a solution so I figure out how to program it for myself. My
experience has mostly been with cold fusion and MS-SQL/Access. I've
been
leaning toward MySQL for a cross-platform project, but from the posts
on
this board I'm just about ready to look at PostgreSQL. I know there's
some
differences between all the SQL's but don't know much about what they
are.
In the example below I see a bit of code which illustrated that point
and
just worries me a tad because I find Access invaluable to build queries
quickly and test them out and if I didn't have to change the code at
all,
that would be a big plus. So which of the sql flavors is closest to
MSSQL
and will go cross-platform?
Thanks,
Oak
It's been my experience that if you ultimately want to move to Oracle, Postgresql is a better choice than mySQL because PG tries to be as Oracle compatible as possible. I can also tell you from experience that if you want to move to MS SQL Server later, be VERY careful about your SQL since there are lots of things that are incompatible even with "simple" SQL statements. For example, in Oracle/Postgres you would join two fields you would use something like SELECT last_name || ', ' || first_name whereas in MS SQL it would be SELECT last_name + ', ' + first_name (very VB like).
_______________________________________________ use-revolution mailing list [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________ use-revolution mailing list [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
--
OYF is... Highly resourceful people working together. <http://www.OwnYourFuture-net.com>
Own Your Future Consulting Services Limited, 1959 Upper Water Street, Suite 407, Halifax, Nova Scotia. B3J 3N2 Phone: 902-823-2339. Fax: 902-823-2139
What’s New...
* Have you ever hired an employee who didn’t work out?
* Did you do that on purpose?
Probably not...
If you want to greatly improve your hiring process, check out our new hiring process... www.HiringSmart.ca/ns <http://www.hiringsmart.ca/ns> and... www.KeepingTheBest.ca/ns <http://www.keepingthebest.ca/ns>
_______________________________________________ use-revolution mailing list [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________ use-revolution mailing list [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
