Sonar helps you commit clean code every time. With over 300 unique rules to find JavaScript bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work. Learn more →
Top 23 JavaScript MySQL Projects
-
Strapi
🚀 Strapi is the leading open-source headless CMS. It’s 100% JavaScript, fully customizable and developer-first.
Strapi is the leading open-source headless CMS based on NodeJS, and its projects can vary a lot between themselves, but also Kubernetes provides a lot of flexibility. Therefore, it's worth investing some time in the best practices to integrate them.
-
Sequelize
Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL Server, Snowflake, Oracle DB (v6), DB2 and DB2 for IBM i.
Project mention: Using a MySQL database to serve multiple guilds | reddit.com/r/Discord_Bots | 2023-01-21If you like the OOP paradigm and you don't know a lot of the SQL syntax i also suggest looking for an ORM, which abstracts query language the language you're using like https://sequelize.org/
-
Appwrite
Appwrite - The Open Source Firebase alternative introduces iOS support . Appwrite is an open source backend server that helps you build native iOS applications much faster with realtime APIs for authentication, databases, files storage, cloud functions and much more!
-
Project mention: I made the most customizable 2048 game you have ever played. | reddit.com/r/2048 | 2022-11-24
Hmm... I'm not sure why you get a "Loading..." I don't even remember adding a "Loading..." so I'm not sure what that's from. Yes, I do have a account system in place using a database. I am using Node.js and have a mysql backed account system. It requires a bit of setup to get MySQL running on your machine (depending on your operating system), but it's super easy to use on your local system if you have the environment setup. It's a bit more challenging once you take it online; I have a digital ocean droplet that's running this service and a couple more personal projects as well, which does come with a cost to have online. But at least using locally you can build something for free and then when you want you can take it online.
-
Knex
A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.
How does HN receive SQL builders in general? I feel like most of us agree ORMs are typically a bad idea. I feel like that almost instantly leaves the need for "something" to take its place. In my experience, it's typically been a query builder like this.
I've also tried:
https://www.npmjs.com/package/sql-template-strings ("out of date" since like 2016? https://www.npmjs.com/package/sql-template-tag might be better)
Are query builders an anti pattern? People who are doing serious/logic heavy stuff with SQL, how do you avoid a query builder (if at all?)
-
Project mention: Is there a 'batteries included' backend framework like Django, but written in JS? | reddit.com/r/learnjavascript | 2022-03-06
If you're set on JS (using only one language on a team/project can be very nice) common choices for backend often involve using Express or hapi with some ORM (like Prisma or Bookshelf).
-
Project mention: Show HN: Slashbase – open-source collaborative IDE for databases in browser | news.ycombinator.com | 2022-11-07
Hey!
Just a few weeks ago I was searching for such a solution (IDE for databases in browsers without viz) and I found a bit old but still very good and simple to use project https://github.com/sqlpad/sqlpad/
-
Project mention: What is the best web-based PostgreSQL for Workshop | reddit.com/r/PostgreSQL | 2022-10-05
Would https://franchise.cloud be any use?
-
Sonar
Write Clean JavaScript Code. Always.. Sonar helps you commit clean code every time. With over 300 unique rules to find JavaScript bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.
-
You can see everything that is exported from the TypeScript declaration files such as the mysql2's index.d.ts where it lists that in fact, yes there is a export function createConnection
-
-
-
Project mention: Show HN: Glue4 is a Redux extension that handles your back end concerns | news.ycombinator.com | 2022-12-19
Thank you for the details.
The databases integrations looks similar to keyv https://www.npmjs.com/package/keyV
-
Chartbrew
Open-source web platform used to create live reporting dashboards from APIs, MongoDB, Firestore, MySQL, PostgreSQL, and more 📈📊
Project mention: Those making $500/month on side projects in 2023 – Show and tell | news.ycombinator.com | 2023-01-22I'm working part-time on my project https://chartbrew.com
It's an open-source data visualization and reporting platform that I started in 2018, I abandoned in 2019, then resumed working on it more seriously in 2020.
Currently, the platform is doing $1,138 in MRR from then managed hosting service and has made over $11k in revenue so far. It's been growing steadily in the last few months but going through a rough Dec-Jan period at the moment. You can see the open page at https://chartbrew.com/open
Onwards and great job everyone at working to make side projects work for you!
-
Project mention: Looking for selfhosted software for tracking repairs at a repair shop and interfacing them with a customer (i.e. ticketing software). | reddit.com/r/selfhosted | 2022-09-04
- OpenSupports: https://github.com/opensupports/opensupports. There is a demo environment that you can test: https://www.opensupports.com/demo/
-
Stackoverflow-Clone-Frontend
Clone project of a famous Q/A website for developers built using MySQL, Express, React, Node, Sequelize :globe_with_meridians:
Stackoverflow Clone - https://github.com/Mayank0255/Stackoverflow-Clone-Frontend
-
Project mention: Architecture Pitfalls: Don’t use your ORM entities for everything — embrace the SQL! | reddit.com/r/programming | 2023-01-12
Furthermore, there can be a lot of boilerplate queries we do that it's nice to not have to write, say, the same kind of delete query over and over. In the past I've used gnorm as one way of generating all that boilerplate code based on the actual database design, and it works reasonably well, but again it plays a similar role to an ORM.
-
Project mention: Open-source Ecommerce platform built with Node.js and React. | reddit.com/r/SideProject | 2023-02-01
And this is link for document site: https://evershop.io
-
ReactJS-Spring-Boot-CRUD-Full-Stack-App
Learn how to develop a full-stack CRUD application using React as frontend and spring boot as backend.
Project mention: How to create many to many relationship? SpringBoot+React.js | reddit.com/r/SpringBoot | 2022-02-25I'm doing this project: https://github.com/RameshMF/ReactJS-Spring-Boot-CRUD-Full-Stack-App
-
Project mention: Finding an Authorization Bypass on My Own Website | news.ycombinator.com | 2022-03-05
As a security professional, I was horrified to find out that the maintainers don't consider this a security issue, though they did promise to take this seriously and change the API when they were made aware of it in 2014 (https://github.com/mysqljs/mysql/issues/731).
So I bumped an issue, noting this is all over HN, and offered to write a pull request for the API change proposed by the maintainers:
https://github.com/mysqljs/sqlstring/issues/60
Doug agreed to accept such a request, so I just sat down to figure out the code and a reasonable upgrade plan.
Three hours later, I proudly wrote Doug this email (pasting it here because the issue and codebase are locked to non-contributors so I had to send it via email):
OK, I have a draft pull request ready. Of course, it's a big change and I expect to get a lot of feedback and have a few rounds of back and forth and fixups before it is accepted.
This is the plan as I envision it:
* Release SqlString 3.0.0 that has a new allowObjectValues parameter defaulting to false. This is a new major, so it shouldn't break anybody's code.
-
ant-simple-pro
简洁，美观，快速上手，支持3大框架(vue3.0,react,angular,typescript)；Concise, beautiful, quick to get started, support 3 big frameworks
-
-
ℹ️ I tried many different ways of getting a reliable binlog stream using typescript libraries and failed. I tried https://github.com/nevill/zongji, mysql2 (which didn't actually use the ROW format) and hacking on the normal mysql npm library myself. This python module which the AWS Blog: Streaming Changes in a Database with Amazon Kinesis uses was much faster to get going.
-
-
-
InfluxDB
Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.
NOTE:
The open source projects on this list are ordered by number of github stars.
The number of mentions indicates repo mentiontions in the last 12 Months or
since we started tracking (Dec 2020).
The latest post mention was on 2023-02-03.
JavaScript MySQL related posts
- Best Clone Projects On Github!!
- best PHP book for 2023?
- Promises, Thenables, & Lazy-evaluation: What, Why, How
- how to know what to import?
- Help with my small Edtech startup.
- Knex.js SQL injection vulnerability, unpatched for 6 years
- New post: Is Prisma better than your 'traditional' ORM?
-
A note from our sponsor - Sonar
www.sonarsource.com | 4 Feb 2023
Index
What are some of the best open-source MySQL projects in JavaScript? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | Strapi | 51,565 |
| 2 | Sequelize | 27,388 |
| 3 | MySQL | 17,649 |
| 4 | Knex | 17,061 |
| 5 | Bookshelf | 6,306 |
| 6 | sqlpad | 4,712 |
| 7 | franchise | 3,941 |
| 8 | node-mysql2 | 3,321 |
| 9 | orm2 | 3,076 |
| 10 | LimeSurvey | 2,164 |
| 11 | Keyv | 2,008 |
| 12 | Chartbrew | 976 |
| 13 | OpenSupports | 755 |
| 14 | Stackoverflow-Clone-Frontend | 476 |
| 15 | gnorm | 471 |
| 16 | evershop | 465 |
| 17 | ReactJS-Spring-Boot-CRUD-Full-Stack-App | 413 |
| 18 | sqlstring | 364 |
| 19 | ant-simple-pro | 363 |
| 20 | mlcraft | 363 |
| 21 | zongji | 357 |
| 22 | rdb | 291 |
| 23 | sqliterally | 256 |
Build time-series-based applications quickly and at scale.
InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.
www.influxdata.com