One place to rule them all???

[Ian Branch 127]

Hi Team,

Philosophical discussion.  Bit like which word processor is best.

Is it better to have all the Database related components TEngine, TSession, TConnection, TTables, TQuerys, etc, in a datamodule or scattered around the forms..

Pros & Cons - Ready... Go!!

[Anders Melander 1782]

It sounds like you already know the answer to that one.

[Lars Fosdal 1792]

We create all these in code.  No visual components used.

We have no sea of DB components floating in designers. It requires a bit more scaffolding code, but it can be generalized and made threadsafe.

[microtronx 38]

1 hour ago, Ian Branch said:

Hi Team,

Philosophical discussion.  Bit like which word processor is best.

Is it better to have all the Database related components TEngine, TSession, TConnection, TTables, TQuerys, etc, in a datamodule or scattered around the forms..

Pros & Cons - Ready... Go!!

Hi Ian,

 

on our mainapp we have one tDataModule with tEngine, tSession but we create all other tTables and tQuery etc. in runtime on each form.

This is different when we have threads: for each thread, we create a seperate tSession

[Alberto Fornés 22]

1 hour ago, Lars Fosdal said:

We create all these in code.  No visual components used.

We have no sea of DB components floating in designers. It requires a bit more scaffolding code, but it can be generalized and made threadsafe.

Yes, rapid development is not always the best solution for big projects.

[Uwe Raabe 2057]

As ever so often, the pragmatic solution probably lies somewhere in between...

[FPiette 383]

In small demo applications, I use a TDataModule with component dropped on it.

For real world large application, I use a simple unit have the code that encapsulate database access and database components are created at runtime. The unit offers classes that give access to the data stored in the database in an abstracted way. More code but much better program if correctly designed.

[Tom Chamberlain 47]

In our 24+ year old system we have a central TDataModule with the connection and shared data access for things used everywhere like customer information retrieval.  Then each form has form specific queries/datasets/command and datasource components dropped on them (no tables) for the form related data.  We don't have a sea of DB components on most forms, but if I could go back 25 years knowing what I know now, I would do it all through objects and/or use some type of ORM and have no DB components anywhere.  Now, where is my Tardis?

[Ian Branch 127]

Uwe nailed my position... 🙂