Key | Value |
---|---|
MD5 | 18526F1B893AFAF01BCD0231F577CCCF |
PackageArch | noarch |
PackageDescription | Mojo::mysql is a tiny wrapper around DBD::mysql and DBD::MariaDB that makes at http://www.mysql.org and at https://mariadb.org/ a lot of fun to use with the at http://mojolicio.us real-time web framework. The two DBD drivers are compatible with both MySQL and MariaDB, but they offer different options. DBD::MariaDB should have better unicode support though and might become the default in the future. Database and handles are cached automatically, so they can be reused transparently to increase performance. And you can handle connection timeouts gracefully by holding on to them only for short amounts of time. use Mojolicious::Lite; use Mojo::mysql; helper mysql => sub { state $mysql = Mojo::mysql->strict_mode('mysql://sri:s3cret@localhost/db') }; get '/' => sub { my $c = shift; my $db = $c->mysql->db; $c->render(json => $db->query('select now() as time')->hash); }; app->start; While all I/O operations are performed blocking, you can wait for long running queries asynchronously, allowing the Mojo::IOLoop event loop to perform other tasks in the meantime. Since database connections usually have a very low latency, this often results in very good performance. Every database connection can only handle one active query at a time, this includes asynchronous ones. So if you start more than one, they will be put on a waiting list and performed sequentially. To perform multiple queries concurrently, you have to use multiple connections. my $db = $mysql->db; $db->query('select sleep(5)' => sub {...}); $db->query('select sleep(5)' => sub {...}); $mysql->db->query('select sleep(5)' => sub {...}); $mysql->db->query('select sleep(5)' => sub {...}); All cached database handles will be reset automatically if a new process has been forked, this allows multiple processes to share the same Mojo::mysql object safely. |
PackageName | perl-Mojo-mysql |
PackageRelease | 1.2 |
PackageVersion | 1.25 |
SHA-1 | C4E9A26872AE0BACD632F57C4766C19D54D379FB |
SHA-256 | CD4C3F710396FCADA6A28B269965D6272E09D6379D6B218F755FB7FE051AB6D2 |
hashlookup:children-total | 29 |
hashlookup:trust | 50 |
The searched file hash includes 29 children files known and seen by metalookup. A sample is included below:
Key | Value |
---|---|
FileName | ./usr/share/doc/packages/perl-Mojo-mysql/examples/blog/lib/Blog/Controller/Posts.pm |
FileSize | 1217 |
MD5 | 829A1A28DE0FDF72B9FA8D0586E5DA11 |
SHA-1 | 07EEEC56A049B73A538C239ABC439D1BE77D045C |
SHA-256 | C13038150524554705B14BE63854EDFA581F2E259DC650579E022635AE054C3B |
SSDEEP | 24:PVfyhO/A+st8lhIwyhOuVtmwKL4hpaVl+QKuTnjV33K3kH:PNyk/Ls8lhZykuVt9KL4PaVl3KurjV3B |
TLSH | T1DB21BDA4B1A1D3452DB269B702C2E156ACEF0C872E4E05A2B83D90B50EC2EF3968704C |
Key | Value |
---|---|
FileName | ./usr/share/doc/packages/perl-Mojo-mysql/examples/blog/templates/posts/edit.html.ep |
FileSize | 219 |
MD5 | D6CA351B018C9A003A6C3C0E705E6368 |
SHA-1 | 09156B59A34CE4C1B4CB22FB143F49BF67DFFE83 |
SHA-256 | 248D3EA9BA62311B4692BD708CF90D01C545BB069F8F49DE4036DDDF1610FB27 |
SSDEEP | 6:gHTRdTEgRZQTIA4gWplr9AxVK5XQJXhhH5Lcq:gHTXwg454gUl2TdXZLcq |
TLSH | T1B7D0235A833C875011B376F911D5E14C1CD5ED14E98195864D5CF4C41F0553D903B30D |
Key | Value |
---|---|
FileName | ./usr/share/man/man3/Mojo::mysql::Transaction.3pm.gz |
FileSize | 1436 |
MD5 | 36F9BD44A58F2C5303BC57AABB4D4892 |
SHA-1 | 1CC627A8AA50CCF403CF8D2B4CF80A4321F83C8F |
SHA-256 | 0510BF28C6C519E6049366296E677D546D38A1C91975A003F184B9842C4348B2 |
SSDEEP | 24:XBPmG3EDyXUCpYvIweQ8xk8VfKkKuDNJonRDAmXNTdl9yohdu2KETKGJCNpWmTZ5:XBL3EDyXURvIVS6KQN2nRcuT1hduMTKt |
TLSH | T15921194E61AB2273CEF25306C77319BB90269080286D560718FCE702947ABB418EC793 |
Key | Value |
---|---|
FileName | ./usr/share/perl5/vendor_perl/Mojo/mysql/Results.pm |
FileSize | 6855 |
MD5 | FFBF317736CBEA39EA450E60D99876D5 |
SHA-1 | 20F767C32FF77AC2EFBD94C58A73A0089751073C |
SHA-256 | AC2EF659A953C2C79F16E6E381ACF7909B745E49D174626331264692034E3452 |
SSDEEP | 192:NjGmD9s3IFZRiZ+/H8g9HUMPnoZ5Ay8sr:wmRgIFZRiZ+/H8g9D/yyy9 |
TLSH | T153E134C624A39EAC87F760F12AC9E5A3A7B6B0544A1C01903DDEC41C9FC2835773C55D |
Key | Value |
---|---|
FileName | ./usr/share/doc/packages/perl-Mojo-mysql/examples/blog/templates/posts/index.html.ep |
FileSize | 217 |
MD5 | B1859529FE67F3F13392B70C7C60B378 |
SHA-1 | 29628463DD70C416C079B31B58A6DADA9F67B621 |
SHA-256 | F37BB910632331C648F89312DA878789993D53FF848618077AF32A9C13722207 |
SSDEEP | 3:gJE4PCFyXfzl2WW3PdJbgLONgWH1ssK02WpPbZQLR7qjv/0xvAFEFzOUyKWGithQ:g3Pzl2WsgWisrX59QdWT/EAKtqm6K |
TLSH | T192D02209C1AC15817412317FCAF1E01EED6A881EFDC00982AF8C3280AF980B16DA6B80 |
Key | Value |
---|---|
FileName | ./usr/share/doc/packages/perl-Mojo-mysql/examples/blog/lib/Blog/Model/Posts.pm |
FileSize | 712 |
MD5 | 20A78835EDA44DCA1FAB1AE86141F4AD |
SHA-1 | 2DB762CF713C5C75A2B6DA4EBEC731CF5E55A169 |
SHA-256 | F1179EE1E420D2DBB8EA974003D1376EE3F9F28556D1656AD80DE49364E8B438 |
SSDEEP | 12:frR1Dh76UFtMF7UUP/9+aa5/AbqBRdJwHUP/AxT2B8A175/CAMIXT2B8csRkXDhu:V1DNLvwnsa4cqLdK0nqExDJXa2WDNp27 |
TLSH | T1A9014C82E0E95A98127191B6CFDAD4C19CAF5151BEEC507858BC702C8ED10265BB939E |
Key | Value |
---|---|
FileName | ./usr/share/perl5/vendor_perl/Mojo/mysql.pm |
FileSize | 16675 |
MD5 | 0B822569E46FAF0A84A0643D1A730E09 |
SHA-1 | 33F148D417730FB6CA49E743FE59AA11F21227A6 |
SHA-256 | 7C09BCE8C876D672AEB64CDCCA699EEE3FEE657275E20046541BD0DC4D4F197D |
SSDEEP | 384:wHSN5GEg6oO8NUgVyuym5o9iT7LJ9/wwG76RjQ9sHYDtk:wHTyoO8NUGym5o9mrBG76RjQ9sHYDtk |
TLSH | T13472C60272629AD840B300B19DDAC0D3A6F5F1597A3886D0B6FCC22C1F57974E67B32B |
Key | Value |
---|---|
FileName | ./usr/share/perl5/vendor_perl/Mojo/mysql/Migrations.pm |
FileSize | 7718 |
MD5 | E9D3E4784286D052E881D73B4988FDBA |
SHA-1 | 3AE6D612581D2E7354FED0846826AC4E1A1D6784 |
SHA-256 | 92687B8882F9E70E3D4326190D028BC2DDB52CF953500424BA3E0C2471BCF6C1 |
SSDEEP | 192:YlNOKK4+mrPfPMXGPOqA0R4vMGbZE0TGGL2KM6qemJgJ:4t1Rv4B2KDP |
TLSH | T1BFF1A484A192E3F201E393B70DD5C6C1AF79D94EFA0848C839DDC10C5F8CD28939A63A |
Key | Value |
---|---|
FileName | ./usr/share/perl5/vendor_perl/SQL/Abstract/mysql.pm |
FileSize | 10797 |
MD5 | E29E08F57C2DE1D0C95D4023BDDDF8E9 |
SHA-1 | 3AF4633E2CF0B20848FD610E863491FB95758BEC |
SHA-256 | 9B6AB8E24926CC972C38798065390442E1DAC4B906A98397EF3F6F77721EC4B5 |
SSDEEP | 192:ebmqcQiQtyl9bEdtpkwvrQ51rd3aNCjqeaGUhyUgMuCU7dUTWuc:eraEtpkwvfuF2uIWz |
TLSH | T12022A80862B3E9F816FED1732BCCC419BA5D4953842C47A5775CA1889FC0DB0D62DA7D |
Key | Value |
---|---|
FileName | ./usr/share/doc/packages/perl-Mojo-SQLite/examples/blog/templates/layouts/blog.html.ep |
FileSize | 468 |
MD5 | EC2145ECFF9D0E33970A835459CA2768 |
SHA-1 | 5F14A95F8070E7178CE7BC569B196E496DC57F73 |
SHA-256 | 042B035981AD25DF353D1FC07F36739C53224707B86389FED9D11E56308BA536 |
SSDEEP | 12:hYeby8G20KsNnPTmdFHxdQM7Z3wlwyJGyB3zfJGAEdOdFPrQL:hYebymemHHxP7ZgCAGyB3zJXEc8 |
TLSH | T113F05C15A0720246B21361402E66398467E3921781CB8C46FEDE5774CFCD2645DEB7E8 |