You can use e.g. LibPQ.jl for PostgreSQL, i.e. it directly. There’s also a specific PostgresORM.jl
But I want to know of the best tools for databases that work for all, FunSQL.jl seems to be one.
FunSQL.jl allows you to build better queries than, say SQLAlchemy, but it doesn’t provide an Object-Relational Mapping. This package does
- Only supports Integer ids.
- Only supports SQLite.
That package depends on DBInterface so it’s unclear to me why it doesn’t support all. Many databases support it, though notably not PostgreSQL (i.e. LibPq.jl).
There’s also “SearchLight is the ORM layer of Genie.jl” (it’s independent of Genie.jl by now actually), so I’m curious what people do use, what’s the best ORM. It has e.g. related SearchLightPostgreSQL.