Alternatives
Products that do what SQLite-S3-query – Python function to query a SQLite database on S3 does
- 1SQ
Part of the workflow for building my website is the generation of a table in tab-separated column format (.tsv). The source data is found in four other .tsv files. I use an SQLite query to perform a 4-way join and write out the new table. For convenience, I wrote a script that encapsulates the query inside a Bash function. The example below illustrates this technique. repertoire() { pushd $CMM_SOURCES/_data sqlite3 <<EOS .headers on .mode tabs .import category.tsv category .import composition.tsv composition .import concert.tsv concert .import program.tsv program .once repertoire.tsv…
2021
- 2SP
2021 · sqlime.org
- 3
- 4CP
2020 · github.com
- 5SA
2017 · spreadsheetdb.io
- 6CQ
2021 · github.com
- 7QJ
2020 · github.com
- 8DS
2021 · django-sql-dashboard.datasette.io
- 9CQ
2019 · github.com
- 10
- 11SS
2021 · github.com
- 12SI
2014 · github.com
- 13
- 14MI
2021 · github.com
- 15SS
SPyQL (https://github.com/dcmoura/spyql) is SQL with Python in the middle, an open-source project fully written in Python for making command-line data processing more intuitive, readable and powerful. Try mixing in the same pot: a SQL SELECT for providing the structure, Python expressions for defining transformations and conditions, the essence of awk as a data-processing language, and the JSON handling capabilities of jq. How does a SPyQL query looks like? $ spyql “ IMPORT pendulum AS p SELECT (p.now() - p.from_timestamp(purchase_ts)).in_days() AS days_ago, sum_agg(price…
2022 · github.com
- 16
- 17SP
2016 · github.com
- 18JG
2016 · github.com
- 19LFLINQ for Go▲84
2014 · github.com
- 20
- 21IS
2017 · github.com
- 22IA
2022 · github.com
- 23PA
2021 · github.com
- 24RS
2021 · spanrr.com
Ranked by how close each launch is in meaning, then by votes. Refine with a description →