bookshelf.js Archives

MySQL degrading performance over many (~10-100K) short select queries

November 26, 2022 by Magenaut

I’m currently building an app on Node with MySQL database where on the initial run I have to calculate ~250M items. Each calculation takes 3 SELECT statements.
I’m testing with a couple of thousands for now to understand what affects the performance. I’m seeing weird behaviour. Initially calculations run really quick, 1k gets processed in under a second. Then, after some (~20k) thousands are run it slows down to about 4 seconds per 1k.

Unit testing with Bookshelf.js and knex.js

October 4, 2022 by Magenaut

I’m relatively new to Node and am working on a project using knex and bookshelf. I’m having a little bit of trouble unit testing my code and I’m not sure what I’m doing wrong.

How to resolve promises when using app with REPL

October 1, 2022 by Magenaut

I’ve got a basic Node webserver (Koa.js + a ORM). I like to start it with a REPL meaning I can use my app like a CLI-tool.

make async call inside forEach

September 30, 2022 by Magenaut

I am trying to iterate thru array of objects and add some stuff inside these objects using async function in Node.js.

Sort Bookshelf.js results with .orderBy()

September 27, 2022 by Magenaut

I am working on a personal project to learn Node.js + express + Bookshelf.js. Where do I build queries? In particular, how do I simply set an ‘ORDER BY’ or ‘WHERE’ in the following code?

bookshelf.js count method

September 26, 2022 by Magenaut

I was searching high and low to find how to do basic counting (like SELECT COUNT(something) FROM table) with Bookshelf.js, but to no avail. Is there anything I’m missing? Or is it just used with a manual select query?

Bookshelf.js – how to save many-to-many relationship?

September 26, 2022 by Magenaut

I’m having troubles saving data in a “many-to-many” relationship.