[Linux-users] Data Base Opinion

[Bill Campbell]

On Mon, Aug 20, 2007, Rick Sivernell wrote:
>all
>
>
>I am in the planning stage of a new commercial product. It will be cross platform,
>Unix Linux and M$ludge. M$ludge creates the best money though.
>

>The product is a Contact Manager program. I will need to use a standard db,
>with the ability to allow Oracle SQL Server, if they wish to waste money,
>or some other db. For my default db I have thought about Postgress, or
>something like sleepycat. What would others think about these or any other
>db types. It would be nice to have a sql statement to load, read or
>manipulate data. No flames,good reasoning please. I will be using the
>wxWidgets for C++.

I would go with postgresql for anything serious.  It's very robust, ACID
compliant, sticks very close to SQL standards, and there are many tools
available to access it via python, perl, php, Zope, C, C++, etc.

The Sleepycat/Berkeley (BDB) code os probably the nastiest I've ever had
opportunity to look at.  They seem to have no qualms about changing the
low-level API, not only amongst major release levels, but even between
minor releases.  If you want to get a feel for this, look at the Berkeley
code for python or perl for examples if #ifn*def hell.

Unfortunately Linux vendors tend to tie the BDB code into their
distributions at a very low level (Caldera had it in libc at one point),
and updating can be rather ``interesting''.

Bill
--
INTERNET:   bill at celestial.com  Bill Campbell; Celestial Software LLC
URL: http://www.celestial.com/  PO Box 820; 6641 E. Mercer Way
FAX:            (206) 232-9186  Mercer Island, WA 98040-0820; (206) 236-1676

When you have an efficient government, you have a dictatorship.
                -- Harry Truman