Discussion:
What databases are you using with Mojolicious? (Poll)
(too old to reply)
sri
2014-09-25 19:07:07 UTC
Permalink
Lets have a little poll, what databases are you using with Mojolicious? And
which modules are you currently using to access them?

--
sri
2014-09-25 19:09:53 UTC
Permalink
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
I'll start... right at this moment i'm using PostgreSQL and SQLite.
Post by sri
And which modules are you currently using to access them?
And i'm using a custom wrapper around DBD::Pg and DBD::SQLite to access
them.

--
sebastian
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Ben van Staveren
2014-09-25 19:16:22 UTC
Permalink
Post by sri
Lets have a little poll, what databases are you using with Mojolicious? And
which modules are you currently using to access them?
--
sebastian
MongoDB using Mango (sniff... cry... sob)
PostgreSQL with DBD::Pg and some really nasty glue code
MySQL with the usual suspect and more crazy glue
SQLite with DBD::Sqlite3 (or however it's cased), with no special stuff
in it altogether

aaaaand... *drum roll*

ElasticSearch.

(the latter is obviously not strictly really speaking a database but
with a proper amount of elbow grease and mild threats to your sanity can
be made to work as such)
rasta
2014-09-26 12:19:12 UTC
Permalink
Post by Ben van Staveren
MongoDB using Mango (sniff... cry... sob)
+1
Post by Ben van Staveren
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And
Post by sri
which modules are you currently using to access them?
--
sebastian
MongoDB using Mango (sniff... cry... sob)
PostgreSQL with DBD::Pg and some really nasty glue code
MySQL with the usual suspect and more crazy glue
SQLite with DBD::Sqlite3 (or however it's cased), with no special stuff
in it altogether
aaaaand... *drum roll*
ElasticSearch.
(the latter is obviously not strictly really speaking a database but
with a proper amount of elbow grease and mild threats to your sanity can
be made to work as such)
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Tobias Oetiker
2014-09-25 19:19:10 UTC
Permalink
Post by sri
Lets have a little poll, what databases are you using with Mojolicious? And
which modules are you currently using to access them?
SQLite
Postgres

both with the DBI DBD drivers

both blocking

cheers
tobi
--
Tobi Oetiker, OETIKER+PARTNER AG, Aarweg 15 CH-4600 Olten, Switzerland
www.oetiker.ch ***@oetiker.ch +41 62 775 9902
s***@alexbyk.com
2014-09-25 19:32:28 UTC
Permalink
I was using Rose::DB::Object and DBIx::Class (Both with MySQL), and...
started to use Mango :-\ in new projects :-)
I like Mango so I'm going to use it further.

Sebastian, does a new dev. release of MongoDB have any breaking changes?
Or it was another reason?
Post by sri
Post by sri
Lets have a little poll, what databases are you using with Mojolicious? And
which modules are you currently using to access them?
SQLite
Postgres
both with the DBI DBD drivers
both blocking
cheers
tobi
Neil Watson
2014-09-25 19:47:46 UTC
Permalink
I'm using Posgresql with DBI/DBD drivers.
--
Neil Watson
Linux/UNIX Consultant
http://watson-wilson.ca
Александр Грошев
2014-09-25 19:53:01 UTC
Permalink
PostgreSQL using DBI and DBD::Pg
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
С уважеМОеЌ, АлексаМЎр ГрПшев.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Gabriel Vieira
2014-09-25 20:24:10 UTC
Permalink
MySQL and SQLite
DBIx::Class and DBIx::Custom

On Thu, Sep 25, 2014 at 4:53 PM, АлексаМЎр ГрПшев <
Post by Александр Грошев
PostgreSQL using DBI and DBD::Pg
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
С уважеМОеЌ, АлексаМЎр ГрПшев.
--
You received this message because you are subscribed to the Google Groups
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
Gabriel Vieira
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Per Carlson
2014-09-25 20:29:14 UTC
Permalink
PostgreSQL and SQLite using DBIx::Class or DBIx::Simple+SQL::Abstract
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
Pelle

Research is what I'm doing when I don't know what I'm doing.
- Wernher von Braun
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Allan Cochrane
2014-09-25 20:36:14 UTC
Permalink
Hi,

Vertica with DBD::ODBC, SQL::Abstract, DBIx::Simple

MongoDB

Allan
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Dan Wierenga
2014-09-25 20:45:21 UTC
Permalink
MariaDB via DBD::mysql and MS SQL Server via DBD::ODBC.
Lets have a little poll, what databases are you using with Mojolicious? And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Glen
2014-09-25 21:23:57 UTC
Permalink
MySQL, sqlite3, DBD::mysql, DBD::sqlite3
Post by Dan Wierenga
MariaDB via DBD::mysql and MS SQL Server via DBD::ODBC.
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an
.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an
.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Karl Boehnker
2014-09-25 21:29:54 UTC
Permalink
Mysql with custom wrapper around DBIx::Connector/DBI.
Mark Dueck
2014-09-25 21:51:45 UTC
Permalink
MongoDB using the MongoDB driver (and the kitchen sink with it), MySQL using DBD/DBI and RRD!

Mark Dueck
www.opmantek.com
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Greg Flynn
2017-04-17 18:59:34 UTC
Permalink
How are you connecting with MS SQL via DBD::ODBC?
I've been trying for days to get a successful connection, let alone create
the schema!
If you have any pointers, links, or info it would be GREATLY appreciated.
Post by Dan Wierenga
MariaDB via DBD::mysql and MS SQL Server via DBD::ODBC.
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an
<javascript:>.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at https://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Tobi Oetiker
2017-04-17 19:13:24 UTC
Permalink
Mojo::Pg and loving it

Tobias Oetiker
***@oetiker.ch
062 775 9902
Post by Greg Flynn
How are you connecting with MS SQL via DBD::ODBC?
I've been trying for days to get a successful connection, let alone create the schema!
If you have any pointers, links, or info it would be GREATLY appreciated.
Post by Dan Wierenga
MariaDB via DBD::mysql and MS SQL Server via DBD::ODBC.
Lets have a little poll, what databases are you using with Mojolicious? And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
Visit this group at https://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at https://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Juergen Nickelsen
2017-04-18 09:05:25 UTC
Permalink
Post by sri
Lets have a little poll, what databases are you using with
Mojolicious? And which modules are you currently using to access them?
Oh, this was before I joined the club. Still, I can answer.

I use PostgreSQL, as that database I use has been there before I
reimplemented the legacy PHP Web GUI with Mojolicious. To be able to use
everything from a CLI tool as well, I chose to implement a DB
abstraction layer without the Mojolicious dependency, so I used DBI as
usual.

In between I have seen that a CLI tool that has to have direct access to
the DB (and DB credentials!) is of very limited use. I have
reimplemented said CLI tool using the web service I implemented with
Mojolicious, so the idea of the DB abstraction is now somewhat moot.
Better reachability and much more flexible authentication make the web
service the better choice in all scenarios.

So, for further applications I will likely abandon the idea of a DB
abstraction and might as well switch to Mojo::Pg, if it turns out to be
suitable after I had a closer look at it.

Regards, Jürgen.
--
Jürgen Nickelsen <***@fu-berlin.de>
Freie Universität Berlin, ZEDAT/FUDIS https://zedat.fu-berlin.de/FUDIS
Jabber ***@jabber.fu-berlin.de; Tel +49.30.838-50740 Fax -450740
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at https://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
sri
2017-04-18 09:30:16 UTC
Permalink
Post by Juergen Nickelsen
So, for further applications I will likely abandon the idea of a DB
abstraction and might as well switch to Mojo::Pg, if it turns out to be
suitable after I had a closer look at it.
Mojo::Pg is pretty nice for DB abstraction actually.


https://github.com/kraih/mojo-pg/blob/master/examples/blog/lib/Blog/Model/Posts.pm

--
sebastian
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at https://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
sri
2017-04-18 09:32:51 UTC
Permalink
And a quick update for myself. I'm still primarily a PostgreSQL and SQLite
user, now
with Mojo::Pg and Mojo::SQLite, which both support SQL::Abstract for query
generation these days.

--
sebastian
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at https://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Dan Wierenga
2017-04-18 15:50:21 UTC
Permalink
You have to use the FreeTDS drivers (http://www.freetds.org) in conjunction
with DBD::ODBC.
Post by Greg Flynn
How are you connecting with MS SQL via DBD::ODBC?
I've been trying for days to get a successful connection, let alone create
the schema!
If you have any pointers, links, or info it would be GREATLY appreciated.
Post by Dan Wierenga
MariaDB via DBD::mysql and MS SQL Server via DBD::ODBC.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at https://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Cecile Neu
2014-09-25 21:00:19 UTC
Permalink
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
DynamoDB using a custom non-blocking library based on Amazon::DynamoDB

Cheers,
Cecile
Stig Sandbeck Mathisen
2014-09-25 21:20:18 UTC
Permalink
Luc Didry
2014-09-25 21:58:43 UTC
Permalink
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
MySQL and SQLite.
Post by sri
And which modules are you currently using to access them?
DBIx::Class and ORLite

In the case I had to use PostgreSQL, I would use DBIx::Class too.
--
Luc
http://www.fiat-tux.fr/
Internet n'est pas compliqué, Internet est ce que vous en faites.
jay m
2014-09-25 21:59:15 UTC
Permalink
mysql with DBIx::Connector and a proprietary ORM layer
MongoDB with Mongoose

jay
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Ian Firns
2014-09-25 22:51:10 UTC
Permalink
MongoDB via Mango
Stefan Adams
2014-09-26 04:28:58 UTC
Permalink
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
I originally was using DBIx::Class with MySQL but got bit hard by the
blocking. I didn't know what to do about it. I tried DBIx::Custom (I
think) as it had some experimental support for async. It's true, it
worked. But I didn't really stick with it. Plus, the whole time, I cursed
my daily life dealing with duplicating efforts between my code and my DB
schema. I really hated what I was doing. And when my DB access was
blocking on top of that, I felt I had to see what else was out there. I
then discovered NoSQL and think that schemaless doc-based DBs are the Holy
Grail. CouchDB seemed easier to comprehend than MongoDB. I've been
working with CouchDB since. I like it a lot. I'm still learning how to
design my data structure as I'm so used to relational models. But I'm
having a lot of fun with the JSON documents and creating views.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Glen
2014-09-26 05:02:37 UTC
Permalink
I prefer the schema and SQL, but the key is to have it generated for you.

It's key to be able to deploy to a DB with dbic config and vice versa with
one step, or you will indeed hate your life.
Post by Stefan Adams
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
I originally was using DBIx::Class with MySQL but got bit hard by the
blocking. I didn't know what to do about it. I tried DBIx::Custom (I
think) as it had some experimental support for async. It's true, it
worked. But I didn't really stick with it. Plus, the whole time, I cursed
my daily life dealing with duplicating efforts between my code and my DB
schema. I really hated what I was doing. And when my DB access was
blocking on top of that, I felt I had to see what else was out there. I
then discovered NoSQL and think that schemaless doc-based DBs are the Holy
Grail. CouchDB seemed easier to comprehend than MongoDB. I've been
working with CouchDB since. I like it a lot. I'm still learning how to
design my data structure as I'm so used to relational models. But I'm
having a lot of fun with the JSON documents and creating views.
--
You received this message because you are subscribed to the Google Groups
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an
.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Andrey Khozov
2014-09-26 06:11:46 UTC
Permalink
MongoDB via Mango
ElasticSearch via Search::Elasticsearch::Async
PostgreSQL via DBI
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
Andrey Khozov
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
AVM
2014-09-26 06:21:12 UTC
Permalink
Roland Lammel
2014-09-26 07:22:26 UTC
Permalink
DBI and DBIx::Class with MySQL (blocking)
Mango and MongoDB with MongoDB (testing purposes only)
Mojo::Util slurp/spurt with Files ;-)
Mojolicious::UserAgent to store/retrieve via REST

