better-sqlite3

The frontend is in Vue. Both the FE and BE are in TypeScript. Parallelism is provided by https://github.com/photostructure/batch-cluster.js/ Metadata reads and writes are via https://github.com/photostructure/exiftool-vendored.js/ Persistence is via SQLite: https://github.com/WiseLibs/better-sqlite3 Image transforms are via Sharp: https://sharp.pixelplumbing.com/ My more nerdier blog posts are tagged here: https://photostructure.com/tags/coding/

It would be great to have some benchmarks against better-sqlite and the regular sqlite libraries, like in https://github.com/WiseLibs/better-sqlite3

I tried to replace SQLite with DuckDB for a customized install of better-sqlite3[1] and failed. [1] https://github.com/JoshuaWise/better-sqlite3

Best option for SQlite with node is this. https://github.com/JoshuaWise/better-sqlite3 Author is all over the issues section, and seems very knowledgeable about how SQLite works.

When I worked as an employee I contributed mostly just with docs fixes or bug reports (and not that often). I think it's mostly a mindset of seeing an issue yourself and noticing that others probably also are confused or misled by something so you go and report it! Now that I'm working full-time on open-source and my own company I can contribute more easily to projects like upgrading SQLite source in a few bindings libraries [0], [1], [2] when 3.38 came out. If anyone is interested in contributing to open-source and wants a bit more guidance though I have a number of good "first timer" projects related to data tooling for [3]. Only expectation is that you have some experience with Go. Join discord.multiprocess.io, go to the #dev channel and say hi! [0] https://github.com/mattn/go-sqlite3/pull/1019 [1] https://github.com/mapbox/node-sqlite