14 replies

I'm trying to import data from an sql

I'm trying to import data from an sql file trough the http api but getting

statement too long: SQLITE_TOOBIG

statement too long: SQLITE_TOOBIG

error. The whole sql file is 24mb and has one insert statement per line (each statement ends with a semicolon followed by a line break). The table has 13 columns I'm inserting into. The longer insert statement line is 751 byte. Are there any limitations for the D1 HTTP API I'm not aware of? Could this be a bug? Or I'm maybe doing something wrong?

Update: Problem was with quotes not been escaped. Escaped those by doubling them and the problem was solved!

Cloudflare Developers•16mo ago•

14 replies

naourass

I'm trying to import data from an sql

I'm trying to import data from an sql file trough the http api but getting

statement too long: SQLITE_TOOBIG

statement too long: SQLITE_TOOBIG

I'm trying to import data from an sql

Similar Threads

I'm trying to import data from an sql

Similar Threads

Similar Threads

Similar Threads