+rl
--
Roland Lammel
QuikIT - IT Lösungen - flexibel und schnell
Web: http://www.quikit.at
Phone: +43 (676) 9737845
Email: ***@quikit.at

"Enjoy your job, make lots of money, work within the law. Choose any two."
Post by Karl Boehnker
Mysql with custom wrapper around DBIx::Connector/DBI.
--
You received this message because you are subscribed to the Google Groups
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
heince.nvg
2014-09-26 09:11:00 UTC
Permalink
MySQL with DBIx::Connector
PostgreSQL with DBD::Pg
Post by Roland Lammel
DBI and DBIx::Class with MySQL (blocking)
Mango and MongoDB with MongoDB (testing purposes only)
Mojo::Util slurp/spurt with Files ;-)
Mojolicious::UserAgent to store/retrieve via REST
+rl
--
Roland Lammel
QuikIT - IT Lösungen - flexibel und schnell
Web: http://www.quikit.at
Phone: +43 (676) 9737845
"Enjoy your job, make lots of money, work within the law. Choose any two."
Mysql with custom wrapper around DBIx::Connector/DBI.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Alexander Karelas
2014-09-26 07:21:18 UTC
Permalink
MySQL in blocking-mode, using DBD::mysql and an ORM (Rose::DB::Object)

