Core-Magma, a functional webapp framework

It's an Intranet, no it's an Extranet, better yet, it's a Ghost-capable Intranet/Extranet/Internet 5gl framework that can turn any database into a productive web system in minutes.

Core-Magma© / DB-UI©

A PHP library-framework built through the years to propel Intranet/Extranet and Internet/Ghosted website development in a safe fashion.

Its reunites a number of classes which we abuse, and a modular Web application system supporting multi-lingual interfaces through a CMS system, SEO optimization with a URI engine and many more nifty features. This website, for example, is built using Core.

Core includes a number of built-in modules meant to kick-start most of the website building work; a proven & secure Filemanager, OWASP compliant User administration, down-to-earth secure mechanisms for password recovery, built-in cryptographic storage engines, a secure multi-server session (which does not require any server synchronisation), an integrated tinyMCE content editor, and many more optional features.

How does it work?

Pick a template to start with, or import your own data structure

Let the system auto-magically design your base Intranet, start using it right away

Use, modify, tune and adjust everything you see; renderings, lists, queries, logic, interfaces, languages, text, images and much more using an intuitive use-&-design wysiwyg framework

June 2020; we now have a documentation index, and a development blog keeping track of new features

What does it do?

It starts by rendering a skeleton of an Intranet site by analyzing your data structure

It then corrects your data structure (using basic DBMS relation logic) and establishes a number of interfaces to access your data, as a DBA you'll appreciate the error-checking the engine does for you

It offers multi-lingual user interfaces for everything you do, up to you to select which languages you wish to support, and it can operate on EDI-X structured data as well

It can turn any database or web administrator into a God ! (And make you super-rich!)

What type of data can it manage?

From the start, anything that MySQL, MariaDB, Oracle, PostgreSQL can hold, Core-Magma can reverse-engineer and render

Within the web-application space, your DBMS fields are converted to HTML form objects; string, numeric, date, time, incremental IDs, dropdown, radios, checkboxes, grab-bags, files, folders, pictures, colors, icons and so much more.

Relational data, with 1-to-N, N-to-N or 1-to-1 relations, the system will understand an N-to-N and derive the necessary 1-to-N tables and logic to integrate them

Streamed data, launch service Bots to consume and process incoming stream data, be it trickling rivers or raging torrents.

File data, upload, manage, virus-check, organize, replicate, shard and distribute files from your application, the system will automatically generate extra tables to handle the uploading, security and classification of files

Images, which can be handled as slideshows when presented in views

Calendar-based data, organize sales, tickets, timesheets, reservations, anything really around an intuitive calendar view

Invoices, (upcoming feature), a way to organize data in invoice formats so end-users can "build & review" generated invoices

Any structure you can imagine (so far...)

What can you do with it? Business-wise ?

For starters, you can use it personally to manage your own database, be it sales, customers, projects, whatever the data you need to organize and manage, Core-Magma can render and manage it for you.

You can manage your own company users, or start selling "ghosted" versions of your own web-database system to customers of yours (as a bonus we provide facilities for your own invoicing of customers)

Sell access to your personally-managed web-database application and become a SaaS provider yourself

Use the system itself as an investigative tool to load, correct, analyse and review (potentially huge!) data structures

Security in built web applications

Core-Magma is built using the strongest security foundation possible.

Built to run under OpenBSD, the safest Operating System, in bare-metal mode.

Includes very strong cryptographic tools in its inner-workings to provide app-designers with the power to cipher data-at-rest using Sodium, OpenSSL and/or PGP and a public key infrastructure.

Support for asymmetrical and symmetrical keying mechanisms (we implemented a PKI-mechanism under Sodium, OpenSSL -and- PGP)

Strong hashed passwords using Argon2 at a minimum using exploit-resistant crypto routines.

OWASP-certified user management, users can change their own passwords using a standard and certifiable methodology.

Server-less and Ciphered Session management, users must login to access any protected web interfaces, and the system maintains cryptographic sessions that cannot be tampered with.

Core-Magma has been built by expert security programmers, built to be security-certifiable under all the current and future authorities; OWA, NIST, SOC, HIPAA, ISO 2700x

