:green_book: SheetJS Community Edition -- Spreadsheet Data ToolkitProject mention: Tips for Making a Popular Open-Source Project in 2021 [Ultimate Guide] | news.ycombinator.com | 2021-11-12
Maybe a story from a maintainer would help. To contextualize, the main SheetJS open source project https://github.com/SheetJS/sheetjs has over 28K stars.
tl;dr: the project involves "crowdsourced research" which benefits from popularity.
The main social goal with the project is data preservation and integrity. Large-scale economic and political decisions are made from data and analyses in spreadsheets. For example, last year in the UK, COVID cases were underreported thanks to Excel minutiae https://www.bbc.com/news/technology-54423988
Due to various corporate stratagems, the older data representations were intentionally obfuscated. To support Excel, many developers poked around at Excel files and guessed at the structures.
In this environment, the biggest challenge is finding worksheets with random corner cases. These types of files are not easy to create and fuzzing has limited effectiveness. This is where open source and popularity come into play. The open source and JS nature of the project helps reduce testing friction (https://oss.sheetjs.com/ runs in the web browser, no need to install anything) and encourage bug reports with test cases.
There will always be "entitled users" and "low quality bug reports" but that comes with the territory. There are also meaningful issues and code contributions. Efforts at trying to prevent the low quality contributions also discourage higher quality contributions.
An easy-to-use and promise-based multi SQL dialects ORM tool for Node.jsProject mention: How do you track the fanfics you read? | reddit.com/r/HPfanfiction | 2021-12-05
Sequelize to interact with an Sqlite database.
Scout APM: A developer's best friend. Try free for 14-days. Scout APM uses tracing logic that ties bottlenecks to source code so you know the exact line of code causing performance issues and can get back to building a great product faster.
MongoDB object modeling designed to work in an asynchronous environment.Project mention: Why is mongoose typed so loosely? | reddit.com/r/typescript | 2021-11-20
Never used it personally. But just having a quick look at their github project...
An SQL-friendly ORM for Node.jsProject mention: I used Typeorm in one of our projects and I have nothing but regrets | reddit.com/r/node | 2021-10-02
And if you want an ORM, you can add Objection which uses knex:
A simple Node.js ORM for PostgreSQL, MySQL and SQLite3 built on top of Knex.jsProject mention: How to get randomly sorted recordsets in Strapi | dev.to | 2021-11-12
First, we need to get all recordsets randomly sorted. To achieve this, we will need to build a query. Strapi is using Bookshelf as an ORM. So we can start by getting our Partnership model, so we can run a query on it. Inside the query, we get a knex (this is the query builder that Bookshelf uses under the hood) query builder instance. On this query builder instance, we can there ask to order recordsets randomly. Let's try this:
An adapter-based ORM for Node.js with support for mysql, mongo, postgres, mssql (SQL Server), and moreProject mention: Best Node.js ORM? | reddit.com/r/node | 2021-06-30
Object Relational Mapping
Run Linux Software Faster and Safer than Linux with Unikernels.
Yes. You can also take at the pg-promise library. https://github.com/vitaly-t/pg-promise
Microsoft SQL Server client for Node.jsProject mention: Need some guidance - Web browser based apps with MS SQL | reddit.com/r/learnprogramming | 2021-11-10
What you can do is use Node.js along with the mssql library to build your site. You can either use templates and render pages on the server, or you can build out an API and write your browser client in a framework like React or Angular.
🍹 MongoDB ODM for Node.js apps based on Redux
📇 Generates and parses MongoDB BSON UUIDs
Need some guidance - Web browser based apps with MS SQL
1 project | reddit.com/r/learnprogramming | 10 Nov 2021
looking for package which can copy values from excel -> html p, h2,h3 etc
1 project | reddit.com/r/npm | 8 Nov 2021
SheetJS - Missing data after modifying xlsm then using sheet_to_txt
1 project | reddit.com/r/node | 3 Nov 2021
Which nodejs ORM is closest to Django?
2 projects | reddit.com/r/django | 28 Oct 2021
Installing from NPM on Existing Project
1 project | reddit.com/r/node | 27 Oct 2021
Transitioning from MySQL to MongoDB
2 projects | dev.to | 25 Oct 2021
Looking for a mentor who can teach me backend using node js.
1 project | reddit.com/r/node | 21 Oct 2021
Are you hiring? Post a new remote job listing for free.