[cad-linux] Re: database application scenarios

  • From: Roland Krause <rokrau@xxxxxxxxx>
  • To: cad-linux@xxxxxxxxxxxxx
  • Date: Thu, 15 May 2003 15:53:13 -0700 (PDT)

Yes, these are all valuable points. 

Nevertheless all SQL databases provide tables in which one can store
numbers and characters which is, at first, all that's needed. 

Other things that would be of advantage: 

1 Some sort of serialization. Simply put - a save to file of all 
  data associated with a model would be perfect. 
2 Revision control, allthough taht can be achieved with standard 
  tools, i.e. CVS if there is 1. 
3 Rollback, saves the hassle to implement Undo.


--- "Hundiak, Arthur" <ahundiak@xxxxxxxx> wrote:
> 1. Don't fall into the trap of thinking that all databases that
> support SQL
> support the same sql.  It's kind of like saying that a CAD app
> supports DXF.
> Take a look on the mysql.com site under non-standard extensions to
> sql.
> 2. Even when the sql does work the same keep in mind that any changes
> to the
> database structure will impact all programs using sql to directly
> access the
> database.  And there will be changes.  Lot's of them.  Keep the sql
> isolated
> to a small number of service type objects and let everyone else talk
> to
> these services.
> 3. For performance reasons you will probably find that you end up
> with a
> custom service for each database type ie. an Oracle service optimized
> for
> Oracle databases.  Yes, you can have an ODBC service but it's gonna
> be slow.
> 4. Finally, using a service means that you don't have to use a sql
> database.
> You could be using some sort of xml database or maybe even a file
> based
> approach.
> -----Original Message-----
> From: Lee Fickenscher [mailto:elfick@xxxxxxxxxx]
> Sent: Wednesday, May 14, 2003 4:13 PM
> To: cad-linux@xxxxxxxxxxxxx
> Subject: [cad-linux] Re: database application scenarios
> Major snipping, not really sure who wrote this:
> >Do you see the library as using standard SQL to manipulate the
> database?
> >The reason I ask is that I feel it would be a huge benefit for a
> user to
> >be able to use which ever DBMS they may want to use (assuming that
> >database understands SQL)

Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.

Other related posts: