5 ms·

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

52 points by j4mie 7y ago

captn3m0 7y ago
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 https://github.com/crtsh
ngcc_hk 7y ago
Interesting
h3rald 7y ago
Similar to my own LiteStore project ;) Project Page: https://h3rald.com/litestore/ https://h3rald.com/litestore/ User Guide: https://h3rald.com/litestore/LiteStore_UserGuide.htm https://h3rald.com/litestore/LiteStore_UserGuide.htm
paparush 7y ago
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.
- bananocurrency 7y ago
  ...and?
- pests 7y ago
  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.
  - paparush 7y ago
    Thank you for reminding me of that. I'll try to keep that in mind and hold my judgements.
CyberFonic 7y 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.
tracker1 7y ago
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.
eismcc 7y ago
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?
- j4mie 7y ago
  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?

52 points by j4mie 7y ago

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 https://github.com/crtsh

ngcc_hk 7y ago

Interesting

h3rald 7y ago

Similar to my own LiteStore project ;) Project Page: https://h3rald.com/litestore/ https://h3rald.com/litestore/ User Guide: https://h3rald.com/litestore/LiteStore_UserGuide.htm https://h3rald.com/litestore/LiteStore_UserGuide.htm

paparush 7y ago

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.

bananocurrency 7y ago
...and?
pests 7y ago
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.
- paparush 7y ago
  Thank you for reminding me of that. I'll try to keep that in mind and hold my judgements.

CyberFonic 7y 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.

tracker1 7y ago

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.

eismcc 7y ago

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?

j4mie 7y ago
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?