Got my feet wet with Node and sqlite and inserts

[pixlapps]

Created a node project, added custom hosting and let Wappler create defaults. Add a sqlite db and used a client to just add a record after adding a table and some fields using Wappler.

Created server action that just queries the table and get this error:

Also this in Terminal:

sqlite does not support inserting default values. Set the useNullAsDefault flag to hide this warning. (see docs http://knexjs.org/#Builder-insert).

Just queried, did not insert

Still part of the beta or am I doing something wrong?

[George]

Seem as something we should handle indeed @patrick

[deckchair]

Bumped into this aswell.

[deckchair]

I also note that it does not support the “alter column”. Which breaks running migrations.

[patrick]

I’ve added the useNullAsDefault option to the knex configuration, here the updated file, unzip it in lib/core.

app.zip (3.7 KB)

[patrick]

Please give some feedback about the update, does it fix your problem? I will set this topic to fixed-in-next-update and assume it is fixed when no feedback comes.

[Teodor]

Fixed in Wappler 3.7.1