FEAT: libsql-server / Turso support

beekeeper-studio / beekeeper-studio

Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.

https://www.beekeeperstudio.io

Other

16.34k stars 1.07k forks source link

FEAT: libsql-server / Turso support #1762

Closed lukeberry99 closed 3 months ago

lukeberry99 commented 11 months ago

Is your feature request related to a problem? Please describe. I've recently swapped to Turso for new projects, and would love a native/desktop app to interact with it.

Describe the solution you'd like Support for libsql/turso - I think we would just need to allow a URL + token instead of just a file for the SQLite driver.

Database type, if appropriate sqlite/libsql/turso

meitrix8208 commented 11 months ago

+1 here

MattHeslington commented 10 months ago

This would be great

RemcoE33 commented 9 months ago

I would like this as well. As far as I know there is no SQL editor that supports Turso. I my opinion the mindset of Turso matches greatly. Would be a win win.

knekvasil commented 4 months ago

Any update on this?

pedroresende commented 4 months ago

Any news on this ?

rathboma commented 4 months ago

Hey all, question, seems like libsql, and turso-server are two separate things? libsql would be a different library to access local .db files, but the server would allow remote connections, is that a valid summary?

Looks like this is the client for remote conns - https://docs.turso.tech/sdk/ts/quickstart And this is libsql for local file access? - https://github.com/tursodatabase/libsql-js

Maybe these should be two tickets?

rathboma commented 4 months ago

Notes on implementation (libsql-server)

Testing: would need to build a docker image of libsql-server (that's the turso server). They don't provide one 🙄
Implementation: This should be a subclass of the sqlite driver
Dialect is sqlite
Tests should be able to run anything that sqlite can run. It will need to make sure any tests for sqlite also check for turso

rathboma commented 4 months ago

Note: This ticket is ONLY for libsql-server / Turso support. Local libsql support should be added separately.

sunxyw commented 4 months ago

Hey all, question, seems like libsql, and turso-server are two separate things? libsql would be a different library to access local .db files, but the server would allow remote connections, is that a valid summary?

Looks like this is the client for remote conns - https://docs.turso.tech/sdk/ts/quickstart And this is libsql for local file access? - https://github.com/tursodatabase/libsql-js

Maybe these should be two tickets?

If I understand it right. The libsql-js is a better-sqlite compatible client with remote database support, it supports both local and remote connections. Instead, the sdk is dedicated for remote libSQL connection.

So we should be able to use libsql-js for both local and remote libSQL support.