On Jul 05, 2006, at 3:02 PM, Peter De Berdt wrote:
Yes, but all other established programming languages out there
(either web development or desktop development) support MySQL
already (and all other major databases), database-backed
applications are a pretty large market.
From what I've experienced, the only really reliable database
adapters for realbasic have always been third-party: OpenBase,
Valentina, PostGreSQL classes, SQLite from SQLabs (now part of
REALbasic). I had to use about every database REALbasic supports in
the Professional version back in the 5.5 days (and I don't think a
single plugin has changed since), all of them had their fair share
of problems: 4D was leaking a lot and didn't return doubles
correctly (fixed after two years, they compiled with a beta API,
compiling with the release classes in place and it was fixed, those
little developer annoyances ;-))), MySQL count wasn't working,
resulting in an additional query to the database and doesn't
support the new pw scheme, PostGreSQL just didn't do anything, ODBC
was leaking, … I still get the shivers thinking back to those days…
Don't get me wrong, I still really like REALbasic, but it sucked at
databases :-)
REAL is a small company and only has so many resources to spread around.
That's one reason why I did suggest to Geoff that they spin the
database adapters out to a third party that would / could make a
business out of it.
But, therein lies part of the problem.
When you pay X amount for RB and database plugins are listed as a
feature you expect to get database connectivity.
It's a listed feature of RB itself so why would you pay a third party
for it ?
If it were not part of the feature set listed then you probably would
not expect to get it "for free" or included.
But it is listed as a feature. However, investing time in the
database plugins does distract from the core product; the IDE,
compilers and language.
But, as you point out it is lagging behind current database vendor
releases.
I keep recommending Actual Technologies ODBC drivers because they are
reasonably priced and that IS their business. Their entire business.
Jonathan has mySQL drivers that work from version 2 to 5. PostgreSQL
as well. Sybase. MS SQL. Oracle. OpenBase. And even one for MS Access
on OS X !
And he's very responsive and things do get fixed quickly when there
is a problem.
So I am using mySQL 5 today with their new passwords. And PostgreSQL
8. And OpenBase. And Sybase and ... You get the idea.
The only thing I need to get from REAL is an occasional update to
any issues in the ODBC plugin.
In other cases I've used other third party mechanisms that are
written entirely outside RB (ie/ shells, pure RB code, etc)
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
