Alternatives
Products that do what SQL query for CSV does
Analyze CSV records using sql syntax right in your browser
- 1CQ
2019 · github.com
- 2WW
2021 · superintendent.app
- 3
- 4
- 5VS
My co-worker and I were debugging a SQL issue; having not seen SQL in two years, I embarrassed myself by confusing union vs. join. After this episode, I tried refreshing my SQL memory, but there are few websites that animate SQL for you. Most of them just have a series of images to help you visualize. There are a few tools that are quite good and robust (especially for large/complex use cases) but require installation and are too complex for my simple purpose. So, just created a small tool to help visualise SQL. Most of the animations are just my understanding of how SQL works. Would…
2022 · animatesql.com
- 6QC
2015 · github.com
- 7
- 8FS
2017 · github.com
- 9
Learn SQL - the preferred tool of data analysts everywhere …
2015
- 10
- 11
- 12
- 13
- 14CP
2020 · github.com
- 15
- 16
- 17
- 18
- 19
- 20SQ
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
- 21
- 22SA
2017 · spreadsheetdb.io
- 23
- 24SO
2022 · github.com
Ranked by how close each launch is in meaning, then by votes. Refine with a description →