Re: Basic SQLite Application
On Wednesday, 1 June 2022 at 15:40:43 UTC, harakim wrote: It's been a long time since I did any C development, and I have never done any on windows, but I thought I could statically link to the .lib at compile time and then I wouldn't need a dll. You sometimes can, it depends on how the library is built. If it was built as a dll, you need to use it that way unless you recompile the library itself.
Re: Basic SQLite Application
On Wednesday, 1 June 2022 at 15:58:01 UTC, Jesse Phillips wrote: On Wednesday, 1 June 2022 at 15:40:43 UTC, harakim wrote: It's been a long time since I did any C development, and I have never done any on windows, but I thought I could statically link to the .lib at compile time and then I wouldn't need a dll. I'm fine with using a dll, but I don't know how to get the corresponding .bin. I'm guessing there is just a c header file. Is this a case where I would need to make bindings? In this case this lib is the dynamic bindings to the dll. Thanks for that reply. That makes sense.
Re: Basic SQLite Application
On Wednesday, 1 June 2022 at 15:40:43 UTC, harakim wrote: It's been a long time since I did any C development, and I have never done any on windows, but I thought I could statically link to the .lib at compile time and then I wouldn't need a dll. I'm fine with using a dll, but I don't know how to get the corresponding .bin. I'm guessing there is just a c header file. Is this a case where I would need to make bindings? In this case this lib is the dynamic bindings to the dll.
Re: Basic SQLite Application
On Wednesday, 1 June 2022 at 10:57:11 UTC, Adam D Ruppe wrote: BTW: "copyFiles":["lib/sqlite3.lib"] You don't need that, the .lib is only used while building. You might need to copyFiles the .dll though. It's been a long time since I did any C development, and I have never done any on windows, but I thought I could statically link to the .lib at compile time and then I wouldn't need a dll. I'm fine with using a dll, but I don't know how to get the corresponding .bin. I'm guessing there is just a c header file. Is this a case where I would need to make bindings? As to the issue at hand, I found that bin linked from another dlang thread where someone was trying to get sqlite working. It linked to this repository: https://github.com/buggins/ddbc/tree/master/libs/win64 So when you said it might be the wrong dll, what I did is I grabbed the dll from there also and it worked. Thanks for your help once again.
Re: Basic SQLite Application
On Wednesday, 1 June 2022 at 03:46:38 UTC, harakim wrote: I started trying to get it to compile in another directory structure but since I've switched to dub It should work the way you have it, just with dub you can also the dub version instead of copying the files: https://code.dlang.org/packages/arsd-official%3Asqlite both are supposed to work. anyway it compiles and runs and returns some large negative number as an error without printing what's in the writeln. What is the number? My guess is you might have gotten the wrong sqlite3.dll (it should come from the same source as the .lib file you used) or it is in the wrong place. I won't rule out that my lib file is the wrong file as I don't know how to tell or find the right one. That's possible too but it would normally fail to link entirely if this was it. My money is on the dll, especially since the main() doesn't even try to open the database, it must be a loading issue. Where did you get the .lib file anyway? BTW: "copyFiles":["lib/sqlite3.lib"] You don't need that, the .lib is only used while building. You might need to copyFiles the .dll though.
Basic SQLite Application
I'm creating an application in D to do some purchase management
stuff and I ran into a snag pretty early on. I'm trying to use
sqlite via [this
library](https://github.com/adamdruppe/arsd/blob/master/sqlite.d).
I started trying to get it to compile in another directory
structure but since I've switched to dub and made a few tweaks,
it compiles and runs and returns some large negative number as an
error without printing what's in the writeln.
Here is my dub file:
```
{
"authors": [
"onesadman"
],
"dflags" : ["-m64"],
"copyright": "Copyright © 2022, onesadman",
"description": "Costco Purchase History",
"license": "proprietary",
"name": "cph",
"libs-windows": ["lib/sqlite3"],
"copyFiles":["lib/sqlite3.lib"]
}
```
Here is my program:
```
import std.stdio;
import arsd.sqlite;
void main()
{
writeln("Edit source/app.d to start your project.");
}
```
I also have database.d and sqlite.d in my source/arsd directory
and a lib folder with sqlite3.lib in it. It is successfully
copied to the root folder and I also copied sqlite3.dll from
c:\windows\sysWOW64\winsqlite3.dll into the root folder just in
case I was doing it wrong and that fixed it.
It seems I must be close as I have it compiling. I'm not sure
where it's going to look for the lib folder.
I have run it with dub and with dub build --arch=x86_64 and then
running the cph.exe directly.
I won't rule out that my lib file is the wrong file as I don't
know how to tell or find the right one.
