Max sqlite primary key length

Question

I need to index a table by a string that can be pretty long (from 50 to 2000 chars aprox).

Is there a limit for the length of the sqlite's primary keys?

Answer 1

The maximum number of bytes in the text of an SQL statement is limited to SQLITE_MAX_SQL_LENGTH which defaults to 1000000. You can redefine this limit to be as large as the smaller of SQLITE_MAX_LENGTH and 1073741824