Ok, I forgot, it's a distributed system. There are up to 30 modules running on a bus (firewire) and have to know each others parameters (sql query?) There are configuration tools running on PC's, connected over Ethernet, which might want to change parameters (in the running system). The same time there might be additional PCs connected over additional interfaces (CAN?, Ethercat?) and parametrise ether. They are not all equal modules on the bus so one modul might have to find out (list) which parameters are possible.
I agree, that this is not neccessary a database application. But we need a query language for all the different parameter cients, so why not use sql? We need a permanent storage for all the parameters (to keep them after poweron), so why not write them into a database? Up to that point sqlite is ideal. But - we have to write some of the parameters to the hardware, too. This could be done with Triggers. And now the question: >> Among the whole paramitration there are some "parameters" which are >> actually reads to specific hardware addresses. The idea is to summerize all parametrisation under a common and well documented and well tested interface: "sql". We did not decide to move that way, yet. It's just to have a look into that direction. >If these values are to be read directly from the hardware, why involve >the database at all? Why not simply have your application code read >them directly, instead of trying to figure out a way for the database >to do it? This is for sure a more simple way to do it, if you look to the hardware side only. But than we have to implement "some" query language. Of course, you could say "sql is to powerful anyway" and might be right. But if I could ask a module "give me a list of measurment cannel which are connected to CAN and have a thermo element connected" or "Reset Maximum Value to Zero for all synchronous channels" this would be hard in a "self implemented" query language and easy in sql. Hottinger Baldwin Messtechnik GmbH, Im Tiefen See 45, 64293 Darmstadt, Germany | www.hbm.com Registered as GmbH (German limited liability corporation) in the commercial register at the local court of Darmstadt, HRB 1147 Company domiciled in Darmstadt | CEO: Andreas Huellhorst | Chairman of the board: James Charles Webster Als Gesellschaft mit beschraenkter Haftung eingetragen im Handelsregister des Amtsgerichts Darmstadt unter HRB 1147 Sitz der Gesellschaft: Darmstadt | Geschaeftsfuehrung: Andreas Huellhorst | Aufsichtsratsvorsitzender: James Charles Webster The information in this email is confidential. It is intended solely for the addressee. If you are not the intended recipient, please let me know and delete this email. Die in dieser E-Mail enthaltene Information ist vertraulich und lediglich fur den Empfaenger bestimmt. Sollten Sie nicht der eigentliche Empfaenger sein, informieren Sie mich bitte kurz und loeschen diese E-Mail. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
