ndjson-spec VS oil

Compare ndjson-spec vs oil and see what are their differences.

oil

Oils is our upgrade path from bash to a better language and runtime. It's also for Python and JavaScript users who avoid shell! (by oilshell)
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
ndjson-spec oil
6 236
633 2,742
2.8% 1.3%
0.0 9.9
over 1 year ago 3 days ago
Python
- GNU General Public License v3.0 or later
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

ndjson-spec

Posts with mentions or reviews of ndjson-spec. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-02-24.
  • Documentation for the JSON Lines text file format
    4 projects | news.ycombinator.com | 24 Feb 2024
    What’s the difference between terminators and separators here? The ndjson spec [0] doesn’t say anything like that, and it seems that ndjson and jsonlines are identical in what documents they accept.

    [0]: https://github.com/ndjson/ndjson-spec

  • Does anyone use JSON files as a database? Best practises? Or should I use a "real" database?
    3 projects | /r/node | 29 Jan 2023
    It's possible to work around this and still use a JSON-ish format. For example, my @broofa/persistentmap project provides an ES6 Map API backed by a persistent append-only file in NDJSON format. (Note: NDJSON isn't really a spec so much as a "convention"). But, honestly,
  • Why isn’t there a decent file format for tabular data?
    13 projects | news.ycombinator.com | 3 May 2022
    ndjson is actually a really pragmatic choice here that should not be overlooked.

    Tabular formats break down when the data stops being tabular. This comes up a lot. People love spread sheets as editing tools but they then end up doing things like putting comma separated values in a cell. I've also seen business people use empty cells to indicate hierarchical 'inheritance". An alternate interpretation of that is that that data has some kind of hierarchy and isn't really row based. People just shoehorn all sorts of stuff into spreadsheets because they are there.

    With ndjson, every line is a json object. Every cell is a named field. If you need multiple values, you can use arrays for the fields. Json has actual types (int, float, strings, boolean). So you can have both hierarchical and multivalued data in a row. The case where all the fields are simple primitives is just the simple case. It has an actual specification too: https://github.com/ndjson/ndjson-spec. I like it because I can stream process it and represent arbitrarily complex objects/documents instead of having to flatten it into columns. The parsing overhead makes it more expensive to use than tsv though. The file size is fine if you use e.g. gzip compression. It compresses really well generally.

    But I also use either tab separated values quite often for simpler data. I mainly like it because google spread sheets provides that as an export option and is actually a great editor for tabular data that I can just give to non technical people.

    Both file formats can be easily manipulated with command line tools (jq, csvkit, sed, etc.). Both can be processed using mature parsers in a wide range of languages. If you really want, you can edit them with simple text editors, though you probably should be careful with that. Tools like bat know how to format and highlight these files as well. Etc. Tools like that are important because you can use them and script them together rather than reinventing wheels.

    Formats like parquet are cumbersome mainly because none of the tools I mention support it. No editors. Not a lot of command line tools. No formatting tools. If you want to inspect the data, you pretty much have to write a program to do it. I guess this would be fixable but people seem to be not really interested in doing that work. Parquet becomes nice when you need to process data at scale and in any case use a lot of specialized tooling and infrastructure. Not for everyone in other words.

    Character encoding is not an issue with either tsv or ndjson if you simply use UTF-8, always. I see no good technical reason why you should use anything else. Anything else should be treated as a bug or legacy. Of course a lot of data has encoding issues regardless. Shit in, shit out basically. Fix it at the source, if you can.

    The last point is actually key because all of the issues with e.g. csv usually start with people just using really crappy tools to produce source data. Switching to a different file format won't fix these issues since you still deal with the same crappy tools that of course do not support this file format. Anything else you could just fix to not suck to begin with. And if you do, it stops being an issue. The problem is when you can't.

    Nothing wrong with tsv if you use UTF-8 and a some nice framework that generates properly escaped values and does all the right things. The worst you can say about it is that there are a bit too many choices here and people tend to improvise their own crappy data generation tools with escaping bugs and other issues. Most of the pain is self inflicted. The reason csv/tsv are popular is that you don't need a lot of frameworks / tools. But of course the flipside is that DYI leads to people introducing all sorts of unnecessary issues. Try not to do that.

  • Has UML died without anyone noticing?
    4 projects | /r/programming | 25 Apr 2021
    Newline-separated JSON is pretty close. It's not exactly a "standard" standard like something the IETF defines, but it's pretty easy to work with anyhow.
  • json to csv on google cloud fusion
    1 project | /r/googlecloud | 16 Feb 2021

