Comments (5)
You ever look at this? Just wondering.
from aura.sql.
(/me furrows brow) I recall looking at it, and thought I commented on closing it. I recall my comment being along the lines of, "Do the underlying engine support nested transaction natively? Do they permit rolling back to the last sub-transaction?" (I recall having other notes, but not what they were.)
from aura.sql.
Do the underlying engine support nested transaction natively?
They don't, or at least MySQL doesn't - that's sort of the point; it counts the transaction level, so that calls to transact()
, during a previous call to transact()
, does not lead to early commits. All nested calls to transact()
need to succeed (return true) in order for the transaction to commit.
The main point though, is to achieve transaction semantics - as opposed to manually having to check conditions and call commit or rollback, potentially breaking semantics (by forgetting to commit or rollback) or forgetting to manually check inTransaction()
, etc... That stuff gets wonky.
I've been doing it this way for a long time, on lots of projects, and it saved me a lot of headache.
from aura.sql.
They don't, or at least MySQL doesn't
(/me nods)
So SAVEPOINT and RELEASE (etc) don't quite do the trick for you? A brief googling revealed support in mysql, sqlite, pgsql, and sql server, though I don't know how recently.
from aura.sql.
AFAIK, in MySql this is supported by INNO only, but yes - you could use
that for sub transactions where available maybe, though that would give it
a very different meaning depending on the database.
I've never personally needed savepoints. I need transactions all the time,
and I don't like the non-transactional API most database APIs provide, so I
usually add in something like this. YMMV.
On Jun 2, 2015 11:19 PM, "Paul M. Jones" [email protected] wrote:
They don't, or at least MySQL doesn't
(/me nods)
So SAVEPOINT and RELEASE (etc) don't quite do the trick for you? A brief
googling revealed support in mysql, sqlite, pgsql, and sql server, though I
don't know how recently.—
Reply to this email directly or view it on GitHub
#66 (comment).
from aura.sql.
Related Issues (20)
- Bug with pgsql query HOT 5
- DB Reconnection HOT 5
- Auto adding Ticks HOT 8
- Decode json? (to arrays) HOT 1
- Bug in Queryparser for SQLite HOT 3
- Question HOT 1
- Using 2.x and 3.x in parallel HOT 10
- What is the future of this project? HOT 15
- Create GIthub Actions to automatically build and test this package
- PHP 8.1 Compatibility HOT 8
- Type hint incomplete HOT 7
- Scrutinizer Error HOT 1
- Version that doesn't throw deprecation warnings in 8.1 but works in 8.0? HOT 19
- Works with all versions of PHP from 5.6 to 8.1
- Release note HOT 7
- Abandon 4.x ? HOT 2
- Consider tagging / releasing 3.0.1 please ? HOT 2
- How to debug "Column count doesn't match value count"? HOT 1
- Time for 5.0.2/5.1 HOT 4
- Does Aura.Sql suffer of the problem of useless order by on some ORM prefetches ? HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from aura.sql.