Issue 4 – Oracle Tips and Tricks

 
Subscribe to Issue 4 – Oracle Tips and Tricks
Avatar Editor Administrator
about 1 year ago

Discussion space for the article

 
Avatar Ed Lebert
about 1 year ago

I’ve been developing a massive rails application for my corporation that uses Oracle. What a mess. I can’t believe people PAY for this database.

I haven’t encountered any of the problems mentioned in you article, but I have encountered a very big problem in the 1000 item limit for a IN clause. This has forced me to monkey-patch ActiveRecord’s association pre-loading logic for every rails release. Also, I can never just pass in an array to ActiveRecord’s find functions, for the fear that my array might have more than 1000 items.