Our great sponsors
-
kysely
Discontinued A type-safe typescript SQL query builder [Moved to: https://github.com/kysely-org/kysely] (by koskimas)
-
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.
Then I found kysely. The author literally rewrote knex with type-safe system. I think kysely could replace knex completely. It can go further and replace ORM(This is my opinion and of course I can't deny the necessity of ORM. Personally I perfer using SQL builder over ORM).
Interesting. Someone asked me if I supported it in Kanel. At the time it was hard to extend Kanel and then I just forgot but perhaps I should take another look at it. I am not exactly overwhelmed with the types that Knex offers even though it does make an honest attempt.
I would highly recommend trying out pgTyped if you want typesafe queries with postgres. It's fantastic!
After that I moved to query builders exclusively for a couple of years. I used knex a lot, then I started using slonik, which was a huge improvement over knex.