JavaScript MySQL

Open-source JavaScript projects categorized as MySQL

Top 23 JavaScript MySQL Projects

  • Strapi

    🚀 Strapi is the leading open-source headless CMS. It’s 100% JavaScript, fully customizable and developer-first.

    Project mention: How to Deploy and Scale Strapi on a Kubernetes Cluster 2/2 | dev.to | 2023-02-03

    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-21

    If 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!

  • MySQL

    A pure node.js JavaScript Client implementing the MySQL protocol.

    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.

    Project mention: Kysely: TypeScript SQL Query Builder | news.ycombinator.com | 2023-01-24

    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://knexjs.org/

    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?)

  • Bookshelf

    A simple Node.js ORM for PostgreSQL, MySQL and SQLite3 built on top of Knex.js

    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).

  • sqlpad

    Web-based SQL editor. Legacy project in maintenance mode.

    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/

  • franchise

    🍟 a notebook sql client. what you get when have a lot of sequels.

    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.

  • node-mysql2

    :zap: fast mysqljs/mysql compatible mysql driver for node.js

    Project mention: how to know what to import? | reddit.com/r/typescript | 2023-01-16

    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

  • orm2

    Object Relational Mapping

  • LimeSurvey

    The most popular FOSS online survey tool on the web.

    Project mention: Attention Mercenaries, we need you! | reddit.com/r/WarTalesGame | 2022-12-21
  • Keyv

    Simple key-value storage with support for multiple backends

    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-22

    I'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!

  • OpenSupports

    OpenSupports is a simple and beautiful open source ticket system

    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:

    Project mention: Best Clone Projects On Github!! | reddit.com/r/github | 2023-01-26

    Stackoverflow Clone - https://github.com/Mayank0255/Stackoverflow-Clone-Frontend

  • gnorm

    A database-first code generator for any language

    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.

  • evershop

    🛍️ NodeJS E-commerce Platform

    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-25

    I'm doing this project: https://github.com/RameshMF/ReactJS-Spring-Boot-CRUD-Full-Stack-App

  • sqlstring

    Simple SQL escape and format for MySQL

    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

  • mlcraft

    Low-code metrics store, modern open-source alternative to Looker

  • zongji

    A mysql binlog listener running on Node.js.

    Project mention: How to Use BinLogs to Make an Aurora MySQL Event Stream | dev.to | 2022-10-03

    ℹ️ 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.

  • rdb

    Javascript ORM

  • sqliterally

    Lightweight SQL query builder

  • 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

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