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

21–30 of 70 posts

Re: Show HN: SQLite Plugin for Jekyll

#21

Post by bbkane »

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!

Re: Show HN: SQLite Plugin for Jekyll

#22

Post by captn3m0 »

raminf wrote: post #18

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.

> bundling a read-only copy of your data alongside the code for your application, as part of the same deployment

You can see https://github.com/captn3m0/northwind for example, which bundles the entire database alongside the code in the _db/northwind.db file. While Simon considers it primarily for dynamic apps, you have the ability to build PWAs and other interesting apps with the baked data pattern.

I'm building blr.today for example using this.

Re: Show HN: SQLite Plugin for Jekyll

#23

Post by freedomben »

captn3m0 wrote: post #10
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 built endoflife.date with it, and it has been great. If I had to do it again, I might pick Mediawiki (or something similar) due to it being a community wiki more than a static site, but Jekyll hasn’t let us down yet.

Really appreciate you building and maintaining it these years! endoflife.date has been an amazing resource ever since you put it up. This has been a great open source success story that I share with people to explain why open source can be great. It's also a great example of the power of crowd-sourcing data. I originally added Ruby[1], Fedora[2], and Alma Linux[3] to endoflife.date and it's rewarded me with years of ability to reference. Prior to this I kept my own notes for the projects I cared most about, but keeping those up to date was a PITA. The best ideas seem obvious in hindsight, and endoflife.date definitely seems obvious :-D

[1] https://github.com/endoflife-date/endoflife.date/commit/7dae...

[2] https://github.com/endoflife-date/endoflife.date/commit/ab16...

[3] https://github.com/endoflife-date/endoflife.date/commit/12a7...

Re: Show HN: SQLite Plugin for Jekyll

#24

Post by captn3m0 »

amcaskill wrote: post #20

We use a similar “baked data” approach with Duck DB + a static site generator in evidence https://github.com/evidence-dev/evidence

This is quite interesting. I always wanted to build something similar using SteamPipe (which can pretend to be sqlite/postgres) alongside Querybook.

THe craziest production with this approach that I've seen is the crt.sh website, which builds a full dynamic website with postgres and sql: https://github.com/crtsh/certwatch_db/blob/master/fnc/web_ap...

Re: Show HN: SQLite Plugin for Jekyll

#25

Post by rapnie »

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.

Re: Show HN: SQLite Plugin for Jekyll

#26

Post by captn3m0 »

freedomben wrote: post #23
captn3m0 wrote: post #10

Earlier quoted context omitted.

I built endoflife.date with it, and it has been great. If I had to do it again, I might pick Mediawiki (or something similar) due to it being a community wiki more than a static site, but Jekyll hasn’t let us down yet.

Really appreciate you building and maintaining it these years! endoflife.date has been an amazing resource ever since you put it up. This has been a great open source success story that I share with people to explain why open source can be great. It's also a great example of the power of crowd-sourcing data. I originally added Ruby[1], Fedora[2], and Alma Linux[3] to endoflife.date and it's rewarded me with years of…

Thanks a ton!

Re: Show HN: SQLite Plugin for Jekyll

#27

Post by abhiyerra »

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.

Django-Distill I found to be pretty good for this. Use Django and the admin interface while being able to generate a static site.

Re: Show HN: SQLite Plugin for Jekyll

#28

Post by anticorporate »

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.

Re: Show HN: SQLite Plugin for Jekyll

#29

Post by sangeeth96 »

Although I don’t use Jekyll, loved this idea. I think using SQLite as the main data source would be a nice way to preserve content and play around with different static generators if they all had a plugin like this.

Also TIL about the baked data pattern, which I think is exactly what I needed for an upcoming project, so thanks for that. Though, I do align with one of the commenters here—this doesn’t seem like the same thing as the Baked data pattern in that Simon’s approach was about using a server rendered app with read-only data instead of generating a lot of static pages.

Nevertheless, this seems like a nice way for static generators to work with bit more complex data sources without dumbing them down to JSON/YAML.

Re: Show HN: SQLite Plugin for Jekyll

#30

Post by tonymet »

Great project. I've long thought about creating a static-site transformer for wordpress sites via SQLLite-- in order to reduce costs and improve security.

The idea would be to feed the wordpress content into a sqlite DB and re-publish the entire site as a static site. Since wordpress comments have declined in usage, this should work well.

Publishing time would be a bit slower, but reads will be 100x faster and 10000x cheaper.

Post reply on HN