Improvements since my presentation at RubyKaigi 2014

Slide 1

Slide 1 text

IMPROVEMENTS SINCE MY PRESENTATION AT RUBYKAIGI 2014 YASUO HONDA @YAHONDA

Slide 2

Slide 2 text

2.YEARS.AGO

Slide 3

Slide 3 text

No content

Slide 4

Slide 4 text

ONE OF THE MISSING FEATURES FOR ORACLE ENHANCED ADAPTER

Slide 5

Slide 5 text

No content

Slide 6

Slide 6 text

USER.FIRST IN RAILS 4.2 SELECT * FROM ( SELECT "USERS".* FROM "USERS" ORDER BY "USERS"."ID" ASC ) WHERE ROWNUM <= 1

Slide 7

Slide 7 text

NO LIMIT OFFSET SUPPORT !

Slide 8

Slide 8 text

OPENED A PULL REQUEST rails/arel#337

Slide 9

Slide 9 text

No content

Slide 10

Slide 10 text

MERGED !

Slide 11

Slide 11 text

USER.FIRST IN RAILS 4.2 (REPEAT) SELECT * FROM ( SELECT "USERS".* FROM "USERS" ORDER BY "USERS"."ID" ASC ) WHERE ROWNUM <= 1

Slide 12

Slide 12 text

USER.FIRST IN RAILS 5 SELECT "USERS".* FROM "USERS" ORDER BY "USERS"."ID" ASC FETCH FIRST 1 ROWS ONLY

Slide 13

Slide 13 text

RAILS 5 ATTRIBUTE API Define an existing type (i.e. :string) or a custom one to each attribute.

Slide 14

Slide 14 text

ATTRIBUTE API REPLACES "LEGACY" SCHEMA SUPPORT IMPLEMENTATIONS

Slide 15

Slide 15 text

No content

Slide 16

Slide 16 text

Rails 4.2 class ::TestEmployee < ActiveRecord::Base set_datetime_columns :hire_date end

Slide 17

Slide 17 text

Rails 5 class ::TestEmployee < ActiveRecord::Base attribute :hire_date, :datetime end

Slide 18

Slide 18 text

✂

Slide 19

Slide 19 text

REMOVED LEGACY SCHEMA SUPPORT IMPLEMENTATION

Slide 20

Slide 20 text

No content

Slide 21

Slide 21 text

BETTER COMPATIBILITY WITH OTHER DATABASE ADAPTERS

Slide 22

Slide 22 text

No content

Slide 23

Slide 23 text

RAILS 5.1

Slide 24

Slide 24 text

ORACLE ENHANCED ADAPTER 2

Slide 25

Slide 25 text

Will only support Oracle Database 12.2 *

Slide 26

Slide 26 text

Oracle enhanced adapter 1.9 will support lower version of Oracle

Slide 27

Slide 27 text

IDENTITY SUPPORT

Slide 28

Slide 28 text

serial IN POSTGRESQL AUTO_INCREMENT IN MYSQL

Slide 29

Slide 29 text

WANTED TO REMOVE IF CURRENT_ADAPTER?(:ORACLEADAPTER)

Slide 30

Slide 30 text

No content

Slide 31

Slide 31 text

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)

Slide 32

Slide 32 text

else @connection.send(method, "INSERT INTO accounts (firm_id,credit_limit) VALUES (42,5000)") end

Slide 33

Slide 33 text

DEVELOPMENT JUST STARTED !

Slide 34

Slide 34 text

NATIVE_DATABASE_TYPES = { - :primary_key => "NUMBER(38) NOT NULL PRIMARY KEY", + :primary_key => "NUMBER(38) GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY",

Slide 35

Slide 35 text

THANK YOU ❤ @yahonda