I'm working on a typical client-server webapp. It is using a system somewhat like GraphQL where the client has some flexibility in specifying what data it needs, without custom API endpoints for every type of data. The server is running…
(I had originally asked this question on the DBA StackExchange, but didn't get much activity in it). In my DB, I have tables for items and connections between them, creating a likely sparse graph, with islands: CREATE TABLE IF NOT…
Apart from checking that the attributeId is in a list of predefined strings – possible, but in this particular case costly – is there any way to re-write this in a less 'injectable' fashion (since the use of '${attributeId}' is…
I'm working on a script to seed my database but am having issues with my node-pg connection being terminated before my rebuild function is finished. const rebuildDB = async () => { try { client.connect(); await dropTables(); await createTables(); await…