On Feb 11, 2007, at 7:48 PM, C. S. Wyatt wrote:
A very serious question, and I'm hoping to avoid a "This solution
is even better..." thread.
Migrating a multiuser database solution from MySQL 4.x because of
the 5.x license, our choices would be between PostgreSQL 8.x on a
Mac network and an all-RB solution.
I have read the "use a real database" threads from last year on the
list archives. Are there genuine issues using the pure RB solution?
Also, would other tools be able to manipulate the RB database,
since it is SQLite-based? In other words, would non-RB manipulation
of the data in the future be impossible or at least difficult?
This is an issue on which I need a fast response and quality
feedback. Updating the solution will take time and energy for
everyone involved and mistakes now will cause much pain later, as
all developers know!
The answer is "it depends".
The RB database is less capable (eg doesn't do right or full outer
joins, stored procedures or [proper] triggers), and is almost
certainly going to work worse under heavy multi-user or complex
transactional loads (possibly significantly so -- google or wikipedia
for MVCC).
OTOH, the RB database is probably faster under light loads or few
users, and is easier to install and maintain.
If you have significant SQL skills, I believe the SQL deficits in the
RB product means you should use Postgres. Also, if you need the most
flexibility, use Postgres.
There's also the matter of PostgreSQL being free with the world's
most friendly license.
But if your needs are modest, the RB product is going to be easier.
Regards,
Guyren G Howe
Relevant Logic LLC
guyren-at-relevantlogic.com ~ http://relevantlogic.com
REALbasic, PHP, Ruby/Rails, Python programming
PostgreSQL, MySQL database design and consulting
Technical writing and training
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
