Hacker News Reader

Does it support Redshift?

By using this the activerecord5-redshift-adapter gem [0], it may be possible.

[0] https://github.com/ConsultingMD/activerecord5-redshift-adapt...

I haven't tried, but if it doesn't, it shouldn't be hard to add.

So far I have only tried with PostgreSQL (full support) and SQLite (some date functions break), however any SQL dialect should work fine... except maybe when it comes to the date functions, which everyone has implemented differently.

RedShift is very close to PostgreSQL (it even uses PostgreSQL drivers to connect to their clusters from programming languages or data IDEs).

A sneakier difference is query latency. RedShift is scalable for queries that scan through very large amounts of data - but there is overhead for each query. One complicated JOIN can be faster than 50 small queries that ORMs and web apps like to make.

Reply on news.ycombinator.com