rs-pbrt-test-scenes VS pgtyped

So, I started working on a library to deal with reading data from Blender‘s binary .blend files. In the past I was able to render some Blender v2.79 files, now I abstracted the library to deal (in theory) with all Blender versions (using the DNA information). I tested with two scenes for Blender 2.79 and Blender 3.0 (which should be quiet different from the GUI perspective). With v2.79 I got away with a naming convention and mis-using the old material settings (pre Cycles renderer). Blender 3.0 forced me to get some material settings from shader nodes and the library allows to follow pointers from one data structure to the next. Prove of concept: Both, the Cornell box, as well as the Radiance Conference Room, render with both Blender scene versions. Get the latest Blender scenes here: https://gitlab.com/jdb-walter/rs-pbrt-test-scenes/-/tree/master/blend

There is an implementation of SQL that operates on a table shaped type, entirely at type level. For your amusement: https://github.com/codemix/ts-sql

There are a bunch of more practical takes that codegen types from your database and generate types for your queries, eg: https://github.com/adelsz/pgtyped

To me the second approach seems much more pragmatic because you don’t need to run a SQL parser in a fairly potato interpreter on every build

ORMs suck, but raw SQL embedded in your code sucks too.

This might be good time to plug my TypeScript non-ORM: https://jawj.github.io/zapatos/.

I should say I also like what I've seen of https://kysely.dev/ and https://pgtyped.dev/.

Thank you for suggestions they helped me finding what I was looking for. I will either pick kysely or https://pgtyped.dev/, but first I will do some tests. Thanks!

Cool. How does this compare to SafeQL, PgTyped, and Postgres language server ?

I would instead rely on code generation like https://github.com/adelsz/pgtyped, because the embedded type-safe SQL will never fully cover all the features of vanilla SQL, for example Common Table Expression (CTE), window functions etc.

There's pgtyped, which I believe does almost the same as sqlc

https://github.com/adelsz/pgtyped

For Postgres there is https://github.com/adelsz/pgtyped, sounds pretty much like what you describe?

Avoiding the cost of learning EDSL that many Haskell DB libraries provide, I found out that only postgresql-typed and postgresql-simple allow to write only raw SQL queries easily. As I extensively use pgtyped for production Node.js application, I am thinking about using postgresql-typed. While I could find many resources for postgresql-simple, the same cannot be said try for postgresql-typed.

I would highly recommend trying out pgTyped if you want typesafe queries with postgres. It's fantastic!