@databases
TypeScript clients for databases that prevent SQL Injection (by ForbesLindesay)
joist-orm
a TypeScript ORM for Postgres (by joist-orm)
SurveyJS - Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App
With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.
surveyjs.io
featured
@databases | joist-orm | |
---|---|---|
13 | 12 | |
588 | 234 | |
- | 2.1% | |
5.7 | 9.7 | |
about 1 month ago | 5 days ago | |
TypeScript | TypeScript | |
MIT License | - |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.
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.
@databases
Posts with mentions or reviews of @databases.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-09-30.
-
Node Core Dev Starter Kit
At Databases because you don't need ORM.
-
Looking for a type safe ORM/mapper
Depending on the complexity of your queries, Prisma might indeed not be the best abstraction for you. If you're proficient in SQL and don't want to sacrifice type-safety, there are really nice, low-level alternatives to Prisma such as Zapatos, Slonik or atdatabases. We're laying this out in our docs here: Should you use Prisma?
-
Top 10 Node.js Security Best Practices
I built https://www.atdatabases.org to make this as easy as possible to get right when querying SQL databases with node.js
-
General ORM question - How costly is not using a SELECT ATTRIBUTES clause?
Depends a lot on the size of your database records. We’ve found that for a few tables with big JSONB columns it can make a huge difference but for 90% of queries it makes very little difference. https://www.atdatabases.org with @databases/pg-typed or @databases/mysql-typed also keeps the types in sync with which columns you select.
-
SQL result into variable
Since the method is marked as async, you can use await to get the results of a query (if your database library supports promises. For example with https://www.atdatabases.org as your db library you could do
-
What are popular ORMs for Node.js?
I found Prisma close but not quite there. That's part of what motivated me to keep working on https://www.atdatabases.org, which I think is already there as an enterprise ready ORM for node.js
- Atdatabases: TypeScript Clients for Databases
-
what node ORM is worth it to learn
I built https://www.atdatabases.org which has an ORM for node.js, but also supports writing SQL queries in a safe way. It is type safe, and has much simpler & more flexible transaction support than most node.js ORMs.
-
Can you use Joi with SQL database?
If you’re using TypeScript and don’t have untrusted user data, @databases can generate static types, which can be a good alternative to runtime validation.
-
How do most people interact with a db these days?
Did either of you consider @databases? It has pretty much the same approach to SQL as Slonik. I’m curious if there’s any reason why Slonik is preferable?
joist-orm
Posts with mentions or reviews of joist-orm.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-04-16.
-
Which ORM would you pick, Prisma or Typeorm
As few comments have already offered alternatives, so I'll mention Joist.
-
Does Typeorm violate the type contract when using relations that aren't explicitly loaded?
I used TypeORM in the past; I had a ton of problems with it. I highly recommend https://joist-orm.io/ instead.
-
What is your favorite way to maintain types and schema in a full stack web app, end-to-end?
Codegen our backend models directly from the db (here a strict 1-1 mapping is a feature imo; we use https://github.com/stephenh/joist-ts/), so we get `Green` added to the backend `Color.ts` for free.
- Joist: An idiomatic ORM library for TypeScript
-
Complex business logic in Node
If you like Rails/ActiveRecord, Joist is our attempt at a "AR-or-better productivity" ORM for TypeScript.
-
Well, shit. Objection.js has been sunset, which ORM/querybuilder did you move to?
Ha, well, as you noted, I'm wary of even bothering to comment :-), but would be great if you checked out Joist: https://joist-orm.io/
-
Looking for a type safe ORM/mapper
Checkout https://github.com/stephenh/joist-ts built from the ground up to be typesafe.
- Ask HN: Who is hiring? (November 2021)
- I used Typeorm in one of our projects and I have nothing but regrets
- What do you think about ORMs?
What are some alternatives?
When comparing @databases and joist-orm you can also consider the following projects:
Lowdb - Simple and fast JSON database
pg-mem - An in memory postgres DB instance for your unit tests
NeDB - The JavaScript Database, for Node.js, nw.js, electron and the browser
beam - 🪵 Beam Design System
database-js - Common Database Interface for Node
graphql-typescript-factories - TypeScript test builders/factories for GraphQL schemas
Keyv - Simple key-value storage with support for multiple backends
studio - 🎙️ The easiest way to explore and manipulate your data in all of your Prisma projects.
Mongo Seeding - 🌱 The ultimate solution for populating your MongoDB database.
kysely - A type-safe typescript SQL query builder
slonik - A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.