flatterer

Opinionated JSON to CSV/XLSX/SQLITE/PARQUET converter. Flattens JSON fast. (by kindly)

Flatterer Alternatives

Similar projects and alternatives to flatterer

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better flatterer alternative or higher similarity.

flatterer reviews and mentions

Posts with mentions or reviews of flatterer. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-11-06.
  • How to convert a massive JSON into CSV
    2 projects | /r/data | 6 Nov 2022
    This tool was built for this purpose https://github.com/kindly/flatterer
  • Show HN: Flatterer Lite, A Rust WASM JSON to tabular converter, for nested data
    1 project | news.ycombinator.com | 22 Oct 2022
    I have been working on this Rust based JSON flattener (https://github.com/kindly/flatterer) to XLSX/CSV/SQLITE/PARQUET/POSTGRES for about 2 years. I finally made a WASM based one for CSV/XLSX which is really easy to play with. You can use it via a url (if the data has CORS headers), for example https://lite.flatterer.dev?url=https%3A%2F%2Fdummyjson.com%2....

    The main difference with other converters/flatteners is that for one-to-many relationships (lists of objects in JSON) it produces a multi table output with keys to help join the tables together. Essentially produces a relational schema, along with some type information, of the JSON provided. For simple non-nested JSON it works too, but is a bit overkill.

    Its all opensource and free, and I think that it will become more and more useful as JSON/Graphql APIs proliferate.

  • Create table from JSON
    1 project | /r/dataengineering | 4 Aug 2022
    flatterer is the easiest option and will do this for you. It will also load the data into a sqlite or postgres database for you.
  • Robust Rust Library for Converting JSON Objects into CSV Rows
    2 projects | /r/rust | 30 Jul 2022
    I have also written something similar but higher level flatterer which is python but is a binding to libflatterer. Its main difference is when there is a list of objects it treats it a one to many and creates a separate CSV file.
  • Flatten a massive json file
    1 project | /r/dataengineering | 26 Jul 2022
    flatterer (github) is designed for this.
  • Simple GUI tool to query JSON or CSV databases [I have no coding skills]
    1 project | /r/dataengineering | 25 Jul 2022
    This looks great and using duckdb as a backend us a great choice. For JSON I suggest using flatterer https://flatterer.opendata.coop/ . Which will convert most JSON into CSV/Parquet with very little technical knowledge.
  • Rust for Data Engineering
    2 projects | /r/dataengineering | 22 Jun 2022
    My project flatterer (used for flattening JSON into tables) also is mainly a python cli/libarary but is written in Rust for speed/memory efficiency and better concurrency.
  • JSON Processing
    4 projects | /r/datascience | 17 Jun 2022
    I have been working on a similar tool for the last while called flatterer (github). It has a similar aim and works with most kinds of JSON well (but not very well with top level objects like yours).
  • Stream processing - Nested JSON to Parquet
    2 projects | /r/dataengineering | 30 May 2022
    You could try Option B with flatterer https://flatterer.opendata.coop/ which purpose is to convert nested JSON into other formats without a schema upfront including parquet.
  • Turning JSON arrays into tables - Data flattening
    2 projects | /r/dataengineering | 14 Apr 2022
    flatterer docs (github)
  • A note from our sponsor - InfluxDB
    www.influxdata.com | 24 Apr 2024
    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. Learn more →

Stats

Basic flatterer repo stats
14
165
6.6
2 months ago

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com