mariadb server now requires bash?

[Veon Ax via freebsd-questions]

Hello FreeBSD users,

During a recent 'pkg upgrade' (11.4-RELEASE) I was informed that 'bash' was to be installed. I am a zsh/csh user and have no intention to install the bash shell. After some trial and error it appears to me that bash is now a runtime dependency of mariadb103-server.

IIRC, bash was also listed after 'make run-depends-list' in the port of the same package.

I am trying to find out why this is the case, and if there is a way around it. But so far my searches have not been successful. Does anyone know?

regards,
Veonax

[Kevin P. Neal]

Post by Veon Ax via freebsd-questions
Hello FreeBSD users,
During a recent 'pkg upgrade' (11.4-RELEASE) I was informed that 'bash' was to be installed. I am a zsh/csh user and have no intention to install the bash shell. After some trial and error it appears to me that bash is now a runtime dependency of mariadb103-server.
IIRC, bash was also listed after 'make run-depends-list' in the port of the same package.
I am trying to find out why this is the case, and if there is a way around it. But so far my searches have not been successful. Does anyone know?

Do I know for sure? No.

But I'd guess that it comes with shell scripts that use non-portable
bashisms. This is common on Linux.

[Valeri Galtsev]

Post by Kevin P. Neal

Post by Veon Ax via freebsd-questions
Hello FreeBSD users,
During a recent 'pkg upgrade' (11.4-RELEASE) I was informed that 'bash' was to be installed. I am a zsh/csh user and have no intention to install the bash shell. After some trial and error it appears to me that bash is now a runtime dependency of mariadb103-server.
IIRC, bash was also listed after 'make run-depends-list' in the port of the same package.
I am trying to find out why this is the case, and if there is a way around it. But so far my searches have not been successful. Does anyone know?

Do I know for sure? No.
But I'd guess that it comes with shell scripts that use non-portable
bashisms. This is common on Linux.

<rant>
There is even worse thing about both mariadb and mysql: both of them in the latest version at least use JSON (Java Script Object Notation, really ?!!) somewhere in their tables.
I feel like these two projects just added Junk onto their product. I always was recommending postgresql to developers I serve as sysadmin for who were starting some new project…
</rant>

Valeri

Post by Kevin P. Neal
--
Kevin P. Neal http://www.pobox.com/~kpn/
"It sounded pretty good, but it's hard to tell how it will work out
in practice." -- Dennis Ritchie, ~1977, "Summary of a DEC 32-bit machine"
_______________________________________________
https://lists.freebsd.org/mailman/listinfo/freebsd-questions

[Bob Proulx]

Post by Valeri Galtsev
<rant>
There is even worse thing about both mariadb and mysql: both of them in the latest version at least use JSON (Java Script Object Notation, really ?!!) somewhere in their tables.
I feel like these two projects just added Junk onto their product. I always was recommending postgresql to developers I serve as sysadmin for who were starting some new project…
</rant>

Ahem...

PostgreSQL documenation
9.16. JSON Functions and Operators
https://www.postgresql.org/docs/current/functions-json.html

I don't know the actual timeline but I myself heard about postgresql
adding json functionality before mysql/mariadb did.

Bob

[Lars Liedtke]

+1
IMHO you should know about JSON and NoSQL.

Post by Bob Proulx

Post by Valeri Galtsev
<rant>
There is even worse thing about both mariadb and mysql: both of them in the latest version at least use JSON (Java Script Object Notation, really ?!!) somewhere in their tables.
I feel like these two projects just added Junk onto their product. I always was recommending postgresql to developers I serve as sysadmin for who were starting some new project…
</rant>

Ahem...
PostgreSQL documenation
9.16. JSON Functions and Operators
https://www.postgresql.org/docs/current/functions-json.html
I don't know the actual timeline but I myself heard about postgresql
adding json functionality before mysql/mariadb did.
Bob
_______________________________________________
https://lists.freebsd.org/mailman/listinfo/freebsd-questions

--
---
punkt.de GmbH
Lars Liedtke
.infrastructure

Kaiserallee 13a
76133 Karlsruhe

Tel. [phone]
https://infrastructure.punkt.de
***@punkt.de

AG Mannheim 108285
Geschäftsführer: Jürgen Egeling, Daniel Lienert, Fabian Stein

[Steve O'Hara-Smith]

On Tue, 30 Mar 2021 20:31:36 -0500

Post by Valeri Galtsev
There is even worse thing about both mariadb and mysql: both of them in
the latest version at least use JSON (Java Script Object Notation,
really ?!!) somewhere in their tables.

Not in the least surprised, JSON is a very popular serialisation
format and as such has been turning up in database field values for some
time now. I know of a number of codebases where a sql query can be
followed by expanding JSON encoded fields in each resultant row and checking
the contents as a secondary filter. It makes a lot of sense to move that
into the database engine.

[Tobias Rehbein]

Post by Veon Ax via freebsd-questions
I am trying to find out why this is the case, and if there is a way
around it. But so far my searches have not been successful. Does
anyone know?

The WSREP option adds bash to the dependency list. If you really want to
avoid the installation of bash, you'll have to disable this option and
build mariadb yourself using the ports tree.

Regards,

Tobias

[parv/freebsd]

Am Tue, Mar 30, 2021 at 07:08:19AM +0000 schrieb Veon Ax via

Post by Veon Ax via freebsd-questions
I am trying to find out why this is the case, and if there is a way
around it. But so far my searches have not been successful. Does
anyone know?

The WSREP option adds bash to the dependency list. If you really want to
avoid the installation of bash, you'll have to disable this option and
build mariadb yourself using the ports tree.

I failed to find the meaning of "WSREP" on MariaDB website; did found
various variables starting with "wsrep_" in context of Galera cluster.

For my own education, does "WSREP" mean "Warm-Standby Replication"?


- parv

--

[doug]

Post by Tobias Rehbein

Post by Veon Ax via freebsd-questions
I am trying to find out why this is the case, and if there is a way
around it. But so far my searches have not been successful. Does
anyone know?

The WSREP option adds bash to the dependency list. If you really want to
avoid the installation of bash, you'll have to disable this option and
build mariadb yourself using the ports tree.
Regards,
Tobias

Installing a package without a non-needed dependency is doable. I did the
following to install libreoffice and keep mysql56:

pkg install libreoffice
pkg delete -f mysql57-client
pkg lock libreoffice
pkg install mysql56-server

In this case it works fine because I do not care about using the DB viewer.