Starbase: SQLite on the Edge • Hacker News Board

Re: Starbase: SQLite on the Edge

#11

Post by ilrwbwrkhv » Sun, Oct 06, 2024, 8:05 PM UTC

_hyn3 wrote: post #2

This is pretty cool. Great artwork too. Building edge DBs on top of S3 or R2 had interested me for a long time. Thanks for writing it! Update: bug in redirection: https://starbasedb.com/blog/blog/blog/blog/blog/blog/develop...

+1. Love the cassette falling in place with the sound effect. Still don't know what it actually does though, but that is very satisfying.

Re: Starbase: SQLite on the Edge

#12

Post by irq-1 » Sun, Oct 06, 2024, 8:07 PM UTC

Cloudflare recently updated this:

Zero-latency SQLite storage in every Durable Object

https://blog.cloudflare.com/sqlite-in-durable-objects/

Re: Starbase: SQLite on the Edge

#13

Post by shivawu » Sun, Oct 06, 2024, 8:18 PM UTC

Am I right to say that this is a template on top of cloudflare durable objects, not an actual software of its own?

Re: Starbase: SQLite on the Edge

#14

Post by jitl » Sun, Oct 06, 2024, 8:21 PM UTC

What is the difference between this and Cloudflare’s first party D1 database offering? https://developers.cloudflare.com/d1/

D1 is SQLite

Re: Starbase: SQLite on the Edge

#15

Post by bhl » Sun, Oct 06, 2024, 8:49 PM UTC

dantiberian wrote: post #9

I don't really understand what this is offering beyond Cloudflare's recent release of running SQLite in durable objects: https://blog.cloudflare.com/sqlite-in-durable-objects/ . Is it about providing an external interface to Cloudflare's SQLite databases?

The project is open source (https://github.com/Brayden/starbasedb/blob/main/src/index.ts). Yes to it provides a way to update Cloudflare's SQLite with HTTP.

Re: Starbase: SQLite on the Edge

#16

Post by Diti » Sun, Oct 06, 2024, 9:16 PM UTC

aliasxneo wrote: post #5

It appears the blog links are broken. Are those also supposed to function as the documentation?

Same here. I wonder if it’s only broken for us or if it’s broken for everybody else as well.

Re: Starbase: SQLite on the Edge

#17

Post by Onavo » Sun, Oct 06, 2024, 9:22 PM UTC

Any comparison with Dzero?

https://news.ycombinator.com/item?id=40563729

Re: Starbase: SQLite on the Edge

#18

Post by brunoqc » Sun, Oct 06, 2024, 9:30 PM UTC

dantiberian wrote: post #9

I don't really understand what this is offering beyond Cloudflare's recent release of running SQLite in durable objects: https://blog.cloudflare.com/sqlite-in-durable-objects/ . Is it about providing an external interface to Cloudflare's SQLite databases?

Some day I really need to learn when to use sqlite in a durable object vs the eventually consistent one (r2).

Re: Starbase: SQLite on the Edge

#19

Post by solarkraft » Sun, Oct 06, 2024, 10:16 PM UTC

This has the same name as an Elon Musk project. I can see the point of reusing names (this is a clever spin after all), but I’d expect the association to evoke quite some negative reactions.

Re: Starbase: SQLite on the Edge

#20

Post by robertclaus » Sun, Oct 06, 2024, 11:30 PM UTC

`Isolation. Due to the nature of our queue and query executions, everything is synchronous by nature so no two queries can be ran concurrently making them run in an isolated nature by default. Check.`

I'm not sure if I misunderstood something, but using a global queue/lock to enforce isolation properties seems to be just a little disingenuous for a dbms. It works, but it's odd to talk about isolation in a system with zero concurrency. It's like saying a bicycle gets infinite miles per gallon in fuel efficiency.