Wiki

how we do

(#orclapex development as fast as possible)

#team #loving #apex

(about us)

      We love APEX

      		As #orclapex entusiasts we are focused on building tools and that automates application development process.
      As a result we built tecnica24.es/quickapeks and tecnica24.es/apbox, helping us to develop code faster and also manage and deploy infrastructure easily.

      We are Certified

      		Registered Oracle Apex Consulting Company and experienced Oracle Apex Certified Developers with 16+ years of experience.


#lets #walk #together

(what activities would like to start)

      1 Let us drive a demo of Oracle APEX low code features
      Will show you how we use quickapeks to code faster
      how Reporter can be integrated in your apps to let end user create reports easily
      and which Applications are ready to be incorporated in our projects

      2 Start a small project as proof of concept
      We follow this Project Life Cycle to accomplish tasks in time
      You will follow up our tasks through Dashboard to track hours consumed

      3 Have a look to your infrastructure
      as we can improve it using full Oracle based stack
      and You have a look to our infrastructure
      as you can trust on projects ending on time
      as we have skills to do so


#showroom

(running technology)

      Every project is hosted by a new development box with full stack, Oracle Database 21c XE...
      apboxdeploying new boxes
      Your browser does not support the video tag.
      installing apex and ords automatically


      Team use Runner to start/stop boxes on demand when sprints are started/stopped
      Runnerstarting, stopping development boxes
      Your browser does not support the video tag. start/stop Your browser does not support the video tag. remove Your browser does not support the video tag. deploy


      Team use Manager to deploy apex workspaces and applications
      Managercreating new application
      Your browser does not support the video tag.
      create app


      Developers use Builder to create standard apex components faster
      Buildercreating reports and maps by end user
      Your browser does not support the video tag.
      create map


      Team use apbox to backup all development boxes on demand or by crontab
      apboxbacking up boxes
      Your browser does not support the video tag.


      Team use Filer to search code from any project in a centralized way
      Filersearching source code
      Your browser does not support the video tag.


    (c) 2022 TECNICA VEINTICUATRO DESARROLLO DE SOFTWARE, S.L.
    all this stuff is published by Wiki app. These are our main actors:



Technology Stack

      We select full Oracle Technology Stack because we are committed to drive as stable as possible.

       

      Oracle Linux 8oracle.com/linux
      Docker, Podman

      docker.com

      podman.io

      Oracle Database 21coracle.com/database/technologies
      Oracle APEX 21.2apex.oracle.com
      Oracle ORDS 21.3https://www.oracle.com/database/technologies/appdev/rest.html


Oracle Apex

the fastest development platform, apex.oracle.com

       

      Low Code Development!

      The choice of thousands of companies and most of Fortune 500 to modernize their Forms/Reports, and Java based applications.

      Oracle APEX rocks! 

      You recently discovered it and started a new development path. Faster than ever. But without a master plan focused on simplicity and not reinventing the wheel you can reach easily a nightmare of applications. Our vision based on years of experience: development based on micro services applications.

      Here is technology we add to our projects: we start with a lot of work done.



Project Life Cycle

      Project Life Cycle


      (how we drive projects and tools used)

      own tools to help development and infrastructure management

      		apbox - to run infrastructure
      tecnica24.es/apbox
      Agenda - log work,
      tecnica24.es/apex/agenda
      Quickapeks - create apex components,
      tecnica24.es/apex/quickapeks
      Runner - run infrastructure,
      tecnica24.es/apex/runner-demo
      Builder - create apex pages,
      tecnica24.es/apex/builder
      Reporter - create apex reports,
      tecnica24.es/apex/reporter
      Parser - parse xlsx files,
      tecnica24.es/apex/parser
      Designer - applications designing,
      tecnica24.es/apex/designer
      Manager - applications install,
      tecnica24.es/apex/manager
      online meetings - zoom, cisco webex, google meet, anydesk

      start project

      		Quickapeks - create new workspace
      Runner - create new developmen box
      Agenda - create new book

      start design

      		Quickapeks to build draft

      input requisites

      		online meeting with customer

      confirm list requisites

      		online meeting with customer

      create application draft

      		Quickapeks

      check application draft

      		customer runs draft in Quickapeks

      confirm application draft

      		online meeting with customer checking application draft

      end design

      start development sprint

      		Quickapeks to build datamodel

      create or restart development box

      		Runner to deploy container running project infrastructure

      create normalized components

      		Quickapeks to build authentication, authorization, lovs, edit forms

      create customized components

      		Oracle APEX to build customized pages

      test application

      deploy application

      		Manager to install application

      archive development box

      		Runner to stop container
      apbox to archive box

      end development sprint

      		Customer follows project tasks using Dashboard
      Agenda to get project status report to send Customer

      start guarantee support

      		Agenda to log incidents

      support incident

      		online meeting with Customer to get feedback
      start development fix when needed
      Agenda to log details

      annotate new requisites

      		Quickapeks

      end guarantee support

      start standard support

      		Agenda to log incidents

      new requisites to start development sprint

      		Agenda to log new requisites

      end standard support

      end project

      		Agenda to get final project status
      send report to Customer

Infrastructure

technology that automates applications building process

      Cloud

      We select Oracle Cloud infrastructure as it has "Always Free" option you can use as an starting point. Then you can grow up inside Oracle Cloud or maintain your existing services.       		 

      On Premise

      We deploy a containerized infrastructure using our technology âp'box. It is managed from an apex application Runner.      		  

      âp'box

      âp'box drives deployment of Oracle 18c and 21c Databases boxes with Apex and Ords installed on the fly. You can manage âp'box from its text menu or from Runner. Here you can see a full deployment of Oracle 21XE Database with Apex 21.2 and Ords 21.3. It is 10x times its normal speed.
      tecnica24.es/apbox      		   Your browser does not support the video tag.

      quickapeks

      Is the evolution of our expertise using Oracle APEX. We must finish projects in time and to accomplish that goal we developed a tool based on templates that creates nearly 90% of source code of any application.
      tecnica24.es/quickapeks      		   Your browser does not support the video tag.

Applications

These are applications are ready to be included in our projects as modules or standalone. This is an investment for your organization as we never start a project with "zero code".

       

      Parser

      Parser lets you upload xlsx files and view its content using select statements.
      tecnica24.es/apex/parser

      Utilities

      Utilities are a set of functions and packages that lets you render dynamic content based on templates. Inside any other app you define templates based on html and sql selects to render dynamically content.
      tecnica24.es/apex/utils      		  
       

      Runner

      Runner lets you drive your infrastructure deploying, starting and stoping containers running Oracle Database 21c XE instances with Oracle APEX 21.2.
      tecnica24.es/apex/runner-demo

      Reporter

      Reporter creates reports, charts and calendars dynamically in execution time. Users can add their own reports in new Oracle APEX pages. Also existing reports can be an starting point for creating new ones.
      tecnica24.es/apex/reporter      		  
       

      Navigator

      Navigator is an extension to Reporter. It has new functionality as a browser of existing objects in database and creating Oracle APEX pages as forms and grids. tecnica24.es/apex/navigator

      Interactive Reports

      Users may know Interactive Reports functionality prior to use Oracle APEX applications as they would be able to filter data, generate charts and so on. Our app showcases Interactive Reports driving users to understand how to use them.
      tecnica24.es/apex/irdemo      		  
       

      Finder

      Finder is an starting point to search data in your entire organization. It has the ability to define sources to external data in others applications using views. Once defined users can search as they were using Google Search.
      tecnica24.es/apex/finder

      Builder

      Builder lets your users create Oracle APEX pages on the fly in execution time. Also developers can have a running draft of new applications in short time. Using Oracle APEX API we drive the creation of new pages easily and faster. Also you can create components like List of Values, and Lists for Navigation.
      tecnica24.es/apex/builder      		  
       

      Manager

      Manager lets you deploy new applications easily. As developers use Oracle APEX to install new applications users can also install and use them easily from a centralized repository you share in your organization.
      tecnica24.es/apex/manager

      Filer

      Filer is a document store. Also is a place to centralize all your source code. When using apbox we do backups of schemas, workspaces, applications and also source code. Source code as generated and posted to a rest service running in Filer.
      tecnica24.es/apex/filer      		  
       

      Designer

      Designer helps to build apex apps. You start designing your menu and items. Then load documents linked to input and output process and define what actions to accomplish in every item of menu. Finally run a draft of your application and get a report of tasks to do.
      tecnica24.es/apex/designer