> I am not sure if I get your point. try-catch nor pcall would
> prevent these connections from accumulating, unless it is placed
> INSIDE the code, in which case you should wonder: "Was throwing that
> exception really worth it?". Or, if you call a external library, you
> should wonder: "Is there anything I can do to prevent my program
> from misbehaving on a error?". If you can't, you should switch
> library, switch database, or accept that you made the wrong choices
> or have to deal with a braindead API and just create a pcall.
> Or, alternatively, you could do something like this:
> local ok, err = pcall(function()
> local f = db.open('file.txt')
> library.call(f)
> f:close()
> end)
> if not ok then
> collectgarbage() -- force garbage collection, closing open database connections
> error(err)
> end
> which is what a sensible database API would want you to do.
There exists several other way in API.
1. Use `acquire` function.
db.acquire(..., function()
... do some work ...
error('some error')
end)
`acquire` function can close db properly and propagate error further.
But there problem with original stack trace. I think error object can
have one.
2. Variant implemented in LuaSocket library with `protect` and `try`
functions.
Also I think about how Lua can extend generic for to be able call some
finalizer when loop breaks. Its real problem because now it not
possible implement such mechanism.
for row in db:rows('select * ...') do
if ... then break end
end
we have no access to cursor directly so we can not close it and have
to rely on GC.
--
С уважением,
Alexey mailto:alexeymelnichuck@gmail.com
---
Это сообщение проверено на вирусы антивирусом Avast.
https://www.avast.com/antivirus
Errors are hard.
My observation is that constructing some difficult to handle code is roughly as easy to do as coming up with an alternate that works fine, which is about as easy as dismissing that alternate as "too much typing" or "awkward."
Dealing with system resources is special and I find myself thinking a lot about architecture and isolation and design when I'm dealing with them.
I haven't found myself wishing for try/catch.
-Andrew
