SQLite? Where does it fit?

22

Currently using jFiles (21 TPS files in total)

!… for each file
SaveAsJson PROCEDURE(*FILE vTPS, *StringTheory vJson)

jf.Save(vTPS, vJson)

!… load json into typedQ)
CASE NAME(vTPS)
OF Trucks
IF oldMD5 <> newMD5
jf.Load (QTrucks, vJson)
END
OF RFID
IF oldMD5 <> newMD5
jf.Load(QRfid, vJson)
END
END

Each file has its own procedure for ETL and write the record to the SQLite table
!… loop thru queue and write to SQLite
Loop queue
write SQLite table
End

I tracked down the GPF - forgot to add OddJob global template (used in a class)

I wrote a simplified app where tWrite app reads TPS and writes to SQLite - while the tRead app simultaneously refreshes the browse against same table as READONLY

Getting closer - now I’ve upgraded to an Access Denied in the write app while tread is running

IMG_2786.jpeg4032×3024 2.01 MB

23

So I’m wondering if I can leverage the new Capesoft FileDriver to really cleanup / improve this process

ToQueue,FromQueue …

24

FromQueue - yes. But of course there’s to ToQueue for the Topspeed driver.
Not sure what zEventLog is - sounds like a file of yours? Perhaps triggered in a callback?

25

I have some space to experiment for a better solution

I’ll have my son purchase the SQL Diver Kit license to support your work forward (understanding the MIT license is available)

TY

26

Thanks Pratik ('s son)