Starbase: SQLite on the Edge

#1

Post by hunvreus » Sat, Oct 05, 2024, 11:35 AM UTC

Starbase: SQLite on the Edge
starbasedb.com

Re: Starbase: SQLite on the Edge

#2

Post by _hyn3 » Sat, Oct 05, 2024, 2:45 PM UTC

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

Re: Starbase: SQLite on the Edge

#3

Post by rmbyrro » Sun, Oct 06, 2024, 6:16 PM UTC

This is very appealing. If the authors are reading:

What is the architecture overview? Does each worker have a copy or do all of them work on the same DB files? How does it handle concurrent workers and db locking? Is SQLite native locking mechanism sufficient in this application?

Re: Starbase: SQLite on the Edge

#4

Post by sgammon » Sun, Oct 06, 2024, 6:29 PM UTC

This is awesome. We’ve adopted a similar architecture with DO. Does it do data sync across devices? Offline first? Or is it all online thru DO and D1?

Re: Starbase: SQLite on the Edge

#5

Post by aliasxneo » Sun, Oct 06, 2024, 6:29 PM UTC

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

Re: Starbase: SQLite on the Edge

#6

Post by wslh » Sun, Oct 06, 2024, 6:31 PM UTC

ELI5: Does "Open source, scale-to-zero, HTTP SQLite database built on top of Cloudflare Durable Objects" mean that you should pay and/or use Cloudflare for this? Or CDOs are generally available outside Cloudflare?

Re: Starbase: SQLite on the Edge

#7

Post by ec109685 » Sun, Oct 06, 2024, 7:14 PM UTC

How does this compare with Cloudflare’s new offering SQLite it durable objects: https://blog.cloudflare.com/sqlite-in-durable-objects

Re: Starbase: SQLite on the Edge

#8

Post by SahAssar » Sun, Oct 06, 2024, 7:16 PM UTC

sgammon wrote: post #4

This is awesome. We’ve adopted a similar architecture with DO. Does it do data sync across devices? Offline first? Or is it all online thru DO and D1?

DO = Cloudflare Durable Objects, https://developers.cloudflare.com/durable-objects/

D1 = Cloudflare D1, https://developers.cloudflare.com/d1/

Just incase someone else was as lost as me.

Re: Starbase: SQLite on the Edge

#9

Post by dantiberian » Sun, Oct 06, 2024, 7:48 PM UTC

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?

Re: Starbase: SQLite on the Edge

#10

Post by floydnoel » Sun, Oct 06, 2024, 7:56 PM UTC

SahAssar wrote: post #8

sgammon wrote: post #4

This is awesome. We’ve adopted a similar architecture with DO. Does it do data sync across devices? Offline first? Or is it all online thru DO and D1?

DO = Cloudflare Durable Objects, https://developers.cloudflare.com/durable-objects/ D1 = Cloudflare D1, https://developers.cloudflare.com/d1/ Just incase someone else was as lost as me.

ah, DO always translates to Digital Ocean for me. So thanks for that! acronyms with name collisions are the woooorst