How to compile sqlite.c

[acreis]

Good Morning, afternoon, evening,

Is it possible to compile sqlite.c then get sqlite.dll ?

Using purebasic "c", of course. In the past I've done it with pelles c, but I'm too old to try it again.

If possible, how?

Thanks in advance

[infratec]

You can download the dll from here if you want the latest version:

https://sqlite.org/download.html

https://sqlite.org/2025/sqlite-dll-win-x64-3500400.zip
https://sqlite.org/2025/sqlite-dll-win-x86-3500400.zip

[skywalk]

If you have visual studio community edition, just run the nmake CMD from a "x64 Native Tools Command Prompt".
It will be in the win folder.
sqlite.org/howtocompile.html

[acreis]

Thanks Infratec, Skywalk,

The public version of sqlite.dll doesn't meet my needs.

I have had taylored a very good 32 bit sqlite.dll to my needs 10 years ago.

Now I need update to 64 bits but I don't have time neither remeber the steps.

So I was thinking about a shortcut using purebasic, so I can take advantage of all hard work of Fred in using gcc to get exes and dlls.

My first attempt is changing sqlite.c prepending an exclamation mark to every line.

It seems the first problem is due to 'no include path to search ...'

I'll try to investigate this issue and post updates here

[acreis]

Update

I've found this sqlite x64 with encription and fts5:

https://github.com/utelle/SQLite3Multip ... s/releases

I think it will be ok for me

Thanks