cznic

Yes as of now. Is it different with respect to other database/sql drivers?

I wonder how other DB drivers manage the classical transaction example: ``` go db.Exec("UPDATE AccountA SET Balance = Balance - $1;", amount) db.Exec("UPDATE AccountB SET Balance = Balance + $1;",...

That is wrong. This is not a safe way of transferring money from one account to the other account. The proper way is: ``` go tx1 := db.Begin() tx1.Exec("UPDATE AccountA...

@Unknwon Agreed, and that **is** the current situation. No magic/implicit transactions - the developer should know and create a proper transaction context explicitly (_"take the responsibility"_). Especially when the database/sql...

After a [discussion on G+](https://plus.google.com/u/0/+JanMercl/posts/LyvQZoKm118): #Accepted.

Reopening b/c the intent is to answer once the new DB backend is finished. No promises on timeline, but it is an active WIP.

I cannot recall what the situation was in 2014, but ATM I think - `SELECT * FROM invoices WHERE customerid = $1;`: O(n). - With `CREATE INDEX invoicesLookup ON invoices(customerid);`:...

> is the new backend you are referring to related to the HTTPFS? No, the new backend should have replaced cznic/lldb. > regarding backup, since ql uses a single file...

Thinking about it, maybe the solution is to - Wait for any pending R/W transaction to finish to have a consistent file image. - Enter backup mode which keeps the...

> Do we keep count of pending transactions? No, but IIRC [DB.rw](https://github.com/cznic/ql/blob/fa0b3688520bac17b6cdef1b3a5022788a3db1af/ql.go#L836) reflects if there is any R/W transaction executing. If so, it executes in isolation.