K
Kysely•14mo ago
dj0024javia

Mysql Query execution never ends

Hello, I have a question regarding my new integration of kysely in trpc. I wanted to port my prisma code to kysely and found that queries are indeed firing to db, but they never end the execution. Anyone knows why this is happening? Connection is taken from pool and mysql workbench also shows connection to db. Just the data is not returning. Same code is working with Prisma. Not sure where its going wrong. Can anyone help?
Solution:
Hey 👋 Try importing createPool from mysql2 and not mysql2/promise....
Jump to solution
2 Replies
Solution
Igal
Igal•14mo ago
Hey 👋 Try importing createPool from mysql2 and not mysql2/promise.
dj0024javia
dj0024javia•14mo ago
yeah, did that. Initially I imported from mysql after i saw the incorrect import, which took 1.2ms time to fire a simple select query. Using mysql2. it took 2.4ms.... Hmm...found something wierd...and its replicating as well on subsequent attempts Thanks @Igal for the help though. In my old code, I was using promise based pool so copied import from there 🙈
Want results from more Discord servers?
Add your server
More Posts
How to do join with raw sql snippets?How can I do this join with kysely? `left join videos on videos.id = CAST(highlights_content.item ASMore elegant way to handle nested relations?Can someone come up with more elegant solution for handling relations than this? I've modified the eJoin DATE_TRUNCHey, sorry if this is already answered somewhere. I couldn't find anything 😦 I want to translate Why does kysely-codegen generate the schema in node_modules?Like probably many people here, I use https://github.com/RobinBlomberg/kysely-codegen . By default, Any plan to complete the Postgres dialect?Hey there, Is there any plan (or a tracking issue) to complete the Postgres dialect with its specifiConvert date to timestamptzHello. I'm trying to convert the following query from TypeORM querybuilder to Kysely: itemReposiShorthand way to pass the entire update object inside of doUpdateSet when updating multiple values.Greetings! Thanks for developing Kysely, some of the stuff that it does actually blows my mind. I oRaw query for RLS not workingI am trying to migrate a raw query from TypeORM's builtin query builder to Kysely. It's required to Problems typing a generic withPerson helperFirst I want to say that I'm in love with Kysely! It's amazing. I could use some help getting the tyRollback transactionHi, I'm trying to figure out if it's possible to intentionally rollback a transaction, the idea is t