Feature Request: SQLite connector

[benoror]

Feature Request

What feature are you missing?

Support for local databases such as SQLite

How could this feature look like in detail? Tradeoffs?

Should be straightforward since it's kinda standard.

My main use-case would be to create decentralized/portable/client-side-only (d)apps.

Similar to: https://github.com/prisma/prisma/issues/2460

[daneroo]

This is a great idea, would accelerate integration testing.

[radojko]

+1 Great for ARM devices like Rpi

[charles-silva]

Hi, some news about sqlite connector ? thanks.

[jeffreygray]

Sorry to gravedig but any update here on the sqlite integration? This seems incredibly useful.

[tombohub]

yes, i am subscribing to this

[dvasdekis]

Hi guys, with the new Alpha releases that include MySQL and MSSQL, I'm hoping this could be included as well!

SQLite supports use cases like LiteStream and decentralized databases, which is super useful for building Web3 applications.

Thanks!

[louy2]

They are going to do this for a HasuraCon workshop LOL https://hasura.io/events/hasura-con-2021/talks/sqlite-implementing-a-new-hasura-backend/

[carlpaten]

@daneroo

This is a great idea, would accelerate integration testing.

@radojko

Great for ARM devices like Rpi

Note that even with different connectors Hasura still needs a Postgres database to manage its metadata, so a SQLite connector would not immediately make Hasura completely portable. You'll still need a Postgres database for integration testing and embedded devices.

[marceloverdijk]

This could also help building a (SSG) Next.js website where the static data (getStaticProps) is retrieved from a local GraphQL server using a local sqlite database.

Note this would also require the Hasura meta tables to be stored in sqlite.

[dvasdekis]

With the announcement of Cloudflare D1, this would be more useful than ever!

[Adron]

Hello all, check out this path here to explore and check out our SQLite connector for Hasura! So far it's just read only queries, but it's a start toward eventual full support!

Hey @dvasdekis would love to see what you'd put together with SQLite and the Cloudflare D1, several of us were pondering what could be done with that and other options out there.

Also for ARM devices/embedded devices, I'd be curious what else everybody else is thinking about, ping me if you've got time to discuss. Here or even ping me direct @Adron.