AWS Redshift Support

[pippolino]

Hi,

Is it on roadmap the support for AWS Redshift?

Thanks

[fredericDelaporte]

No one works on this, as far as I know. It could be you.

By the way, it seems this database is to be connected with ODBC, for which NHibernate has a driver.

And according to Wikipedia, it is based on PostgreSQL 8.0.2, so using a PostgreSQL dialect could work.

Have you tried it?

[pippolino]

Hi @fredericDelaporte,

I have not yet tried to connect via the ODBC driver but I will try these days.

Unfortunately it is not possible to use PostgreSQL dialect because there are differences that make the two DBs ​​incompatible as unsupported types or different functions...

[fredericDelaporte]

It could still work, if your model and queries do not use those mismatched types or functions. Or else deriving from a PostgreSQL dialect for overriding just these types or functions mappings is quite easy and lightweight. You could then contribute your adapted dialect into NHibernate if you wish.