--- title: "SQL in your JavaScript" publication: "Node Weekly" issue: 472 published_at: "2023-02-02" canonical_url: "https://nodeweekly.com/issues/472" --- Plus a new template for building enterprise-grade Node apps. | #​472 — February 2, 2023 [Read on the Web](https://nodeweekly.com/issues/472) Together with [![AppSignal logo\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_700,h_120/e_make_transparent/co_white,e_outline:7/lme8p344dw1aodshz9px.png)](https://www.appsignal.com/nodejs?utm_source=node-weekly-sponsored&utm_medium=email&utm_campaign=2023-02-02#) ![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/zowjpekij6ka0gv4o9pr.jpg)](https://github.com/alasql/alasql) [AlaSQL.js 3.0: Isomorphic JavaScript SQL Database](https://github.com/alasql/alasql) — A SQL database you can use in Node.js and the browser. The interesting bit, for me, is how it opens up the idea of using SQL to query JavaScript objects – [as in this example](https://jsfiddle.net/8brvex4f/). _“The library adds the comfort of a full database engine to your JavaScript app. No, really.”_ Andrey Gershun [On Building Enterprise-Grade Node Apps](https://www.codeflashbacks.com/announcing-the-enterprise-node-js-service-template/) — A look at [node-service-template](https://github.com/lokalise/node-service-template), a newly open-sourced _“enterprise-grade Node.js service template”_ which covers a lot of best practices through both scaffolding and its dependencies. [Fastify](https://www.fastify.io/) sits at its heart. Igor Savin (Lokalise) [![\](https://copm.s3.amazonaws.com/d179d899.png)](https://www.appsignal.com/nodejs?utm_source=node-weekly-sponsored&utm_medium=email&utm_campaign=2023-02-02) [An Intuitive APM for Node.js Developers](https://www.appsignal.com/nodejs?utm_source=node-weekly-sponsored&utm_medium=email&utm_campaign=2023-02-02) — AppSignal doesn’t just offer Node.js performance monitoring and error tracking. We have a full set of features to monitor your application from A to Z packed in a clear and intuitive interface. All features are included in all plans. AppSignal sponsor [How Node & SWC Can Make a Lightning Fast TypeScript Runtime](https://featurist.co.uk/blog/running-typescript-in-node-with-near-zero-compilation-cost/) — If the added compilation time for TypeScript has irritated you so far, Artem has found a way to get things as fast as possible. Artem Avetisyan **IN BRIEF:** - Popular dev / hosting platform [Netlify has acquired Gatsby,](https://www.gatsbyjs.com/blog/gatsby-is-joining-netlify/) best known as creators of the React-based Gatsby framework. - Maxim Orlov has shared [7 interesting free APIs](https://maximorlov.com/awesome-apis-for-nodejs-projects/) you could integrate into a Node.js project. - [Hacker News discussed](https://news.ycombinator.com/item?id=34536041) an observation that _"many PHP projects are moving to Node."_ [Understanding the GraphQL Type System](https://www.taniarascia.com/graphql-type-system/) — Tania is one of our favorite tech bloggers as everything she writes is so easy to follow without sacrificing the necessary technical details, so if you want to learn more about how GraphQL schemas are structured, this is a handy read. Tania Rascia [Building a Blog with Next.js, AdminJS, and React](https://medium.com/adminjs/building-a-blog-with-next-js-adminjs-and-react-a-simple-step-by-step-guide-8838f4e594a6) — [AdminJS](https://adminjs.co/) is a popular open source administration panel/UI for Node. Adam Frydrych [How To Build Reliable Distributed Systems in Node.js](https://temporal.io/blog/building-reliable-distributed-systems-in-node) Temporal Technologies sponsor [Five Ways to Use `npm audit` to Protect Your Code](https://www.jit.io/blog/npm-audit-to-protect-your-code) Avichay Attlan [Generate Art with DALL·E 2 and Twilio Serverless via SMS](https://www.twilio.com/blog/generate-art-with-dall-e-2-and-serverless-sms) Lizzie Siegle 🛠 Code & Tools [TestCafe 2.3: Node-Based End-to-End Web Testing](https://github.com/DevExpress/testcafe/releases/tag/v2.3.0) — We frequently link to releases of this popular testing tool (the [official homepage](https://testcafe.io/) sells it better than these release notes), but v2.3 is noteworthy for adding a new `create-testcafe` tool to help you interactively generate new TestCafe projects quickly. Experimental ESM support has also made it in. Developer Express Inc. [pg-promise 11.2: Promise-Based Interface for Postgres](https://github.com/vitaly-t/pg-promise) — Originally it was a promisified version of [node-postgres](https://github.com/brianc/node-postgres) but over time it’s added a lot more including automatic connections and transactions, query generation, and more. Vitaly Tomilov [Just Postgres. Made for Developers](https://crunchybridge.com/start?utm_source=cpnd-lk-0127) — Fully-managed, cloud hosted Postgres. Plans starting at $10 a month. Sign-up and find out why developers love us. Crunchy Bridge sponsor [Eta 2.0: Embedded JS Template Engine for Node, Deno, and Browser](https://eta.js.org/) — Boasts being lighter and faster than EJS but with many of the same features (it looks a lot like Ruby’s ERB). [2.0](https://github.com/eta-dev/eta/releases/tag/v2.0.0) is considered a straightforward upgrade for existing users and is focused more on security. [GitHub repo](https://github.com/eta-dev/eta). Ben Gubler [MongoDB Node.js Driver 5.0](https://github.com/mongodb/node-mongodb-native/releases/tag/v5.0.0) — With this release, the official MongoDB driver drops support for callbacks entirely in favor of promises (though [nodejs-mongodb-legacy](https://github.com/mongodb-js/nodejs-mongodb-legacy) can be used to regain callbacks while you migrate). MongoDB, Inc. - [Electron 22.2](https://github.com/electron/electron/releases/tag/v22.2.0) ↳ Cross-platform desktop app platform. _Now updated to Chromium 108._ - [Node-MySQL2 3.1](https://github.com/sidorares/node-mysql2) ↳ Performance-focused MySQL driver. - [Nest 9.3](https://github.com/nestjs/nest) ↳ Popular Node.js app framework. - [Mercurius 12.0](https://github.com/mercurius-js/mercurius/releases/tag/v12.0.0) ↳ GraphQL servers and gateways atop Fastify. - [slugify 2.2](https://github.com/sindresorhus/slugify) ↳ Slugify a string (URLs, filenames, IDs..) - [node-resque 9.3](https://github.com/actionhero/node-resque) ↳ Delayed/background jobs backed by Redis. 💻 Jobs [Backend Engineer, TypeScript (Berlin / Remote)](https://feather-insurance.com/careers/senior-backend-engineer?channel_id=921907) — Thousands of people love our product (see Trustpilot for yourself). Join the team behind it and help us scale. 🚀 Feather [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=easy-job-hunting) — Hired makes job hunting easy-instead of chasing recruiters, companies approach you with salary details up front. Create a free profile now. Hired 📰 Extra, Extra! [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/eugfyuqslahgypqnmtps.jpg)](https://github.com/pathikrit/newswall) [Newswall: Rotate and Display Newspapers on an E-Ink Display](https://github.com/pathikrit/newswall) — The downside is you need a rather large and expensive e-ink display to get the full effect, but.. a cool project nonetheless. Pathikrit Bhowmick **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|*)