Does not immediate saved into db?

[wildfiremedia]

I have a prepare statement that insert into table.

When I submitted 1st form submission, I could not find any row appear in my table, and test 2nd form submission, then I realised the 1st row will then appear but not the 2nd row that will only appear after the next form submission.

Why is this a weird behaviour or a bug?

[wildfiremedia]

Testing out better-sqlite3, it did immediately add new row into the table. I think there is a critical bug in libSQL that should be fix.

The tested packages:

"better-sqlite3": "^11.7.0",
"@types/better-sqlite3": "^7.6.12",
"libsql": "^0.5.0-pre.5"