oil

Posts with mentions or reviews of oil. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-04-03.
  • The life and times of an Abstract Syntax Tree
    1 project | news.ycombinator.com | 2 May 2024
    Some related references (on a somewhat messy wiki page) - https://github.com/oilshell/oil/wiki/Compact-AST-Representat...

    Feel free to add others

  • Autoconf makes me think we stopped evolving too soon
    8 projects | news.ycombinator.com | 3 Apr 2024
    will prevent almost all of the "silent footguns".

    YSH has strict:all and then a bunch of NEW features.

    There's been good feedback recently, which has led to many concrete changes. So your experience can definitely influence the language! https://github.com/oilshell/oil/wiki/Where-To-Send-Feedback

  • Basic Things
    1 project | news.ycombinator.com | 30 Mar 2024
    Regarding writing tools/tests/benchmarks in bash+Python, vs. writing tools in your main language:

    I think we might eventually concede that something Debian-like is the “standard development environment” (at least for server side stuff, i.e. not iOS apps)

    In this case, bash+Python is a non-issue. It works extremely reliably. That’s actually why I use it! Everything else seems to break, or it’s really slow (node.js is a very common alternative).

    - Microsoft conceded this back in ~2017, by building Linux into their kernel with WSL, and providing Ubuntu on top

    Yes bash + Python is a disaster on Windows (I have scars from it), but Microsoft agrees that the right place to solve that is in Windows :-)

    - Every CI system runs Debian/Ubuntu

    - Every hosting provider runs Debian/Ubuntu

    - Every online dev env like gitpod.io provides Debian/Ubuntu

    This is somewhat related to remote dev envs: https://lobste.rs/s/ucirlx/lapdev_self_hosted_remote_dev

    One vision for https://www.oilshell.org/ is that the CI environment is the dev environment is the hosting environment.

    Everything is just an equal node in a distributed system. BUT it’s more git like, in that you explicitly sync and work “locally”, wherever that is. You don’t have the network chatter and flakiness of “the cloud”.

    Oils has a very large set of monotonically increasing properties too - https://www.oilshell.org/release/0.21.0/quality.html

    All that is bash+Python that is run on every commit, and it’s extremely good at catching bugs and perf regressions.

    I’m skeptical that any project has that level of quality automation written in pure Rust or Zig. More likely it’s a bunch of cloud services with YAML.

    Also a bunch of “hard-coded” toolchains that you can’t script with bespoke code. Like some shell commands in your package.json, which is just a worse way of writing a shell script.

    Our quality process is all self-hosted, in the repo, and runs on both Github Actions and sourcehut - https://www.oilshell.org/release/0.21.0/pub/metrics.wwz/line...

    bash and Python runs perfectly on Github Actions and sourcehut, with zero change. Containers also do.

    (Although we need to unify the CI and release, because the release runs on 2 different real hardware machines, while CI is cloud only.)

    Also, a main point Oils is that bash now has another highly compatible, spec-driven implementation – OSH. Having 2 independent implementations is something newer languages don’t have.

    (copy of lobste.rs comment)

  • The secret weapon of Bash power users
    2 projects | news.ycombinator.com | 24 Mar 2024
    in your bashrc to enable it. I've used it for probably ~18 years now.

    It also works with https://www.oilshell.org/ since we use GNU readline. Just 'set -o vi' in ~/.config/oils/oshrc

  • Pipexec – Handling pipe of commands like a single command
    6 projects | news.ycombinator.com | 9 Mar 2024
    No other shell does that.

    But I didn't know it was called MULTIOS until now. (I guess that's read "mult I/O's"? I have a hard time not reading it was multi-OS :) )

    It seems a bit niche to be honest, but it's possible to support in Oils.

    ---

    Oils also uses Unix domain sockets already for the headless shell protocol

    https://github.com/oilshell/oil/wiki/Headless-Mode

    We could do something like dgsh, but so far I haven't seen a lot of uptake / demand. Every time it's mentioned, somebody kinda wants it, and then it kinda peters out again ... still possible though.

    I think flat files work fine for a lot of use cases, and once you add streaming, you also want monitoring, more control over backpressure/queue sizes, etc.

  • Show HN: Hancho – A simple and pleasant build system in ~500 lines of Python
    4 projects | news.ycombinator.com | 3 Mar 2024
    which works well. You don't have to clean when rebuilding variants. IMO this is 100% essential for writing C++ these days. You need a bunch of test binaries, and all tests should be run with ASAN and UBSAN.

    ---

    I wrote a mini-bazel on top of Ninja with these features:

    https://www.oilshell.org/blog/2022/10/garbage-collector.html...

    So it's ~1700 lines, but for that you get the build macros like asdl_library() generating C++ and Python (the same as proto_library(), a schema language that generates code)

    And it also correctly finds dependencies of code generators. So if you change a .py file that is imported by another .py file that is used to generated a C++ header, everything will work. That was one of the trickier bits, with Ninja implicit dependencies.

    I also use the Bazel-target syntax like //core/process

    This build file example mixes low level Ninja n.rule() and n.build() with high level r.cc_library() and so forth. I find this layering really does make it scale better for bigger projects

    https://github.com/oilshell/oil/blob/master/asdl/NINJA_subgr...

    Some more description - https://lobste.rs/s/qnb7xt/ninja_is_enough_build_system#c_tu...

  • Re2c
    4 projects | news.ycombinator.com | 22 Feb 2024
    This is sort of a category error...

    re2c is a lexer generator, and YAML and Python are recursive/nested formats.

    You can definitely use re2c to lex them, but it's not the whole solution.

    I use it for everything possible in https://www.oilshell.org, and it's amazing. It really reduces the amount of fiddly C code you need to parse languages, and it drops in anywhere.

  • Ask HN: Looking for a project to volunteer on? (February 2024)
    15 projects | news.ycombinator.com | 1 Feb 2024
    SEEKING VOLUNTEERS - https://www.oilshell.org/ - https://github.com/oilshell/oil/

    I'm looking for people to help fill out the "standard library" for Oils/YSH. We're implementing a shell for Python and JavaScript programmers who avoid shell!

    On the surface, this is writing some very simple functions in typed Python. But I've realized that the hardest parts are specifying, TESTING, and documenting what the functions do.

    ---

    The most recent release announcement also asks for help - https://www.oilshell.org/blog/2024/01/release-0.19.0.html (long)

    If you find all those details interesting (if maybe overwhelming), you might have a mind for language design, and could be a good person to help.

    Surveying what Python and JavaScript do is very helpful, e.g. for the recent Str.replace() function, which is nontrivial (takes a regex or string, replacement template or string)

    But there are also very simple methods to get started, like Dict.values() and List.indexOf(). Other people have already contributed code. Examples:

    https://github.com/oilshell/oil/commit/58d847008427dba2e60fe...

    https://github.com/oilshell/oil/commit/8f38ee36d01162593e935...

    This can also be useful to tell if you'll have fun working on the project - https://github.com/oilshell/oil/wiki/Where-Contributors-Have...

    More on #help-wanted on Zulip (requires login) - https://oilshell.zulipchat.com/#narrow/stream/417617-help-wa...

    Please send a message on Github or Zulip! Or e-mail me andy at oilshell dot org.

  • The rust project has a burnout problem
    3 projects | news.ycombinator.com | 17 Jan 2024
    This is true, but then the corrolary is that new PRs need to come with this higher and rigorous level of test coverage.

    And then that becomes a bit of a barrier to contribution -- that's a harness

    I often write entirely new test harnesses for features, e.g. for https://www.oilshell.org, many of them linked here . All of these run in the CI - https://www.oilshell.org/release/latest/quality.html

    The good thing is that it definitely helps me accept PRs faster. Current contributors are good at this kind of exhaustive testing, but many PRs aren't

  • Unix as IDE: Introduction (2012)
    3 projects | news.ycombinator.com | 27 Dec 2023

What are some alternatives?

When comparing ndjson-spec and oil you can also consider the following projects:

hsv5 - HTML5 Based Alternative to CSV, TSV, JSONL, etc

nushell - A new type of shell

tplant - Typescript to plantuml

fish-shell - The user-friendly command line shell.

rson - Rust Object Notation

elvish - Powerful scripting language & Versatile interactive shell

odiff - The fastest pixel-by-pixel image visual difference tool in the world.

xonsh - :shell: Python-powered, cross-platform, Unix-gazing shell.

parquet-wasm - Rust-based WebAssembly bindings to read and write Apache Parquet data

PowerShell - PowerShell for every system!

node-skeleton - Starter skeleton for Node applications

ShellCheck - ShellCheck, a static analysis tool for shell scripts