Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: SQLite Plugin for Jekyll

github.com

Post reply on HN
Print view View original

31–40 of 70 posts

Re: Show HN: SQLite Plugin for Jekyll

#31

Post by diggan »

rapnie wrote: post #25
jordanmorgan10 wrote: post #5

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 ground of taking care of the cruft I don't want to deal with, while allowing me to get my hands dirty and code when I want. Some of my favorite software ever.

I have some old jekyll websites that I only very infrequently need to update. Each time something in the ruby / gem / bundler / jekyll chain setup is broken, and with some weird errors it is stackoverflow search time. Very time consuming, highly annoying. I postponed my last typo correction, to first make up my mind on whether to port to astro that I use currently.

> , to first make up my mind on whether to port to astro that I use currently.

Just sucks that eventually, that will happen with whatever you use after migrating too, the only difference is how long it takes.

I'm hoping NixOS or even just Nix for dev envs (or something similar) will help against this, so you end up with environments that just keep working.

Re: Show HN: SQLite Plugin for Jekyll

#32

Post by Tomte »

bbkane wrote: post #21
jordanmorgan10 wrote: post #5

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 ground of taking care of the cruft I don't want to deal with, while allowing me to get my hands dirty and code when I want. Some of my favorite software ever.

I actually switched my blog to use Zola (similar to Jekyll but packaged as a static binary instead of a Ruby gem) because I couldn't figure out how to build my site with Jekyll after a few years- it kept trying to compile C code? Bear in mind this was 5 years ago and I had never used Ruby before, so probably a user error :) Glad it's been so stable for you!

> it kept trying to compile C code?

That‘s something that works incredibly well on Windows, better than I would have expected to.

The rubyinstaller.org people are shipping a fantastic installation. Under the hood it‘s msys2, but everything simply works out of the box.

Re: Show HN: SQLite Plugin for Jekyll

#33

Post by [deleted] »

jordanmorgan10 wrote: post #5

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 ground of taking care of the cruft I don't want to deal with, while allowing me to get my hands dirty and code when I want. Some of my favorite software ever.

[deleted]

Re: Show HN: SQLite Plugin for Jekyll

#34

Post by klandergren »

Nice! Great to see innovation in the Jekyll space.

Quick FYI on Jekyll performance:

I noticed slow generation times on one of my sites and traced it to a plugin that was spawning a git process to get the last commit info for every page. I wrote a drop-in replacement called jekyll-last-commit[0] that uses the ruby libgit2 wrapper for improved performance. Details on its origins are in an old HN comment[1] if you are interested!

[0]: https://github.com/klandergren/jekyll-last-commit

[1]: https://news.ycombinator.com/item?id=34331663

Re: Show HN: SQLite Plugin for Jekyll

#36

Post by captn3m0 »

klandergren wrote: post #34

Nice! Great to see innovation in the Jekyll space. Quick FYI on Jekyll performance: I noticed slow generation times on one of my sites and traced it to a plugin that was spawning a git process to get the last commit info for every page. I wrote a drop-in replacement called jekyll-last-commit[0] that uses the ruby libgit2 wrapper for improved performance. Details on its origins are in an old HN comment[1] if you are i…

The other last-modified-plugin is now archived, and no longer included in the default Jekyll, but the sitemap and seo plugin still seem to rely on the page.last_modified_at property, albeit undocumented (https://github.com/jekyll/jekyll/issues/9702), so might be worth getting the implementation switched upstream perhaps?

We show the last-modified date on endoflife.date products (https://endoflife.date/jekyll), but I'm not sure how we have the property set right now, since I don't remember including either plugin. Thanks for creating this, I have a few other sites where this will be quite helpful.

Re: Show HN: SQLite Plugin for Jekyll

#37

Post by captn3m0 »

nikeee wrote: post #35

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?

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 as JS/JSON. You can write a Jekyll plugin in a few lines of ruby code (with no gem management needed, just drop it in the _plugins directory), so the "write-index-to-a-sqlite-file" part shouldn't be hard to build either.

Is FTS5 included in the SQLite browser builds? The SQLite amalgamation includes it by default.

[1]: https://lunrjs.com/docs/index.html

Re: Show HN: SQLite Plugin for Jekyll

#39

Post by Imustaskforhelp »

anticorporate wrote: post #28

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 solution for Hugo? Technically I'm sure I could run a script to generate .md (or a format like .csv that Hugo can work with) from my database, but this seems like it might be easier for a database that updates frequently.

Oh my god , I had written the exact same comment when seeing this for the first time , and then I scrolled to see your comment. Xd , definitely felt a bit of deja vu.

Yeh I am genuinely interested in this project. but I don't think I have the technical prowess to manage it , but I am going to try but I hope that others could somehow create it as well (since I have created nothing open source which people care about)

Post reply on HN