Use sqlalchemy.engine_from_config

[jqnatividad]

@amercader We were able to switch from sqlite to postgres by simply replacing the sqlalchemy_database_uri default sqlite uri with a postgres uri.

However, if I want to pass more engine configuration settings through sqlalchemy to postgres, its not possible.

Similar to CKAN and the datastore, ckan service provider should use sqlalchemy.engine_from_config as well so users can pass more engine configuration settings through.

[amercader]

Sounds good @jqnatividad , if you want to send a PR here's where the engine is created:

ckan-service-provider/ckanserviceprovider/db.py

Line 78 in 673a738

ENGINE = sqlalchemy.create_engine(uri, echo=echo, convert_unicode=True)