I’ve read the brief sqlite tutorial online. When I try to run the getversion() function in the included .js I get an error that sqlite.getversion is not a function.
It seems like specifying a column type in a CREATE statement has no real effect on the column type. For example I can specify as INT(1) and still store a string there. I’m mostly concerned with the maximum size of character data that can be stored in this mystery column type being used by sqlite.
I know it’s purposely undocumented/supported, but is there any info on this? Thanks.