On Feb 11, 2007, at 6: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!
Any tools you use for EITHER will need to be "the right version" so
they can manipulate either database.
REAL's implementation is based on SQLIte 3 so any tools based on
older SQLite engine won't be useful.
For PostgreSQL there are lots of choices from open source to commercial.
I've not used REAL's SQL Server so I cannot comment except to say
that the goals for it seem to be to make it dead easy to set up and
run a server and to make it so that stand alone databases and server
databases are compatible formats. You could take a database from the
server and use it locally or vice versa from what I know.
That said, I can't see why you would not use REAL SQL server except
it costs $ where PostgreSQL is free.
PostgreSQL is a very robust database with support for everything
you'd expect from an enterprise capable database.
It can be more work to set up and administer but that also comes with
increased capabilities.
I'm sure either would work equally well and that, if we knew more
about how you intend to use the database, that more recommendations
of value could be made.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