- Alex
Post by sri
Lets have a little poll, what databases are you using with
Mojolicious? And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google
Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Helmut Wollmersdorfer
2014-09-26 10:14:55 UTC
Permalink
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
MySQL, SQLite, PostgreSQL

via

DBIx::Class, DBIx::Class::Schema

and try to use DBIx::Class::DeploymentHandler in future.

Where possible, I run tests on all 3 DBs (MySQL, SQLite, PostgreSQL).
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Daniel Vinciguerra
2014-09-26 11:27:25 UTC
Permalink
using MySQL and SQLite (DBIx::Class and ObjectDB)



*Daniel Vinciguerra (@dvinciguerra)*
Web solution architect, perl dev, vegetarian, geek and co-founder at *Bivee*
bivee.com.br - github.com/Bivee

On 26 September 2014 07:14, Helmut Wollmersdorfer <
Post by Helmut Wollmersdorfer
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
MySQL, SQLite, PostgreSQL
via
DBIx::Class, DBIx::Class::Schema
and try to use DBIx::Class::DeploymentHandler in future.
Where possible, I run tests on all 3 DBs (MySQL, SQLite, PostgreSQL).
--
You received this message because you are subscribed to the Google Groups
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Brian Duggan
2014-09-26 12:55:23 UTC
Permalink
Post by sri
Lets have a little poll, what databases are you using with Mojolicious? And
which modules are you currently using to access them?
For large projects : PostgreSQL with Rose::DB::Object and a little
DBIx::Simple, DBIx::Custom and plain DBI/DBD::Pg.

