Transitioning from user-defined, dynamic schemas in document DB to a relational DB

This page summarizes the projects mentioned and recommended in the original post on /r/Database

InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  • sqrl

    Compiler for streaming data pipelines and data microservices with configurable engines. (by DataSQRL)

  • I think you're looking for document shredding. There are a few different strategies, depending on the query patterns. What you describe is one way, just flatten all the paths (e.g. JSONPath) and have a single table w/ key/value. Another way would be to create tables for each level in the hierarchy, but this way can get complex very quickly. You may want to use a different tool for it, such as https://github.com/DataSQRL/sqrl

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • AI Agent in Java with LangGraph4j

    1 project | dev.to | 21 May 2024
  • Happy Path: Web UI for Ollama using Java Only

    1 project | dev.to | 21 May 2024
  • Modernizing the AntennaPod Code Structure

    2 projects | news.ycombinator.com | 20 May 2024
  • Show HN: Kafka's Storageā€Compute Separation Architecture:Offload Storage to Ceph

    1 project | news.ycombinator.com | 20 May 2024
  • Introducing Stalactite ORM

    1 project | dev.to | 20 May 2024