jekyll-sqlite
Infrastructure
static site generator plugin
SHOW HN2024
How HN took it
15 positive, 7 neutral or asking, 0 mixed, 5 critical, out of 27 comments about the project. Thread score +0.40.
Idea: 10 for, 3 againstExecution: 0 for, 2 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Jekyll is stable and easy to use
From 2 comments
I have nothing to add other than Jekyll has been rock solid for me for, what, like a decade plus now? I've ran swiftjectivec.com on it, and it's always been the perfect middle…
jordanmorgan10 on HNI’ve always been a big fan of Jekyll because it’s so easy to use & so stable. This adds a lot of value to the ecosystem. I’ve built a bunch of faculty websites over the years…
zephyreon on HN
Useful for structured data sites
From 3 comments
I’ve always been a big fan of Jekyll because it’s so easy to use & so stable. This adds a lot of value to the ecosystem. I’ve built a bunch of faculty websites over the years…
zephyreon on HNThis is welcome news! I already use spreadsheets and SQLite as part of my Jekyll workflow. I import spreadsheet data into SQLite, create some additional tables, and export them…
chmaynard on HNNice to see this project here! I've been using it with the Steam API to publish a list of the games I've been playing on my personal website: https://yboulkaid.com/games I found…
yboulkaid on HN
Objections
Generating pages per row is not really baked data
From 2 comments
I'm a little confused. The baked-data model is so you DON'T have to generate a thousand static pages. But this solution does exactly that. Not complaining, mind you. My kid is…
raminf on HNBut it's still not baked data, no? The whole point of baked data is that you don't generate static pages for every item in the data set. Mind you, it's great to have a Jekyll…
groby_b on HN
Unclear what the plugin does at build time
From 1 comment
I have an understanding of static site generators, I've used several of them and even written my own. But I simply don't understand what this is or what it's doing. You're using…
audiodude on HN
Requests
Hugo equivalent
From 2 comments
This is awesome, and would solve an actual problem I've been thinking through... if only I had selected Jekyll for my static site generator. Does anyone know of a similar…
anticorporate on HNI wish if there was some hugo alternative to it , I guess I am going to go into the weeds of this project to replicate it in golang
Imustaskforhelp on HN
Full-text search via SQLite FTS in the browser
From 2 comments
Is it possible to generate an SQLite DB from the site data and statically serve it, so sql.js can use it as a DB to provide something like search?
nikeee on HNI'm mostly focusing on sqlite-as-the-data-source, but I can imagine something like this might be in scope for a project like lunr.js[1], which currently uses a large index served…
captn3m0 on HN
Questions
Is this really baked data
From 2 comments
I'm a little confused. The baked-data model is so you DON'T have to generate a thousand static pages. But this solution does exactly that. Not complaining, mind you. My kid is…
raminf on HNBut it's still not baked data, no? The whole point of baked data is that you don't generate static pages for every item in the data set. Mind you, it's great to have a Jekyll…
groby_b on HN
Can SQLite be queried at serve time
From 1 comment
I have an understanding of static site generators, I've used several of them and even written my own. But I simply don't understand what this is or what it's doing. You're using…
audiodude on HN
Alternatives named
Gatsby with GraphQL
From 1 comment
Right, looking again I understand better. Instead of a bunch of shaky YAML in a md file, you have properly structured data. Isn't this what Gatsby tries to do with GraphQL?
audiodude on HN
Evidence with DuckDB
From 1 comment
We use a similar “baked data” approach with Duck DB + a static site generator in evidence https://github.com/evidence-dev/evidence
amcaskill on HN
SQLPage
From 1 comment
This is a cool approach to integrating SQL with static site generation! If you're into SQL-powered tooling, you might find something like https://sql-page.com interesting as a…
lovasoa on HN
Decap CMS and Tina CMS
From 2 comments
Decap CMS: https://decapcms.org/
WorldMaker on HNTinaCMS, fka Forestry is trying to do this. It's been a while since I've tried them out, but I love the idea. https://tina.io/
anamexis on HN