drjdpowell

I think your second point is wrong; VIs without the front panel loaded don't use any resources.  EXEs don't even include the code for those front panels.  

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.

Note the WITHOUT ROWID keyword also, as that could make a significant performance improvement with this kind of table.

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

Why don't you just try it?  Open your SQLite viewer app if choice and execute "SELECT * FROM sqlite_schema"

You're looking for the sqlite-schema table: https://www.sqlite.org/schematab.html

8 hours ago, CT2DAC said:

Cannot install versions more recent than 1.13 with VIPM - error: unable to download from repository.

Do you have the latest version of vipm?

Yes, at some point I intend to make an interface that has "to JSON" and "from JSON" methods, that one can inherit from.  But at the moment JSONtext is based in LabVIEW 2017.

15 hours ago, X___ said:

Raised here: https://bitbucket.org/drjdpowell/jsontext/issues/103/what-to-do-about-complex-numbers

I will fix the inconsistance, either by making comlex numbers full not supported or fully supported. 

On 12/21/2023 at 10:45 PM, daenglis said:

How does JSONtext handle null strings?

Can you give a more specific question?

15 hours ago, Scatterplot said:

Is there any reason to NOT want this behavior, by the way? 

Not necessarily, but it is trickier than it looks because of those "multipoint paths" that unflatten does not support.  A path like $.a.[new,old].b[4].c.d, for example.  If all paths were straightforward like $.a.b.c.d then it would be easy.

Although I use JSON for configuration, I'm not using it in the same way you are doing, so it hasn't motivated me to solve this issue. Sorry.

See if "Unflatten JSONpath Array to Object" will do what you want.  It will create the extra levels if needed.

That vipm package seems to have gotten corrupted somehow.  I'll contact NI about it.  In the meantime, try getting it from here: https://forums.ni.com/t5/JDP-Science-Tools/Out-of-Memory-Error/m-p/4335019/highlight/true#M156

On 11/6/2023 at 1:31 PM, ciozi137 said:

@drjdpowell bumping this topic to see how best I can contribute to the postgres repo

 

Can you try forking the repo?  Then making a pull request?   I only have a free Bitbucket account and there is a limit on how many people I can add to my repos.

Compiled object cache is an SQLite database, I believe, so is suspect you can easily delete VIs from it.  Though you'd have to test that.

I'm afraid I don't have an example.  I did once prototype a version where I swapped out the flattened message format for one that used JSON (I recommend JSON as an easy, reliable format to go between languages).  

I use the "Advanced PNG Export" feature of https://pictogrammers.com/library/mdi/.  This allows some customisation of icon (size, colour, transparency, border) before downloading.

Why are you making Setting modules at all, rather than just having the other modules just read the INI file directly?   This seems very over complicated.

15 hours ago, Francois Aujard said:

I have loops that start but how to transfer the data without going through global variables or FGV.... 

Quite a lot of good architectures are based on using messages between semi-independent modules, with the modules being based on a standardized template.  There are a few such "frameworks" publicly available via vipm.io that you could look at.  Mine is "Messenger Library", which has some instructional videos.

I've long thought the Event API has bad naming.  If the Event Reg Refnum was called "Event Queue" and the User Event was called "Event Generator", then it would be easier for people to understand it.  

Maybe if you posted what device you are trying to talk to, and perhaps pointed to the manual, you might get better help. 

Did you do the Write?  It only outputs on Write. I am considering having the Read write the Template, as it is confusing to have an empty file untill the Write happens.

17 hours ago, Jordan Kuehn said:

I couldn't find the code repository entry for this library,

Here is the Issues lost: https://bitbucket.org/drjdpowell/pq-labview/issues?status=new&status=open

I am not actively working on this project, but it might be the case that the PQ dll used by the library needs updating.

Re the main issue, this seems to be my misunderstanding about how Savepoints work (as distinct from BEGIN and ROLLBACK).  Here is a relevant discussion. 

From that discussion, I see I should, instead of "ROLLBACK TO <Savepoint>" I should do "ROLLBACK TO <Savepoint>; RELEASE <Savepoint>;"  Issue 22

2 hours ago, mwebster said:

LabVIEW 2020.  Example.vi

As an aside, you should look into the Upsert clause, which allows doing INSERT or UPDATE in a single SQL statement.

Also, note that you don't need savepoints about a single transaction (all single statements are their own transaction, and either succeed or rollback automatically).