GizmoSQL
A terabyte-scale, lightning-fast SQL data engine for 80% less cost
GizmoSQL lets you query terabytes of data in seconds or less, for 80% less cost than other cloud engines. It far outperforms legacy platforms, and eliminates the need for distributed compute for data workloads that are less than 10 terabytes. With GizmoSQL - you can remotely and securely query billions of rows in the time it takes legacy engines to query millions.
Unparalleled Performance/Cost ratio
GizmoSQL can run your analytic workloads with outstanding performance for 80% less. Check out our performance and cost comparison chart below.
GizmoData's white-glove installation and configuration services will ensure that your installation of GizmoSQL is optimized to provide the very best performance possible for your challenging workloads.
Performance
GizmoSQL – powered by DuckDB – runs the TPC-H benchmark for 1 Terabyte in less than 3 minutes – on a single cloud virtual machine for pennies in compute cost!
Combine the power of DuckDB, Apache Arrow, Flight SQL, and ADBC
GizmoSQL is a composed OLAP SQL engine combining the power of the DuckDB, Apache Arrow Flight SQL, and enterprise-grade security. Combined with ADBC - you can leverage columnar data throughout your entire data infrastructure - maximizing throughput and performance.
With GizmoSQL, you can run DuckDB remotely and securely – and use it from virtually any client.
Flexibility
Allows you to run in your Cloud, in your VPC, with an Enterprise, or per-CPU core license – the more you use it, the more you save.
Choose your data engine back-end: DuckDB or SQLite.
Run GizmoSQL in the cloud, or on-prem. Host it on a virtual machine, or in Kubernetes – it is your choice.
Works with your Data
Because it is powered by DuckDB, GizmoSQL allows you to work with many data formats - including:
- Iceberg
- Delta Lake
- Parquet
- CSV
- JSON
- ORC
- and more...
Compatibility
Use any front-end – including, but not limited to: Tableau, Apache Superset, Si-Sense, and more!
You can easily use GizmoSQL from a JupyterLab notebook – from your laptop – while leveraging the processing power of the cloud to power your analytics.
Built with Apache Arrow Flight SQL, you can talk to it with ADBC, JDBC, and ODBC drivers.
Use the powerful DuckDB engine with the PostgreSQL dialect – maximizing SQL compatibility.
Easy to Use
GizmoSQL is extremely simple to install. It is statically compiled, with all libraries baked into a single executable. Administration is simple, and setup is a breeze.
Try GizmoSQL
Try GizmoSQL out, or contact GizmoData for more info – let us prove this technology works for your business.
The Best Combination of Performance and TCO
Don't overpay for lightning-fast analytics
GizmoSQL is proven to securely run terabyte-scale workloads with amazing performance - and even better cost.
With GizmoSQL, you can save 80% or more on your cloud computing costs, while providing outstanding performance for your customers.
The chart above shows the run-time and cost for running the TPC-H 22-query benchmark at scale factor: 1 Terabyte.
Find Out More
Interested in learning more about how GizmoSQL can help your business? Contact us today to schedule a consultation.