[ANN] ob-dsq.el: Use SQL to join and query JSON, CSV, Org tables, all the things!

This page summarizes the projects mentioned and recommended in the original post on /r/emacs
Emacs Golang org-mode CSV org-agenda

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

  • dsq

    Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more.

    • dsq by Multiprocess Labs is a command line tool that allows for running SQL queries against multiple files of a growing number of supported types (JSON, CSV, many more) as database tables and for joining between them.

  • ob-dsq

    Emacs: Babel functions for the `dsq` CLI tool by Multiprocess Labs

    • Spending half my day in Org mode, I created ob-dsq.el, which adds Org tables, Org source block results, and basically any valid Org reference to the list of supported input types.

  • 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

  • org-ql

    A searching tool for Org-mode, including custom query languages, commands, saved searches and agenda-like views, etc.

    • I think your use case might be better served by alphapapa's org-ql package. It's not using SQL, but it does allow for querying the actual Org file's outline structure, including values of properties (check out the "properties" entry in the "General predicates" section of the package's README for details).

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

  • Hello everyone, I created an Emacs-independent (doesn't require Emacs to be running) agenda notification app. I tested it under Doom Emacs and vanilla Emacs, and it worked fine, please try it and report any possible issues at GitHub. Thanks!

    3 projects | /r/emacs | 23 Nov 2022

  • how to search for all .org files in a directory structure that have a specific tag in a directory structure?

    1 project | /r/orgmode | 7 Dec 2023

  • Release v0.7.1 · alphapapa/org-ql

    1 project | /r/orgmode | 8 Sep 2023

  • Release v0.7.1 · alphapapa/org-ql

    1 project | /r/emacs | 8 Sep 2023

  • org-super-agenda: Supercharge your Org daily/weekly agenda by grouping items

    1 project | /r/planetemacs | 4 Sep 2023