TODO: delete Themes

View Github Repository Open presentation in a new window

martindsouza

See all presentation from martindsouza

TODO: delete Themes

0 6

pres-open-source-apex

View presentation:

On Github martindsouza / pres-open-source-apex

Open Source & APEX

Presentation: bit.ly/open-source-apex

  • Started ~1.5 years ago
  • Over 10 active projects w. 15 active developers
  • 1 Project Sponsor

Slides

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

  • This entire presentation is open source.
    • This may be a first at OOW!
  • Can fork the project, modify, and make any changes you'd like!
  • View the presentation online right now

Goal:

  • Learn about an OS project that can help you out
  • Get involved Outline:
  • Introduction
  • Popular projects
  • Considerations
  • How to get involved

<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.
  • Services: application development, coaching, consulting, EBS extensions, and Forms migration.
  • 80 employees and growing

Popular APEX 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 3rd Party Integrations

Logger

OXAR

Build script to generate VM with:

  • Oracle XE
  • APEX
  • ORDS
  • Node.js
    • Oracle Node.js driver (node-oracledb)
  • And more...
  • 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.

Demo (SSL)

OXAR

Comming soon

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

“This product is one of the best alternatives for comparing different releases of an application.”
  • 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

Common set of PL/SQL utility methods

Demo

  • No video for this now as OOS Utils is still in beta -

OOS Utils

github.com/OraOpenSource/oos-utils

How you can help: Test beta & submit issues

OMonAPEX

Database monitoring application

Demo

demolink

OMonAPEX

github.com/OraOpenSource/OMonAPEX

APEX Front-End Boost

Code faster, easier, and prettier

Demo

APEX Front-End Boost

github.com/OraOpenSource/apex-frontend-boost

Webinar

PLSQL to Markdown

Converts PL/SQL JavaDoc documentation to markdown

Demo

PLSQL to Markdown

github.com/OraOpenSource/plsql-md-doc

APEX Sert

Security Evaluation and Recommendation Tool for APEX

github.com/OraOpenSource/apex-sert

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.

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.

APEX Apps

APEX Apps

PL/SQL

  • Basic tutorial for those new to Git.
  • Git is a DVCS (Distributed Version Control System). Very similar to SVN but everyone has their own copy of the entire repo.

Cloud Hosting

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

Info

One More Thing

Get Involved

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

KScope 17 June 25-29 - San Antonio

Events

end;

Slides: github.com/martindsouza/pres-open-source-apex

  • I mentioned over 10 active projects at the start
  • Only had time to show a few of them, check out OOS and also get involved.
  • Only possible by the community. Use the tools, submit issues/suggestions, help out, create your own project!
Open Source & APEX martindsouza www.talkapex.com martindsouza mdsouza@insum.ca Insum Solutions Presentation: bit.ly/open-source-apex Turn off notes