The Unofficial Poster Child for Notes and Domino

    Feedback Appreciated - Integrating Domino, External Data, and Graphics Engines Like Google Charts and Dojo Charts

    Robert Baehr  July 13 2019 05:20:02 AM
    Greetings:


    I am seeking feedback on something that I have developed that will integrate Domino, external data (SQL, MySQL, etc.), and Google Charts.   And if Dojo Charts are your preference - don't worry, I am integrating those, too.  

    I call this project DYLYTHIUM.  It is running on Domino 10 (of course).

    The goal of DYLYTHIUM is simple - to allow you to enter a minimal amount of information and, without coding, generate charts and graphs for inclusion in Domino and non-Domino web applications.  Furthermore, these charts will be updated based on a time frame that you specify.   The results will include:
    • a link to the chart for web browser display.
    • embedded code so that the chart can be placed on a web page, even in a non-Domino front-end development environment.
    • dashboards containing a user-selectable grid of charts that can be displayed in a web browser.  Currently, a 4x4 grid is supported to keep the dashboard layout "readable".

    A simplified example is shown below:

    Let's say you have a database containing the popularity of South Park characters.   This data can be almost anywhere - in Domino, SQL Server, MySQL, etc.   This data will change, and, you want to make a chart that will update periodically and display the data in a friendly format to the user.   And... you don't want to take the time to "code" the chart - you want it now!

    For this example, you decide on a 2D Google Pie Chart.    You open DYLYTHIUM, and create a document, as shown below.  You provide the name, title, size, data source (Domino FT Query), whether you want a 2D or 3D chart, and the data you want displayed on the chart.  Note that we can connect to external data sources to retrieve the data as well (not just Domino).

    Image:Feedback Appreciated - Integrating Domino, External Data, and Graphics Engines Like Google Charts and Dojo Charts

    Once you save this document, a link to the following is generated for display in a browser.

    Image:Feedback Appreciated - Integrating Domino, External Data, and Graphics Engines Like Google Charts and Dojo Charts

    You will also get the embedded code which can be one-click copied, then pasted into virtually any front-end development environment.

    Other items of note:
    • The chart will update, in this example, every 10 seconds.   This will allow the page refresh to have near-time updates of the data.
    • Since the link/embedded code will reference the chart in Domino, the application containing the link/embedded code will update automatically.
    • If new data is added to the data source (for example, you add Kyle to the list of characters), he will be included on the chart at next refresh.
    • Currently supported Google Charts include line (smooth), line (straight), linear regression, column charts, gauges, pie charts (2D and 3D), among others.

    Would such an application be useful to the Domino Universe?  I'd appreciate any feedback on this concept, even if it is harsh criticism (I'm a big boy,,, I can take it).

    Thanks - and happy computing!

    Bob Baehr
    The Unofficial Poster Child for Notes and Domino