Q: Hello, how many databases can I connect?
As well as files? Or just one?
Thank you.
Josef
Leo_PartnerSupport
May 14, 2024A: Hi @I_am_Josef! Thanks for the questions!
You can actually connect as many databases as you want. From these databases, you create APIs by querying the database. Each API is equivalent to a "file" and files are capped on each tier as you can see.
Hopefully this information helps!
I_am_JosefHey, Leo,
we've been chatting, and I have to say, your customer service is phenomenal. Keep up the good work.
One more question, please. What size can the databases be?
In Tier 4 there is a limit of 750 files, so I can have 750 databases, am I understanding correctly?
But how big can these databases be? Do you limit them in size (100 megabytes, 1 gigabyte...) or e.g. on the number of tables, rows, columns? (750 000 rows as file?)
Thank you.
Josef
Hi @I_am_Josef! Thanks for your reply and kind words. :)
So the way databases and files work is as follows:
1. Connect your database(s). As many as you want
2. Create your API from a database(s) by providing a query such as "select * from user"
3. Now this API is treated as a "File". And all the restrictions that apply to files apply here.
So, for example, if you are on a plan that restricts rows per file to 150,000 and your query returns more rows than that, then it will give an error. And if you create more Files (database APIs) than your plan permits, you will need to upgrade. This is how we do the restriction for databases.
Hopefully this information helps!