Thinking to save 1 million records

For historical data of financial products, can fibery store million records? Daily new 12000 records to be added once. Not much filtering or sorting will be done on UI. Mainly it will be for API fetch in another app.

Basically can we use Fibery for this, as replacement of nocode DB? Or need to spin up and maintain separate DB, e.g., Neon?

I wouldn’t recommend it. Fibery is not designed to be a highly-performant headless db.