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

11–20 of 70 posts

Re: Show HN: SQLite Plugin for Jekyll

#11

Post by charles_f »

cannibalXxx wrote: post #8

In this article I show you a project on how to develop a static blog in jekyll. https://chat-to.dev/post?id=296

In this one I show how to host it in various stupid ways https://fev.al/posts/blog-infra/

Though the idea of using a database to store the content could make things even better. Maybe sprinkle some redundant postgres?

Re: Show HN: SQLite Plugin for Jekyll

#12

Post by hk1337 »

This is interesting. I suppose if you wanted to setup your Jekyll data relationally, this would make it simpler to pull a simple list of the combined data.

I wonder if DuckDB would make it easier to do this same thing and use the existing Jekyll data files?

Re: Show HN: SQLite Plugin for Jekyll

#13

Post by yboulkaid »

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 that separating data from content on a Jekyll site is a really powerful way to have anything from photo galleries, blog entries, book lists, easily changeable menus etc...

Re: Show HN: SQLite Plugin for Jekyll

#15

Post by sofixa »

giancarlostoro wrote: post #14

In wake of all the WP craziness a few weeks back, I wonder how long before someone builds a "best of both worlds" CMS to rival WordPress. "You get the nice admin UI, but it generates a static site" type of thing.

There are a few of those, I think the term used to describe them is "headless CMS".

Re: Show HN: SQLite Plugin for Jekyll

#16

Post by anamexis »

giancarlostoro wrote: post #14

In wake of all the WP craziness a few weeks back, I wonder how long before someone builds a "best of both worlds" CMS to rival WordPress. "You get the nice admin UI, but it generates a static site" type of thing.

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/

Re: Show HN: SQLite Plugin for Jekyll

#17

Post by raminf »

charles_f wrote: post #11
cannibalXxx wrote: post #8

In this article I show you a project on how to develop a static blog in jekyll. https://chat-to.dev/post?id=296

In this one I show how to host it in various stupid ways https://fev.al/posts/blog-infra/ Though the idea of using a database to store the content could make things even better. Maybe sprinkle some redundant postgres?

When you went from Jekyll to Kubernetes, it was must have been like when Ted Kaczynski first learned about battery-operated timed fuses.

Enjoyed the read.

Looking forward to when you chuck the whole thing into the bin and run Wordpress on your linux home server, fronted by a free Cloudflare zero trust tunnel.

Re: Show HN: SQLite Plugin for Jekyll

#18

Post by raminf »

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 trying to learn HTML/CSS/JS and wants to put together a read-only website with a database backend. I'll be pointing him this way as an ootion once he's far enough.

But it's still puzzling to link it to baked-data. Maybe I'm missing something.

Re: Show HN: SQLite Plugin for Jekyll

#19

Post by tajd »

This is really cool. Whilst it's been fun mucking around with next.js etc (and arguably that's for a different purpose) for an out the box website Jekyll has proven itself time and again. Looking forwards to trying this out.
Post reply on HN