Please add PostgreSQL 18 and bump versions of other databases

[zhuravel]

• PostgreSQL 18.1 - https://www.postgresql.org/docs/release/18.1/
• MySQL 8.4.7 LTS - https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-7.html
• MySQL 9.5.0 Innovation - https://dev.mysql.com/doc/relnotes/mysql/9.5/en/news-9-5-0.html
• MariaDB 11.8 - https://mariadb.com/docs/release-notes/community-server/11.8

[huyphams]

We're working on it.

[HungNth]

And please add MariaDB version 11

[matteoveglia]

Not to be pushy or sound ungrateful but any timeline on getting especially pg 18 in?

[Nemesis19]

+1 to this request

[huyphams]

Working on it now. We will have the new dbngin next week!

[huyphams]

We added the PostgreSQL 18 to the list, you can create server PostgreSQL 18 now (from current version of DBngin)

We will release other database and new DBngin later (this week)!

[Nemesis19]

@huyphams is the "new release" gonna solve the issue with Postgis and the new Postgres 18.1?

In case it's unrelated I'm gonna open a new issue about it...

this is what happens when running CREATE EXTENSION postgis;;

Query 1 ERROR at Line 1: : ERROR:  could not load library "/Users/Shared/DBngin/postgresql/18.1/lib/postgis-3.dylib": dlopen(/Users/Shared/DBngin/postgresql/18.1/lib/postgis-3.dylib, 0x000A): Library not loaded: /Users/Shared/DBngin/postgresql/16.4/lib/libgmpxx.4.dylib
  Referenced from: <76539918-19B6-3B94-82C9-EB722B270A6C> /Users/Shared/DBngin/postgresql/18.1/lib/libSFCGAL.2.dylib
  Reason: tried: '/Users/Shared/DBngin/postgresql/16.4/lib/libgmpxx.4.dylib' (no such file), '/System/Volumes/Preboot/Cryptexes/OS/Users/Shared/DBngin/postgresql/16.4/lib/libgmpxx.4.dylib' (no such file), '/Users/Shared/DBngin/postgresql/16.4/lib/libgmpxx.4.dylib' (no such file)
CONTEXT:  SQL statement "CREATE OR REPLACE FUNCTION spheroid_in(cstring)
	RETURNS spheroid
	AS '$libdir/postgis-3','ellipsoid_in'
	LANGUAGE 'c' IMMUTABLE STRICT PARALLEL SAFE"
extension script file "postgis--3.6.1.sql", near line 118

[huyphams]

Thanks @Nemesis19 I just checked and it works on Macbook Intel but not on Macbook arm, let me check why it use the wrong dynamic lib libgmpxx.4.dylib

[huyphams]

Hi @Nemesis19

Please stop server PostgreSQL 18.1

then right click on the Server and select Show database server binaries then delete the Folder 18.1

When you start it again, the app will download the new version of 18.1 which addressed the Postgis issue

[Nemesis19]

Hi @Nemesis19

Please stop server PostgreSQL 18.1

then right click on the Server and select Show database server binaries then delete the Folder 18.1

When you start it again, the app will download the new version of 18.1 which addressed the Postgis issue

works like a charm @huyphams , thank you! Sorry for not mentioning Apple Silicon, that was the case indeed.