DT
Drizzle TeamMatt

Struggling when changing tables relationships or columns

I find myself getting errors such as quite regularly [cause]: [ResponseError: SQLite error: no such table: main.old_push_business] { code: 'SQLITE_UNKNOWN', proto: { message: 'SQLite error: no such table: main.old_push_business', code: 'SQLITE_UNKNOWN' } } } It normally happens when I've changed a relationship or a column. I'll push the changes, it appears to be successful, I'll then try to run studio, which just gives me the loading spinner on the left where the columns normally are. I'll then try and push again and errors such as the above. This happens a lot, the work around I've found, at least locally, is to recreate the local db and push again which then seems to reset everything (I'm using LibSQL/Turso). Am I doing something fundamentally wrong that's causing these issues?
Matt
Matt•22d ago
Anyone?
Want results from more Discord servers?
Add your server
More Posts
How can I get rid of the buffer object returned when using Magical sql operator?This is and example of how I execute the query: ```ts const id = 69; await db.execute(sql`select * fField 'email' doesn't have a default with connection pool in MySQL``` [next-auth][error][adapter_error_createUser] https://next-auth.js.org/errors#adapter_error_creatabje.js exports not defined in table.d.tsIs there any reason why the table.d.ts is not matching with the table.js file? table.js has these exHow not to exceed the max connections limit in the DB in a Serverless env like AWS lambda?[question] What is the recommended way to use drizzle in a serverless environment like AWS lambda -