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

[gintominto5329]

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

[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.

[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.

[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