How do Web based Gantt Chart software store Project data?

Hello,

We are building a Gantt Chart and Project WBS web app software and currently at a design stage.

Question here is that how do other popular Gant chart app like Smartsheet, Wrike etc store Gantt chat data along with Project WBS data (tasks, resource, dates etc.) ?

I can't think that these apps stay connected to a relational database such as Oracle or MySQL for thousands of sessions.

Are these flat fiel based json databases in the backend with no relational databases at all?

Thank you,

Rich


1 Reply

AG Ajithkumar Gopalakrishnan Syncfusion Team June 24, 2024 01:55 PM UTC

Hi Ruch,

Greetings from Syncfusion Support.

Query 1:  Question here is that how do other popular Gant chart app like Smartsheet, Wrike etc store Gantt chat data along with Project WBS data (tasks, resource, dates etc.) ?

We have reviewed your query, but we regret to say that currently we don’t have support to achieve your requirement. We have already logged a feature request for the same and you can track the status of the feature from the feedback link given below.

Feedback link: https://www.syncfusion.com/feedback/6474/work-breakdown-structure-support-for-gantt

We have already lined up some major features, we could not implement this support immediately. We will implement this and include it in any of our upcoming releases. Please cast your vote on this feature. Based on the customer demand we will prioritize the features in our upcoming road map. We are closing this ticket. You can communicate with us or track the status of the feature using the feedback link.

Query 2:  I can't think that these apps stay connected to a relational database such as Oracle or MySQL for thousands of sessions.

To achieve your requirement, we suggest using self-referencing data binding in the Gantt chart. This binding method makes it easier to connect with the database because the data source structure can be easily updated in the database and then rendered properly in the Gantt chart. But we have updated sample in local dataSource. We have attached a code snippet and sample for your reference.

<ejs-gantt ref='gantt' id="GanttContainer"

           ...

           :taskFields="taskFields"

           >

</ejs-gantt>

taskFields: {

        id: 'TaskID',

        parentID:'ParentId'

        ...

},


Sample link:
https://stackblitz.com/edit/2v6oj4-ulfyep?file=src%2FApp.vue

If you have any further questions or need additional assistance, please let me know!

Regards,

Ajithkumar G


Loader.
Up arrow icon