Knex
Directus
Our great sponsors
Knex | Directus | |
---|---|---|
94 | 206 | |
18,622 | 25,113 | |
0.9% | 2.3% | |
8.1 | 9.9 | |
1 day ago | 3 days ago | |
JavaScript | TypeScript | |
MIT License | GNU General Public License v3.0 or later |
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.
Knex
-
Create a Blog web app using Adonis.js 6
AdonisJS core team has created/maintains Lucid. It is a SQL query builder, and an Active Record ORM built on top of Knex.
-
Type-safe Data Access in Go using Prisma and sqlc
Now, why not use an ORM? I've seen performance issues too many times with ORMs. I prefer writing my own SQL to avoid surprises. After all, I know the database schema and writing code for a specific purpose very often leads to better performance than generic code. ORMs have to support all kinds of database schemas. I only have to support mine. Having successfully used Knex.js in NodeJS (a popular query builder) in the past, I know writing SQL queries myself is not hard and provides very good performance.
-
Can I create another WordPress that satisfies humanity?
Given the dynamic nature of the schema, we employ Knex, a query builder, for database access.
-
What's wrong with Node.js ORMs? Thousands of issues? Why?
https://www.npmjs.com/package/knex - 779 issues
-
Credentials Leak with Knex
This article will be focused on a security issue that I found in Knex and how to mitigate it, but I'll also talk briefly about the social aspects of this problem.
-
Why SQL is right for Infrastructure Management
SQL is an old, irregular language to work with, but it is better known than HCL and SQL already has it's own Pulumi/CDK in the form of every ORM with introspection (like Javascript's Prisma, Python's Django, Go's XO etc) and QueryBuilder (LINQ, Knex, etc) in whatever programming language you prefer. You probably already know it.
- Help with SQL and Serialport
-
Kysely: TypeScript SQL Query Builder
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?)
-
Promises, Thenables, & Lazy-evaluation: What, Why, How
Of course, this is a trivial example that you probably won’t find in production code, but there are many projects that use lazy-evaluated Promise-like objects. Probably the most common example is with database ORMs and query builders like Knex.js or Prisma.
-
MagLit - Free and Open Source Link Shortener with Privacy, Encryption, Password Protection and more!
why not just use a mariadb or postgres docker image? heck, even sqlite should be fine, given the simplicity of your needs. i work with nodejs myself, i'd highly recommend knexjs for this- it's super flexible!
Directus
-
Form to DB
I don't know, it's something I've wanted many times.
Recently I discovered https://directus.io/ which comes pretty close and it's open source.
-
Open-Source Headless CMS in 2024
Directus: The Shape-Shifting Maverick
-
A Year of Self-Hosting: 6 Open-Source Projects That Surprised Me in 2023
The Backend to Build Anything or Everything | Directus
-
Prismic.io is increasing our price by *1900%* over Christmas
Along those lines, I’ve been happy with Directus as a backend for my little blog.
I using Directus CMS on several projects with pretty complicated flows, api extensions etc. probably there will be some work if you move. I liked Directus is because it's standard SQL I can always move my DB and documents to another solution. I don't use their hosted solution but they have an unlimited offering for $100 / month.
-
Why Is the Django Admin "Ugly"?
It depends on your skillsets, but I'd highly recommend https://directus.io/ especially if you need "slickness" to raise money otherwise try a pyhat stack if you hate javascript.
-
Building a Blog in Django
The admin is extremely unacceptable for anything beyond trivial borderline trivial use cases, and the modifications you'd have to make are just awful especially the more interactive something needs to be. The extremely tight integration between models and the modeladmin is a blessing and curse.
The people who like Django,also tend to overload it to do everything. This makes sense at small companies. The only place I really see Django at large companies is as an api using DRF or something.
For internal admins, I've been lobbying to use https://directus.io/ at my company.
- Show HN: I built a Python web framework from scratch
-
I need recommendations for creating an API. Start from scratch, or are there projects I can build from?
I initially looked into CMS's like Strapi and Directus to possibly handle my admin UI + API all at once. I haven't found anything that looks like it can do this yet, but I'd be very happy to be proven wrong. I would prefer it to be based in .NET or Node.js since I am more familiar with those, but there's no reason I couldn't do PHP either.
-
Pros and cons of off-the-shelf solutions for creating a control panel
- We want a solution that creates CRUD (create, read, update, delete) quickly and requires minimal effort. - We want to be able to create some sort of complex interface if the task requires it. - We make cool, beautiful projects, so we want a visually pleasing solution. - We want the solution to be independent of the language on the back-end, because, for example, we started with PHP, Laravel, but over time node.js, Go appeared in the stack. In short, we want fast, beautiful and custom. We've had time to poke at various off-the-shelf solutions that we've been advised. They're good, but: - they are created specifically for some frameworks / languages like laravel, node.js - they can only generate CRUDs with a rigidly defined structure, where you can't implement or customize anything of your own. - they can't be styled Here's what we've been looking at Control Panels for Laravel: https://demo.backpackforlaravel.com/admin/dashboard Not a very pretty solution in our opinion. And the promo page has nice screenshots, not the demo "well such". https://orchid.software/en/ Not particularly functional, but neatly done https://nova.laravel.com They have a beautiful, but rigidly set strutkrua, you can not create castmon interfaces, stylize them. Just do CRUD and that's it. And it's paid https://filamentphp.com/ Analog to Nova, with essentially the same problems. For node.js: https://adminjs.co Nice promo, and the demo is way behind As standalone dashboards: https://strapi.io/ Very cool, but for other purposes. It's more of an entity builder with an interface and API https://pocketbase.io/ Similarly, it's an entity builder with an interface and API https://directus.io/ This is a backend builder. https://filamentphp.com/It is purely for php, you can't customize styles, you can't create your own interfaces. It is possible to create only tables and forms by template, and we remember that we want flexibility, independence from the language and the ability to create their own interfaces and customize them https://flatlogic.com This is also more of a backend builder. Direct competitors: https://github.com/refinedev/refine https://marmelab.com/react-admin/is probably the best solution that is currently on the market, they have been developing for a long time, they are our favorite. To the disadvantages we considered the following points: quite an old project, and somewhere the technology is already outdated, unsympathetic interface, old UI libraries. Huge documentation, it’s simply to create CRUD but hard to work without immersion. After all this there is only one conclusion: you need to do it yourself....
What are some alternatives?
Prisma - Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
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.
supabase - The open source Firebase alternative.
pg-promise - PostgreSQL interface for Node.js
Strapi - 🚀 Strapi is the leading open-source headless CMS. It’s 100% JavaScript/TypeScript, fully customizable and developer-first.
TypeORM - ORM for TypeScript and JavaScript. Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
Appwrite - Build like a team of hundreds_
budibase - Budibase is an open-source low code platform that helps you build internal tools in minutes 🚀
KeystoneJS - The most powerful headless CMS for Node.js — built with GraphQL and React
appsmith - Platform to build admin panels, internal tools, and dashboards. Integrates with 25+ databases and any API.
nocodb - 🔥 🔥 🔥 Open Source Airtable Alternative
Baserow - Open source no-code database and Airtable alternative. Create your own online database without technical experience. Performant with high volumes of data, can be self hosted and supports plugins