Live data from Hacker News

Turso is an in-process SQL database, compatible with SQLite

github.com

61–70 of 109 posts

Re: Turso is an in-process SQL database, compatible with SQLite

#61
post #34

Disclaimer: I am author of Marmot https://github.com/maxpert/marmot so I will sound extremely bias. I have been asked multiple times on why I chose SQLite and not Turso. I've always responded people that I don't trust an open-source project once it's backed by a VC firm. I've moved away from Redis to Val-Key for same reason, and we have seen the Redis train-wreck in slow-mo. I hope at no point in future Turso ever en…

So then the follow-up question to that is:

How can we make sure that fundamental pieces of open source software that power the Internet can have funding, and that the people who write them can have comfortable lives working on the piece of software they love that so many people use?

I think you've described a real problem. But people turn to VC because there are few other ways to make funding happen.

Re: Turso is an in-process SQL database, compatible with SQLite

#62
post #48

Earlier quoted context omitted.

I find it crazy that people would ask you in that direction. I would wonder why anyone would chose Turso over SQLite. SQLite is some of the most battle tested software in the world. Turso seems like relatively new software that is still a bit experimental. You do not want your databases to be new or trendy. You want your databases to be solid as a rock.

Sqlite had such a stellar stellar reputation, for so many excellent reasons. I still find it absolutely freakish & abominable that people are so incredibly touchy & reflexively mean & vile to Turso. I've seen a couple Turso centric YouTube's recently and there are dozens and dozens of up votes for what just seems like the most petulant vacuous reflexive bitter viewed comments, dominating the comments. Sqlite deserves…

> What if this is better?

If it was actually better you would probably be describing how and why you think its better instead of complaining about "negativity".

Re: Turso is an in-process SQL database, compatible with SQLite

#63

Earlier quoted context omitted.

I am confused, this product appears to be an in-process DB, so what does "networking thing in their side" even mean?

Turso offers a cloud-hosted sqlite product. The idea is you can easily spin up per-tenant databases and have a "serverless" sqlite interface. It feels like it has a lot of the same downsides of hosted databases so I'm not sure what the specific value is. From their site they really emphasize local first syncing (so mobile apps and electron/tauri apps) and multi tenancy (hard database boundaries)

Honestly I still don't understand how "cloud sqlite" isn't an oxymoron.

I get it, Turso wants to actually make some money, but I just don't get it.

Re: Turso is an in-process SQL database, compatible with SQLite

#64
post #4

I'm confused why I would use this when Sqlite exists? Being written in Rust it's not even a good libc-less drop in choice for a language like Go?

One quick thing I can think of is multiple writers [0] [0]: https://turso.tech/blog/beyond-the-single-writer-limitation-...

What's the isolation level? They only mention write-write conflicts.

The reason SQLite's BEGIN CONCURRENT does not greatly increase concurrency (unless you're very careful with your schema and queries) is as much due to page level conflict detection as it is because it enforces serializable isolation.

Re: Turso is an in-process SQL database, compatible with SQLite

#65
post #59

Earlier quoted context omitted.

[flagged]

That's no ethical code, thats just religious fluff. The tenants my comment-neighbour quoted are a much better example.

we are moving from a world of "tenets" to a world of "tenants" yes

Re: Turso is an in-process SQL database, compatible with SQLite

#66
post #62

Earlier quoted context omitted.

Sqlite had such a stellar stellar reputation, for so many excellent reasons. I still find it absolutely freakish & abominable that people are so incredibly touchy & reflexively mean & vile to Turso. I've seen a couple Turso centric YouTube's recently and there are dozens and dozens of up votes for what just seems like the most petulant vacuous reflexive bitter viewed comments, dominating the comments. Sqlite deserves…

> What if this is better? If it was actually better you would probably be describing how and why you think its better instead of complaining about "negativity".

Pretty good vector processing built-in. Time series capabilities. Nice Change-Data-Capture table that I've used & loved. Rust which is easy as hell to embed. Underlying libsqlite is very useful too. The CLI has far better ergonomics than sqlite & good formatting. Async & concurrent writes. Backwards compatibility. Just so ragingly badass. Tries. Isn't narrow & conservative. Amazing test suite.

The discussion didn't seem to be about merits. It just simply seemed to be a bunch of pissy empty whining & loser statements that it wasn't even worth beginning to regard it at all, for dumb petulant reasons x y and z. Fuck that. Fine, I'm happy to sing some praises. But IMO there is a war against imagination & this loserly attitude is the omni present all pervading no value woeful forefront. This pox is everywhere, just no regard, no consideration at all, just out of hand disregard for ridiculous inconsiderate Fear Uncertainty and Doubt anti-reason, thought terminating no's.

Murderers of hacker spirit. Sure, come ask for better! Yes!! Please!!! Inquire & challenge. Push for actual meat (both ways). I saw none, I tried to give you some here. These empty vessels have just vapors of fear, boogiemen to conjure & scare with. No actual content or assessment. So weird to rally so hard against open source, just because it doesn't also hail from 2.5 decades ago. We need more than reflexivism. Or we are shite non hacker people of a low culture.

I complain about negativity because this is rotten & a stink. It's everywhere & so rarely is it of substance, talks to anything. I've tried to add some weight here, and most of what I've said feels basic but this gets bold: I think the weight of anti-possibility weighs heavier & has a bigger mantle to bear in its naysaying than speaking for. We should attune ourselves to consideration. The hacker spirit should favor the idea of possibility above rejection & discarding of potential.

Re: Turso is an in-process SQL database, compatible with SQLite

#67
post #7

Turso is sqlite with a server client arch. I use them for stashing my llm usage logs all the time. Pretty neat. Plus I'm rooting for them to rewrite sqlite in Rust.

If it is in-process (as the article says), why do you describe it as client / server architecture? If it’s not in-process why compare it to SQLite instead of other client server databases like Postgres?

There is turso cloud.

https://docs.turso.tech/turso-cloud

Re: Turso is an in-process SQL database, compatible with SQLite

#68
When it is ready for production and they implemented DDL to alter tables that D. Hipp just refuses to implement for some reason then I am in. People that feel attacked by this didn't have to deal with the antagonist behaviour of SQLite maintainers toward the community.

Re: Turso is an in-process SQL database, compatible with SQLite

#69
post #53
post #10

I’d imagine there’s an extremely long tail of features and quirks that will take time to iron out even after SQL compatibility is achieved. Looks like it’s still missing some important features like savepoints (!!!), windows and attach database. I’d be more excited and imagine it would be more marketable if it focused instead on being simply an embedded sql db that allowed multiple writers (for example), or some othe…

I've been using a sqlite alternative to avoid dependencies on a native library. It's go application that uses a native go sqlite reimplementation so i can create platform specific binaries that include all dependencies. Makes installation easier and more reliable.

modernc.org/sqlite is upstream SQLite, compiled to Go using ccgo. Spiritually similar to, say, a WASM build of SQLite. Not a separate reimplementation.

Re: Turso is an in-process SQL database, compatible with SQLite

#70
post #32

Didn't have a good experience with them. One day we suddenly started to experience severe latency spikes, lasting for more than a day, causing timeouts. Unrelated to our DB which was small, even happened on trivial queries - a networking thing on their side. Google showed this to have happened before with certain regions of theirs. If you can't offer a certain region in a stable manner as a DB vendor, don't offer it.…

I am confused, this product appears to be an in-process DB, so what does "networking thing in their side" even mean?

Sorry, the other replier is correct, it was about their cloud offering.
Post reply on HN