3 ms·
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)
by mariusandra 9y ago
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.
- ProblemFactory 9y agoRedShift 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.