Re: The Zen nature of a Delphi database application

marek jedlinski wrote:

I do have classes that register themselves and factories that create them
based on some form of ID that a single class responds to. But for storage,
it immediately implies a "god class" that first loads a "metatable" with
class IDs of the actual data objects. So there are now at least two tables
which must be kept in sync: the metatable (classID, objectUID) and one or
more tables for the objects themselves.

In addition the class definitions in source code must be kept in sync with the database. I don't think that it's a good idea to have databases, which can become corrupt or otherwise unusable when the source code of the related programs is changed. If you want more flexibility, use XML and store information strictly as text.

DoDi
.

Relevant Pages

  • Re: What so special about PostgreSQL and other RDBMS?
    ... Unsubstantiated bunk, if you have the source code, it is not magic to ... my comments where ment *FOR DEVELOPERS* that is those who ... Oracle suits your needs and you think it's worth the money, use it, ... your database server, then write some additional functions as wrappers ...
    (comp.lang.php)
  • Re: custom insert for databound datagridview
    ... There probably is a way to insert your own change tracking logic, but I think using Sync Services, which already provides change tracking logic inside the SQL Compact engine might be easier in the long run. ... Here's a sample for syncing with an Oracle database using a custom ... I am syncing between a PDA SQLCE ...
    (microsoft.public.sqlserver.ce)
  • Re: custom insert for databound datagridview
    ... gets put into the database until you hit the save button on the navigation ... CTP you can download that handles syncing with a mobile device, ... the desktop piece is SQL Server so you'd still need to write a custom sync ... I am syncing between a PDA SQLCE ...
    (microsoft.public.sqlserver.ce)
  • Re: What happens if I break the connection during activesync in WM5 ?
    ... My prior response was for WM5 devices and greater. ... transaction is closed and the data is committed to the database. ... I sync my machine with my work and home PC. ...
    (microsoft.public.pocketpc.activesync)
  • Re: custom insert for databound datagridview
    ... I already have a solution for doing the sync part. ... Here's a sample for syncing with an Oracle database using a custom ... does not support syncing between a PDA and SQLCE or even SQLCE and SQLCE ... The first field is a Guid. ...
    (microsoft.public.sqlserver.ce)