For small/experimental projects I've really enjoyed redis (with RedisDB as
well as Mojo::Redis).

Brian
Michel
2014-09-26 12:17:14 UTC
Permalink
Daniel Mantovani
2014-09-26 13:40:55 UTC
Permalink
Postgresql & DBIx::Class

Daniel
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Mike Slattery
2014-09-26 13:43:23 UTC
Permalink
PostgreSQL using DBD::Pg, handrolled SQL and modules that take care of very
simple joins.


Would love to see ElasticSearch examples!
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Joe Landman
2014-09-26 13:57:21 UTC
Permalink
Post by sri
Lets have a little poll, what databases are you using with
Mojolicious? And which modules are you currently using to access them?
Currently using SQLite3 -> DBD::SQLite, starting to work with Tarantool
-> DR::Tarantool and ArangoDB -> ArangoDB. Was using MongoDB, but had
a number of issues with it, so we left it. I looked at RethinkDB ->
https://github.com/njlg/perl-rethinkdb .

I've been hoping UnQLite -> https://metacpan.org/pod/UnQLite will get
better over time, so I am keeping my eye on that. I've looked a little
at Tie::LevelDB as well.

I've used PostgreSQL in the past with DBI/DBD::pg and some wrappers
(DBIx::SimplePerl, because I hate writing SQL).
Paolo Saudin
2014-09-26 14:28:31 UTC
Permalink
PostgreSQL with DBIx::Connector

paolo saudin
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Fred Steinberg
2014-09-26 14:29:13 UTC
Permalink
PostgreSQL, SQLite, MySQL

DBIx::Class
Post by Paolo Saudin
PostgreSQL with DBIx::Connector
paolo saudin
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
M. Aaron Bossert
2014-09-26 14:34:23 UTC
Permalink
Mysql with dbi/dbd

