A "more useful" default for ash_postgres Version possible?

wintermeyer · November 25, 2024, 10:08am

Every time I use mix igniter.install ash_postgres I run into this situation:

What is the minimum PostgreSQL version you will be using?

AshPostgres uses this information when generating queries and migrations,
to choose the best available features for your version of PostgreSQL.


Please enter the version in the format major.minor.patch (e.g. 13.4.0)

Default: 16.0.0

❯

Of course I can run psql --version in an other terminal to find the answer to that question (at least for my development system) but I don’t want to. I am using igniter to make my life easier.

Why doesn’t igniter try to run psql --version or something similar in the background and give me something like this as an option:

What is the minimum PostgreSQL version you will be using?

AshPostgres uses this information when generating queries and migrations,
to choose the best available features for your version of PostgreSQL.

On this system we found a PostgreSQL with the version number 14.13

Please enter the version in the format major.minor.patch (e.g. 13.4.0)

Default: 14.13.0

❯

This will make the live of 99% of all developers easier. And the other 1% doesn’t have any disadvantages.

zachdaniel · November 25, 2024, 1:04pm

Sounds very useful please open an issue/PR

wintermeyer · November 25, 2024, 1:24pm

Done.

github.com/ash-project/ash_postgres

Set the default PostgreSQL version to the one on the current system

opened 01:24PM - 25 Nov 24 UTC

wintermeyer

enhancement needs review

Every time I use `mix igniter.install ash_postgres` I run into this situation: … ```bash What is the minimum PostgreSQL version you will be using? AshPostgres uses this information when generating queries and migrations, to choose the best available features for your version of PostgreSQL. Please enter the version in the format major.minor.patch (e.g. 13.4.0) Default: 16.0.0 ❯ ``` Of course I can run `psql --version` in an other terminal to find the answer to that question (at least for my development system) but I don't want to. I am using igniter to make my life easier. Why doesn't igniter try to run `psql --version` or something similar in the background and give me something like this as an option: ```bash What is the minimum PostgreSQL version you will be using? AshPostgres uses this information when generating queries and migrations, to choose the best available features for your version of PostgreSQL. On this system we found a PostgreSQL with the version number 14.13 Please enter the version in the format major.minor.patch (e.g. 13.4.0) Default: 14.13.0 ❯ ``` This will make the live of 99% of all developers easier. And the other 1% doesn't have any disadvantages.