Forum Home › Forums › New Ideas › about SCADA V6
- This topic has 22 replies, 5 voices, and was last updated 3 years, 8 months ago by Mikhail.
-
AuthorPosts
-
March 9, 2021 at 11:29 am #8452ZeusParticipant
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?March 9, 2021 at 2:02 pm #8460MikhailModeratorHi,
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.
March 9, 2021 at 2:20 pm #8461ZeusParticipanti 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.March 9, 2021 at 2:36 pm #8462ZeusParticipantwill 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.
March 10, 2021 at 5:11 am #8468JWParticipantI 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.
March 10, 2021 at 6:50 am #8469manjey73ParticipantSince the xml file is used to save the dat file data and transfer copies, the system itself works with the dat file
March 10, 2021 at 8:12 am #8470ZeusParticipanthi 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.March 10, 2021 at 8:21 am #8471ZeusParticipantif 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
March 10, 2021 at 11:36 am #8474MikhailModeratorHi,
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.
March 10, 2021 at 11:37 am #8475MikhailModeratori 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?
March 10, 2021 at 11:38 am #8476MikhailModeratori have done much work on rapid scada.
i really love it.Appreciated 🙂
March 10, 2021 at 11:40 am #8477MikhailModeratorMay be there should be a tool to export a project to RDBMS. This would be very useful for complex systems and different integrations.
March 11, 2021 at 2:21 am #8486ZeusParticipanthi 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?March 11, 2021 at 2:28 pm #8492MikhailModeratorHis 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.March 29, 2021 at 6:18 am #8583zzzParticipantHowever, 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. -
AuthorPosts
- You must be logged in to reply to this topic.