Cannot save invoice: "Item must be less than 10 KB"

[wzulfikar]

When I try to save my invoice with several items (8 items to be precise), it says "Item must be less than 10 KB". I assume the 10 KB limit is the total size of all items (payload) that's being stored.

If that so, is it a UI-imposed limit or a limitation from Userbase itself?

Cheers!

[j-berman]

Good catch :)

That's imposed by Userbase, with some relevant notes:

1. The underlying items stored in Prinvoice are unnecessarily large because they have a ton of unnecessary whitespace. If you open up the dev console while you're creating an invoice, you'll see clean SQL statements with all that extra unnecessary whitespace. That whitespace could easily be trimmed, and items (and invoices) could therefore be much larger.

2. I could change userbase-sql.js a bit to store larger SQL statements as files, and that would work ok. I'm actually using this pattern in a new piece of software I'm working on that's using Userbase, I'll link to it here to show you how it can be done :)

[wzulfikar]

I see. Thanks for the explanation! Looking forward for the link so I can try it in my machine.

[j-berman]

Check this out:

• if an item exceeds the limit, I upload it as a file
• then when loading a database, I check if the item is stored as a file, then retrieve the file