other db's ?

[joeblew99]

really nice framework.

anyone know if there is support for sql dialects, so that other databases can be targeted ?

maybe this is envisaged on the roadmap ?

[itsjoeconway]

To add support for another database, PersistentStore must be implemented. MySQL would likely be relatively straightforward, as it would be really similar to the Postgres implementation. There are a few places where things got tangled - specifically with DB migration and tests - where we would have to make some changes. The long term goal is to support other DBs as packages outside of Aqueduct.

[joeblew99]

@joeconwaystk
Sounds like the proper way to do it might be to introduce an actual dialects class, so that the PeristentStore and the Migration can both use them ?
I remember Hibernate and NHibernate had dialects as first class objects.

its a long list, since Hibernate has been around for ever: https://docs.jboss.org/hibernate/orm/3.5/api/org/hibernate/dialect/package-summary.html

[itsjoeconway]

Not having a lot of experience with Hibernate, it looks like dialects are doing translations a lot closer to the syntax, whereas the goal for persistent store is to do those translations by behavior. Not saying that is going to work long-term, but that is the goal.

[joeblew99]

i used NHibernate for years.
https://github.com/nhibernate/nhibernate-core/tree/master/src/NHibernate/Dialect

If you even want a source of already worked out dialects, that i think might be the best source.
Just saying..
Shall we leave this open ?

[mnordine]

Aqueduct seems really interesting, and I'd very much consider using it for our stack, but we use MySQL, so this is preventing us.

[itsjoeconway]

You can use any of the Dart MySQL drivers with Aqueduct, you just can't use the ORM features like Query and ManagedObject. Same goes for MongoDB or any other database.

[itsjoeconway]

This isn't accurate. The types AuthServer, AuthController, AuthRedirectController, AuthToken, AuthClient, Authorizer and Authorization have no dependency or even relationship with PostgreSQL or the ORM.

The abstract interface AuthDelegate is overridden for storage/retrieval for auth-related tasks. There is one provided implementation that uses the ORM (and therefore PostgreSQL). You can provide your own implementation for that one type, and still use all of the classes above without any changes.

[MoacirSchmidt]

I would really like to extend the AuthDelegate interface (or another ones) to use MySQL. Could you please guide me to some documentation or source code to achieve that?

[itsjoeconway]

Override this class in the docs, and pass instance of it to your AuthServer constructor:

https://pub.dartlang.org/documentation/aqueduct/latest/aqueduct/AuthServerDelegate-class.html

[MoacirSchmidt]

You were completely right, joeconwaystk. I have just override AuthServerDelegate for my needs and it was pretty easy! You have done a great job! Thank you very much!

[MoacirSchmidt]

And What about the Google and facebook integrated login. Is aqueduct ready for that?

[itsjoeconway]

Yes and no. There won't be any full integrations for a particular identity provider. You can attach data to an Authorization object or request that comes from another identity provider, and you can use client packages on pub for a particular identity provider to get that data. I don't think the framework should set a standard on how you integrate with those types of identity providers.

[MoacirSchmidt]

I overrided AuthServerDelegate to support Microsoft SQL Server databases. It is working pretty well!

Unfortunately I was unable to solve a little issue: Is there a way for me to pass a parameter to getResourceOwner in order to identify the user throughout several different applications (but same database)?

[BNSby]

You were completely right, joeconwaystk. I have just override AuthServerDelegate for my needs and it was pretty easy! You have done a great job! Thank you very much!

@MoacirSchmidt , could you share a solution for MySQL.
The problem is that I do not have the proper experience and deep knowledge in DART

[yusrenaltair]

I overrided AuthServerDelegate to support Microsoft SQL Server databases. It is working pretty well!

Would you like to share with us?
I'm using MSSQL Server as well. Thanks