# DuckDB vs SingleStore

**Leader by Vioscale score:** SingleStore

| Attribute | DuckDB | SingleStore |
|---|---|---|
| **Vioscale score** | 62.4 (56% (medium)) | 72 (72% (medium)) |
| activity.commits_last_30d | 100 | - |
| adoption.dependent_repos | 1 | - |
| adoption.github_stars | 40,661 | - |
| adoption.package_downloads_weekly | 17,889,302 | - |
| deployment.options | `{"self_hosted":true}` | `{"cloud":true,"self_hosted":true}` |
| description.long | An in-process SQL analytical database that runs natively in applications across operating systems and environments. Supports querying files and cloud data directly with a SQL dialect and includes vector search capabilities. | A hybrid transactional and analytical processing (HTAP) database that combines real-time transactions, analytics, and AI capabilities in a single engine for enterprise applications. |
| features.capabilities | `{"in_db_ml":true,"deployment":"embedded","sql_dialect":"vendor","license_class":"permissive","table_formats":"Parquet, CSV, JSON, Iceberg, Delta Lake, Vortex, DuckLake, Lance, Arrow, Avro, E","semi_structured":"functional","federation_query":true}` | `{"deployment":"hybrid","sql_dialect":"vendor","architecture":"coupled_mpp","license_class":"proprietary","semi_structured":"first_class","streaming_ingest":true}` |
| integrations.count | 27 | 7 |
| integrations.list | `[{"name":"Postgres"},{"name":"AWS"},{"name":"S3"},{"name":"Azure"},{"name":"Google Cloud"},{"name":"Hugging Face"},{"name":"SQLite"},{"name":"MySQL"},{"name":"Iceberg"},{"name":"Delta Lake"},{"name":"Parquet"},{"name":"JSON"},{"name":"Arrow"},{"name":"Avro"},{"name":"Pandas"},{"name":"dplyr"},{"name":"Jupyter"},{"name":"Marimo"},{"name":"Claude"},{"name":"Cloudflare"},{"name":"ODBC"},{"name":"HTTP"},{"name":"Excel"},{"name":"Vortex"},{"name":"DuckLake"},{"name":"Lance"},{"name":"Geospatial formats"}]` | `[{"name":"Kafka"},{"name":"Amazon S3"},{"name":"HDFS"},{"name":"MongoDB"},{"name":"Okta"},{"name":"Azure AD"},{"name":"Ping"}]` |
| language.primary | C++ | - |
| license.spdx | MIT | - |
| market.availability | `{"hqCountry":"NL","primaryMarkets":[],"availabilityScope":"global","availableCountries":[],"notAvailableCountries":[]}` | `{"hqCountry":"US","primaryMarkets":[],"availabilityScope":"global","availableCountries":[],"notAvailableCountries":[]}` |
| platform.support | `{"cli":true,"mac":true,"web":true,"linux":true,"windows":true}` | `{"web":true}` |
| pricing | `{"type":"open_source","summary":"Free, open source under MIT license","freeTier":true,"sourceUrl":"https://duckdb.org","retrievedAt":"2026-08-14T15:30:03.636Z"}` | `{"type":"hybrid","plans":[{"free":true,"name":"Free Workspace","summary":"Free","features":["Shared Workspace","All SQL and Programmability features","Monitoring","Self-support"],"components":[{"kind":"fixed","amount":0,"period":"month","currency":"USD"}],"description":"Shared workspace for evaluation, development and non-production testing","contactSales":false},{"free":false,"name":"Standard","summary":"Starts at $0.99/hr + $0.023/GB storage","features":["Read-replicas","All SQL and Programmability features","Database Branching","Monitoring (30-day)","99.9% SLA (1 AZ) or 99.99% SLA (2 AZ)","Standard Support"],"components":[{"per":{"qty":1,"unit":"hour"},"kind":"metered","amount":0.99,"currency":"USD"},{"per":{"qty":1,"unit":"GB"},"kind":"metered","amount":0.023,"currency":"USD"}],"description":"For general-purpose production workloads","contactSales":false},{"free":false,"name":"Standard BYOC","summary":"Contact us for pricing","features":["Fully managed within customer VPC","Read-replicas","All SQL and Programmability features","Monitoring (30-day)","Standard Support"],"description":"Bring Your Own Cloud - fully managed within customer VPC","contactSales":true},{"free":false,"name":"Enterprise","summary":"Starts at $1.49/hr","features":["Online PITR","Smart DR","Audit Logging","CMEK","99.9% SLA (1 AZ) or 99.99% SLA (2 AZ)"],"components":[{"per":{"qty":1,"unit":"hour"},"kind":"metered","amount":1.49,"currency":"USD"}],"description":"Enhanced DR & security for customer-facing workloads","contactSales":true}],"summary":"Free tier available. Usage-based with commitment options. Compute from $0.99/hr (Standard) or $1.49/hr (Enterprise); storage $0.023/GB. Includes $600 free credits for Standard.","currency":"USD","freeTier":true,"sourceUrl":"https://www.singlestore.com","retrievedAt":"2026-08-03T12:41:44.172Z","startingPrice":{"amount":0.023,"period":"month","currency":"USD"},"billingPeriods":["month"]}` |
| pricing.free_tier | yes | yes |
| pricing.model | open_source | freemium |
| pricing.price_level | free | low |
| pricing.transparent | yes | no |
| release.cadence_days | 28 | - |
| release.history | `[{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.5.5","date":"2026-07-22T10:51:50Z","type":"stable","version":"v1.5.5"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.5.4","date":"2026-06-17T10:45:53Z","type":"stable","version":"v1.5.4"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.4.5","date":"2026-06-17T10:42:38Z","type":"stable","version":"v1.4.5"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.5.3","date":"2026-05-20T11:50:43Z","type":"stable","version":"v1.5.3"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.5.2","date":"2026-04-13T10:46:51Z","type":"stable","version":"v1.5.2"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.5.1","date":"2026-03-23T12:10:58Z","type":"stable","version":"v1.5.1"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.5.0","date":"2026-03-09T12:40:59Z","type":"stable","version":"v1.5.0"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.4.4","date":"2026-01-26T12:08:09Z","type":"stable","version":"v1.4.4"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.4.3","date":"2025-12-09T10:20:40Z","type":"stable","version":"v1.4.3"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.4.2","date":"2025-11-12T13:04:29Z","type":"stable","version":"v1.4.2"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.4.1","date":"2025-10-07T10:29:57Z","type":"stable","version":"v1.4.1"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.4.0","date":"2025-09-16T10:17:31Z","type":"stable","version":"v1.4.0"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.3.2","date":"2025-07-08T10:39:09Z","type":"stable","version":"v1.3.2"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.3.1","date":"2025-06-16T13:54:58Z","type":"stable","version":"v1.3.1"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.3.0","date":"2025-05-21T16:04:19Z","type":"stable","version":"v1.3.0"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.2.2","date":"2025-04-08T08:44:15Z","type":"stable","version":"v1.2.2"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.2.1","date":"2025-03-05T18:03:02Z","type":"stable","version":"v1.2.1"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.2.0","date":"2025-02-05T13:57:07Z","type":"stable","version":"v1.2.0"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.1.3","date":"2024-11-04T13:59:58Z","type":"stable","version":"v1.1.3"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.1.2","date":"2024-10-14T11:41:35Z","type":"stable","version":"v1.1.2"}]` | - |
| reliability.sla_pct | - | 99.99 |
| reliability.status_page | yes | yes |
| security.disclosure_policy | - | yes |
| security.gdpr | - | yes |
| security.hipaa | - | yes |
| security.iso27001 | - | yes |
| security.soc2 | - | yes |
| security.vulnerabilities | `{"count":0,"source":"https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=conda&package_name=python-duckdb&per_page=100","last_12m":0,"max_severity":null}` | - |

## Capabilities (Data Warehouse Software)

| Capability | DuckDB | SingleStore |
|---|:--:|:--:|
| **Deployment** |  |  |
| Deployment | Embedded | Hybrid |
| **Architecture** |  |  |
| Architecture | - | Coupled MPP |
| Compute model | - | - |
| **Query** |  |  |
| SQL dialect | Vendor-specific | Vendor-specific |
| Federation / lakehouse query-in-place | ✓ | - |
| **Interoperability** |  |  |
| Table-format support | Parquet, CSV, JSON, Iceberg, Delta Lake, Vortex, DuckLake, Lance, Arrow, Avro, E | - |
| **Scale** |  |  |
| Concurrency scaling | - | - |
| **Ingestion** |  |  |
| Streaming ingest | - | ✓ |
| **Data model** |  |  |
| Semi-structured (JSON/VARIANT) | Functional | First-class |
| **Analytics** |  |  |
| ML / in-DB functions | ✓ | - |
| **Sharing** |  |  |
| Data sharing / marketplace | - | - |
| **Licensing** |  |  |
| Licence class | Permissive OSS | Proprietary |

*Source: Vioscale. Generated 2026-09-01T17:34:11.707Z. "-" = undocumented, not absent.*