|4 days ago||1 day ago|
|Apache License 2.0||MIT License|
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Tips for Making a Popular Open-Source Project in 2021 [Ultimate Guide]
12 projects | news.ycombinator.com | 12 Nov 2021
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.
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
I come on this subreddit as my last chance of finding help, please be kind. So, I'm facing the worst bug in my life rn with the library sheetjs, I am adding some row like this :
1 project | reddit.com/r/learnprogramming | 13 Oct 2021
1 project | news.ycombinator.com | 9 Oct 2021
Any reporting engine in nodejs?
1 project | reddit.com/r/node | 8 Sep 2021
8 Node.js Projects To Keep An Eye On 2021
7 projects | dev.to | 23 Aug 2021
Website -> https://sheetjs.com/
My tiny side project has had more impact than my decade in the software industry
3 projects | news.ycombinator.com | 1 Aug 2021
Our story is very similar. I wrote a small library for converting XLSX and XLS files to CSV. Over the years, that grew into one of the most popular open source libraries on npm/github: https://github.com/SheetJS/sheetjs
Back in 2015, 'patio11 reached out to us. In addition to a structured license purchase, he gave great insights and actually wrote a blog post about the experience https://www.kalzumeus.com/2015/01/28/design-and-implementati...
Today, we offer paid software builds to solve related problems and it allows us to work on SheetJS full-time!
[TypeScript] Read spreadsheets by SheetJS
2 projects | dev.to | 21 Jul 2021
SheetJS - Home2 projects | dev.to | 21 Jul 2021
SheetJS/sheetjs - GitHub
Where is Ruby Headed in 2021?
14 projects | news.ycombinator.com | 18 Nov 2021
TypeORM has a lot of issues but in our case it hasn't caused any major blockers. Most of the time the issue is with documentation and sometimes you run into issues like this: https://github.com/typeorm/typeorm/issues/316.
NestJS on the other hand is very solid. It has good documentation and a good community. We haven't faced any issues with NestJS yet.
How can I use my Oracle Cloud wallet in TypeOrm.io?
1 project | reddit.com/r/node | 16 Nov 2021
OracleDB - problems with TNS options #3484
Why is TypeORM hated so much?
2 projects | reddit.com/r/node | 16 Oct 2021
Majority of the criticism I see is towards it being buggy and not maintained well. I haven't encountered any serious bugs, and the maintenance seems okay to me, according to Github change log and snyk analysis .2 projects | reddit.com/r/node | 16 Oct 2021
This bug is a total showstopper for our app, and it was randomly introduced in a minor version update way back in March: https://github.com/typeorm/typeorm/issues/7736
An overview of TypeORM
1 project | dev.to | 4 Oct 2021
In this post I have tried to discuss the basic topics of TypeORM briefly. Advanced topics like Migration, Indices, Transactions, Listeners, Subscribers etc have not been discussed here. The official document is very elaborative and nicely explained with lots of examples. You are highly encouraged to have a look at it.
Build fast and customizable admin panel with NestJS.
6 projects | dev.to | 4 Oct 2021
TypeORM is definitely the most mature ORM available in the node.js world. Since it's written in TypeScript, it works pretty well with the Nest framework. I chose mysql as database. TypeORM supports many databases (MySQL, MariaDB, Postgres etc.)
query builder problem
1 project | reddit.com/r/Nestjs_framework | 29 Sep 2021
From the docs
Does anyone here actually use TypeORM?
3 projects | reddit.com/r/Nestjs_framework | 14 Sep 2021
Nestjs🐺⚡ | The framework of Nodejs (Part-3) | Database Integration, TypeORM
1 project | dev.to | 5 Sep 2021
This tutorial isn't about TypeORM but I'll give a little explanation of it to get started. You can find more information about it in their docs
How to migrate database data in production?
2 projects | reddit.com/r/node | 26 Aug 2021
Definitely you should use migrations or a schema diffing tool. Usually schema migration is a feature offered by many ORMs e.g. https://github.com/typeorm/typeorm/blob/master/docs/migrations.md You can also handle migrations with a dedicated SQL only tool like migrate https://github.com/golang-migrate/migrate. Or, as a schema diffing tool, afaik the best one is the one from pgadmin https://www.pgadmin.org/docs/pgadmin4/development/schema_diff.html#:~:text=Schema%20Diff%20is%20a%20feature,(from%20source%20to%20target).
What are some alternatives?
Sequelize - An easy-to-use and promise-based multi SQL dialects ORM tool for Node.js
Mongoose - MongoDB object modeling designed to work in an asynchronous environment.
Prisma - Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite & MongoDB (Preview)
Objection.js - An SQL-friendly ORM for Node.js
Entity Framework - EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.
MikroORM - TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases.
Bookshelf - A simple Node.js ORM for PostgreSQL, MySQL and SQLite3 built on top of Knex.js
node-mssql - Microsoft SQL Server client for Node.js
ExcelJS - Excel Workbook Manager
pg-promise - PostgreSQL interface for Node.js
Dapper - Dapper - a simple object mapper for .Net [Moved to: https://github.com/DapperLib/Dapper]