Custom Apache Jena SPARQL endpoint

Aaron
Lets have a little poll, what databases are you using with Mojolicious? And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Harun Delgado
2014-09-26 14:41:06 UTC
Permalink
MySQL / PostgreSQL : DBIx::Class

And in cases where I need non-blocking : Redis and other process dump to
mysql or postgresql.

Jarun Delgado

http://djmania.es
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Виктор Турский
2014-09-26 15:14:43 UTC
Permalink
MySQL + Rose::DB::Object
Post by Harun Delgado
MySQL / PostgreSQL : DBIx::Class
And in cases where I need non-blocking : Redis and other process dump to
mysql or postgresql.
Jarun Delgado
http://djmania.es
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
Viktor Turskyi
http://webbylab.com
http://koorchik.blogspot.com
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Scott
2014-09-26 15:54:10 UTC
Permalink
MongoDB with Mango
MySQL with DBIx::Connector/DBIx::Simple

Anyone using PostgreSQL's NoSQL capabilities along with the traditional sql
approach?
Michael Ezzell
2014-09-26 16:35:21 UTC
Permalink
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
MySQL... my perception is that we lack solid non-blocking solutions in that
arena, so I have rolled some of my own, which I hope to make available once
they take on a more solid form:

I have a Mojo-based MySQL/JSON REST "gateway" (somewhat reminiscent of
DBSlayer, it's technically more of a DBI/JSON gateway, with actions named
after DBI method calls), speaks JSON, uses blocking calls to DBI, runs
under Hypnotoad with one client (and one DBI connection) per process, and
it's accessed via nonblocking Mojo::UserAgent calls from the application,
which is either in a different process or on an entirely different server.
This one is used in production.

I've also been toying with a this same basic model, but a MySQL/JSON helper
process that uses blocking DBI calls from perl threads, speaking JSON on
STDIN/STDOUT. The application spawns and communicates with this code,
non-blocking, via Mojo::IOLoop::ReadWriteFork. Each database request is
assigned an opaque identifier on the application side, which is returned
with the response by the gateway, allowing concurrent queries to be run and
disambiguated (the callback for the response is mapped to the opaque ID).

And I've played around a bit with the idea of a new pure-perl non-blocking
MySQL interface using Mojo::IOLoop::Client. Lots of interesting
challenges, there, but if it can perform, I think this would be my ideal
solution.

Of course, in some cases, I just use DBI and wait.

Also, there's Memcache... which isn't what you'd typically think of as a
"database," but we do have a web platform which, in QA mode, uses memcache
as its session store. For a sidecar Mojolicious application that needs to
access this session store, I wrote a plugin that uses Mojo::IOLoop::Client
and has a ground-up implementation of a subset of the memcache text
protocol. Currently, it only supports "get" (of single keys) and
"version," (for keepalives) but that's what I needed. It's also
non-blocking and can have multiple queries simultaneously in-flight on one
connection. MySQL introduced a memcache interface to InnoDB in 5.6... I
haven't tested my code against it, yet, but this seems like it could also
have interesting implications for simple, quick, lightweight, nonblocking
database key/value lookups from MySQL down the road.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
sri
2014-09-26 16:55:16 UTC
Permalink
Wow, this thread gives a great overview of what the community currently
looks like, personally i'm (positively) surprised how strong SQL databases
are represented. So here's a bonus question, how do you manage schema
upgrades?

--
sebastian
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Glen
2014-09-26 16:58:10 UTC
Permalink
*crickets*
Post by sri
Wow, this thread gives a great overview of what the community currently
looks like, personally i'm (positively) surprised how strong SQL databases
are represented. So here's a bonus question, how do you manage schema
upgrades?
--
sebastian
--
You received this message because you are subscribed to the Google Groups
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Stefan Adams
2014-09-26 17:01:29 UTC
Permalink
how do you manage schema upgrades?
I have only used DBIx::Class::Schema::Loader, more specifically dbicdump.
I've tied that into a Mojolicious::Command such that I could upgrade fairly
easily using my Mojo app commands as the basis for all things maintenance.
M::C FTW! :)
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Neil Watson
2014-09-26 17:05:08 UTC
Permalink
databases are represented. So here's a bonus question, how do you manage
schema upgrades?
Haven't had to yet. If I do I think I'll have the application examine
the schema and make the change when needed. I haven't thought hard about
it.
--
Neil Watson
Linux/UNIX Consultant
http://watson-wilson.ca
Brian Duggan
2014-09-26 17:46:46 UTC
Permalink
Post by sri
Wow, this thread gives a great overview of what the community currently
looks like, personally i'm (positively) surprised how strong SQL databases
are represented. So here's a bonus question, how do you manage schema
upgrades?
Module::Build::Database

