drop in replacement for `go-sqlite3`

First, a big thank you for this project!

I am experimenting with replacing our use of go-sqlite3 and all of our interactions are directly through sqlx.

I am hoping you could help me understand a behavior difference I am seeing.

We have a few tables with MEDIUMBLBOB NOT NULL as type definitions sprinkled throughout. Our sqlx structs have this field as a []byte

In some instances we end up marshaling zero value byte slices. Never is the member a nil pointer.

with go-sqlite3 the not null constraint was still satisfied with these values, however with sqlite this constraint ends up being violated.

Now there is some question of the validity of these constraints, but I am trying more to understand the difference in behavior here as this may also appear in other similar situations.

Thanks for the help, once I have some space I will try and make a simple example.