The best Hacker News stories from Show from the past day
Latest posts:
Show HN: App that asks ‘why?’ every time you unlock your phone
Show HN: Silent Poems – Visual expression of unspoken thoughts
An interactive digital art project that turns typed text into flowing, abstract animated symbols. The symbols connect fluidly, much like handwriting, but in an entirely abstract way. Each letter has its own design, and then each instance of the letter has a different seed such that you have slight differences - the same as with handwriting.
Show HN: Silent Poems – Visual expression of unspoken thoughts
An interactive digital art project that turns typed text into flowing, abstract animated symbols. The symbols connect fluidly, much like handwriting, but in an entirely abstract way. Each letter has its own design, and then each instance of the letter has a different seed such that you have slight differences - the same as with handwriting.
Show HN: Silent Poems – Visual expression of unspoken thoughts
An interactive digital art project that turns typed text into flowing, abstract animated symbols. The symbols connect fluidly, much like handwriting, but in an entirely abstract way. Each letter has its own design, and then each instance of the letter has a different seed such that you have slight differences - the same as with handwriting.
Show HN: Silent Poems – Visual expression of unspoken thoughts
An interactive digital art project that turns typed text into flowing, abstract animated symbols. The symbols connect fluidly, much like handwriting, but in an entirely abstract way. Each letter has its own design, and then each instance of the letter has a different seed such that you have slight differences - the same as with handwriting.
Show HN: SQLite Plugin for Jekyll
I love Jekyll, especially the Datafiles[0] feature, which lets you use CSV/JSON/YAML files and iterate through them. Mixed with the Jekyll Data Pages generator[1], which lets you create a page for every row in your dataset, it is a very powerful combination.<p>However, Liquid is a terrible language for data-mangling, and simple filtering/sorting/merging can become very annoying. So I wrote a Jekyll SQLite plugin that lets you use the same data interface in Jekyll/Liquid, but backed by a SQLite file(s).<p>It gives you the simplicity of the Baked Data pattern[2], and the flexibility of using SQL for data-wrangling, within a static site generator.<p>As a demo, I took the northwind dataset, and generated a site[3] with a few sample queries[4]. It demos both site-level, and page-level queries alongside data-pages generator to generate a page for every product/category/customer.<p>I've been using this across a few sites in production for almost a year, looking for feedback on usage semantics and feature suggestions.<p>[0]: <a href="https://jekyllrb.com/docs/datafiles/" rel="nofollow">https://jekyllrb.com/docs/datafiles/</a><p>[1]: <a href="https://github.com/avillafiorita/jekyll-datapage_gen">https://github.com/avillafiorita/jekyll-datapage_gen</a><p>[2]: <a href="https://simonwillison.net/2021/Jul/28/baked-data/" rel="nofollow">https://simonwillison.net/2021/Jul/28/baked-data/</a><p>[3]: <a href="https://northwind.captnemo.in/" rel="nofollow">https://northwind.captnemo.in/</a><p>[4]: <a href="https://github.com/captn3m0/northwind">https://github.com/captn3m0/northwind</a>
Show HN: SQLite Plugin for Jekyll
I love Jekyll, especially the Datafiles[0] feature, which lets you use CSV/JSON/YAML files and iterate through them. Mixed with the Jekyll Data Pages generator[1], which lets you create a page for every row in your dataset, it is a very powerful combination.<p>However, Liquid is a terrible language for data-mangling, and simple filtering/sorting/merging can become very annoying. So I wrote a Jekyll SQLite plugin that lets you use the same data interface in Jekyll/Liquid, but backed by a SQLite file(s).<p>It gives you the simplicity of the Baked Data pattern[2], and the flexibility of using SQL for data-wrangling, within a static site generator.<p>As a demo, I took the northwind dataset, and generated a site[3] with a few sample queries[4]. It demos both site-level, and page-level queries alongside data-pages generator to generate a page for every product/category/customer.<p>I've been using this across a few sites in production for almost a year, looking for feedback on usage semantics and feature suggestions.<p>[0]: <a href="https://jekyllrb.com/docs/datafiles/" rel="nofollow">https://jekyllrb.com/docs/datafiles/</a><p>[1]: <a href="https://github.com/avillafiorita/jekyll-datapage_gen">https://github.com/avillafiorita/jekyll-datapage_gen</a><p>[2]: <a href="https://simonwillison.net/2021/Jul/28/baked-data/" rel="nofollow">https://simonwillison.net/2021/Jul/28/baked-data/</a><p>[3]: <a href="https://northwind.captnemo.in/" rel="nofollow">https://northwind.captnemo.in/</a><p>[4]: <a href="https://github.com/captn3m0/northwind">https://github.com/captn3m0/northwind</a>
Show HN: Trilogy – A Reusable, Composable SQL Experiment
Recipe: Add a semantic layer to SQL; use it drop the requirement for joins/group_by; add in type-checking and a lightweight python-esque import syntax to enable reuse and hierarchical querying.<p>Trilogy is intended to provide an accessible but deep alternative to raw SQL. It offers a new-but-inspired-by-SQL syntax that compiles to various dialects of SQL (with DuckDB as the default).<p>The target audience is people that really like SQL for analytics and data engineering, but want less boilerplate and sharp edges and looser coupling to the DB.<p>Semantic models can be easily shared, composed and iterated on in an interactive session, preserving the adhoc workflows that make SQL so powerful.<p>The "higher level" of the language vis-a-vis SQL makes it straightforward to extend into ETL (an experimental basic DBT integration is available), offering potential to optimize a processing graph across intermediate staging nodes automatically.<p>This higher level of abstraction also offers some nice opportunities for more reliable text to SQL for LLMs. A similarly basic integration is available to demonstrate this, as is a very basic VsCode extension and electron-based IDE.<p>Tech stack is primarily Python. Open source, MIT license. Github is linked from demo page. Thoughts, feedback, contributions all welcome!<p>Note: renamed from PreQL (see prior show <a href="https://news.ycombinator.com/item?id=40728938">https://news.ycombinator.com/item?id=40728938</a>) to avoid confusion with the many PreQLs of the world. The `SQL pun` naming space is unfortunately well-explored.<p>Other SQL replacements (all great, all worth a look!):<p>PRQL (pipelined SQL alternative, all new syntax) <a href="https://news.ycombinator.com/item?id=36866861">https://news.ycombinator.com/item?id=36866861</a><p>Malloy (all new syntax, semantic focus) <a href="https://news.ycombinator.com/item?id=30053860">https://news.ycombinator.com/item?id=30053860</a><p>preql (much more ambitious, all new syntax) <a href="https://news.ycombinator.com/item?id=26447070">https://news.ycombinator.com/item?id=26447070</a>
Show HN: Trilogy – A Reusable, Composable SQL Experiment
Recipe: Add a semantic layer to SQL; use it drop the requirement for joins/group_by; add in type-checking and a lightweight python-esque import syntax to enable reuse and hierarchical querying.<p>Trilogy is intended to provide an accessible but deep alternative to raw SQL. It offers a new-but-inspired-by-SQL syntax that compiles to various dialects of SQL (with DuckDB as the default).<p>The target audience is people that really like SQL for analytics and data engineering, but want less boilerplate and sharp edges and looser coupling to the DB.<p>Semantic models can be easily shared, composed and iterated on in an interactive session, preserving the adhoc workflows that make SQL so powerful.<p>The "higher level" of the language vis-a-vis SQL makes it straightforward to extend into ETL (an experimental basic DBT integration is available), offering potential to optimize a processing graph across intermediate staging nodes automatically.<p>This higher level of abstraction also offers some nice opportunities for more reliable text to SQL for LLMs. A similarly basic integration is available to demonstrate this, as is a very basic VsCode extension and electron-based IDE.<p>Tech stack is primarily Python. Open source, MIT license. Github is linked from demo page. Thoughts, feedback, contributions all welcome!<p>Note: renamed from PreQL (see prior show <a href="https://news.ycombinator.com/item?id=40728938">https://news.ycombinator.com/item?id=40728938</a>) to avoid confusion with the many PreQLs of the world. The `SQL pun` naming space is unfortunately well-explored.<p>Other SQL replacements (all great, all worth a look!):<p>PRQL (pipelined SQL alternative, all new syntax) <a href="https://news.ycombinator.com/item?id=36866861">https://news.ycombinator.com/item?id=36866861</a><p>Malloy (all new syntax, semantic focus) <a href="https://news.ycombinator.com/item?id=30053860">https://news.ycombinator.com/item?id=30053860</a><p>preql (much more ambitious, all new syntax) <a href="https://news.ycombinator.com/item?id=26447070">https://news.ycombinator.com/item?id=26447070</a>
Show HN: Trilogy – A Reusable, Composable SQL Experiment
Recipe: Add a semantic layer to SQL; use it drop the requirement for joins/group_by; add in type-checking and a lightweight python-esque import syntax to enable reuse and hierarchical querying.<p>Trilogy is intended to provide an accessible but deep alternative to raw SQL. It offers a new-but-inspired-by-SQL syntax that compiles to various dialects of SQL (with DuckDB as the default).<p>The target audience is people that really like SQL for analytics and data engineering, but want less boilerplate and sharp edges and looser coupling to the DB.<p>Semantic models can be easily shared, composed and iterated on in an interactive session, preserving the adhoc workflows that make SQL so powerful.<p>The "higher level" of the language vis-a-vis SQL makes it straightforward to extend into ETL (an experimental basic DBT integration is available), offering potential to optimize a processing graph across intermediate staging nodes automatically.<p>This higher level of abstraction also offers some nice opportunities for more reliable text to SQL for LLMs. A similarly basic integration is available to demonstrate this, as is a very basic VsCode extension and electron-based IDE.<p>Tech stack is primarily Python. Open source, MIT license. Github is linked from demo page. Thoughts, feedback, contributions all welcome!<p>Note: renamed from PreQL (see prior show <a href="https://news.ycombinator.com/item?id=40728938">https://news.ycombinator.com/item?id=40728938</a>) to avoid confusion with the many PreQLs of the world. The `SQL pun` naming space is unfortunately well-explored.<p>Other SQL replacements (all great, all worth a look!):<p>PRQL (pipelined SQL alternative, all new syntax) <a href="https://news.ycombinator.com/item?id=36866861">https://news.ycombinator.com/item?id=36866861</a><p>Malloy (all new syntax, semantic focus) <a href="https://news.ycombinator.com/item?id=30053860">https://news.ycombinator.com/item?id=30053860</a><p>preql (much more ambitious, all new syntax) <a href="https://news.ycombinator.com/item?id=26447070">https://news.ycombinator.com/item?id=26447070</a>
Show HN: Minimal, customizable new tab for Chrome/Firefox
Hello HN!<p>Flowtide is a project I have been working on for about 2 months now. It is a customizable new tab page for Firefox or Chrome. By default, it is configured to have a minimal amount of features, but it can be configured to include a clock, to-do list, or even soundscapes.<p>Install: <a href="https://flowtide.app/" rel="nofollow">https://flowtide.app/</a>
GitHub: <a href="https://github.com/thingbomb/flowtide">https://github.com/thingbomb/flowtide</a>
Show HN: Minimal, customizable new tab for Chrome/Firefox
Hello HN!<p>Flowtide is a project I have been working on for about 2 months now. It is a customizable new tab page for Firefox or Chrome. By default, it is configured to have a minimal amount of features, but it can be configured to include a clock, to-do list, or even soundscapes.<p>Install: <a href="https://flowtide.app/" rel="nofollow">https://flowtide.app/</a>
GitHub: <a href="https://github.com/thingbomb/flowtide">https://github.com/thingbomb/flowtide</a>
Show HN: Minimal, customizable new tab for Chrome/Firefox
Hello HN!<p>Flowtide is a project I have been working on for about 2 months now. It is a customizable new tab page for Firefox or Chrome. By default, it is configured to have a minimal amount of features, but it can be configured to include a clock, to-do list, or even soundscapes.<p>Install: <a href="https://flowtide.app/" rel="nofollow">https://flowtide.app/</a>
GitHub: <a href="https://github.com/thingbomb/flowtide">https://github.com/thingbomb/flowtide</a>
Show HN: Gemini LLM corrects ASR YouTube transcripts
Show HN: Gemini LLM corrects ASR YouTube transcripts
Show HN: Gemini LLM corrects ASR YouTube transcripts
Show HN: I am Building a Producthunt alternative
Show HN: I am Building a Producthunt alternative
Show HN: I am Building a Producthunt alternative
Show HN: Rill – Composable concurrency toolkit for Go