Audited codebase using the latest in vulnerability scanning techniques, Core-Magma is maintained exploit-free since day-1.

Inside the web applications (Intranet & Extranets), group-based permissions can be managed to distribute fine-grained access to particular users

In addition to group-based security, 3 different User Access levels can be assigned to users, optionally on a per-module level as well

Assign the privilege of UX-editing to specific users yourself, or reserve yourself the privileges to modify the webapp interfaces and presentations

Extras and paraphernalia

A web application framework wouldn't be complete with some support elements that keeps it running, and integration points for the most expert programmers.

Core-Magma is built to run & execute on a cluster of bare-metal servers (old school baby!), or it can be deployed on Virtual instances (do read our warnings about this though).

Thanks to our internal integration of Tlaloc, it scales horizontally without any worries. (It also scales on the X,Y & Z-axis, if you want to get technical about it.)

Because Core-Magma has evolved over more than 20 years, its a very solid piece of programming. Refined like old wine, it comes with a host of innovative features not found anywhere else.

Modularity and portability, as a backend programmer you can design your own modules and export them on our module community shares, importing a module is as easy as copying & dropping a folder.

Built for massive online presence, with well-designed components and practically no bottlenecks.

Bear eats Bear, you can also use our framework to run, deploy & maintain a cluster of servers, services or instances. (Current limitations being that our system cannot manage Windows bare-metal servers).

Deploy integrated File Servers using Samba and/or SSH

Manage your own Search Engine Optimization (SEO) campaigns, slurp Internet sites into your webapp and manage their content through our own Content Management System (CMS)

Deploy and integrate a full stack of Customer Relationship Management tools (CRM); auto-responders, mailings, doorway pages, personalized or promotional URIs (PURL), pixel counters, URI shorteners, and more.

Integrate a business-class Message Queue service at your enterprise-level (also known as a Service Bus in Microsoft lingo nowadays)

Tlaloc©

A PHP automation engine that includes a System Configuration manager for farm/clustering on baremetal and virtual nodes, a monitoring system and a job-scheduling suite.

Most of the backend automation related to this website is done using Tlaloc. New customers are deployed using Tlaloc, services are maintained and redundancy implemented all through Tlaloc.

Tlaloc is also a proof of concept for push-pull server configuration theory, idempotent, and introduces the concept of tri-state boolean result evaluations.

Tlaloc's documentation can be found under http://tlaloc.cryptochocolate.com (work in progress still...)

DB-UI©

My oldest and most complicated piece of programming. My first real-world application was a 4GL application built on Oracle PSQL. And since then I've been piqued by the concept and rebuilt it in different languages (Oracle, Perl, ASP, PHP). This last iteration, being a more modern version running under PHP 7.2 is the creamiest of all. It allows to directly map database tables and/or queries to web interfaces which are then generated within the Core web application framework. It's meant to reproduce known 4GL environments like Filemaker&tm;, Access&tm; and others which allow you to directly edit interfaces as you're working the GUI, directly.

The system is also dual-minded, not only can someone generate web interfaces from a database, but it can also bind the database objects through a new javascript client that intercepts a proprietary <CMS /> tag.

It's very flexible in that it allows web developers to rapidly prototype web pages and interfaces, while still offering the ability to replace chunks of 4GL code with custom coding. Developers can also include 4GL components in their own programming, and automatically gain the additional features while editing the GUI directly.

Bots

Our automated system now includes a Bot framework!

Bots can now be managed from the administrative GUI, paused, launched, deployed and configured.

Bots are part of a new framework we're developing at Kopel for automating our daily work, and we're extending their functionality to Core-Magma for managing internal automation.

For more information on our Bot and Automation framework, consult CryptoChocolate.com

componentology.com

Our implementation for moderately expert users of all of the above under a Cloud Software Service model.

We're currently in the works on opening registration and account setups (as of May 2020)

aTrAK.io

Another implementation of all of the above, this time for users without much experience in db handling, this version simply does a lot more for the users and has a bit more constraints built-in.

This cloud software service comes with a lot more focus on digital and physical marketing. Its roadmap targets a close integration with first-class providers, with a current geo-focus on Canadian markets.