Stark-DB: SQLite-backed, change-tracking database available over HTTP

#1

Post by thunderbong » Thu, Oct 12, 2023, 8:09 PM UTC

Stark-DB: SQLite-backed, change-tracking database available over HTTP
npmjs.com

Re: Stark-DB: SQLite-backed, change-tracking database available over HTTP

#2

Post by MobiusHorizons » Sun, Oct 15, 2023, 11:45 PM UTC

Doesn't this lose the primary latency benefit of Sqlite by introducing a network connection?

Re: Stark-DB: SQLite-backed, change-tracking database available over HTTP

#3

Post by codetrotter » Mon, Oct 16, 2023, 12:45 AM UTC

Interesting that they chose to use port 5984, which is also the same port that CouchDB uses, but their API is completely different from the CouchDB API.

Re: Stark-DB: SQLite-backed, change-tracking database available over HTTP

#4

Post by kissgyorgy » Mon, Oct 16, 2023, 1:02 AM UTC

MobiusHorizons wrote: post #2

Doesn't this lose the primary latency benefit of Sqlite by introducing a network connection?

I wanted to comment exactly the same. This loses the advantage of SQLite, make it slower and more cumbersome to operate. You can simply do this with a library.

Re: Stark-DB: SQLite-backed, change-tracking database available over HTTP

#5

Post by refulgentis » Mon, Oct 16, 2023, 1:37 AM UTC

kissgyorgy wrote: post #4

MobiusHorizons wrote: post #2

Doesn't this lose the primary latency benefit of Sqlite by introducing a network connection?

I wanted to comment exactly the same. This loses the advantage of SQLite, make it slower and more cumbersome to operate. You can simply do this with a library.

Simply?

Re: Stark-DB: SQLite-backed, change-tracking database available over HTTP

#6

Post by g00gler » Mon, Oct 16, 2023, 2:28 AM UTC

refulgentis wrote: post #5

kissgyorgy wrote: post #4

Earlier quoted context omitted.

I wanted to comment exactly the same. This loses the advantage of SQLite, make it slower and more cumbersome to operate. You can simply do this with a library.

Simply?

They pretty much did the work for a lib at this point…

Re: Stark-DB: SQLite-backed, change-tracking database available over HTTP

#7

Post by ericls » Mon, Oct 16, 2023, 2:36 AM UTC

I'd only fallback to "changes" when I don't know the "intentions".

Re: Stark-DB: SQLite-backed, change-tracking database available over HTTP

#8

Post by meowtimemania » Mon, Oct 16, 2023, 5:15 AM UTC

What is the intended use case?

Re: Stark-DB: SQLite-backed, change-tracking database available over HTTP

#9

Post by pizzafeelsright » Mon, Oct 16, 2023, 7:37 AM UTC

MobiusHorizons wrote: post #2

Doesn't this lose the primary latency benefit of Sqlite by introducing a network connection?

Lemme try and defend without fully understanding or use:

Say you have a local sqlite database and want to share it.

Wouldn't this allow such an extension?

Re: Stark-DB: SQLite-backed, change-tracking database available over HTTP

#10

Post by andrewamurphy » Mon, Oct 16, 2023, 10:01 AM UTC

meowtimemania wrote: post #8

What is the intended use case?

To get VC funding?