I’m writing to a SQLite database, and after 1000 rows it isn’t taking any more inserts. There is no error, the insert statement completes successfully but the row just gets swallowed. I also tried from a tool called SQLIte Studio and it’s the same.
If i delete a row, I can then insert one but no more. There’s rowid as primary key and a couple other columns.
Okay this will be lame. The button that shows “next page of rows” wasn’t visible in SQLite studio. All the bazillion rows after the 1000 are there on next pages.