Yes, all relevant NIPs are supported.

The maximum size of a SQLite database depends on the size of your server — hundreds of gigabytes should be possible (though probably not recommended. You can always switch to PostgreSQL)