Who's using what dbs?

[Jan Schenkel]

Sorry if I'm late to reply - but you might find it useful anyway :-)
My choice of database is primarily based on its ACID-compliance, rather than price. Having fixed many a datafile in FoxPro, I find the robustness of the database extremely important.

For client-side or embedded database, SQLite is the obvious choice.
For server-side, I would go for PostgreSQL, unless the customer already has an Oracle installed.

SQLite drivers ship with Rev 2.8.1 and later for MacOSX, Windows and Linux. PostgreSQL drivers ship with Rev since version 2.0, for all platforms.
Oracle requires revEnterprise; but there is unfortunately no driver for Intel-bvased Macs, so you'll have to create a PowerPC app to run under Rosetta.

Jan Schenkel
=====
Quartam Reports & PDF Library for Revolution
<http://www.quartam.com>

=====
"As we grow older, we grow both wiser and more foolish at the same time."  (La Rochefoucauld)


--- On Sun, 11/29/09, Alex Adams <alex at a2technology.com> wrote:

> From: Alex Adams <alex at a2technology.com>
> Subject: Who's using what dbs?
> To: use-revolution at lists.runrev.com
> Date: Sunday, November 29, 2009, 6:26 PM
> I need to decide on a multi-user
> database for a family of rev apps to run
> against.  Developing in other technologies, I have
> experience with OpenBase,
> FrontBase, MS SQL Server, and MySQL and a little
> Oracle.  I don¹t want to
> use SQL Server for a whole host of reasons.  Oracle is
> too expensive for
> most situations.  I am not aware of a rev driver for
> OpenBase.  I have had
> problems with MySQL and large BLOBs.  That leave
> FrontBase which I like and
> works very well with very large blobs, but is not currently
> shipping in a 64
> bit version.  Is anybody using FrontBase?  I see
> that there is Valentina.  I
> need to store and interact with masses of information, but
> there are no
> relationships setup in the database and there are no joins
> in the SQL
> statements.  Constraints and relationships are handled
> by the apps.  I store
> files in blobs.  Any kind and size of file.
> 
> To the apps, the database is a generic place to put
> information.  This
> allows the apps to be database agnostic.  So they can
> use embedded SQLite
> and hosted multiuser databases, just the same.
> 
> Any feedback would be appreciated.  Oh yeah. 
> Cross platform is a must.
> 
> Thanks,
> -- 
> Alex Adams
>