200OK Web Conference

Here is a summary of the presentations.

Data Warehouses from an app developers perspective.?

presenter: Adnan Arabic, Cube Dev

• Bottlenecks
• Benchmarks
• Sub-second latency

Data warehouses are a single source of truth.

Extract, Transform and Load ETL data for use in data analysis and business insights.

Data warehouses love OLAP = Online Analytical processing

• Insert & update statements
• Low volume of complex analytical queries
• Numerical calculations with aggregations

AVG, COUNT_DISTINCT, PERCENTILE_CONT

• Scan a vast amount of data
• How to improve the performance of a data warehouse
• Does the unicorn exist??
• Materialized views
• OLAP cubes
• Pre computed multi-dimensional datasets
• Filter and aggregate values by dimensions

Building Data Apps is Hard.

• Consume data
• Responsive and performant apps
• Performance?
• Instantaneous response 10ms
• Interrupts the flow of thought above 1 second
• Blinking your eye = 100 ms

Query latency?

• Time to ex a query and receive a result
• amount of data scanned
• Understanding latency as an app dev
• 1&0 186000 mi/s
• 30 ms latency

Understanding latency as an app developer.

• Network delays
• High concurrency ?
• Query latency in BigQuery
• Serverless big data warehouse
• Slots Compute units
• More slots Higher performance
• Hands-on Query Latency in BigQuery
• TPC-H-data with 150 million views
• Pre-aggregation Acceleration
• Latency less than one second

Latency vs. Concurrency

• Concurrent parallel queries
• Competing for resources
• 1.4s for 1 concurrent query with 3 GB

Query Concurrency is?actively co-executing queries.?

• Query concurrency in BigQuery
• Capped at 100 queries per project
• Query cache is included.

BigQuery is a Black Box

• Only improve query performance
• Limit input & output data
• Reduce data before GROUP By and JOIN clauses
• ORDER?By LIMIT
• Latency vs Concurrency with Cube?

BigQuery vs Cube

• Data warehousing needs caching
• Give Cube a star on GitHub
• Cube-js/cube.js
• give Cube a try

How to improve the performance of data warehouses

Bit.Lu/techlahomasmile?AmazonSmile to donate 0.5%

Techlahoma.org/donate

Inasmuch Foundation is lessening the suffering of Oklahomans and strengthening the institutions that support Oklahoma.

Web dev Best Practices: What the Data Tells Us

presenter: Laurie Voss, Netlify

1 - State of Web Dev

2 - The popular choice is not the same as the best choice

Sources of Error

1 - The Jamstack Community Survey

Who we are

82% are engineers

45% are front end web developers

37% are full stack web developers

6% are management

16% are students

5% are other

Average experience 6+ yrs

Increasingly geographically diverse 15 yrs+ experience are in North America and Europe.

Purple is the New Black: Modern Approaches to Application Security

presenter: Tanya Janca DevR @ Bright Security

1 - Best Practices Red TeAm Offensive security

2 - Blue?security Defensive security

3 - Purple Team Collaborative security is the bridge between security and software devs.

Collaboration, Empathy and Advocacy Let’s talk purple?

Definitions?

IAST Interactive Application Security Testing

RASP Run Time Application Security Protectio file Integrity Monitoring

Application Control Tools

Cloud Native Controls are customized for each cloud.

Non-UI A User Obsessed Design Approach

presenter: Pereware Pere

How to turn a frustrating experience into a delightful one.

• Lemonade
• Bunch?
• Revolut

" Design is not just how it looks, it’s how it works. " — Steve Jobs

What does the user want to do on this page??

System Design: What is the design achieving?

• Friction Design
• Driver Design
• Anticipatory

Natural human state to Invisible state

• Not all things can be implemented.
• You determine the least amount of effort.
• Research is encouraged for this process.
• Might not be the best for heavy interaction products.
• It is good for users to take an action.
• Will vary from business to business.
• The framework Non UI.

