TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Show HN: SQLSite – serve simple websites, APIs and files directly from SQLite

52 pointsby j4mieover 5 years ago

7 comments

CyberFonicover 5 years ago
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.
h3raldover 5 years ago
Similar to my own LiteStore project ;)<p>Project Page: <a href="https:&#x2F;&#x2F;h3rald.com&#x2F;litestore&#x2F;" rel="nofollow">https:&#x2F;&#x2F;h3rald.com&#x2F;litestore&#x2F;</a><p>User Guide: <a href="https:&#x2F;&#x2F;h3rald.com&#x2F;litestore&#x2F;LiteStore_UserGuide.htm" rel="nofollow">https:&#x2F;&#x2F;h3rald.com&#x2F;litestore&#x2F;LiteStore_UserGuide.htm</a>
captn3m0over 5 years ago
Looks fairly interesting. I have a lot of static data heavy sites where I struggle with Static site generators.<p>This might be a good alternative.<p>Suggestion: First class serverless&#x2F;S3 support perhaps?<p>This also reminds me of how crt.sh runs primarily off Postgres: <a href="https:&#x2F;&#x2F;github.com&#x2F;crtsh" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;crtsh</a>
tracker1over 5 years ago
A few years ago, worked on something similar with Node, Redis and Cassandra... depending on the type of data a given site&#x2F;resource was, it would either deliver the static content, or run a given node module&#x2F;version to process and deliver the request... worked very well at scale.
eismccover 5 years ago
Cool! I was thinking doing something similar.<p>Question: why not put everything into the SQLite DB as opposed to files next to the db in an archive?
评论 #22072898 未加载
ngcc_hkover 5 years ago
Interesting
paparushover 5 years ago
Maybe I&#x27;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.
评论 #22070219 未加载
评论 #22068612 未加载