node-mysql2 VS oceanbase-sveltekit

MySQL2, a MySQL driver for Node.js

I have done online searches already but didn't find anything conclusive. This github thread was inconclusive and is riddled with people complaining. This thread is shorter but also inconclusive. I've already increased the max_allowed_packet.

Hi I just found a ticket with this error in the mysql2 repo: https://github.com/sidorares/node-mysql2/issues/1885

You can see everything that is exported from the TypeScript declaration files such as the mysql2's index.d.ts where it lists that in fact, yes there is a export function createConnection

For those who have never used node-mysql2 is a package to integrate MySQL with NodeJS (see here for more information about MySQL and its features).

I've been using https://github.com/sidorares/node-mysql2 in a couple of sites in production, gives me the two main things I need, named parameters and async compatible. Not a big fan of ORMs as invariably you'll have to do a query that doesn't fit into the paradigm and you'll spend fruitless hours trying to coerce it to do what you want.

Looks like you've added an issue to github -- https://github.com/sidorares/node-mysql2/issues/1370 -- getting a simple repro to the package maintainers is probably the best way to approach this.

You should consider using prepared statements which make the issue you’re asking about, as well as much more serious issues with your example, easily resolved:

I have uploaded a project to GitLab that you can clone and use to start your own project using SvelteKit and OceanBase. You can find the project at https://gitlab.com/waynering/oceanbase-sveltekit. Simply clone the repository and follow the instructions in the README file to set up the project in your local environment.