[Lazarus] What is a TSQLTransaction and why do I need one?

[Michael Van Canneyt]

On Wed, 24 Nov 2010, Alexsander Rosa wrote:

> But it is transparent to the libpq programmer; why it's not transparent with sqldb?

Correction: it can be transparant in libpq.

But we can make it so in SQLDB.

The SQLDB model is in fact modeled after Firebird. 
Firebird offers more control over the transactions.

We did not want to take away this possibility, so we modeled sqldb on 
the most powerful RDBMS. This adds some overhead for the others.

What we neglected to do is add what Martin added: offer a less intrusive 
way for the programmer to use it (i.e. create a default transaction in the 
background if none is specified, and close the transaction once the data 
is read).

But we'll do that too, all in good time.

If someone is in a hurry, patches are definitely accepted.

Michael.