https://metacpan.org/pod/Module::Build::Database

Brian
Per Carlson
2014-09-26 18:02:11 UTC
Permalink
Post by sri
Wow, this thread gives a great overview of what the community currently
looks like, personally i'm (positively) surprised how strong SQL databases
are represented. So here's a bonus question, how do you manage schema
upgrades?
I've just started using DBIx::Class::DeploymentHandler. It's a bit of
struggle to get understand how it works, but it's terrific when you get the
grip of it.
--
Pelle

Research is what I'm doing when I don't know what I'm doing.
- Wernher von Braun
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Allan Cochrane
2014-09-26 18:36:43 UTC
Permalink
Hi,

our app has a very wide table and outside of and asynchronously to the Mojo
application that plucks data from the database the wide table can be
widened. So for every query we check 1) the DB description of the table and
2) a list of columns descriptions (the descriptions are stored in Mongo)
that define the columns that ought to be in the table (and generally are).
It's a bit yucky but because the main DB is a columnar DB we can get away
with it.

So schema upgrades are handled on every request to the web api :-)

Allan
Post by sri
Wow, this thread gives a great overview of what the community currently
looks like, personally i'm (positively) surprised how strong SQL databases
are represented. So here's a bonus question, how do you manage schema
upgrades?
--
sebastian
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Justin Hawkins
2014-09-27 02:19:32 UTC
Permalink
Wow, this thread gives a great overview of what the community currently looks like, personally i'm (positively) surprised how strong SQL databases are represented. So here's a bonus question, how do you manage schema upgrades?
Sqitch.

I’d urge everyone still doing schema upgrades by hand to try it (or something similar).

- Justin
perlpong
2014-09-26 21:17:07 UTC
Permalink
PostgreSQL and 2 Redis instances (one as a persistent data store, other as
a volatile cache).

Here's my algorithm for managing schema upgrades (copied straight from my
docs):

Every time a change is made to the the development database, the SQL
commands
are put in a $appname.sql.changes file. A pre-commit hook will detect this
and will
automatically dump the new schema and add it to the commit.

The deploy script will check for the presence of a sql.changes file, and
if found, will execute those changes on the production database. It then
renames
the sql.changes file to sql.changes.ok. The sql.changes.ok file should then
be
distributed to any production servers, and when found by the deploy script,
those changes are executed and the sql.changes.ok file is then deleted. Once
the production server is synced, the original sql.changes.ok file should be
manually deleted from the origin repo.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Roey Almog
2014-09-27 17:05:57 UTC
Permalink
At Infoneto with mojolicious we use Firebird database with either
DBD::Firebird (for Perl 5.10.1 and up) or DBD::Interbase (for Perl 5.8.9)
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Антон Щанкин
2014-09-28 16:14:23 UTC
Permalink
Hello!
I am using PostgreSQL with DBIx::Class now, old projects living on MySQL
and Rose::DB::Object and older projects is on BerkleyDB =)
For schema migrations i have own tool ( like DBIx::Migration ) and
DBIx::Class::Schema::Loader ( its also very helpfully if you need take live
project with big schema for rewriting on perl/mojolicious )
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Alberto Mijares
2014-09-28 16:22:46 UTC
Permalink
Hi,

I'm just starting a new project with Mojolicious::Lite and Redis.

Regards,


Alberto Mijares



On Sun, Sep 28, 2014 at 11:44 AM, Антон Щанкин
Post by Антон Щанкин
Hello!
I am using PostgreSQL with DBIx::Class now, old projects living on MySQL and
Rose::DB::Object and older projects is on BerkleyDB =)
For schema migrations i have own tool ( like DBIx::Migration ) and
DBIx::Class::Schema::Loader ( its also very helpfully if you need take live
project with big schema for rewriting on perl/mojolicious )
--
You received this message because you are subscribed to the Google Groups
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Jan Henning Thorsen
2014-09-29 12:43:54 UTC
Permalink
Hi,

