https://www.sqlite.org/serverless.html (first published 2007, before the more recent misuse of the term began)
That’s kinda unrelated. The title here could have been “SQLite in serverless apps” or something to avoid the confusion.
Serverless SQLite
41–50 of 167 posts
Re: Serverless SQLite
#42Earlier quoted context omitted.
Almost like how the English language has been literally hijacked and destroyed. Language does change and evolve. The misuse and subsequent additional meaning for “literally” to now also be a simile for “figuratively” is a good example of how this isn’t necessarily always a good thing.
The changing and evolution of language is neither a good nor bad thing, it just is.
Disagree.
If a change diminishes the clarity, efficiency or even the beauty of the language for no good reason, then it's a bad change, at least for the purposes of communication.
Re: Serverless SQLite
#43Honestly, I think the page's "edge-sql" title is more descriptive. This is running SQLite within "edge" workers, as a nifty little proof-of-concept.
Re: Serverless SQLite
#44Earlier 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?
I thought the term was FaaS?
Re: Serverless SQLite
#45I 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…
That could be a lot of round trips.
Re: Serverless SQLite
#46I 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…
Have you seen http://sigusr2.net/serving-traffic-directly-from-sqlite.html ?
Re: Serverless SQLite
#47Earlier 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?
Homeless - of no fixed abode.
Catchy like vagrant but perhaps a bit insensitive (unless it was used to highlight the plight of the homeless).
Less catchy - Poste Restante or General Delivery
Re: Serverless SQLite
#48I 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…
Have you seen http://sigusr2.net/serving-traffic-directly-from-sqlite.html ?
This is interesting. The polar opposite of what I was thinking.
Re: Serverless SQLite
#49What would this be best used for?
I use something like this for a metadata search tool serving static data. Its high performance and easy to set up which is the main use case for me.
Re: Serverless SQLite
#50I 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…
That could be a lot of round trips.
Yes. Maybe you could increase the sizes of B+ pages ?
The only reason that databases use B+ trees rather than a red-black tree or avl trees is because of the overhead of reading data from the hard drive.
This would be a interesting hack.