node-sqlite3 VS neon

Probably wrong import: https://github.com/TryGhost/node-sqlite3/issues/1532

A good example for showing a solution to those questions is the node-sqlite3 package. It's a native module written in C++ and made available as a Node package: https://github.com/TryGhost/node-sqlite3

sqlite3 appears to have this, but there may be some issues as to whether it works. https://github.com/TryGhost/node-sqlite3/issues/419

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 tools. 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-sqlite3/pull/1550

[2] https://github.com/JoshuaWise/better-sqlite3/pull/778

I have had no problems using SQLite itself in Electron, for a desktop project that runs under both Windows and Linux. See https://github.com/mapbox/node-sqlite3

I like to set up a function in the main process with https://github.com/mapbox/node-sqlite3 handling my queries.

Use SQLite to store the data and retrieve it using sqlite3

Hey I would like to use a nextcloud instance to host a sqlite database file, and connect directly to that file, with javascript/Electron and the sqlite3 library.

This sub is for discordjs, not just general javascript and npm issues. Ask sqlite3 package devs about this. https://github.com/mapbox/node-sqlite3

Great interview!

Love how much thought is being put into what you “gold-plate”. I’ve always felt that my best work comes around on round two (or three or four…).

Curious what you are planning for the ability to script the configuration? I haven’t played with zed much yet; is it possible today? Would something like Neon [1] help bridge the gap from VSCode and old Atom users?

[1]: https://github.com/neon-bindings/neon

Neon

Is there a third option? Surely node has a way to directly call native code, similar to Python's C extensions? Some Node equivalent of PyO3? For example, I found neon which promises "safe and fast native Node.js modules".

Have a look at https://crates.io/crates/napi and https://crates.io/crates/neon which allow you to call rust from node. We went with napi but they're both pretty good.

Just to add: N-API is incredibly underrated. Then again, maybe the lack of a strong native modules ecosystem is an indicator that the pure JS ecosystem is just so good. But man, got something computationally intensive? Just offload it to Rust with Neon or something. Got some proprietary bit of code in your product? Build a native module.

> rust is not well-suited for interfacing with FFI

How so? Packages like neon [1] and rustler [2] suggest otherwise. I'm using both of those in a real product (I'm using neon directly, to write native modules for an Electron app; on the back-end, I depend on an Elixir package that uses rustler).

[1]: https://github.com/neon-bindings/neon

[2]: https://github.com/rusterlium/rustler

You can use https://github.com/infinyon/node-bindgen, https://github.com/neon-bindings/neon, or https://github.com/napi-rs/napi-rs for Node.js libraries, https://github.com/PyO3/pyo3 for Python libraries, https://rustwasm.github.io/wasm-bindgen/ for WebAssembly, and https://github.com/rust-lang/rust-bindgen for C libraries!

They can use Rust to speed up Nodejs through https://crates.io/crates/neon for example

I’m not prompted again while actively using my laptop. When it’s time to switch to an open source project, I’m seamlessly prompted for my GitHub key.