About LuaSQL, SQLite3, FireBird and ODBC

[jhernancanom]

Hello, friends.

This message is for the team in charge of LuaSQL, specifically SQLite3, FireBird and ODBC connection.

I am interested in make tests to LuaSQL using SQLite3 and FireBird, and ODBC for the same both.

I would like you to guide me.

For starting I would like you to provide me with the respective LuaSQL DLLs for Lua v5.3.2 and/or Lua v5.3.3.

Thanks, friends.

HERNAN CANO M Systems Analyst - Programmer

[blumf]

The problem here is that it's not really practical to provide DLLs separate from whatever project produced the Lua EXE. You need to build all these things in the same environment or you end up with incompatibilities, some of which may be subtle and go unnoticed until it's too late.

You'll probably be better off learning how to build it all from source yourself. It's not that hard, but involves pulling together all the dependencies. At least that way you can experiment with unreleased features.

[jhernancanom]

Sorry, friend.

... it's not really practical to provide DLLs separate from whatever project produced the Lua EXE.

I never have done, nor will do, 'produce the Lua.exe': I only downloaded from original portal (It seems you do not know where are the Lua versions; they are here http://luabinaries.sourceforge.net/ http://luabinaries.sourceforge.net/, and also from http://webserver2.tecgraf.puc-rio.br/iup/ http://webserver2.tecgraf.puc-rio.br/iup/)

((and as I am not en expert, I'll say the following)) I think to understand that when you say "whatever project" you mean "every utility that any one put in Internet (or in his/her own company where every one works) for people can use". If that is so, I agree with you....

Buy my scenario it is not that way. My scenario is: I download "Lua Binaries" since the standard portal and use them with several other utilities.

Then --that way-- the Lua.Exe that I am using ((and many other people ---¿¿¿¿or not?????---)) is the same that what any one can find there.

I consider that I can find a LuaSQL-ODBC.DLL that can RUN with Lua v5.1... but there are other versions: v5.2 and v5.3..... but LuaSQL-ODBC.DLL (or LuaSQL-SQLite3.DLL) do not run with these two versions (do the same .DLL that I can use for v5.1 must run also with v5.2 or v5.3? or --if it do not run-- it indicates a problem in my Win7 machine?).

If you are using Lua as your main language, why don't put a .DLL that can RUN with v5.2 and v5.3 (or two different that run with each one)? That way when I update my Lua v5.1 to v5.2 (or v5.3), I (and any other) can download a LuaSQL-ODBC.DLL (or LuaSQL-SQLite3.DLL) that can run with the updated version of Lua.

Said in another way: You do not need to get a LuaSQL-ODBC.DLL for "every project in Lua developed in the world"....You only need to get a LuaSQL-ODBC.DLL for every version of Lua.exe....

Said in another way: You only need to get three LuaSQL-ODBC.DLLs: one for Lua v5.1, another for Lua v5.2, and another for Lua v5.3.

Just three..... and put them in the download-pages I wrote before... Are you pleasant with the decrease of the quantity?

And I consider that when me (or any other) want to update the version only have to download the .DLLs for Lua and for LuaSQL-ODBC (or LuaSQL-SQLite3 or any) that he/she wants.....

...You need to build all these things in the same environment...

Yes!!! Although I do not consider it the optimal solution, I want to try it..... I have tried it..... But the instructions do not run effectively.

In the doc you say that we need LuaRocks to "install" LuaSQL.... But then we need to install this thing... and it do not run when the utility I want needs a "dependency".... (I discover it when I try to "install" Alien)....

((LuaRocks is saying me an error about "wget does not found"))

If you could write me (or say me where can I find them) instructions that do run..... I'll try it.... basically for learning.... although the optimal scenario is that you provide me the .DLL for Lua v5.2 or v5.3 (or say me where can I find it).

... or you end up with incompatibilities..., some of which may be subtle and go unnoticed until it's too late.

Ehhh... well.... ... I.... ehhhh.... then...... A big problem.... well..... INSTRUCTIONS!!!!!!!!!!!!!!11 Then some good instructions are necessary.......

Can you provide me some more instructions for building/compiling LuaSQL? For now I need ODBC, SQLite and FireBird. I can start with one of the first two.

((as an anecdote, I tell you that the first time I see LuaJIT it only have C-source files. I also find a .BAT; I read it and understand it.... and ---since my explorer--- I click on it..... LuaJIT.exe was compiled and it only take some 20 (twenty) seconds.... Only twenty seconds!!!! And it runs well until now.... I tried the same with Alien.....FFI... wxLua... LuaCOM... XLSXwriter.... the first two forced me to use LuaRocks, but it only shows errs... the second -and last- is very complex and the compiling has many steps...))

......((building yourself)) ... but involves pulling together all the dependencies. At least that way you can experiment with unreleased features.

I do not need 'unreleased features'; I only need to use Lua effectively...

+++++++++++++++++++++++++++++++++++++++++++++++++++ +++++++++++++++++++++++++++++++++++++++++++++++++++

I am thinking... If I write a Payroll application in Lua in my Windows 7 PC, do I need to build/compile Lua.exe/Lua.dll/LuaSQL/LuaSQLite/SQLite/Widgets/wxLua for every one of the PCs of the customer that buys me this app? I learn about LuaSQL, but it can only use it in Lua v5.1. If I want to update Lua to v5.2 or v5.3, I cannot use LuaSQL, because the .DLL of LuaSQL that I have runs only in v5.1.

+++++++++++++++++++++++++++++++++++++++++++++++++++ +++++++++++++++++++++++++++++++++++++++++++++++++++

Thanks, friend.

2016-07-01 8:37 GMT-05:00 blumf:

The problem here is that it's not really practical to provide DLLs separate from whatever project produced the Lua EXE. You need to build all these things in the same environment or you end up with incompatibilities, some of which may be subtle and go unnoticed until it's too late.

You'll probably be better off learning how to build it all from source yourself. It's not that hard, but involves pulling together all the dependencies. At least that way you can experiment with unreleased features.

—