--- title: "All the ways to use Postgres from Node" publication: "Node Weekly" issue: 488 published_at: "2023-05-30" canonical_url: "https://nodeweekly.com/issues/488" --- Plus must-see news for Oracle users, Got 13, and playing some bebop. | #​488 — May 30, 2023 [Read on the Web](https://nodeweekly.com/issues/488) Together with [![Temporal logo\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_451,h_112/e_make_transparent/co_white,e_outline:7/cqly2c0y8ng0dhzk9qpx.png)](https://learn.temporal.io/courses/temporal_101/typescript?utm_source=CooperPress&utm_medium=CooperPress&utm_campaign=temporal-101-typescript&utm_content=temporal-101-typescript) ![Node.js Weekly](https://res.cloudinary.com/cpress/image/upload/v1653576619/lgfqinzbdqttwmhvljxb.png) [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/gbkb41mytt3anoi0xhjr.jpg)](https://www.youtube.com/watch?v=4QN1BzxF8wM) ▶['I Tried 8 Different Postgres ORMs'](https://www.youtube.com/watch?v=4QN1BzxF8wM) — A modern, fast-paced, and slightly irreverent meme-heavy look at the various ways in which you can interact with Postgres (provided serverless by [Neon](https://neon.tech/), in this case) from a backend JavaScript app. It’s pretty neat as whirlwind tours go. _(9 minutes.)_ Beyond Fireship 🐘 And if you're a Postgres user, [we have a newsletter for that!](https://postgresweekly.com/) [Advanced Fastify: Hooks, Middleware, and Decorators](https://blog.appsignal.com/2023/05/24/advanced-fastify-hooks-middleware-and-decorators.html) — [Fastify](https://www.fastify.io/) is an increasingly common alternative to Express ([more on why here](https://blog.appsignal.com/2023/04/26/getting-started-with-fastify-for-nodejs.html)). Damilola looks at some higher level Fastify concepts here, as well as how you might incrementally migrate from Express to Fastify. Damilola Olatunji [![\](https://copm.s3.amazonaws.com/1d226efc.png)](https://learn.temporal.io/courses/temporal_101/typescript?utm_source=CooperPress&utm_medium=CooperPress&utm_campaign=temporal-101-typescript&utm_content=temporal-101-typescript) [Temporal 101 Course in TypeScript](https://learn.temporal.io/courses/temporal_101/typescript?utm_source=CooperPress&utm_medium=CooperPress&utm_campaign=temporal-101-typescript&utm_content=temporal-101-typescript) — Learn Temporal's open source key concepts and best practices with our free self-paced training course in TypeScript. Temporal Technologies sponsor [Color Names: A Gigantic List of Handpicked Color Names](https://github.com/meodai/color-names) — At first, I thought this was just going to be a hundred or so obvious choices like the named colors in HTML ([💜 `rebeccapurple`](https://medium.com/@valgaze/the-hidden-purple-memorial-in-your-web-browser-7d84813bb416)) but it’s actually _30126_ colors with a delightful array of names and uses. There’s more to this project than meets the eye. David Aerne **IN BRIEF:** - The folks at Deno have written about how [Deno Deploy now supports importing Node.js built-in modules](https://deno.com/blog/node-builtins-on-deploy) such as `http`, `fs`, and `path`, making it easier to run existing Node apps on their platform. - A look at the [security implications of various HTTP response headers](https://snyk.io/blog/security-implications-of-http-response-headers/) and how [Helmet](https://snyk.io/advisor/npm-package/helmet) lets you work with them in Express apps. - [npmjs.com](https://npmjs.com/) has gained [a variety of accessibility improvements.](https://github.blog/changelog/2023-05-16-accessibility-improvements-for-npmjs-com/) [Deploying Vanilla Node.js Apps on Fly.io](https://fly.io/blog/vanilla-candy-sprinkles/) — Actually titled _“Vanilla with Candy Sprinkles”_, this post covers the basics of using Fly’s next-gen hosting platform to quickly deploy Node apps (we have no affiliation with Fly but use it for some internal apps – it’s pretty good). Sam Ruby (Fly) ▶[Building a RESTful API with Fastify, MongoDB and Mongoose](https://www.youtube.com/watch?v=ACVBMrgdXgE) — A substantial first part of a promised series of videos, along with [the code.](https://github.com/doingandlearning/building-an-api/tree/first-video) Kevin Cunningham 🛠 Code & Tools [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/g1mw8jeqak1pivxfbcuo.jpg)](https://github.com/betwixt-labs/bebop/releases/tag/v2.7.0) [Bebop 2.7: Fast, Typesafe Binary Serialization](https://github.com/betwixt-labs/bebop/releases/tag/v2.7.0) — Schema-based, typesafe, binary serialization and code generation that supports numerous languages, including TypeScript. Has a built in REPL for playing with the code generation which has had some big improvements in this release. (Its [homepage](https://bebop.sh/) has a neat bit of ASCII art.) Betwixt Labs [Got 13: A Powerful HTTP Request Library for Node](https://github.com/sindresorhus/got) — A popular HTTP request library. [v13](https://github.com/sindresorhus/got/releases/tag/v13.0.0) requires Node 16 and makes Unix socket support off by default. Sindre Sorhus [🚀 Need to Upgrade React Native from V0.59 to V0.71? We Can Help 🚀](https://go.upgradejs.com/lqu) — Read the full case study on our bold upgrade strategy (regenerating the ReactNative project) to reduce tech debt. UpgradeJS | JS Upgrade Services sponsor [node-oracledb 6.0: A Pure JS Oracle Database Driver](https://medium.com/@sharad-chandran/usher-in-a-new-era-with-the-node-oracledb-6-0-pure-javascript-thin-driver-e10e2af693b2) — A major release for the Oracle Database driver which can now be used [in ‘thin’ and ‘thick’ modes](https://itnext.io/how-do-i-choose-between-thin-and-thick-modes-in-node-oracledb-6-0-c516d202a71f) providing either the essentials or the full fat Coke version (which requires some extra Oracle client libraries to be installed). Sharad Chandran [Migrate 2.0: An Abstract Migrations Framework](https://github.com/tj/node-migrate) — Provides a simple _mechanism_ around working with migrations without enforcing any particular database or system. TJ Holowaychuk [axios-token-manager: Manage the Caching of Axios Tokens](https://github.com/mickeypuri/axios-token-manager) — For managing the caching of auth tokens for specified validity periods as well as refreshing _or_ recovering them transparently (such as when the backend has revoked a token before its period has expired.) Mickey Puri 💻 Jobs [Find Tech Jobs with Hired](https://hired.com/join/?utm_source=newsletter&utm_medium=sponsor&utm_campaign=%28b2c%29%28l-all%29%28r-all%29%28cooper-nodeweekly%29&utm_content=find-your-next-job) — Hired makes job hunting easy-instead of chasing recruiters, companies approach you with salary details up front. Create a free profile now. Hired [CSV Parse: Convert CSV Text into Arrays / Objects](https://csv.js.org/parse/) — Extends the native Node.js transform stream API so you can get up and running quickly – see [some example code.](https://csv.js.org/project/examples/) Part of [a suite of CSV libraries](https://csv.js.org/) that can also generate and transform CSV more generally. Adaltas [Jest Puppeteer 9.0: Run Tests using Jest and Puppeteer](https://github.com/argos-ci/jest-puppeteer/) — A Jest preset enabling end-to-end testing with [Puppeteer.](https://pptr.dev/) Argos CI [sequelize-paranoid-delete: `onDelete` for Sequelize Paranoid Mode](https://github.com/ReMatter/sequelize-paranoid-delete) — It sounds like a Radiohead song title, but actually enables `onDelete` when using paranoid mode with Sequelize. (Paranoid mode is an option where rows are not truly deleted but _marked_ as deleted.) Nico Gallinal [node-xlsx: An Excel File Parser and Builder](https://github.com/mgcrea/node-xlsx) Olivier Louvignes **Got a link for us?** Reply and tell us. We can't include everything but we'll look at anything you send. _Thanks!_ --- **Sponsorship:** Email `[kristina@cooperpress.com](mailto:kristina@cooperpress.com)` for details. --- Published by Cooper Press Ltd. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom [Cancel your subscription](https://nodeweekly.com/leave/*|UID|*) or [change your address.](https://nodeweekly.com/edit_subscription/*|UID|*)