--- title: "Node experiments with adding SQLite" publication: "Node Weekly" issue: 539 published_at: "2024-07-09" canonical_url: "https://nodeweekly.com/issues/539" --- Plus now you can pretend you're using Mongo while using Postgres. | #​539 — July 9, 2024 [Read on the Web](https://nodeweekly.com/issues/539) Together with [![Memetria\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_600,h_145/e_make_transparent/co_white,e_outline:7/vvpdctzacmq3xehpvwps.png)](https://dashboard.memetria.com/nodeweekly/) ![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/usoeosjrughpuajgldex.jpg)](https://github.com/nodejs/node/pull/53752) [Node to Get SQLite Built-In?](https://github.com/nodejs/node/pull/53752) — Deno has its own [built in key/value store](https://deno.com/blog/kv) powered by SQLite – perhaps Node could gain similar powers by this initial effort to bake SQLite into the Node distribution. **It's early days,** but interesting to see. [More discussion here](https://github.com/nodejs/node/issues/53264). Colin Ihrig et al. [Node v22.4.1 (Current) and Others Released](https://nodejs.org/en/blog/release/v22.4.1) — Releases to fix an incomplete fix of [an earlier vulnerability](https://nodejs.org/en/blog/vulnerability/april-2024-security-releases-2#command-injection-via-args-parameter-of-child_processspawn-without-shell-option-enabled-on-windows-cve-2024-27980---high) on Windows, as well as a vulnerability relating to bypassing network import restrictions by use of `data:` URLs. [Node v20.15.1 (LTS)](https://nodejs.org/en/blog/release/v20.15.1) and [v18.20.4 (LTS)](https://nodejs.org/en/blog/release/v18.20.4) have also been released with said fixes. Rafael Gonzaga [![\](https://copm.s3.amazonaws.com/d153c302.png)](https://dashboard.memetria.com/nodeweekly/) [Memetria: Redis Hosting for Serious Developers](https://dashboard.memetria.com/nodeweekly/) — Memetria provides secure, scalable hosting with features that enhance your development experience, including large key tracking and detailed performance metrics. Keep your production apps fast with better and uptime. Memetria sponsor [Moving from Express to Fastify (Part 1)](https://blog.val.town/blog/fastify/) — Express has outlasted a lot of change in the Node.js world and still forms the basis of most Web-facing Node apps. Nonetheless, there are other compelling options, and the [Val Town](https://www.val.town/) platform shares its story of making the move to [Fastify](https://fastify.dev/). Tom MacWright (Val Town) [`pnpm` 9.5 Introduces _Catalogs_](https://socket.dev/blog/pnpm-9-5-introduces-catalogs-shareable-dependency-version-specifiers) — [pnpm](https://pnpm.io/) is a popular efficiency-focused npm alternative. A new _Catalogs_ feature enables shareable dependency version specifiers, reducing merge conflicts and improving support for monorepos. Sarah Gooding (Socket) [Behind the Code: A Discussion with Backend Experts](https://sentry.io/resources/behind-the-code-a-discussion-with-backend-experts/?utm_medium=paid-community&utm_source=nodeweeklys&utm_campaign=fy25q2-backendworkshop&utm_content=newsletter-backendworkshop-register) — July 16, join experts from Node.js, Laravel, Prisma & Supabase to discuss backend trends, challenges, and community. Sentry sponsor 📄 [What's Coming Next for ESLint](https://eslint.org/blog/2024/07/whats-coming-next-for-eslint/) – The new configuration system is “_just the beginning of significant changes_” coming to ESLint. Nicholas C. Zakas 📄 [Vercel Enabling Streaming for All Node.js _Vercel Functions_](https://vercel.com/changelog/vercel-functions-to-enable-streaming-by-default) Vercel 📺 [How I Used GitHub Projects to Move House](https://www.youtube.com/watch?v=UY8pXVBtG5Q) – Not Node specific but a neat way to become familiar with _GitHub Projects._ Michelle 'MishManners' Duke 📄 [How to Parse HTML Programatically in JavaScript](https://blog.apify.com/javascript-parse-html/) Brian Wachira 🛠 Code & Tools [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/vodminnqth1ewp2hrqug.jpg)](https://github.com/4awpawz/snitch) [Snitch: A CLI Tool to Create GitHub Issue Reports](https://github.com/4awpawz/snitch) — Create reports from the issues in your GitHub repos in five different formats. There’s [▶️ a 20 minute screencast](https://www.youtube.com/watch?v=_vUUfBxtSFE) showing off where this can be useful. Jeff Schwartz [Pongo: Write Mongo but Use Postgres](https://github.com/event-driven-io/Pongo) — An interesting idea. Rather than being a _database server_ that ‘speaks’ the MongoDB protocol and uses Postgres on the backend (like [FerretDB](https://github.com/FerretDB/FerretDB)), Pongo's a _PostgreSQL client library_ that presents a Mongo-like interface to Node developers, so you get to use Postgres but act as if you’re using MongoDB. Event-Driven 💡 The author has also [written a blog post](https://event-driven.io/en/introducting_pongo/) going into more detail. 💻 JOBS [Want to kill meetings?](https://docs.google.com/forms/d/e/1FAIpQLSdBPMJathunNduH8LKM5EPcUSIyFGzL3K3zPq_dpOZJ1ImIuQ/viewform) — We’re looking for software engineering leaders to join the beta for a product aiming to do just that. [Apply here](https://docs.google.com/forms/d/e/1FAIpQLSdBPMJathunNduH8LKM5EPcUSIyFGzL3K3zPq_dpOZJ1ImIuQ/viewform). Sleuth [🦸 Full Stack Developer (Remote Job, EU/NA)](https://d4h.link/full-stack-engineer-oc-nodeweekly) — Create groundbreaking software that gives super powers to real life heroes. D4H [pgvector-node: Improved `pgvector` Support for Node.js](https://github.com/pgvector/pgvector-node) — [pgvector](https://github.com/pgvector/pgvector) is rapidly becoming the _de facto_ way to work with vectors in vector similarity search systems in Postgres. This library improves support in node-postgres, Knex.js, pg-promise, Prisma, TypeORM, MikroORM, Drizzle ORM, and others. Andrew Kane [Fabric.js 6.0: A SVG-to-Canvas and Canvas-to-SVG Library](https://github.com/fabricjs/fabric.js) — Provides an interactive object model on top of the HTML5 canvas to make it easier to work with multiple visual elements there. Ideal for the browser but it works with Node too, on top of [node-canvas.](https://github.com/Automattic/node-canvas) Fabric.js - [file-type 19.1](https://github.com/sindresorhus/file-type) – Detect file type from a `Buffer`, `Uint8Array`, or`ArrayBuffer`. It can now read from [web streams too.](https://github.com/sindresorhus/file-type/pull/635) - [milliparsec 3.0](https://github.com/tinyhttp/milliparsec) – _"Tiniest body parser in the universe."_ - [Express Zod API 19.3](https://github.com/RobinTail/express-zod-api) – Schema validation and custom middleware in minutes. - [updtr 4.1](https://github.com/peerigon/updtr) – Update outdated npm modules with _"zero pain™."_ - [Mongoose 8.5](https://github.com/Automattic/mongoose/releases/tag/8.5.0) – Popular MongoDB object modeling library. - [zx 8.1.4](https://github.com/google/zx/releases/tag/8.1.4) – Google's tool for better Node shell scripting. - [Mocha 10.6](https://github.com/mochajs/mocha/releases/tag/v10.6.0) – Test framework for Node & browsers. - [pg-promise 11.9](https://github.com/vitaly-t/pg-promise) – Postgres interface for Node. - [node-jq 6.0](https://github.com/sanack/node-jq) – Node.js wrapper for `jq`. **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|*).