• how to interface sqlite3.dll

    From Sanjay Minni@21:1/5 to All on Sat Apr 17 10:00:29 2021
    Hi

    i have a minimal basic requirement so if possible want to directly interface dolphin7 (7.1.20) to sqlite3.dll (32 bit) (3.35.4) https://sqlite.org/2021/sqlite-dll-win32-x86-3350400.zip
    and read / write sqlite database files

    dont need ODBC ORM etc.

    is directly interfacing dolphin7 to sqlite3.dll and using doable and
    can someone pls guide to on going about using sqlite3.dll with Dolphin7

    Sanjay

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From vinref@gmail.com@21:1/5 to Sanjay Minni on Sat Apr 17 21:02:10 2021
    On Sunday, 18 April 2021 at 03:00:31 UTC+10, Sanjay Minni wrote:
    Hi

    i have a minimal basic requirement so if possible want to directly interface dolphin7 (7.1.20) to sqlite3.dll (32 bit) (3.35.4) https://sqlite.org/2021/sqlite-dll-win32-x86-3350400.zip
    and read / write sqlite database files

    dont need ODBC ORM etc.

    is directly interfacing dolphin7 to sqlite3.dll and using doable and
    can someone pls guide to on going about using sqlite3.dll with Dolphin7

    Sanjay

    I have had some experiments with talking to various DLLs and it is straightforward. The help file that comes with Dolphin is perfectly adequately to get started. Looking at other examples as a guide is very helpful. The most recently-created one that I
    had looked at is BCryptLibrary. You can clearly see the form of the method calls in that one.

    I was planning to port https://github.com/pharo-rdbms/Pharo-SQLite3 to Dolphin, or at least use it as a guide, when I had the time. Maybe I can contribute if someone else can get it going.

    Vince

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Sanjay Minni@21:1/5 to vin...@gmail.com on Sat Apr 17 21:25:08 2021
    Thanks Vince,

    I think John Aspinall in this group was working on this - i.e. SQLite native driver - you find it in this thread in which you are also there
    https://groups.google.com/g/comp.lang.smalltalk.dolphin/c/KLrUwQCOlgk

    But coming back, can you point me to the help file sections i need to follow for Dolphin to talk to a dll. (I not much into internal type of stuff).
    also the tools may have changed so do i have to use COM Component Wizard ?

    I want to avoid registering sqlite3.dll as it will be deployed and i dont want to touch users registry entries

    Sanjay





    On Sunday, 18 April, 2021 at 9:32:11 am UTC+5:30, vin...@gmail.com wrote:
    On Sunday, 18 April 2021 at 03:00:31 UTC+10, Sanjay Minni wrote:
    Hi

    i have a minimal basic requirement so if possible want to directly interface
    dolphin7 (7.1.20) to sqlite3.dll (32 bit) (3.35.4) https://sqlite.org/2021/sqlite-dll-win32-x86-3350400.zip
    and read / write sqlite database files

    dont need ODBC ORM etc.

    is directly interfacing dolphin7 to sqlite3.dll and using doable and
    can someone pls guide to on going about using sqlite3.dll with Dolphin7

    Sanjay
    I have had some experiments with talking to various DLLs and it is straightforward. The help file that comes with Dolphin is perfectly adequately to get started. Looking at other examples as a guide is very helpful. The most recently-created one that I
    had looked at is BCryptLibrary. You can clearly see the form of the method calls in that one.

    I was planning to port https://github.com/pharo-rdbms/Pharo-SQLite3 to Dolphin, or at least use it as a guide, when I had the time. Maybe I can contribute if someone else can get it going.

    Vince

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Sanjay Minni@21:1/5 to Sanjay Minni on Sat Apr 17 21:37:48 2021
    Vince

    OK Found the classes incl BCryptLibrary under ExternalLibrary.

    What Do I have to do with the external DLL and the beginning / preparatory steps is what I am looking for in the help file

    Sanjay

    On Sunday, 18 April, 2021 at 9:55:09 am UTC+5:30, Sanjay Minni wrote:
    Thanks Vince,

    I think John Aspinall in this group was working on this - i.e. SQLite native driver - you find it in this thread in which you are also there
    https://groups.google.com/g/comp.lang.smalltalk.dolphin/c/KLrUwQCOlgk

    But coming back, can you point me to the help file sections i need to follow for Dolphin to talk to a dll. (I not much into internal type of stuff).
    also the tools may have changed so do i have to use COM Component Wizard ?

    I want to avoid registering sqlite3.dll as it will be deployed and i dont want to touch users registry entries

    Sanjay
    On Sunday, 18 April, 2021 at 9:32:11 am UTC+5:30, vin...@gmail.com wrote:
    On Sunday, 18 April 2021 at 03:00:31 UTC+10, Sanjay Minni wrote:
    Hi

    i have a minimal basic requirement so if possible want to directly interface
    dolphin7 (7.1.20) to sqlite3.dll (32 bit) (3.35.4) https://sqlite.org/2021/sqlite-dll-win32-x86-3350400.zip
    and read / write sqlite database files

    dont need ODBC ORM etc.

    is directly interfacing dolphin7 to sqlite3.dll and using doable and
    can someone pls guide to on going about using sqlite3.dll with Dolphin7

    Sanjay
    I have had some experiments with talking to various DLLs and it is straightforward. The help file that comes with Dolphin is perfectly adequately to get started. Looking at other examples as a guide is very helpful. The most recently-created one that
    I had looked at is BCryptLibrary. You can clearly see the form of the method calls in that one.

    I was planning to port https://github.com/pharo-rdbms/Pharo-SQLite3 to Dolphin, or at least use it as a guide, when I had the time. Maybe I can contribute if someone else can get it going.

    Vince

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From vinref@gmail.com@21:1/5 to Sanjay Minni on Sat Apr 17 21:53:50 2021
    On Sunday, 18 April 2021 at 14:37:49 UTC+10, Sanjay Minni wrote:
    Vince

    OK Found the classes incl BCryptLibrary under ExternalLibrary.

    What Do I have to do with the external DLL and the beginning / preparatory steps is what I am looking for in the help file

    Sanjay
    On Sunday, 18 April, 2021 at 9:55:09 am UTC+5:30, Sanjay Minni wrote:
    Thanks Vince,

    I think John Aspinall in this group was working on this - i.e. SQLite native driver - you find it in this thread in which you are also there
    https://groups.google.com/g/comp.lang.smalltalk.dolphin/c/KLrUwQCOlgk

    But coming back, can you point me to the help file sections i need to follow for Dolphin to talk to a dll. (I not much into internal type of stuff).
    also the tools may have changed so do i have to use COM Component Wizard ?

    I want to avoid registering sqlite3.dll as it will be deployed and i dont want to touch users registry entries

    Sanjay

    The relevant chapter in the help file is Programming Cookbook > External Interfacing.

    You won't be using the COM code generator (which is itself a great tool!). Just read that chapter and look at BCryptLibrary as an example on how it is implemented.

    Try for yourself by calling something simple like the beep method (https://docs.microsoft.com/en-us/windows/win32/api/utilapiset/nf-utilapiset-beep). There are lots of stuff in Win32 that you can experiment with. It is far easier than you might imagine.
    The Microsoft docs are pretty good in this regard.

    Good luck and keep Smalltalking.

    Vince

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)