Set a field to null

[jghauser]

Is there a way of using update to set a field to null? When I set the value to nil then it's not passed on to sqlite at all (because lua considers that key-value pair as inexistent). When i set it to null, I just get the string "null" (or an error if the type isn't string). Thanks!

[kkharji]

Oh that's a tricky use case I did not consider, or might've but overlooked the usage of null as removing something 🤔. I don't think it's possible with high level api. You would need to use sqlite.db methods, like sqlite.db:eval or sqlite.db:execute.

If you can update the whole row, then it might work.

[jghauser]

Thanks for the quick reply! I'll go with the db methods then :)

[jghauser]

@kkharji, I just wanted to say thanks for all the support. I've now published papis.nvim which wouldn't have been possible without all your effort!