ToolJet's multi-dimensional data connectivity system
ToolJet has built a perfect data middleware architecture, currently supporting relational databases including PostgreSQL, MySQL, MS SQL Server, and NoSQL solutions such as MongoDB and Supabase. The system is developed in adapter mode, with dedicated connection drivers and query optimizers for each data source. For example, when connecting to PostgreSQL, the platform will automatically identify table relationships to generate ER diagrams; docking Supabase can take advantage of its real-time subscription feature.
At the security level, all database connections are encrypted using SSH tunnels and support IP whitelisting and role-based access control. Enterprises can configure data operation audit logs to meet compliance requirements such as GDPR. Tests show that ToolJet's query latency is controlled within 200ms when processing 100,000-level data tables, and the distributed query engine enables cross-database federated analysis, which is of significant value in enterprise scenarios such as inventory management and sales reporting.
This answer comes from the articleToolJet: Rapidly Build and Deploy On-Premise Applications with Text DescriptionsThe
