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.
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 - 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!
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.
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://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?)
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).
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
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/
🍟 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?
:zap: fast mysqljs/mysql compatible mysql driver for node.jsProject 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
Object Relational Mapping
The most popular FOSS online survey tool on the web.Project mention: Attention Mercenaries, we need you! | reddit.com/r/WarTalesGame | 2022-12-21
Simple key-value storage with support for multiple backends
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 is a simple and beautiful open source ticket systemProject 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/
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
A database-first code generator for any languageProject 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.
🛍️ NodeJS E-commerce PlatformProject 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
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
Simple SQL escape and format for MySQLProject 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:
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.
简洁，美观，快速上手，支持3大框架(vue3.0,react,angular,typescript)；Concise, beautiful, quick to get started, support 3 big frameworks
Low-code metrics store, modern open-source alternative to Looker
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.
Lightweight SQL query builder
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.
Best Clone Projects On Github!!
5 projects | reddit.com/r/github | 26 Jan 2023
best PHP book for 2023?
1 project | reddit.com/r/PHP | 24 Jan 2023
Promises, Thenables, & Lazy-evaluation: What, Why, How
2 projects | dev.to | 23 Jan 2023
how to know what to import?
2 projects | reddit.com/r/typescript | 16 Jan 2023
Help with my small Edtech startup.
4 projects | reddit.com/r/nextjs | 5 Jan 2023
Knex.js SQL injection vulnerability, unpatched for 6 years
1 project | news.ycombinator.com | 28 Dec 2022
New post: Is Prisma better than your 'traditional' ORM?
5 projects | reddit.com/r/node | 6 Dec 2022
A note from our sponsor - Sonar
www.sonarsource.com | 4 Feb 2023