mapzy VS node-sqlite3

I haven an open-source app (it's a store finder) that also uses Docker and Redis. Have a look at the GitHub repo, maybe there's something to help you there in my setup?

Mapzy is a store finder, and like Fugu it focuses on simplicity. Again, I've created it because the store finders out there were either ugly, too complex and/or expensive, and not privacy-focused. Read more on mapzy.io

If you're interested in the code, have a look at location_imports_controller.rb, location_import.rb, and batch_geocode_worker.rb.

I contribute to Our World In Data [0] and some of the Rails repos. I also run my own open source projects [1][2].

I've just recently started doing it, and I only put in a few hours each week. Slow and steady wins the race. My motivation is three-fold: First, it's gratifying to give something back to software I love using for free. Second, I learn a lot. Third, if I ever want to work with one of the companies who are stewarding these repos, it gives me a leg up in the application process.

0: https://github.com/owid/owid-grapher

1: https://github.com/shafy/fugu

2: https://github.com/mapzy/mapzy

I've been trying out Jekyll for a new side project's static website and of course added my favorite CSS framework, Tailwind, into the mix. However, after adding Tailwind with PostCSS I began to see very slow build times. Generating the site went from less than a second to more than 30 seconds. Waiting this long to see every change you do makes working with Jekyll impossible.

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