Project != Program != Product

presenter: Kylie Humpert with LegalShield

Project

What is a project? A temporary effort to create value through a unique result.?

Project Mgr

• They break down the initative into tangle tasks.
• Assign resources
• Maintain budgets and timelines
• Monitor and report progress
• Communication, GSD, Provlem solvers, project focused, output driven, resources, short-term owners, tactical
• Collaboration?
• Assigned to project team
• Work with other project mgr
• Partner with program and product

Other titles are product owner, business analyst, scheduler and release train engineer.

Program

What is a program? A set of projects organized to achieve a strategic objective.

Responsibilities of the Program Manager

• Operational strategic plans
• Multiple projects in program
• Manage team
• Monitor and report progress
• Collaboration
• Assigned to programs
• Work with various project managers and teams
• Partner with product

Other titles are portfolio manager, strategic project manager and product manager.

Program managers are?

• Business focused
• Communicators
• GSD
• Long-term owner
• Problem solver
• Outcome driven
• Resources
• Strategic

Product Managers are

• Champions for the product
• Define and evangelize vision
• Assigned to a product service
• Works with various teams to support the product
• Partner with program and project teams

Prioritization of product roadmap

• Customer insights
• The go to market strategy
• Collaboration

Other titles are product marketing?manager, marketing manager and product developer manager.

Product Managers are?

• Communicators
• Customer focus
• GSD?
• KPI driven
• Long-term Owners

Priorities

• Problem finders or solvers
• Strategic

All PMs are not alike

A short-term Project has project focus and is output driven. A long-term program has business focus and is outcome driven.

A long-term product has customer Focus and is KPI Driven.

Developing Through Barriers

presenters: Kendawill Werts and Maxx Crawford, with Jeanette Washington

Intersectionality includes race, ethnicity, gender identity, class, language, religion, ability, sexuality, mental health, age, education and body size.

It has to do with the way people view other peoples lives.?

Ability Neurodiversity is used to describe the differences of the nervous system.?

Learning, Visual, Hearing, Mobility, Neurodiversity, Mental Health?

Who benefits from high contrast text?

Those with vision loss, cataracts or that are snow blinded (situational blindness).

Who benefits from large tap areas?

Those with Parkinson’s disease, a broken hand or a drunken individual.

Who benefits from closed captions?

Those with hearing loss or an ear infection.

Developers need

• Internet filters
• Page simplifiers

The dark side of UX

presenter: Courtney Heitman

Archon Resources Aaron Sams

Understanding of IT

https://bit.my/Quibit-meta

UX = Psychology

Honest Design = Percent of Mistakes

Manipulative Design = Hide negative reviews

Harry Brignull www.dark?patterns.org

A Taxonomy of?Dark patterns

1. Trick questions
2. Membership status
3. Privacy zuckering
4. Misdirection
5. Bait and switch
6. Roach Motel easy in offers a difficult out E.g The AirPods I ordered that we’re advertised for shipping cost only. When they were received I was charged a much more expensive rate.
7. Forced Continuity
8. Fake Advantage

The 200OK web conference on June 3rd featured these presenters.

Rahi?, Adnan. Cube Dev. Making Data Warehouses fast: A?developer’s story. @adnanrahic ?adnanrahic.com

Voss, Laurie. Netlify.?Web development best practices: what the data?tells us. @seldo ?seldo.com

Janca, Tanya. Purple is the new black: Modern Approaches to?Application Security.

@tanya.janca shehackspurple.ca

Pereware, Pere. Non-UI — A User-obsessed?Design Approach. trameter.com

Humpert, Kylie. LegalShield. Project != Program?!= Product. ?legalshield.com

Beseda, Taylor. Functional Web Apps: The revenge of dynamic?web apps. @tbeseda ?tbeseda.com

Emily Harden, Executive Director

Devon Mobiley, President, OKC?

To learn more about this conference, visit https://200ok.us.