Page 1 of 1

LUASQL - Not available in FH7

Posted: 04 Jan 2021 01:06
by shoshk
:(

Does anybody know why this has been taken out in FH7?

According to the KB, the version (2.2.1) which has been in use up to now does not work with FH7. That makes sense, since it doesn't work with lua 5.3.

But, there is a newer version (2.3.5) which does work with lua 5.3, so it should be possible to use in FH7.

If this isn't high on Calico Pie's list of priorities (understandable), is there a way to install it so that I can use it with FH7?

Re: LUASQL - Not available in FH7

Posted: 04 Jan 2021 07:33
by ColeValleyGirl
For private use, if you can find a distribution of luasqp 2.3.5 you could just drop the relevant files into C:\Program Files (x86)\Family Historian\Program\Lua

However, you'll probably need to compile it which means getting to grips with Lua Rocks...

Re: LUASQL - Not available in FH7

Posted: 04 Jan 2021 07:39
by shoshk
Lua Rocks it is. what's one more new technology to learn. :) Thank you.

Re: LUASQL - Not available in FH7

Posted: 04 Jan 2021 09:29
by ColeValleyGirl
Lua Rocks is a special snowflake... Drives me nuts. If you only need SQLlite outside the FH environment you might be better doing without the Lua library and running it standalone.

Re: LUASQL - Not available in FH7

Posted: 04 Jan 2021 09:51
by shoshk
I definitely need SQLite in the FH environment.

I started playing with Lua Rocks this morning. Sigh... You are right; it is a very special snowflake. It's currently waiting for a day when my mind is at its clearest.

Perhaps Calico Pie will release an update with the new version of luasql and I won't have to break my brain.

Re: LUASQL - Not available in FH7

Posted: 04 Jan 2021 10:06
by ColeValleyGirl
Have you raised a ticket for CP re the SWL library. Although they will sigh mightily as it needs to be compiled which makes it a bigger more complex task to include.

Re: LUASQL - Not available in FH7

Posted: 04 Jan 2021 10:09
by shoshk
Do you think that will actually make a difference? I understand why it would be rather low on their list of priorities.

Re: LUASQL - Not available in FH7

Posted: 04 Jan 2021 10:20
by ColeValleyGirl
I suspect they think nobody uses it (pretty sur eno published plugins do) so they do need to know differently.

Re: LUASQL - Not available in FH7

Posted: 04 Jan 2021 10:28
by shoshk
Ticket created

Re: LUASQL - Not available in FH7

Posted: 05 Jan 2021 17:12
by ColeValleyGirl
Shosh,

if you master Lua Rocks and achieve a working version of the library compiled for windows, detail of the necessary folder/file structure and a copy of the relevant dll(s) might speed things along.

Re: LUASQL - Not available in FH7

Posted: 05 Jan 2021 18:37
by shoshk
I got a reply from Calico Pie. They asked for a link to a version which works with lua 5.3, which I supplied. I replied with a link, they said thank you and closed the ticket. They said they would check it out, but obviously, didn't give a timeframe.

Meanwhile, I'm busy cleaning up place names in my husband's database. Among other things, he managed to create a bunch of duplicates, by adding a space to the end of places he was entering. He was using a phrase manager and didn't check the box to remove the terminating delimiter. Creative, no? He was so proud of himself for making his own phrase without my help. I guess I have to give him points for trying. ;)

Lua Rocks is definitely on my list of things to do. I'm not going to wait for Calico Pie. But, as you say, it's not an easy tech to get into. I've been doing this since the late 70's and have learned a lot of new stuff, but this definitely ranks up there with some of the most incomprehensible stuff I've learned.