Ask your MariaDB database what is going on in the business.
Connect a user that can only read, and ask about sales, stock or customers in plain words. Every answer comes with the query so you can follow the numbers.
You can connect MariaDB today.
What Adea reads from MariaDB
- Tables and views you allow, with columns and keys
- Orders, customers and products as your own tables hold them
- Counts and totals, read with plain SELECT queries
- A read replica if you have one, so live traffic is unaffected
What you can ask
Which customers have not ordered in the last six months?
1,138 customers, 14 percent of the base. 302 of them spent more than €500 before they went quiet.
What is our average order value this month?
€67.40 across 2,615 orders, up from €63.10 last month.
Questions about MariaDB
How does Adea connect to MariaDB?
You create a user with read rights only and give Adea the details. Adea checks that the user cannot write, and connects from fixed addresses you can allow in your firewall.
Does Adea ever write to my database?
Never. It only reads, and it refuses to connect with a user that could write.
Can I limit what Adea reads?
Yes. You decide which tables and views the user can see, and Adea only reads inside that.
