Agenda: Database Adapters

[abishekrsrikaanth]

Can you allow extensibility to this package to hook up different data stores, so that we can add additional database adapters to it. I am looking for MYSQL support and if it was allowed, then we could use this package for different data sources.

[rschmukler]

Yeah, I think this is a good way to do it. I'll look at it this week!

[wachunga]

Sounds like a great approach.

[coreybutler]

+1

[vanthome]

I vote for a Redis apater

[AndreasPizsa]

:+1:

[toddpi314]

Seriously consider JugglingDB.
The migration from Mongo is pretty darn similar and it will allow consumers to use their adapter pattern for momento.

Keep up the great work!

[thelinuxlich]

RethinkDB! :)

[danilosampaio]

postgresql adapter would be great! i use sequelizejs, and a integration with it would be good for me, but the important thing is the flexibility to use other databases.

[briandela]

This would be awesome. Perhaps something like https://github.com/tgriesser/knex (or it's ORM https://github.com/tgriesser/bookshelf) could help make this easier (as it's pretty flexible with database).

If there was an easy way to plug in an adapter I'd gladly write a postgres one.

[jesucarr]

What about Waterline? https://github.com/balderdashy/waterline

It already has some of the adapters mentioned here, or you can write your own.

[doublerebel]

:+1: for Redis

[traviskaufman]

:+1: for Redis!

[jakemcgraw]

:+1: for Redis!

[ManuGowda]

I have used agenda for my job scheduling and everything working as expected, as we are moving away from mongodb to postgresql i am wondering when this planned ticket will be completed so that i can make use of it. :+1: for PostgreSQL!

[hackley]

👍

[mathieumg]

:+1:

[pangnate]

+1

[stevokk]

Have you considered how the job lock will work across different databases types? - I've been researching locking in a distributed node environment (avoiding multiple job executions)

Background on locking issue https://engineering.gosquared.com/distributed-locks-using-redis

Unfortunately I think for now I'll have to implement node-redis-warlock, node-cron and a custom wrapper for loading cron tables from MySQL.

I would appreciate your opinions about this, and if agenda is usable then I can definitely put some time in to contribute!

[jeonghwan-kim]

+1

[rochdev]

+1

[jdnichollsc]

:+1: for Postgres!

PD: Exist any example to create a new adapter? I need to migrate my code from MongoDB to PostgreSQL :/

Thanks in advance, Nicholls

[JohanPelaez]

👍 for Postgres!

[darrymorales]

👍 for Postgres!

[karthikbalu]

for MySQL

[PaulGrimshaw]

This would be a great addition

[boomshadow]

Redis or DynamoDB would just be awesome!

[shenghu]

can support cassandra?

[fzondlo]

Datastore would be great! Redis would be good too!

[noamnelke]

+1 on any persistence layer that AWS offers as a hosted service.

Our biggest con when we considered using Agenda was that we had to set up and maintain our own Mongo cluster for it. We don't want to have the data outside the VPC so we can't use hosted Mongo services offered by 3rd parties.

Hosting our own Mongo cluster means paying for 3 EC2 instances, setting up backups, ongoingly keeping the OS and Mongo up-to-date, etc...

If Redis or SQL were supported it would really be a no-brainer.

[simison]

NeDB suggested in https://github.com/agenda/agenda/issues/628

[dandv]

Given the development pace for the current adapter, supporting others seems quite out of scope.

That is, unless some folks come out of the woods and start approving PRs? :)

[PaulGrimshaw]

What about trying Agenda with DocumentDb:

https://aws.amazon.com/documentdb/

[goECS-enterprise]

I'm starting to work on integrating sequelize https://github.com/goECS/agenda-sql