Cq Alternatives

Similar projects and alternatives to cq

sqlitebrowser

279 19,943 8.9 C++ cq VS sqlitebrowser

Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:
datasette

187 8,934 9.3 Python cq VS datasette

An open source multi-tool for exploring and publishing data
InfluxDB

www.influxdata.com featured

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.
q

46 10,122 2.1 Python cq VS q

q - Run SQL directly on delimited files and multi-file sqlite databases (by harelba)
octosql

34 4,699 1.2 Go cq VS octosql

OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
sqlite-utils

35 1,510 8.1 Python cq VS sqlite-utils

Python CLI utility and library for manipulating SQLite databases
textql

15 9,030 3.7 Go cq VS textql

Execute SQL against structured text like CSV or TSV
otj-pg-embedded

6 666 6.4 Java cq VS otj-pg-embedded

Java embedded PostgreSQL component for testing
SaaSHub

www.saashub.com featured

SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
csvs-to-sqlite

4 858 0.0 Python cq VS csvs-to-sqlite

Convert CSV files into a SQLite database
datablox

1 0 0.0 Python cq VS datablox

A distributed, typed, data column
superintendent

2 7 2.7 cq VS superintendent

Write SQL on CSV files

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

Suggest an alternative to cq

cq reviews and mentions

Posts with mentions or reviews of cq. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-08-04.

SQLite Is Dynamically Typed (2020)
3 projects | news.ycombinator.com | 4 Aug 2021

It seems beneficial for my case.
I have a light wrapper around SQLite called cq[1], to make querying CSVs with SQL more convenient. The point of the tool is to facilitate making ad-hoc, one-off queries on CSV data. CSVs don't specify the types of their columns, and they're either text or numeric. Having to be explicit on what the columns are would be a downside for me. Many CSVs have a ton of columns and I often care only about a few columns for one particular query I'll write and run once and never again.
I've fallen into the trap[2] where imported columns compare alphabetically despite them being numbers. I've been casting in my queries and was considering adding argument syntax for specifying the types of certain columns, but now that I see this, I think the behavior on specifying everything as NUMERIC is more desirable. It's more like Excel/LibreOfficeCalc, where you can just use numbers and they behave like numbers without having to be super-explicit.
I do very much agree that it's not desirable design for the DB of an app. There type-safety is more desirable.
[1] https://github.com/jolmg/cq
[2] https://news.ycombinator.com/item?id=28071615
Show HN: Work with CSV files using SQL. For data scientists and engineers
10 projects | news.ycombinator.com | 18 Jul 2021