Live data from Hacker News

Serverless SQLite

sql.lspgn.workers.dev

151–160 of 167 posts

Re: Serverless SQLite

#151

Earlier quoted context omitted.

The "industry" is comprised of much more than techies -- there are millions of marketing people out there who get hyped up at the shallowest sounding buzzword and we absolutely never will out-shout them. Nor do customers who love buzzwords.

It's not just marketers. The vast majority of engineers are just fine with this term. The set of people complaining about it are a tiny minority. I'm the lead engineer on Cloudflare Workers. We didn't originally call it "serverless", but after talking to lots of engineers who said "Oh so it's serverless?" we decided to go with that term. The decision was not made by marketers.

So network effects. And the other engineers already bought the marketing term and are implicitly pressuring you into using it. Ouch.

Re: Serverless SQLite

#152
post #62

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

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 think I will always struggle to understand the popularity of the term serverless.

AWS marketing is very good.

Serverless was a creation of the AWS Lambda team / AWS marketing department "I helped start the serverless movement..." from the LinkedIn of Tim Wagner (https://www.linkedin.com/in/timawagner/)

Re: Serverless SQLite

#153
post #35

I was thinking of making it possible for SQLite to be used with static pages. My idea is to modify SQLite to use ajax with the HTTP Range header to fetch B+ pages from the server as they are needed. SQLite already has a VFS (virtual file system) so this shouldn't be too hard. I am not sure how fast it would be and it would waste a lot of bandwidth. That's why I haven't made it yet. This would only be useful for using…

I have a sqlite 'on top' of a chrome cache filesystem. My usecase is to torrent the database as i also have support for files. The caveat is that i primarily use as a key-value store (the btree storage part of sqlite).

They are used to share structured and unstructured data in a p2p way where a torrent could be a database(structured) or a fileset(unstructured) .

But all of this is part of a bigger project that is basically a new sort of p2p "app browser" with a local-first emphasis but where every app can share its functionality though RPC (locally or remotely) with distribution going over DHT's and torrents.

Re: Serverless SQLite

#154

Earlier quoted context omitted.

It's not just marketers. The vast majority of engineers are just fine with this term. The set of people complaining about it are a tiny minority. I'm the lead engineer on Cloudflare Workers. We didn't originally call it "serverless", but after talking to lots of engineers who said "Oh so it's serverless?" we decided to go with that term. The decision was not made by marketers.

So network effects. And the other engineers already bought the marketing term and are implicitly pressuring you into using it. Ouch.

There's nothing "ouch" about it. People understand a term to mean a thing, we are doing that thing, we adopt the same term, now everyone understands what we're doing. Communication is good.

Re: Serverless SQLite

#155

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.

well, you don't need to manage a server to run the process. So, technically, it is less server. It's not no-server, just less.

[deleted]

Re: Serverless SQLite

#156

Earlier quoted context omitted.

So network effects. And the other engineers already bought the marketing term and are implicitly pressuring you into using it. Ouch.

There's nothing "ouch" about it. People understand a term to mean a thing, we are doing that thing, we adopt the same term, now everyone understands what we're doing. Communication is good.

Well, I agree on that. But I do get sad sometimes about how easily influenced the people at large are.

Re: Serverless SQLite

#157
post #117
post #35

I was thinking of making it possible for SQLite to be used with static pages. My idea is to modify SQLite to use ajax with the HTTP Range header to fetch B+ pages from the server as they are needed. SQLite already has a VFS (virtual file system) so this shouldn't be too hard. I am not sure how fast it would be and it would waste a lot of bandwidth. That's why I haven't made it yet. This would only be useful for using…

Someone has built it already for bittorrent, maybe you can reuse some parts: https://github.com/lmatteis/torrent-net Even with an artificially slow connection it seems to be reactive enough. Actually fetching pages on-demand can only be better for the bandwidth, the real issue is going to be latency

I haven't looked at the code but this sounds cool. There is also something called Kademlia which is a distributed hash table for keeping track of seeds for torrents. https://en.wikipedia.org/wiki/Kademlia

Re: Serverless SQLite

#158
post #103

Earlier quoted context omitted.

And https://en.m.wikipedia.org/wiki/Web_SQL_Database which was truly serverless SQLite for a web browser.

How is the OP not "truly serverless SQLite for a web browser"?

SQLite has a stricter definition of serverless than conventional.

Re: Serverless SQLite

#159

So we start adding sqlite. Then comes some sort of small framework for templating. Then we add session storage. Then we add an api endpoint so we can serve a SPA. I think after that it's really time to create a VM in sqlite so we can emulate linux and run somethings else in the 'serverless' endpoint

Lol I did this (sqlite via rest, custom urls, static file hosting) plus authentication/authorization and smtp with email templates. Everything needed for SPAs, no one was interested.
Post reply on HN