Cannot save invoice: "Item must be less than 10 KB" about prinvoice HOT 3 OPEN

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 :)

from prinvoice.

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

from prinvoice.

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

from prinvoice.