Vincent Rischmann

I've ended up with an API for `filter` that's not too bad: ``` pub const FilterArg = struct { value: ?*c.sqlite3_value, pub fn as(self: FilterArg, comptime Type: type) Type {...

Still to do: * improve the tests * implement `xCreate` and `xDestroy` * add `connect`, `disconnect` called by `xConnect` and `xDisconnect` respectively * add an argument parser for args received...

Thanks ! I'll take a look at your links once I get back to working on building an extension.

The abiilty to build loadable extensions is part of #112 now. This PR will focus only on virtual tables.

I'm still not 100% sure when/how to use xCreate vs xConnect and xDestroy vs xDisconnect, I think I'll implement in another PR. The arguments are now parsed into a more...

I think this already works, it's tested [here](https://github.com/vrischmann/zig-sqlite/blob/master/sqlite.zig#L2344-L2350). i tested locally with spaces too and it works fine, sqlite already ignores whitespaces and comments. Do you have a test case...

I'm still not sure I understand the problem. Your test case fails for another reason, you're selecting from the table `b` which doesn't exist. This works fine: ```zig test "sqlite:...

You need to set the target and mode on the sqlite library too: ``` sqlite.setTarget(target); sqlite.setBuildMode(mode); ``` I'm not sure why it fails when not adding this. And yeah it...

Right, I accidentally executed the test with the file already existing so it passed. I already saw this error some time ago but found no way to resolve it. Building...

I did a little digging, the error `SQLITE_CANTOPEN` is ultimately due to a `lstat` call [here](https://github.com/sqlite/sqlite/blob/version-3.39.2/src/os_unix.c#L6475). For `/tmp/my1.db` there's two calls to this function and the last to `osLstat` returns...