Dup
DTDrizzle Team
•Created by Dup on 9/25/2024 in #help
Query syntax with Turso (in NextJS context)
Maybe this is in plans for a future release.
6 replies
DTDrizzle Team
•Created by Dup on 9/25/2024 in #help
Query syntax with Turso (in NextJS context)
https://nextjs.org/docs/app/api-reference/functions/fetch
Apparently, no. But as I stated, I read and heard that this design isn't welcomed by users nor popular lib devs since it changes the behavior of node fundamental API.
6 replies
DTDrizzle Team
•Created by Dup on 9/25/2024 in #help
Query syntax with Turso (in NextJS context)
I leave the info here just in case someone is finding this issue:
NextJS has a controversial way to manage cache by overriding the
fetch JS API. It caches request to app pages, including the data retrieval using fetch.
So, using the local sqlite file (file:/), drizzle/libsql is using conventional sqlite driver to connect to database and query and everything works fine.
But when it comes to use turso driver to connect cloud hosted database, then it uses turso APIs to query the database with http requests using fetch. If I make my app bypass the cache or apply TTL, then I can get the correct data.6 replies