oclif VS Objection.js

oclif is a library that helps create CLI applications using Node.js. If you are using a different programming language, search for a suitable library.

It is possible, oclif is a full featured framework produced by Salesforce and is used for the Salesforce and Heroku CLI applications. I have used oclif and pkg to bundle a standalone, though I was focused on MacOS not Windows. Any node application should work with pkg, though.

oClif.io

Check out https://oclif.io/

Interesting. TIL about the Open CLI framework that they all seem to be moving to: https://oclif.io/

https://oclif.io is a tool that helps you build command line tools with node. You can use it to help you create an executable for Linux, max, or windows that you can invoke from the command line.

Oclif to quickly click together CLI tools for kicking off and monitoring crawls, generating reports, etc.

During the second Ably Innovation Days, I started working on specifications for an Ably CLI. After the first day Phil and I started with a prototype based on oclif. We managed to create a working prototype in a day that lists Ably apps, and creates a new Ably app. This project is still Work In Progress. Once the CLI is in a releasable state, I'll create some content around this.

A command-line interface, often referred to as a CLI, is a program that allows users to type instructions and interact with a script that processes the input and produces an output. Node.js has a lot of packages that allows you to build CLIs, like args, minimist, and oclif.

Objection.js is a SQL-friendly ORM for Node.js that supports various relational databases, including PostgreSQL, MySQL, and SQLite. It provides a flexible and expressive query builder. Objection.js is known for its expressive syntax, allowing developers to build complex queries easily. It supports eager loading, transactions, and migrations.

I don't think there's a best per say, but we did recently use Objection on our project. Did the job well, only issue is there's no constructor for the DB Models but it's just something you work around (https://vincit.github.io/objection.js/)

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!

I'd also like to point out objection js is no longer actively maintained. I'm going to switch my work's codebase from it eventually because of it.

You should look into Objection.js. IMHO using that will make your life much easier as it seems you are trying to reimplement it's features in this sample code.

Next, let’s set up the database for our newly created Nest application. I’ll be using PostgreSQL, but you can use any of the databases Knex supports. To interact with our database, we’ll be using Objection.js, which is an ORM for Node.js built on top Knex. For this tutorial, we’ll be using Nest Objection, a Nest module for Objection.