APEX in your hands: Lessons learnt from a tablet project

APEX in your hands

APEX in your hands

CONSISTENCY

hardware -> APIs -> JavaScript -> APEX -> Layer 8

Lessons learned from a tablet project

CSS

tiger snake

deadly accurate

deathly quick

CSS / jQuery

learn

Oracle APEX != WYSIWYG

yet tablets yearn to be...

canvas

real estate

vital

/* push/prod components */

margin-top : 50px;

easy

medium

/* Fix the menu at the top of the page */

.navbar {

position:fixed;

width:100%;

z-index:10000;

}

contemporary

Scott Wesley

/* Hide column/button when in portrait */

@media (orientation:portrait) {

#P1_BUTTON,

th#HIREDATE, td[headers=HIREDATE]

{

display: none;

}

}

expand your skills

learn jQuery

learning how to experiment

div.ui-datepicker {

font-size: 200%;

}

table.ui-datepicker-calendar > tbody > tr > td > a {

padding:10px;

}

$('#saving span').css('color','red');

$(completePerc).val(100).change();

worth it

if ($this).attr('headers') = 'TOT')

jQuery

+

Dynamic Actions

coming in 2014...

NAVIGATION

jQUERY

Menus

• enlarged (for big fingers)

• customised with attributes

• dynamic (based on SQL)

apex_application_pages

apex_application_page_groups

Movement

do

you

see

it?

• large template

• placement

• highlight preferred

Modals

• just another region

• dynamic action driven

• examples in sample applications

• con - more content to generate

Our Client

spot the difference

* Respectable home builder

Browser differences

* Metro / Southwest

speed in increments

* Supervisors on-site

real differences in toolbar

tiny

took a few touches

guess the browser

* Many have big fingers

"standards mode"

IE not immediately HMTL5 friendly in APEX

<!--[if (gt IE 9)|!(IE)]> <!-->

<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">

<!--<![endif]-->

FAST=

http://www.grassroots-oracle.com/2013/07/apex-rendering-issues-in-ie10.html

goo.gl/Hj1k08

Firefox

Chrome

IE10

IE8

If red touches black,

it is a friend of Jack

If red touches yellow,

it can kill a fellow

20km/h

aggressive

web services

infrastructure

APEX Listener

caching

CDN

>

#APP_IMAGES#

#IMAGE_PREFIX#

maintenance

Optimise

&F_FILE_LOCATION.

BROWSER

database

2008

2013

SQL

Source: Wikipedia

yesterday's pc = today's mobile

http://theoatmeal.com/comics/apostrophe

PL/SQL

AJAX

apex

Joel Kallman

Modals

Workflow

http://goo.gl/xD774X

APEX or the DB?

screen design

plugins

conditions

* 50 = 1.5s

http://www.grassroots-oracle.com/2013/05/performance-of-apex-conditions.html

black mamba

select round(avg(execution_time),5) avg_time

,message

from apex_debug_messages

where message like '%sparkline%'

group by message;

20-50% reduction

known to kill an elephant

you start to notice

TRUE

MATTERS

Name : Scott Wesley

Rank : Systems Consultant & Trainer

Web : about.me/scottwesley

Serial# :

SIZE

african

snake

amongst

the

trees

defence in depth

be prepared to make everything

okonjima.wordpress.com

Coverage

bigger

Connectivity

4G LTE

padding

date

pickers

Speed

/* date picker */

div.ui-datepicker {

font-size : 200%;

}

table.ui-datepicker-calendar>tbody>tr>td>a {

padding : 10px;

}

3G

(April 2008)

row height

buttons

font scale

CITRIX

ADSL

talk tips

Device

BYOD

Developers - pay attention

Facsimile

< $500

iPad

Windows Surface RT

Battery life

Laptops

see a snake?

2013

Files & boxes

get your nerd on

(May 2010)

2007

Responsive Web Design

asia

Oracle Forms

Tipping the balance

Session based

just because you can...

pain

SAGE

Excel macros

... doesn't mean you should

Platform

Right people

Process

APEX 4.2

Change management

On-site

Mobile ready

consider your theme choice carefully

Web delivery

Culture

IT

APEX - 2011

saw scaled viper

Progress in "Points"

Tablet

Infrastructure

RWD

Standard construction methods

Testing

Prototyping

Business Case

it won't happen overnight

$$$

Progress in days

Why?

2012

check out

New construction methods & types

trentdrake.com

fresh ground

remember: pc -> mobile -> tablet

S-Curve (Sigmoid)

nocturnal

banded krait - asia

HYBRID

The Great Divide

KEYBOARD

it all started with a ...

Desktop

Mobile

Tablet apps still on the rise

July 2013

even native store apps

canvas : "wellUtilised"

images : "notSharp"

slow to catch up

retro="on"

appropriateKeyboard : "forgotten"

logoutHard2find : "true"

capt0bvious : "speaking"

if you want to expand horizons

invasive

jpl.nasa.gov

Be prepared to break new ground

nasa.gov

Australian Style

TOUCH

Touch

changes everything

1963

How old is the

the oldest mouse?

kustoms.com.au/

Lessons learned from a tablet project