[CLUE-Tech] Clue: Database

[Richard Knechtel]

Sorry, I didn't mean to take so long to respond to the response on this 
subject.
Between work and home I have gotten to busy to even get much sleep!

Anyway,
What I am looking at storing in the database is like "contact" information. 
I am creating a contact application - for storing names, addresses, phone 
numbers, notes etc...

I have layed out my database tables to the level I need them,

It sounds like I will probably want to go with Postgres, because it has the 
Foreign key support, I am using foreign keys in my database layout 
(Important!).

I have already completed my first CLX Kylix project. It is a numeric 
converter. It will convert between Hexadecimal, Decimal, and Binary.  It 
will handle up to 64 bit numbers!  Nothing overly spectacular but hey it's 
my first Kylix application I ported from my Delphi version.  I will be 
releasing it with some of my other Delphi/pascal stuff to my web page in 
the very near future. (I have to finish the page :^)  .

I am slowly porting all my Delphi, and Visual Basic applications to Kylix. 
To Visual Basic apps are already on my web page ^:)

http://www.pcisys.net/~rknech    - See the General Programming page.


BTW> Anyone know of a Visio like application for Linux???? I hate having to 
use Visio when I want to do ALL my development in Linux!

I Will have to some time give a "demostration" of Kylix to a user group 
meeting sometime!

Regards all !!


At 10:21 PM 2/1/02 -0700, you wrote:
>Richard,
>
>It really depends on what you wish to store in the database.
>
>Postgres has more features that are equivalent to Oracle / DB2 / Sybase /
>MS-SQL.  Their goal is to produce a database that is equivalent in features
>and speed with 'commerical' RDBMS.  Thus far, they have succeeded in the
>standard features.
>
>MySQL differs from PG because their stated goals (according to their manual)
>is SQL support and speed.  Yes, they will have transactions finally but there
>are other features, such as referential integrity (i.e., Foreign Keys) that
>(again according to their manual) will never be implemented because it
>violates the 'speed' rule.
>
>So, you have to ask yourself a few questions:
>
>1.  How important is the data in my database?
>2.  To what level will I normalize the entities in my database?
>3.  How much of your data integrity do you want to protect using the database?
>
>If your data is extremely valuable, I would recommend PG because it has much
>better error recovery and it the transactions and FK constraints allow you to
>guarantee that data will not be lost.
>
>If you wish to normalize your data at all, then MySQL will not help with
>referential constraints.  It does not support hooking tables together using
>Foreign Keys.  This means it is up to you (the application programmer) to
>enforce data relationships.  In my 7 years of building database applications,
>this is always a Bad Idea (tm).  There are many reasons this model fails, but
>to sum it up:  the database is much better than programmers at enforcing
>integrity rules.
>
>However, if you want a FAST flat-file database that supports SQL (which IMHO)
>is much easier for data retrieveal than ISAM, the definetely use MySQL.
>
>Jeff
>
>On Friday 01 February 2002 06:40 pm, Richard Knechtel wrote:
> > I am working on a Kylix application and am wondering what would be the best
> > general databse to use for the application.  I have used Oracle and DB2 at
> > work mainly. But normal Linux users don't have these installed.  Which is
> > probably the best general database to use ?  MySQl or Progress? or is there
> > another that might be better.
> >
> > Thanks,
> >
> > _______________________________________________
> > CLUE-Tech mailing list
> > CLUE-Tech at clue.denver.co.us
> > http://clue.denver.co.us/mailman/listinfo/clue-tech
>_______________________________________________
>CLUE-Tech mailing list
>CLUE-Tech at clue.denver.co.us
>http://clue.denver.co.us/mailman/listinfo/clue-tech