Why developers like ScratchDB

What is ScratchDB?

It is an open-source alternative to BigQuery, Redshift, and Snowflake. It is a wrapper around Clickhouse that lets you input arbitrary JSON and perform analytical queries against it. It automatically creates tables and columns when new data is added.

ScratchDB is a tool in the Big Data Tools category of a tech stack.

ScratchDB is an open source tool with GitHub stars and GitHub forks. Here’s a link to ScratchDB's open source repository on GitHub

Who uses ScratchDB?

Developers

13 developers on StackShare have stated that they use ScratchDB.

Kubernetes

Toxiproxy

Keycatd

Terranetes Controller

Graphql Engine

Revive

Flannelv2

Nocode

Skywire Services

ScratchDB Integrations

JSON

Clickhouse

ScratchDB's Features

Open source
Build analytics with zero infrastructure
Automatically create and optimize tables from JSON
Lets you stream data without a "CREATE TABLE"

ScratchDB Alternatives & Comparisons

What are some alternatives to ScratchDB?

MySQL

The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.

PostgreSQL

PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.

MongoDB

MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.

Redis

Redis is an open source (BSD licensed), in-memory data structure store, used as a database, cache, and message broker. Redis provides data structures such as strings, hashes, lists, sets, sorted sets with range queries, bitmaps, hyperloglogs, geospatial indexes, and streams.

Amazon S3

Amazon Simple Storage Service provides a fully redundant data storage infrastructure for storing and retrieving any amount of data, at any time, from anywhere on the web

ScratchDB