Preview feature feedback: @prisma/adapter-libsql / Turso support

[janpio]

Support for Turso is in early access behind the driverAdapters preview feature. You can learn about it in our blog post.

Please share your feedback about @prisma/adapter-libsql released in v5.4.0 in this issue.

• If you encounter a bug, please open a bug report in this repo.
• If the feature is working well for you, please share this in a comment below or leave a 👍 on this issue.
• If you have any questions, don't hesitate to ask them in the Prisma Slack community

[edgarsilva]

@ruheni @janpio first of all great work with the Turso libsql Adapter 👏🏽 !

Is it a known issue that when using embedded replicas you can not write to the DB?

I was experimenting with this and embedded replicas as explained here -> https://www.prisma.io/blog/prisma-turso-ea-support-rXGd_Tmy3UXX and found out all inserts fail with this error ->

I'm wondering if this is really a Prisma issue or maybe a libsql problem, but you might have better insight.

[2] PrismaClientKnownRequestError: 
[2] Invalid `prisma.todo.create()` invocation:
[2] 
[2] 
[2] TRANSACTION_CLOSED: The transaction is closed
[2]  code: "TRANSACTION_CLOSED"
[2] 
[2]       at new U (/home/edgar/workspace/scaffold-apps/beth-stack/node_modules/@prisma/client/runtime/library.js:26:1479)
[2]       at handleRequestError (/home/edgar/workspace/scaffold-apps/beth-stack/node_modules/@prisma/client/runtime/library.js:123:6816)
[2]       at handleAndLogRequestError (/home/edgar/workspace/scaffold-apps/beth-stack/node_modules/@prisma/client/runtime/library.js:123:6200)
[2]       at /home/edgar/workspace/scaffold-apps/beth-stack/node_modules/@prisma/client/runtime/library.js:123:5920
[2]       at processTicksAndRejections (:61:76)
[2] POST - http://localhost:3000/api/todos failed
[2] 2023-11-05T14:27:30.140811Z ERROR tower_http::trace::on_failure: response failed classification=Code: 9 latency=42 ms

It seems the transaction is closed prematurely or something similar, going back to no syncUrl works great though, no issues with the adapter so far.

It might be worth mentioning somewhere that so far, due to this still being experimental, inserts to the db don't work while also using embedded replicas.

It's hard to go back though after experiencing the crazy fast query responses.

[rodolphoasb]

I think it's fixed now: tursodatabase/libsql#577

[janpio]

Yes, but no release since merge yet: https://github.com/tursodatabase/libsql/releases

[janpio]

This should have been release in the meantime @edgarsilva. Can you maybe confirm?

[edgarsilva]

Nice, will test it over the weekend to make sure all CRUD operations work and update here 👍🏽

[edgarsilva]

@janpio confirmed is working 👍🏽 !

here are my current deps versions used to confirm it ->

Note: running on bun v1.0.25

{
   "dependencies": {
    "@libsql/client": "^0.4.0-pre.2",
    "@prisma/adapter-libsql": "^5.5.2",
    "@prisma/client": "^5.5.2",
    "libsql": "^0.2.0-pre.7",
    "prisma": "^5.5.2",
  },
}

Read speeds are "blazingly fast" (less than 1ms locally), sadtly writes to the remote replicas are all over the place from around 400 ms the fastest to over 1s.

This is what I'm seeing on first sync (and every 30s my turso sync runs) ->

A couple avg. writes (5th and 10th write in under 30s) ->

And this are the avg. read speeds from the local replicas.

This is not good if you have a few writes, services like Supabase and PlanetScale easily give you under 200ms avg. per operation (of course depending on relative location) and way more stable times.

I'm wondering if too much sync after the write ant select that Prisma does could be hurting response times...

[Ivanrenes]

Really waiting for applying migrations with schema entity changes, is there anything in progress for that?

[janpio]

No, please leave a 👍 reaction on #22184 to register your interest.

[itsmylife]

Probably it is a known issue but just want to point this:

@prisma/adapter-libsql@5.10.2 and @libsql/client@0.5.3 is not compatible.

❯ npm i
npm ERR! code ERESOLVE
npm ERR! ERESOLVE could not resolve
npm ERR! 
npm ERR! While resolving: @prisma/adapter-libsql@5.10.2
npm ERR! Found: @libsql/client@0.5.3
npm ERR! node_modules/@libsql/client
npm ERR!   @libsql/client@"0.5.3" from the root project

[Jolg42]

@itsmylife Indeed, if you use @prisma/adapter-libsql@early-access or use --force or --legacy-peer-deps it would work.
Because it's technically compatible but the peerDependencies are on the conservative side, and because it's a v0 package for @libsql/client, they need to be update for each minor version.

[itsmylife]

@Jolg42 Thank you for the reply. I'll do that.
Apart from that, I'll keep getting build errors with nextjs@14.1.3, prisma@5.10.2 and libsql@0.5.3, nodejs@20.10.0
I don't think it is related to prisma but just want to share it to reach more people. Maybe somebody has an idea.

Failed to compile.

./node_modules/@libsql/darwin-arm64/README.md
Module parse failed: Unexpected character ' ' (1:1)
You may need an appropriate loader to handle this file type, currently, no loaders are configured to process this file. See https://webpack.js.org/concepts#loaders
> # `@libsql/darwin-arm64`
| 
| Prebuilt binary package for `libsql` on `darwin-arm64`.

[Jolg42]

@itsmylife I found a related issue on Turso's repo tursodatabase/libsql-client-ts#184, maybe you can post there.

[Jolg42]

I think you could try to manually add the package to serverComponentsExternalPackages
see https://github.com/vercel/next.js/blob/canary/docs/02-app/02-api-reference/05-next-config-js/serverComponentsExternalPackages.mdx)