Improvements since my presentation at RubyKaigi 2014

Since RubyKaigi 2014 Oracle enhanced adapter have implemented new features supporting better Top N query. Since Rails 5 has been released. It will going to have another new features and new major version.

Transcript

1. IMPROVEMENTS SINCE MY PRESENTATION AT RUBYKAIGI 2014 YASUO HONDA @YAHONDA
2. 2.YEARS.AGO
4. ONE OF THE MISSING FEATURES FOR ORACLE ENHANCED ADAPTER
6. USER.FIRST IN RAILS 4.2 SELECT * FROM ( SELECT "USERS".* FROM "USERS" ORDER BY "USERS"."ID" ASC ) WHERE ROWNUM <= 1
7. NO LIMIT OFFSET SUPPORT !
8. OPENED A PULL REQUEST rails/arel#337
10. MERGED !
11. USER.FIRST IN RAILS 4.2 (REPEAT) SELECT * FROM ( SELECT "USERS".* FROM "USERS" ORDER BY "USERS"."ID" ASC ) WHERE ROWNUM <= 1
12. USER.FIRST IN RAILS 5 SELECT "USERS".* FROM "USERS" ORDER BY "USERS"."ID" ASC FETCH FIRST 1 ROWS ONLY
13. RAILS 5 ATTRIBUTE API Define an existing type (i.e. :string) or a custom one to each attribute.
14. ATTRIBUTE API REPLACES "LEGACY" SCHEMA SUPPORT IMPLEMENTATIONS
16. Rails 4.2 class ::TestEmployee < ActiveRecord::Base set_datetime_columns :hire_date end
17. Rails 5 class ::TestEmployee < ActiveRecord::Base attribute :hire_date, :datetime end
18. ✂
19. REMOVED LEGACY SCHEMA SUPPORT IMPLEMENTATION
21. BETTER COMPATIBILITY WITH OTHER DATABASE ADAPTERS
23. RAILS 5.1
24. ORACLE ENHANCED ADAPTER 2
25. Will only support Oracle Database 12.2 *
26. Oracle enhanced adapter 1.9 will support lower version of Oracle
27. IDENTITY SUPPORT
28. serial IN POSTGRESQL AUTO_INCREMENT IN MYSQL
29. WANTED TO REMOVE IF CURRENT_ADAPTER?(:ORACLEADAPTER)
31. if current_adapter?(:OracleAdapter) sequence_name = "accounts_seq" id_value = @connection.next_sequence_value(sequence_name) @connection.send(method, "INSERT INTO accounts (id, firm_id,credit_limit) VALUES (accounts_seq.nextval,42,5000)", nil, :id, id_value, sequence_name)
32. else @connection.send(method, "INSERT INTO accounts (firm_id,credit_limit) VALUES (42,5000)") end
33. DEVELOPMENT JUST STARTED !
34. NATIVE_DATABASE_TYPES = { - :primary_key => "NUMBER(38) NOT NULL PRIMARY KEY", + :primary_key => "NUMBER(38) GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY",
35. THANK YOU ❤ @yahonda