implement a pkg:realm:Transaction like class, simplifying commit and rollback

[gintominto5329]

Hi,

MongoDB's Realm package, has a Transaction class, returned by its Database-equivalent's beginWrite method.

But, we should name it beginWriteTransaction, instead of beginWrite.

thanks

[simolus3]

This is a fairly low level library around sqlite3, so I think users should manage transactions themselves by calling BEGIN and COMMIT as necessary.

If we support transactions, every call on the database would have to wait for a transaction to be complete because transactions aren't separate connections (and so the call outside of the transaction would read data written in the transaction). With a synchronous API, this isn't possible.

[gintominto5329]

hi,

your are so quick, i must say.

This is a fairly low level library around sqlite3.

How may I access the actual ffi bind-ed functions, if possible? if not, can those be exposed publically.

users should manage transactions themselves by calling BEGIN and COMMIT as necessary.

Using db.execute right?

You may think otherwise, but I tell you, that Im a beginner to both SQL and SQLite; Hope you understand.

thanks

[simolus3]

How may I access the actual ffi bind-ed functions, if possible

Why would you want to do that? It requires allocating and freeing memory yourself, which this library takes care of. You can call methods from this package which directly correspond to sqlite3 calls except that they wrap them in Dart types.

Using db.execute right?

Exactly.