Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Generic Database Driver - Beta
Yeh, it's on the tokenizer. I think it's documented in the 3.0 beta docs. Actually, there's a quoted comma list and a CSV. If you don't want all of them to have to be quoted, then CSV would be better probably.
Dean Roddey
Explorans limites defectum
Reply
Not sure if anyone's interested, but for those db guru's out there the ListBuilder driver http://www.charmedquark.com/vb_forum/sho...#post68844 supports the idea of using multiple custom queries to access db's. it stores it's configuration into a database so everything is completely stateful.

i originally created it to support pulling data out of db's into stringlists, but have since used it to keep CQC Var states in a db when CQC resets, pull data out of the DataLogDB driver db, manage a couple MyMovie interfaces by talking to the db directly, etc.
~~~ B01nk
Reply
Is there a place to set the refresh time of this driver? I didnt see a place to set that. i seem to be getting a 7 to 10 second refresh time but cpu usage is almost none so wanted to see if i could up the refresh time a little.
Rich
Reply
I think the poll time is hardcoded to one second for every "Select" statement that you want to monitor.
Reply
Currently, the driver auto updates every 5 seconds. i guess i could add the ability to configure the refresh rate dynamically if its critical.
~~~ B01nk
Reply
I realize it has been almost 6 years since there was a thread update about this driver, but I am curious if it is still functional on the current version of CQC? It sounds like a powerful way to access data that might not be otherwise available and I am looking at it to potentially resolve some Gem monitoring issues I am having. Just curious before I dive in if anyone is still currently using this or if there has been an update in the last 6 years?

Joe
Reply
yup. we're still using it with the latest version of CQC
~~~ B01nk
Reply
Awesome. Thanks! Are there any plans to make it an officially released driver in CQC?
Reply
Not at the moment. If we did that, it would probably be a deal where we redid it in C++ to maximized performance and flexibility.
Dean Roddey
Explorans limites defectum
Reply
Wow... I forgot all about this. Good to see it is getting some use. One of these days I will get back into the automation game... just no time/$ right now.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  RainMachine Sprinkler Irrigation Controller Driver kblagron 60 18,714 07-17-2022, 08:36 PM
Last Post: kblagron
  SmartThings API V1 driver kfly 5 668 02-22-2022, 07:55 AM
Last Post: kfly
  Tesla Driver Driver kfly 14 5,554 02-21-2022, 10:11 AM
Last Post: kfly
  Help on editing existing Driver Spot 5 563 02-03-2022, 06:50 PM
Last Post: kblagron
  New to driver development - where to start? jokermac 2 611 09-22-2021, 04:01 PM
Last Post: Spot
  Yamaha RX-V673 IP control Driver jdmevo123 22 11,296 03-27-2021, 03:02 PM
Last Post: Spot
  Updated SMS Driver gReatAutomation 0 649 01-28-2021, 12:53 PM
Last Post: gReatAutomation
  Sage Media Server driver (beta) Fonceur 698 343,341 07-26-2020, 04:59 PM
Last Post: sic0048
  Russound MCA-66 on TCP driver lapointe.sc@gmail.com 5 2,605 05-24-2020, 06:23 AM
Last Post: gReatAutomation
  Samsung SmartTV Driver George M 0 897 05-20-2020, 09:04 AM
Last Post: George M

Forum Jump:


Users browsing this thread: 1 Guest(s)