News for hackers. Stuff that matters.
Re:Show HN: SQLSite – serve simple websites, APIs and files ... by CyberFonic on Thursday January 16, 2020 @03:49PM (#22068737)
I too wrote something similar in Python a couple of years ago. BUT that's not the point. Your contribution is well documented and effectively shared with whomever might want to use it. That is of value to our community.
Re:Show HN: SQLSite – serve simple websites, APIs and files ... by h3rald on Thursday January 16, 2020 @01:48PM (#22067576)
Similar to my own LiteStore project ;)

Project Page: https://h3rald.com/litestore/

User Guide: https://h3rald.com/litestore/LiteStore_UserGuide.htm

Re:Show HN: SQLSite – serve simple websites, APIs and files ... by captn3m0 on Thursday January 16, 2020 @01:21PM (#22067291)
Looks fairly interesting. I have a lot of static data heavy sites where I struggle with Static site generators.

This might be a good alternative.

Suggestion: First class serverless/S3 support perhaps?

This also reminds me of how crt.sh runs primarily off Postgres: https://github.com/crtsh

Re:Show HN: SQLSite – serve simple websites, APIs and files ... by tracker1 on Thursday January 16, 2020 @05:52PM (#22069934)
A few years ago, worked on something similar with Node, Redis and Cassandra... depending on the type of data a given site/resource was, it would either deliver the static content, or run a given node module/version to process and deliver the request... worked very well at scale.
Re:Show HN: SQLSite – serve simple websites, APIs and files ... by eismcc on Thursday January 16, 2020 @11:00PM (#22071727)
Cool! I was thinking doing something similar.

Question: why not put everything into the SQLite DB as opposed to files next to the db in an archive?

Re:Show HN: SQLSite – serve simple websites, APIs and files ... by j4mie on Friday January 17, 2020 @03:29AM (#22072898)
That's exactly what it does do! Everything is served from the sqlar table inside the database. Is there a bit of the documentation that doesn't make that clear?
Re:Show HN: SQLSite – serve simple websites, APIs and files ... by ngcc_hk on Thursday January 16, 2020 @01:45PM (#22067550)
Interesting
Re:Show HN: SQLSite – serve simple websites, APIs and files ... by paparush on Thursday January 16, 2020 @02:28PM (#22067941)
Maybe I'm missing something. I built a website and hand-rolled cms ten years ago leveraging PhP and SQLite that stores and serves the site and certainly allows full CRUD operations.
Re:Show HN: SQLSite – serve simple websites, APIs and files ... by pests on Thursday January 16, 2020 @06:28PM (#22070219)
This a Show HN where people post things they built. There doesn't need to be more than that. You too can post that cms you mentioned if you want.
Re:Show HN: SQLSite – serve simple websites, APIs and files ... by paparush on Friday January 17, 2020 @10:12AM (#22075227)
Thank you for reminding me of that. I'll try to keep that in mind and hold my judgements.