I'm using Redis, MySQL, SQLite for testing and occasionally MongoDB. In
future I think I will be using PostgreSQL.

I'm using Mojo::Redis2 for Redis. (I'm the author)
I'm using DBI and DBIx::Class with SQLite, MySQL and PostgreSQL.
I'm using Mango+Mandel for MongoDB. (I'm the author of Mandel)

Side note: I wonder what to do with Mandel. If anyone is up for it, I will
gladly give commit bit and access to PAUSE (send me an direct email or make
a github issue)

I've also (barely) started a non-blocking API for SQL:
https://github.com/jhthorsen/mojo-sql Current state: Not working. Plain
awful code. I'm also still trying to figure out what kind of API that makes
sense: Raw SQL vs datastructures. (send me an direct email if you're
interested)


Regards,
Jan Henning Thorsen (batman)
Post by Alberto Mijares
Hi,
I'm just starting a new project with Mojolicious::Lite and Redis.
Regards,
Alberto Mijares
On Sun, Sep 28, 2014 at 11:44 AM, АМтПМ ЩаМкОМ
Post by Антон Щанкин
Hello!
I am using PostgreSQL with DBIx::Class now, old projects living on MySQL
and
Post by Антон Щанкин
Rose::DB::Object and older projects is on BerkleyDB =)
For schema migrations i have own tool ( like DBIx::Migration ) and
DBIx::Class::Schema::Loader ( its also very helpfully if you need take
live
Post by Антон Щанкин
project with big schema for rewriting on perl/mojolicious )
--
You received this message because you are subscribed to the Google
Groups
Post by Антон Щанкин
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send
an
Post by Антон Щанкин
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Pavel Shaydo
2014-09-29 16:57:01 UTC
Permalink
On Thu, 25 Sep 2014 12:07:07 -0700 (PDT)
Post by sri
Lets have a little poll, what databases are you using with
Mojolicious? And which modules are you currently using to access them?
PostgreSQL with AnyEvent::Pg
s***@gmail.com
2014-10-01 13:37:19 UTC
Permalink
Right now: MySQL, DBD::mysql

In the future probably SQLite and MongoDB.
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
lenz
2014-10-01 17:55:10 UTC
Permalink
CouchDB with Store::CouchDB (I am the author and use it in other non Mojo
projects too)

no schema changes :)

cheers
Lenz
Post by s***@gmail.com
Right now: MySQL, DBD::mysql
In the future probably SQLite and MongoDB.
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
hammondos
2014-10-02 12:23:18 UTC
Permalink
MongoDB (via official driver), now more inclined towards ElasticSearch - in
the future probably Redis too
Post by lenz
CouchDB with Store::CouchDB (I am the author and use it in other non Mojo
projects too)
no schema changes :)
cheers
Lenz
Post by s***@gmail.com
Right now: MySQL, DBD::mysql
In the future probably SQLite and MongoDB.
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an
<javascript:>.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Daniel Böhringer
2014-10-02 19:45:37 UTC
Permalink
postgres
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Jeremy Zawodny
2014-10-08 01:43:12 UTC
Permalink
MySQL via DBD::mysql semi-async, SQLite, Sphinx (speaks the MySQL protocol)
search engine
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Kevin Hughes
2014-10-10 03:11:49 UTC
Permalink
Elasticsearch and Mojolicious match up to well. No driver needed when
using Mojo::UserAgent.
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Simotrone
2014-10-10 15:43:38 UTC
Permalink
what databases are you using with Mojolicious? And which modules are you
currently using to access them?
Mysql, Redis, (a sort of) Pg via internal wrappers builded on DBI.
Also used sqlite in home context.

how do you manage schema upgrades?
currently, manual. :)
Post by Kevin Hughes
Elasticsearch and Mojolicious match up to well. No driver needed when
using Mojo::UserAgent.
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
sri
2014-10-13 18:43:24 UTC
Permalink
Allright, i've counted results so you don't have to. :)

