jekyll-sqlite

Infrastructure

static site generator plugin

SHOW HN2024

227points
65comments
#333of 3,515 in 2024
Top 10%of 2024 by points

How HN took it

MixedNo clear lean

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 HN
    • 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 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 HN
    • This 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 HN
    • Nice 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 HN
    • But 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 HN
    • I 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 HN
    • I'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 HN
    • But 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 HN
    • TinaCMS, 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

Category, keywords, summaries and labels on this page were made by AI (Thread Reader v2) and not checked by hand. Each point links to the comments it came from.

Add a badge to your READMEShown on HackerShow
[![Shown on HackerShow](https://hackershow.org/badge.svg)](https://hackershow.org/show/42244987)