how to interface sqlite3.dll

[Sanjay Minni]

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

[vin...@gmail.com]

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

[Sanjay Minni]

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

[Sanjay Minni]

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

[vin...@gmail.com]

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