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! Learn more →
👩💻👨💻 Awesome cheatsheets for popular programming languages, frameworks and development tools. They include everything you should know in one single file.Project mention: Cool Github repositories for Everyone | dev.to | 2022-12-29
📗 SheetJS Spreadsheet Data Toolkit -- New home https://git.sheetjs.com/SheetJS/sheetjsProject mention: Product Comparison App (JS Demo Project) | dev.to | 2023-02-04
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!
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/
MongoDB object modeling designed to work in an asynchronous environment.Project mention: Building a RESTful API With Functions | dev.to | 2023-01-29
A custom NodeJS OpenFaaS template that uses MongoDB and Mongoose to manage the data models
I just finished the first stable version of go-store, a lightweight embeeded database written in pure Go. It was heavily inspired by lowdb. The motivation was that I needed something simple to store information for another project and that I wanted to try out Go's generics.
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?)
An open source cybersecurity protocol for syncing decentralized graph data.Project mention: Meet OctoBase - AFFiNE's local-first, collaborative open-source database! | reddit.com/r/rust | 2023-01-31
:koala: - PouchDB is a pocket-sized database.Project mention: Recommend an embedded database for use in Electron app | reddit.com/r/electronjs | 2022-12-28
I have used pouchdb as an embedded db for electron - API and performance were not the best, but that was the price to pay for the requirements.
Maybe you can try to use some SQL database compiled as Web Assembly Modules? Like this one for example: https://github.com/sql-js/sql.js
PostgreSQL client for node.js.Project mention: What is your development stack for 2023? | reddit.com/r/node | 2023-01-09
node-postgres (raw sql, without ORM)
🔥 A well-tested feature-rich modular Firebase implementation for React Native. Supports both iOS & Android platforms for all Firebase services.Project mention: Im in a HUGE pinch for a group project thats due in a week, please help (advice desperately needed). | reddit.com/r/reactnative | 2023-01-15
If you have to fetch and persist out of the app, then use firebase firestore with https://rnfirebase.io/.
🍉 Reactive & asynchronous database for powerful React and React Native apps ⚡️Project mention: Starting React Native Project in 2023 | dev.to | 2023-01-06
A Minimalistic Wrapper for IndexedDBProject mention: SvelteKit: Use local database in the browser | reddit.com/r/sveltejs | 2023-01-26
Dexie works swell with SvelteKit. https://dexie.org
The Missing Web UI for Elasticsearch: Import, browse and edit data with rich filters and query views, create search UIs visually.Project mention: macOS Dev Setup | dev.to | 2022-11-06
However, if you prefer a graphical interface, you can take a look at Dejavu. You can easily install it via the Dejavu Chrome Extension.
Peer-to-Peer Databases for the Decentralized WebProject mention: orbit-db VS db3 - a user suggested alternative | libhunt.com/r/orbit-db | 2023-01-15
An SQL-friendly ORM for Node.jsProject mention: Simple postgres 'ORM' for node project? | reddit.com/r/node | 2023-01-19
If you aren't using TypeScript I'd very much recommend Objection.js, I've used it multiple times and no complaints so far. You can pass raw SQL queries to it as well so I'm sure it would be a good fit for your project!
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).
An adapter-based ORM for Node.js with support for mysql, mongo, postgres, mssql (SQL Server), and more
during development we use mirage JS to spin up an in-browser mock server which returns mock data for any API endpoints not currently implemented by the real backend. during integration testing we configure this server to return mock data for all API endpoints in the system, giving us a fixed environment against which our tests can run. test suites can be run in parallel since each time a playwright page is opened a new copy of the webapp, and thus a new copy of the mock server, is launched. these integration tests run whenever a frontend PR is opened or updated.
Postgres.js - The Fastest full featured PostgreSQL client for Node.js and Deno (by porsager)Project mention: Well, shit. Objection.js has been sunset, which ORM/querybuilder did you move to? | reddit.com/r/node | 2022-12-03
About a year ago I moved to raw SQL using Postgres.js. Honestly I thought it would be traumatic but it's been great so far.
A wrapper for abstract-leveldown compliant stores, for Node.js and browsers.
🍟 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?
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.
3 projects | reddit.com/r/react | 1 Feb 2023
Adding real-time full-text search to a Next.js app with Tigris
5 projects | dev.to | 2 Feb 2023
Data Store with Nucleoid (Low-code Backend)
2 projects | dev.to | 31 Jan 2023
D&D 5th Edition SRD as JSON objects
1 project | news.ycombinator.com | 30 Jan 2023
Ask HN: Why are so many PHP projects moving to Node?
6 projects | news.ycombinator.com | 26 Jan 2023
Which ORM do you prefer with nodejs/Typescript project and why ?
2 projects | reddit.com/r/node | 25 Jan 2023
Promises, Thenables, & Lazy-evaluation: What, Why, How
2 projects | dev.to | 23 Jan 2023
A note from our sponsor - Appwrite
appwrite.io | 5 Feb 2023