The best Hacker News stories from Show from the past day
Latest posts:
Show HN: One-on-one calls with your followers on Twitter
Show HN: Flash your ESP32 from the browser using JavaScript
Show HN: Flash your ESP32 from the browser using JavaScript
Show HN: Flash your ESP32 from the browser using JavaScript
Show HN: Open-source real-time transcription playground (React, Python, GCP)
Show HN: Open-source real-time transcription playground (React, Python, GCP)
Show HN: Open-source real-time transcription playground (React, Python, GCP)
Show HN: Open-source real-time transcription playground (React, Python, GCP)
Show HN: SQLite query inside a Bash function
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.<p>The example below illustrates this technique.<p><pre><code> 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
SELECT
category.name AS category,
composition.key,
composition.composer,
composition.name AS composition,
concert.name AS concert
FROM
category,
concert,
composition,
program
WHERE
julianday(concert.date) < julianday('now')
AND composition.category = category.name
AND program.key = composition.key
AND program.date = concert.date
ORDER BY
category.sequence,
composition.key
;
EOS
popd
}</code></pre>
Show HN: SQLite query inside a Bash function
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.<p>The example below illustrates this technique.<p><pre><code> 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
SELECT
category.name AS category,
composition.key,
composition.composer,
composition.name AS composition,
concert.name AS concert
FROM
category,
concert,
composition,
program
WHERE
julianday(concert.date) < julianday('now')
AND composition.category = category.name
AND program.key = composition.key
AND program.date = concert.date
ORDER BY
category.sequence,
composition.key
;
EOS
popd
}</code></pre>
Show HN: SQLite query inside a Bash function
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.<p>The example below illustrates this technique.<p><pre><code> 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
SELECT
category.name AS category,
composition.key,
composition.composer,
composition.name AS composition,
concert.name AS concert
FROM
category,
concert,
composition,
program
WHERE
julianday(concert.date) < julianday('now')
AND composition.category = category.name
AND program.key = composition.key
AND program.date = concert.date
ORDER BY
category.sequence,
composition.key
;
EOS
popd
}</code></pre>
Show HN: SQLite query inside a Bash function
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.<p>The example below illustrates this technique.<p><pre><code> 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
SELECT
category.name AS category,
composition.key,
composition.composer,
composition.name AS composition,
concert.name AS concert
FROM
category,
concert,
composition,
program
WHERE
julianday(concert.date) < julianday('now')
AND composition.category = category.name
AND program.key = composition.key
AND program.date = concert.date
ORDER BY
category.sequence,
composition.key
;
EOS
popd
}</code></pre>
Show HN: Autogenerate a CRUD app from a CSV file
Show HN: Autogenerate a CRUD app from a CSV file
Show HN: Rysolv – Fix open source issues, get paid (V1)
Show HN: Rysolv – Fix open source issues, get paid (V1)
Show HN: Side Quest – An aggregator for not full-time tech jobs
Show HN: Side Quest – An aggregator for not full-time tech jobs
Show HN: Side Quest – An aggregator for not full-time tech jobs
Show HN: Visual Python – open source visual Python code generator