Software Alternatives & Reviews

Run SQL on CSV, Parquet, JSON, Arrow, Unix Pipes and Google Sheet

OctoSQL Superintendent.app LNAV DSQ DataStation
  1. OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL. - cube2222/octosql

    #Databases #Big Data #Relational Databases 22 social mentions

  2. Superintendent.app is a Desktop app that enables you to write SQL on CSV files.

    #Productivity #Developer Tools #Data Dashboard 19 social mentions

  3. 3
    The Log File Navigator (lnav) is an advanced log file viewer for the console.
    Pricing:
    • Open Source
    Oh, okay... https://lnav.org is a log file viewer for the terminal that integrates with SQLite so you can use SQL to query your log files.

    #Monitoring Tools #Log Management #Realtime Analytics 58 social mentions

  4. 4

    DSQ

    Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more. - GitHub - multiprocessio/dsq: Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and ...
    I am currently evaluating dsq and its partner desktop app DataStation. AIUI, the developer of DataStation realised that it would be useful to extract the underlying pieces into a standalone CLI, so they both support the same range of sources. Dsq CLI - https://github.com/multiprocessio/dsq.

    #Application And Data #Languages & Frameworks #Shell Utilities 11 social mentions

  5. Application and Data, Data Stores, and Database Tools
    Pricing:
    • Open Source
    DataStation desktop app - https://datastation.multiprocess.io/ Two alternative CLI tools that I looked at: sq - https://sq.io/.

    #Application And Data #Data Stores #Database Tools 1 social mentions

Discuss: Run SQL on CSV, Parquet, JSON, Arrow, Unix Pipes and Google Sheet

Log in or Post with