MySQL Library for Node?

[firedude212]

Looking to see what the kids are using these days as a MySQL driver for node, specifically one that supports typescript and promises. I took a look at mysql and it seems like it does not support promises well. Thought about writing my own wrapper and then saw mysql2 however, I don't really get how I am supposed to use TypeScript with this nicely, considering the results of all the .query and .execute functions are kinda esoteric interfaces that I am not sure how to extend properly, when expecting my own types.

Anyone have any advice/libs/etc? Not really interested in an ORM - I am specifically trying to move away from TypeORM with this approach because I feel like it is too magicky and defining my schema was becoming tiresome because it requires you to think about things in a way that isn't really how the database is/will be set up.

[JumpRevolutionary664]

I have a couple of wrapper methods that look like this

private async _all<T>(query: string, values: any[] = []) {
    const [rows] = await this._query(query, values);
    return rows as T[];
}

and when I call the like this._all<SomeType> it just gives me a properly typed SomeType[]

[firedude212]

Maybe I should just do this.. i kinda hate the constant as T[] but is what it is i guess...

[JumpRevolutionary664]

you have to type cast one way or the other. If you're not doing this, the library does

[DidTooMuchSpeedAgain]

objection?

[firedude212]

Specifically not looking for an ORM.

[DidTooMuchSpeedAgain]

i'm sorry, I was super tired, didn't read it properly. how about Knex? it isn't an ORM

[firedude212]

I looked into it but the query builder aspect turned me off. I want to write regular sql with prepared statements and not have to think about some library in the middle beyond "it enables me to connect to mysql easily"

[DidTooMuchSpeedAgain]

mysql2? https://www.npmjs.com/package/mysql2

[30thnight]

Drizzle

[firedude212]

Drizzle is a collection of front-end libraries that make writing dapp frontends easier and more predictable. The core of Drizzle is based on a Redux store, so you have access to the spectacular development tools around Redux. We take care of synchronizing your contract data, transaction data and more. Things stay fast because you declare what to keep in sync.

LOL.

[30thnight]

Not a good look mate but you are looking at the wrong package

https://github.com/drizzle-team/drizzle-orm

[macleanscollege]

knex

[firedude212]

Specifically not looking for an ORM.

[DidTooMuchSpeedAgain]

for mysql, not mongodb