about SCADA V6

Forum Home Forums New Ideas about SCADA V6

Tagged: ,

Viewing 15 posts - 1 through 15 (of 23 total)
  • Author
    Posts
  • #8452
    Zeus
    Participant

    hi Mikhail
    i am curious about the road map of scada v6.
    will you use vue.js in the furture?
    will all tools build by web instead of winform?

    #8460
    Mikhail
    Moderator

    Hi,

    Long story short, we will upgrade configuration database and archives. Also we will move to modern .NET5. I can share a road map file in Russian if you could automatically translate it for yourself.

    will you use vue.js in the furture?

    We will use Razor Pages instead of WebForms for the web part of the software.

    will all tools build by web instead of winform?

    I would like to do that but it requires too many man-hours. In the 6th version we focus on configuration database, archives and app engines. There are no obstacles to implement a web-based interface for configuration in the future.

    #8461
    Zeus
    Participant

    i have a friend he could translate it for me. will you send the file.
    the .Net6 is coming and Blazor is a way to build web app.
    i use vue.js a lot. i think i will translate the razor page into vue.js if i have time.
    i used to use razor. it is not confotable and low efficiency for me.

    #8462
    Zeus
    Participant

    will all configuration file save in database such as sqlserver mysql oracle and so on. it is not convient to handle xml files. especially in eneity mapping.

    #8468
    JW
    Participant

    I am kind of love and hate the xml file.

    Pros:
    To modify multiple channels, it can be done with text editor supports regular expression on any pc. I have been modifying the InCnl.xml in text editor more than the administrator app.
    User may need to build many projects, or modify a project many times.

    Cons:
    But when other programs need to read data from the InCnl.xml, it’s so slow, for the InCnl.xml with 10k channels, may take more than 10s.
    I found a work around is to read the InCnl.dat, which takes 1-2s, not ideal but acceptable.

    Saving config file in DB is easier to read but less continent to modify, in my opinion.

    #8469
    manjey73
    Participant

    Since the xml file is used to save the dat file data and transfer copies, the system itself works with the dat file

    #8470
    Zeus
    Participant

    hi manjey73
    i know about it.
    when you try to do some job such as data analysis or bussiness intelligence.
    you have to build device mapping line mapping and cnl mapping in you own system.
    the xml file is in different project.
    is not a good way to handle xml file.
    but if i have config saved in database.
    it is convinent to use ORM read all relationships of the running project.
    i have done much work on rapid scada.
    i really love it.

    #8471
    Zeus
    Participant

    if the V6 is still saved in xml file. i am going to write a vue.js project to handle all config file and save them in my own db by .Net5 backend

    #8474
    Mikhail
    Moderator

    Hi,

    What’s new in v6 (in Russian).

    Projects will be saved in XML as it is currently. This is very convenient in order to control changes using GIT.

    However, I know one guy ported configuration database to PostgreSQL and integrated it with the existing Agent service to upload projects to Rapid SCADA runtime.

    the .Net6 is coming

    When it is released, Rapid SCADA will be targeted to it.

    #8475
    Mikhail
    Moderator

    i am going to write a vue.js project to handle all config file and save them in my own db by .Net5 backend

    What DBMS will you choose?

    #8476
    Mikhail
    Moderator

    i have done much work on rapid scada.
    i really love it.

    Appreciated 🙂

    #8477
    Mikhail
    Moderator

    May be there should be a tool to export a project to RDBMS. This would be very useful for complex systems and different integrations.

    #8486
    Zeus
    Participant

    hi Mikhail
    the DBMS i will choose sqlserver.

    However, I know one guy ported configuration database to PostgreSQL and inte
    grated it with the existing Agent service to upload projects to Rapid SCADA
    runtime.

    could you give me the url of this project?
    i have write some kpdrivers moddrivers. how can i put it on website and sell it?

    #8492
    Mikhail
    Moderator

    His email is below this article.

    i have write some kpdrivers moddrivers. how can i put it on website and sell it?

    Are they ready for other users? I mean tested and contain manual?
    Could you provide description of the modules?
    It’s possible to publish them to the repository after some validating. Please create new topics to discuss the modules. It’s better, a topic for each module.

    #8583
    zzz
    Participant

    However, I know one guy ported configuration database to PostgreSQL and integrated it with the existing Agent service to upload projects to Rapid SCADA runtime.

    That sounds very helpful, especially for data analysis in my project.
    I’ve seen SQL script in the repositories for schema initalization.
    Many python Flask projects do so. It’t not at uncommon.

    It seems a trend that many enterprise choose to employ BI system for business logic analysis and process optimization. They cost a lot and are more powerful.
    External RDBMS will make it so easy to integrate with existing project.
    The dat files are very efficient in performance, xml files are [fill in strong points here, I really can’t think of much], but they can’t be used with existing platforms.

    Another advantage, it’s much easier to manipulate in batch and validate with manual sql queries. In my current proejct, manually creating all the channels, lines, in the UI, is very tedious. Though they come in groups and share many similarity. Writing scripts to manipulate XML & validate relations directly, is much more work than doing it in a RDBMS workbanch tool.

    Maybe SQLite could be a portable local choice? I have a WinCE handheld project communicating with remote SQLServer and use local SQLite as config/info cache storage. The CRUD operations are identical. I am not familiar with C#4+. The desktop RDBMS driver can only do better I suppose.

    Pros:
    To modify multiple channels, it can be done with text editor supports regular expression on any pc. I have been modifying the InCnl.xml in text editor more than the administrator app.
    User may need to build many projects, or modify a project many times.

    If the config is a SQLite db, and you have a lightweighted RDBMS workbanch tool e.g. SQLWorkbanch/J. + SQLite driver. I bet you will list this as a Con point for XML.
    Plus it’s easier to search, validate data cross table with queries to ensure that they are consistent.

Viewing 15 posts - 1 through 15 (of 23 total)
  • You must be logged in to reply to this topic.