DrillDb vs PHPRunner

DrillDb

Description: DrillDb is an open-source SQL query engine for big data that supports querying a variety of NoSQL databases and file systems. It allows users to analyze large datasets without requiring them to structure the data upfront.

Type: software

Pricing: Open Source

PHPRunner

Description: PHPRunner is a tool for quickly building business web applications without coding. It allows you to visually design databases, forms, reports, and interfaces to create custom CRM, ERP, inventory and other systems in PHP and MySQL.

Type: software

DrillDb Features

• Supports SQL queries on NoSQL and distributed file systems
• Massively parallel processing for fast query performance
• Plugin architecture to connect to different data sources
• Support for Hadoop, MongoDB, HBase, HDFS, MapR-DB, Amazon S3
• Interactive SQL shell and JDBC/ODBC drivers
• In-memory caching for repeated queries
• Columnar storage for analytics
• Cost based optimizer
• Visualization with tools like Tableau

PHPRunner Features

• Visual application builder
• Automatic CRUD code generation
• Support for MySQL, PostgreSQL, MS SQL Server and Oracle databases
• Responsive design and Bootstrap support
• User management, roles and permissions
• Charts, dashboards and printable reports
• Email integration and scheduler
• Data import and export
• Multi-language support

DrillDb

• Open Source

PHPRunner

• Not listed