I have been away from RB for quite a while now (3.5) although I do
have a licence for RB5.5, when I was using RB before I was a bit of
a novice so I am probably worse off now, I have a project that I
could probably use RB for and basically need some advice from RB
users that use databases.
I have not used RB for any database projects in the past but feel
this project might lend itself to saving the user inserted
information to database files rather than text files. I have been
working with PHP and MySQL the last couple of years and it never
ceases to amazed me with the versatility of these two together and
the seemingly logical storage system when using a database, which is
one of the reasons I am thinking of using database files to store
data and not text or binary files. At some time in the future I may
integrate or allow users to integrate, backup or store to an online
database, which is another reason I am thinking of saving the user
input information to database files rather than text or binary files.
So basically I am looking for advice, trying to save myself time in
discovering the best way to go here. I read that there are various
database options now with RB, I wonder which would be recommended to
be reliable and suitable of the available databases for my purposes,
allowing a user to save these as separate files rather than text
files, easy access, for the future permit easy integration with an
online MySQL database, ease of use in RB etc. I guess reliability
would probably be the most important factor for me to consider here
although cost would also need to be taken into account.
Any advice or pointers on which 'database' way to go would very
much be appreciated.
I have RB5.5 so this would be the preferred version of RB for me, or
would there be any advantages in upgrading to the current version?
Many thanks
Hi Mike,
I use single-user databases extensively in my applications
(User-prefernces, reference libraries, order generation and data
links between applications). I started with the original REAL
database ( available in 5.5 pro Ibelieve) but migrated to the
SQLite-based REALSQLdatabes that became part of RB2005r?. I found it
most reliable, very fast, well supported (Will Leshner and Mario
Bambini are most helpful and responsive!). I had lots of troubles
with the old RB database handling NULL values for dates and
timestamps. Not so with the new. -- I don't use any plugins for
that; works fine, but you must have the PRO version of RB. I use now
RB2006r2 Pro.
For multi-user needs I started with PostgreSQL and now have
migrated to the REAL SQL Server. It is still in beta; but for a beta
product it is remarkably solid. It has several advantages: Being
also SQLite-based the programming interface is nearly identical to
the REALSQLdatabase. The User interface for managing the database
server is very good and can easily be handled by people without
in-depth knowledge of Unix system or OS internals. -- It may not
have all the sophisticated features of a PostgreSQL, Valentina,
MySql, etc, but for my applications I do not need them and SQLite
does everything I need. There are quite a few people on this least
who are much more qualified then I am to make accurate comparisons
here.
These are my experiences. HTH.
--
Cheers,
Peter
TI PowerBook G4, 1GHz, 1GB RAM, OSX 10.3.9, RB2006r2 Pro
_______________________________________________
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>
