Comments (7)
DB::Pg
is in pretty good shape. DB::MySQL
has some fundamental brokenness I haven't been able to fix.
from dbiish.
In general, one cannot reuse database connection objects across threads. This isn't anything Raku-specific; the same is observed over different database drivers and bindings to them in different programming languages. The typical solution is to use a connection pool; I'm not sure if this module offers one (and that's why I've tended to use DB::Pg
instead in Cro apps, since it has had one out of the box from the start).
from dbiish.
from dbiish.
@jnthn , yeah DB::Pg is one of the options here, though I am hesitant to switch to postgresql
from mysql
which is on my view is easier to maintain ....
from dbiish.
yeah DB::Pg is one of the options here, though I am hesitant to switch to postgresql from mysql which is on my view is easier to maintain ....
D'oh, yes, that wan't so useful an answer on my part. :-) What I should have added is that there is https://modules.raku.org/dist/DB::MySQL:cpan:CTILMES too, which is pretty much the DB::Pg
approach but for MySQL. That said, if you're already using DBIish
, the pool module is probably the path of least resistance from where you are.
from dbiish.
@jnthn ++ thanks for that, @patrickbkr already mentioned DB::MySQL
in raku irc channel, I will keep it as a second possible solution ...
from dbiish.
I've just tried to use DBIish::Pool and looks like it works great for my sparky web cro app and concurrent db requests - melezhik/sparky@106f82b. @patrickbkr @jnthn @CurtTilmes @rba thanks for your help
from dbiish.
Related Issues (20)
- Oracle support for "TIMESTAMP WITH LOCAL TIME ZONE" is missing HOT 1
- $sth.allrows(:array-of-hash) not an exact replacement for $sth.fetchall_hashref('KEY') HOT 1
- Oracle Support - Forcing SELECT'ed field names to lower-case is bad mojo HOT 5
- Cannot avoid DBDish::Oracle: Error: ORA-01000: maximum open cursors exceeded HOT 6
- Failure to self manage statement handles causes DBDish::Oracle: Error: ORA-01000: maximum open cursors exceeded HOT 4
- CI Test Oracle for Oracle driver
- Support default value in insert&update HOT 1
- Places for placeholders HOT 1
- SQLite Threads: Getting errors on macos during install HOT 6
- Add support to firebird database HOT 4
- Native call expected argument 1 to reference a native integer, but got CPointer HOT 6
- Oracle InstantClient 18 not used? HOT 10
- DBIish: DBDish::Pg needs 'pq', not found HOT 12
- BLOB support for Oracle?
- Cryptic error message on using disconnect HOT 2
- MySQL driver cannot handle bigint unsigned in `execute( )` HOT 14
- zef install test failures HOT 5
- Non-repeatable test failures in Github cron job HOT 2
- X::AdHoc: Cannot look up attributes in a VMNull type object. Did you forget a '.new'? HOT 10
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 dbiish.