Jump to content

drjdpowell

Members
  • Posts

    1,985
  • Joined

  • Last visited

  • Days Won

    183

Posts posted by drjdpowell

  1. I think this is teh same issue as this: https://forums.ni.com/t5/JDP-Science-Tools/Cannot-Install-JDP-Science-Common-Utilities/m-p/4418396#M205

    The SQLite package requires JDP Common Utilities, and that package seems to have a problem.   Workaround is to download it and have VIPM install it directly, rather than try and get it from the Tools Network servers (it's a server issue, not a problem with the package itself).  I'll attach it here as well.

    Try installing this and then retry installing SQLite.

     

    jdp_science_lib_common_utilities-1.4.1.18.vip

  2. I think this is a Windows touch-screen behaviour, due to Windows using press-and-hold to give a right click.  Windows waits for the release before sending "mouse down" so it can decide to make it a right click or not.  It's annoying but I have not found a way around this.

  3. A non-JSON option you could try is:

    CREATE TABLE TestData (
      Channel,
      Time, 
      Data,  -- individual reading at Time for Channel
      PRIMARY KEY (Channel,Time)
      ) WITHOUT ROWID

    This is every reading sorted by a Primary Key that is Channel+Time.  This makes looking up a specific channel in a specific Time Range fast.  

    BTW, you don't need to make an index on a Primary Key; there is already an implicit index . 

    You would select using something like:

    SELECT (Time/60)*60, Avg(Data) FROM TestData
       WHERE Channel=? 
       AND TIME BETWEEN ? AND 1717606846
       GROUP BY Time/60
    • Thanks 1
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.