another point is with integrity… it does not respect integrity of links by default and does not have a way to force it.

_

Daniel Ferreira Monteiro Alves

@danfma

anyway, its a great db… if we could only workaround the transaction api ;)

Luca Garulli

@lvca

Hi guys, executing multiple commands as transaction against a stateless protocol by definition, like HTTP, it's expensive in terms of keeping server side statuses and timeouts. But this could be done. Did you guys already open a new issue for that?

Roman Gordon

@GoorMoon

@lvca , you mean open issue to support transaction over HTTP ?

Charles Pick

@phpnode

TX over http is already supported via SQL batch

Henry Hazan

@henry-hz

Hi guys, please, how can I make big queries to stream and process row by row ? once my selects returns millions of rows.... [here is an example using the mssql driver for node]

Luca Garulli

@lvca

@GoorMoon I mean creating an open execution context created with a new "begin" command. After a timeout it could be rollbacked.

Roman Gordon

@GoorMoon

@henry-hz, I think it's not posible in current approach for remote binary protocol.

Charles Pick

@phpnode

@GoorMoon i believe it's possible via async queries, but i've not tried it