MySQL: 25
PostreSQL: 24
SQLite: 15
MongoDB: 12
Redis: 6
ElasticSearch: 4
CouchDB: 3
MariaDB: 2
Percona: 1
Firebird: 1
Vertica: 1
BerkleyDB: 1
DynamoDB: 1
MS SQL Server: 1

P.S.: I'm a little surprised MySQL is so strong, but glad we are on the
right track with Mojo::Pg and Mojo::mysql. :)

--
sebastian
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Joe Landman
2014-10-13 18:51:16 UTC
Permalink
Post by sri
Allright, i've counted results so you don't have to. :)
MySQL: 25
PostreSQL: 24
SQLite: 15
MongoDB: 12
Redis: 6
ElasticSearch: 4
CouchDB: 3
MariaDB: 2
Percona: 1
Firebird: 1
Vertica: 1
BerkleyDB: 1
DynamoDB: 1
MS SQL Server: 1
Should have 1 each for InfluxDB, Tarantool, ArangoDB, and I am working
on interfacing to kdb+ (www.kx.com). Influx and kdb+ are time series
DB, and ArangoDB and Tarantool are more "general". I'd love a pure perl
capability, DBM::Deep looks nice, but there are performance concerns
expressed in the reviews. I've got to play with them to be sure.

I'd love a direct tie in to PostgreSQL. That's my go to SQL DB for
anything that SQLite can't/shouldn't handle.
sri
2014-10-13 18:56:37 UTC
Permalink
Should have 1 each for InfluxDB, Tarantool, ArangoDB...
Oops, i've tried to filter out the "i've looked at X" ones and might have
missed some smaller databases because of it.

--
sebastian
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Ed Rantanen
2014-10-14 23:56:36 UTC
Permalink
Whisper & rrdtool
Should have 1 each for InfluxDB, Tarantool, ArangoDB...
Oops, i've tried to filter out the "i've looked at X" ones and might have
missed some smaller databases because of it.
--
sebastian
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Viktor Nacht
2014-10-16 03:09:22 UTC
Permalink
Paul Williams
2014-10-16 08:34:54 UTC
Permalink
Databases
- DBIx::Class + DBD::Pg/DBD::SQLite
- DBIx::Connector + DBD::Pg
- Mojolicious::Plugin::PgAsync + DBD::Pg

Deployment
- MicroOLAP db designer for PostgreSQL (paid for SQL designer)
- Manual

I'm looking to use sqitch for new projects.
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Michel
2017-04-19 11:52:38 UTC
Permalink
On my side I am still a CouchDB user, and I have a request for advice: I'd
like to develop an offline first web app, and I am a bit stuck with
Mojolicious. I see that most of offline first apps are based on 100%
javascript frameworks (most of them using PouchDB). So does anyone here
have an offline first experience with Mojolicious?
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
--
sebastian
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at https://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Brian Manning
2017-04-21 02:29:14 UTC
Permalink
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
Paradox (!) via DBD::ODBC + BDE driver on Windows (Strawberry Perl on
Windows 2003 Server). All hail the Perl glue!

The same Mojolicious app also uses DBD::SQLite for development use on other
platforms, via a switch in the config file.

Thanks,

Brian
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at https://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
John Scoles
2017-04-21 11:14:20 UTC
Permalink
Well for me it is what DBs you do not use with Mojo

the only one I have not used in a project is Informix

Normally I use DBIx::Connector and then tap into my own Data Accessor
Module that is largely SQL neutral but base on DBI

So in order Oracle, MySQL, Prostgress, SQLlight , ADO, PGLight and When
needed MongoDb and I have even used it with Jade (yuck)
Post by sri
Lets have a little poll, what databases are you using with Mojolicious?
And which modules are you currently using to access them?
--
sebastian
--
The contents of this e-mail and any attachments are intended solely for the use of the named addressee(s) and may contain confidential and/or privileged information. Any unauthorized use, copying, disclosure, or distribution of the contents of this e-mail is strictly prohibited by the sender and may be unlawful. If you are not the intended recipient, please notify the sender immediately and delete this e-mail.
--
You received this message because you are subscribed to the Google Groups "Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mojolicious+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at https://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
Continue reading on narkive:
Loading...