pres-open-source-oracle

View Github Repository Open presentation in a new window

martindsouza

See all presentation from martindsouza

pres-open-source-oracle

0 0

pres-open-source-oracle

View presentation:

On Github martindsouza / pres-open-source-oracle

Open Source Oracle

- Turn off notes

Slides

github.com/martindsouza/pres-open-source-oracle

- This entire presentation is open source. - Can fork the project, modify, and make any changes you'd like! - View the presentation online right now

How old is open source?

  • 1993 Free BSD
  • 1950/60s Software produced by academics
  • Older?
How long has open source been around for? - I think it's been around for a very long time, only recently its been given a fancier name.
Source Liz West The concept of open source has been around for a very long time. Think of recipes. A time honored tradition of passing cooking instructions on to friends and family members. More importantly they get copied along the way.

Agenda

  • Intro
  • Popular OS Projects
  • Git
  • Considerations
  • Wrap-up

<me>

Oracle & APEX

Open source

</me>

- Been involved with OS for over 5 years. - Started with APEX plugins. - Really got involved with open source when I took over Logger.

insumsolutions

- North America's largest APEX company. - PL/SQL and APEX consulting services.

Popular Oracle Open Source Projects

- This section includes videos which will only play in Chrome. - If you do not have Chrome, the files are in the www/video folder.

Logger

PL/SQL Instrumentation Tool

Logger

OXAR

Build script to generate VM with:

  • Oracle XE
  • APEX
  • ORDS
  • Node.js
    • Oracle Node.js driver (node-oracledb)
    • Bower
- All demos for this presentation were built from an OXAR built machine.
- Visit the project page for all options. - In this demo used a custom script that edit config. - Need to copy the files over to the VM Oracle licensing prevents including them. - Can also reference files on network or provide URL to file.

OXAR

APEX-Diff

  • Exports APEX in JSON format
  • Easily compare two APEX applications
- This has been a huge pain for APEX. - Though can't do a direct restore can see all the changes from one version to next.
- Script takes time to run. For demo purposes cut out wait time.

APEX-Diff

github.com/OraOpenSource/apex-diff

- Read the pre-requisites section (solve 90% of issues people have reported). - Usage: run after once a day for simple code reviews by tech lead.

OOS Utils

github.com/OraOpenSource/oos-utils

- Common developer utility tools - Still in Alpha Phase

Live Demo

PL/SQL Documentation

OOS Utils Docs

PL/SQL to Markdown

Live Demo

PL/SQL to Markdown

github.com/OraOpenSource/plsql-md-doc

Docs

APEX Front-End Boost

Live Demo

APEX Front-End Boost

github.com/OraOpenSource/apex-frontend-boost

Webinar Thursday, May 5, 2016 5:00 pm (Berlin)

OMonAPEX

Live Demo

Link

OMon APEX

github.com/OraOpenSource/omonapex

APEX Plugins

New home for all plugins: apex.world

- All management is done on each plugin separately. - Ex: Issues, bugs, etc are managed by the developer and not by apex.world.
- Highlights apex.world plugin directory - Look at Select2 plugin from Nick Buytaert

Oracle

  • Oracle
    • Official Oracle GitHub account
  • DB Tools
    • Code samples for SQLcl, ORDS, REST, etc

- The following demos have not been used, tested, or vetted by me. - They were suggestions provided by the community. - Can not comment on their stability, effectiveness, security, etc. - Not saying that they're bad, I just haven't used them.

PL/SQL

- Git is a DVCS (Distributed Version Control System). Very similar to SVN but everyone has their own copy of the entire repo.

Git 101

Applications

- Personal recommendation: - Learn Git command line - Use SourceTree for Gui.

Sites

- Both sites are very good. - Free for public projects. - Different pricing models for private projects.

Considerations

- Several to consider when choosing an open source platform.

Open source isn't free

- Support, maintain, inherit, etc. - What happens if owner stops work on project?

- OS: Long term maintenance. - Can mitigate this by sponsoring. For example, Insum recently sponsored a project on OOS. It was cheaper for them then to build/manage themselves. - Build: Maintenance. - Buy: Is it worth it, pay more than you just need. Security?

OS Check List

  • How active is the project?
  • Can you inherit the project?
  • How popular is the project?
  • Paid support option?
- If you decide to use an OS project, there are some things to consider.

Get Involved

  • Signup to Github
  • Learn
  • Help on a project
    • Suggestion, issue, bug fix, enhancement, etc.
  • Start your own project!

Homework

- Would like to get feedback from this talk. - Please create an issue with the label of feedback and leave your thoughts.

end;

Presentation: bit.ly/open-source-oracle

Open Source Oracle martindsouza www.talkapex.com martindsouza mdsouza@insum.ca Insum Solutions Presentation: bit.ly/open-source-oracle - Turn off notes