Live data from Hacker News

Serverless SQLite

sql.lspgn.workers.dev

81–90 of 167 posts

Re: Serverless SQLite

#81
post #25
post #16

Earlier quoted context omitted.

Indeed it's quite stupid. Any alternative catchy name for the concept?

We already had terms that covers about 90% of the different use cases: “managed”, “SaaS”, “shared hosting”, “multi-tendency”, “timesharing”.

tendency > tenancy (or tenant)

Re: Serverless SQLite

#82
post #80

Earlier quoted context omitted.

Isn't the modern serverless just a "load on demand"-concept?

My intuition is: "Don't care where it runs, don't want to manage it, I want to pay only for when I actually use it, thanks for managing it, here's some extra cash for the effort"

(Neo-)Serverless just means billing per-request instead of per-day, right?

Re: Serverless SQLite

#83
post #62

Earlier quoted context omitted.

I think I will always struggle to understand the popularity of the term serverless. From the two definitions found in https://www.sqlite.org/serverless.html classic serverless --> "embedded database" exists and is often used neo-serverless --> I suspect that this is a marketing term used to attract cool people to new cloud offerings (like "jamstack" for services such as netlify). There is no good replacement here bec…

I wouldn't be surprised if the term originated as a marketing tactic (e.g., AWS) to seed in people's heads the idea of not having to care about servers

I think I heard it first wrt GAE, but I think it was more "wry observation" then than actual "thing".

Re: Serverless SQLite

#84

https://www.sqlite.org/serverless.html (first published 2007, before the more recent misuse of the term began)

Serverless is an adjective so you can slap it everywhere. Worker-based or FaaS (function as a service) don't roll off the tongue that well. I'm not advocating for the term, just trying to explain why it is so popular.

Also, serverless solutions like DynamoDB or S3 aren't compute, so worker based and FaaS would simply be wrong.

Re: Serverless SQLite

#85
post #5

I've also experimented with this, unfortunately the 50ms CPU time isn't enough for datasets larger than 1.5MB. And the wasm init add at least 100ms to each request even when "hot" in cache. Also, out of a cost perspective, running a VM with SSD for cheap with SQlite will give much more requests than a CF worker for much less. Adding writes to this is also very limited due to the max 1sec write per KV key limit.

Cloudflare's "Workers Unbound" don't have that limit.

Re: Serverless SQLite

#86

Earlier quoted context omitted.

I wouldn't be surprised if the term originated as a marketing tactic (e.g., AWS) to seed in people's heads the idea of not having to care about servers

You hit the nail on the head. It is all about marketing for the new front-end developers who don't want to learn "server side" manipulation db, files, etc. Personally the whole indexdb, localstorage really break the web page as a stateless model. Why do you need save so much local data to just maintain the session? Stop putting everything in the web browser.

I can see the value of serverless in general (not this hack necessarily) in small startups that don't have sysadmins on payroll but still want to rapidly deploy products with confidence that it will just work - all without worrying about infrastructure, scaling, etc.

What I'm curious is if (1) serverless is cheaper than hiring competent sysadmins who can maintain the infrastructure instead and (2) are these savings worth being locked into a chaotic architecture and boring proprietary tooling that is forced on you for the profit of the Google, Microsoft, and Amazon monopolies?

I've recently entered the job market and personally find no joy in working in serverless environments because of the latter.

Re: Serverless SQLite

#88
post #16

Earlier quoted context omitted.

> SQLite was already serverless. Yes but now it runs on someone else server! Wait a minute, this makes no sense... 'serverless' is perhaps the stupidest marketing buzzword developers have come up with.

Indeed it's quite stupid. Any alternative catchy name for the concept?

computer-free software

Re: Serverless SQLite

#89

Earlier quoted context omitted.

You hit the nail on the head. It is all about marketing for the new front-end developers who don't want to learn "server side" manipulation db, files, etc. Personally the whole indexdb, localstorage really break the web page as a stateless model. Why do you need save so much local data to just maintain the session? Stop putting everything in the web browser.

I can see the value of serverless in general (not this hack necessarily) in small startups that don't have sysadmins on payroll but still want to rapidly deploy products with confidence that it will just work - all without worrying about infrastructure, scaling, etc. What I'm curious is if (1) serverless is cheaper than hiring competent sysadmins who can maintain the infrastructure instead and (2) are these savings w…

Personally I suspect that the chaotic tooling will waste more dev time than what the sysadmin time will cost you. So that it will be a net loss even before you consider lock-in and fees.

Re: Serverless SQLite

#90
post #84

Earlier quoted context omitted.

Serverless is an adjective so you can slap it everywhere. Worker-based or FaaS (function as a service) don't roll off the tongue that well. I'm not advocating for the term, just trying to explain why it is so popular.

Also, serverless solutions like DynamoDB or S3 aren't compute, so worker based and FaaS would simply be wrong.

Would we lose any meaning by just calling DynamoDB and S3 managed solutions, like in the old times?
Post reply on HN