From owner-freebsd-questions@freebsd.org Wed Mar 31 20:34:18 2021 Return-Path: Delivered-To: freebsd-questions@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id B80705AFBB9 for ; Wed, 31 Mar 2021 20:34:18 +0000 (UTC) (envelope-from 4250.82.1d4cf0000ccdb71.d8ed226ecf3cdc4ad30396ed58ea3f25@email-od.com) Received: from s1-b0c6.socketlabs.email-od.com (s1-b0c6.socketlabs.email-od.com [142.0.176.198]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 4F9dMY6LB3z4cFm for ; Wed, 31 Mar 2021 20:34:17 +0000 (UTC) (envelope-from 4250.82.1d4cf0000ccdb71.d8ed226ecf3cdc4ad30396ed58ea3f25@email-od.com) DKIM-Signature: v=1; a=rsa-sha256; d=email-od.com;i=@email-od.com;s=dkim; c=relaxed/relaxed; q=dns/txt; t=1617222858; x=1619814858; h=content-transfer-encoding:content-type:mime-version:references:in-reply-to:message-id:subject:cc:to:from:date:x-thread-info; bh=j6c3r/k7C2R3E2wpVbM2Z76G2J7KoIfcyWVZl7S6xoY=; b=DKuUdgJVl3iE9WLRgRWO59zQjLiPe2tSzp5TXjTttVB+k4VchtIOrOxNOQsplbfBSTyiG+HPhN+YUFor0NAIvS68zf5e0fbFxeV4SL8lB+3oDcUtOvkZlBmE8+IjSMU0f55T/85X263SYo75/vufScWqZcKpy+LNzn4Xb0C1rbA= X-Thread-Info: NDI1MC4xMi4xZDRjZjAwMDBjY2RiNzEuZnJlZWJzZC1xdWVzdGlvbnM9ZnJlZWJzZC5vcmc= Received: from r1.us-east-1.aws.in.socketlabs.com (r1.us-east-1.aws.in.socketlabs.com [142.0.191.1]) by mxsg2.email-od.com with ESMTP(version=Tls12 cipher=Aes256 bits=256); Wed, 31 Mar 2021 16:34:05 -0400 Received: from smtp.lan.sohara.org (EMTPY [185.202.17.215]) by r1.us-east-1.aws.in.socketlabs.com with ESMTP(version=Tls12 cipher=Aes256 bits=256); Wed, 31 Mar 2021 16:33:57 -0400 Received: from [192.168.63.1] (helo=steve.lan.sohara.org) by smtp.lan.sohara.org with smtp (Exim 4.94 (FreeBSD)) (envelope-from ) id 1lRhXH-0000hp-Ce; Wed, 31 Mar 2021 21:33:55 +0100 Date: Wed, 31 Mar 2021 21:33:55 +0100 From: Steve O'Hara-Smith To: Valeri Galtsev Cc: "Kevin P. Neal" , Veon Ax , "freebsd-questions@freebsd.org" Subject: Re: mariadb server now requires bash? Message-Id: <20210331213355.dad8ffd7dbbf20f283434269@sohara.org> In-Reply-To: References: X-Mailer: Sylpheed 3.7.0 (GTK+ 2.24.33; amd64-portbld-freebsd12.1) X-Clacks-Overhead: "GNU Terry Pratchett" Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Rspamd-Queue-Id: 4F9dMY6LB3z4cFm X-Spamd-Bar: - Authentication-Results: mx1.freebsd.org; dkim=pass header.d=email-od.com header.s=dkim header.b=DKuUdgJV; dmarc=none; spf=pass (mx1.freebsd.org: domain of 4250.82.1d4cf0000ccdb71.d8ed226ecf3cdc4ad30396ed58ea3f25@email-od.com designates 142.0.176.198 as permitted sender) smtp.mailfrom=4250.82.1d4cf0000ccdb71.d8ed226ecf3cdc4ad30396ed58ea3f25@email-od.com X-Spamd-Result: default: False [-1.70 / 15.00]; TO_DN_EQ_ADDR_SOME(0.00)[]; TO_DN_SOME(0.00)[]; MV_CASE(0.50)[]; R_SPF_ALLOW(-0.20)[+ip4:142.0.176.0/20]; RCVD_COUNT_THREE(0.00)[4]; DKIM_TRACE(0.00)[email-od.com:+]; NEURAL_HAM_SHORT(-1.00)[-1.000]; FORGED_SENDER(0.30)[steve@sohara.org,4250.82.1d4cf0000ccdb71.d8ed226ecf3cdc4ad30396ed58ea3f25@email-od.com]; RCVD_TLS_LAST(0.00)[]; MIME_TRACE(0.00)[0:+]; RBL_DBL_DONT_QUERY_IPS(0.00)[142.0.176.198:from]; MID_RHS_MATCH_FROM(0.00)[]; FROM_NEQ_ENVFROM(0.00)[steve@sohara.org,4250.82.1d4cf0000ccdb71.d8ed226ecf3cdc4ad30396ed58ea3f25@email-od.com]; ASN(0.00)[asn:7381, ipnet:142.0.176.0/22, country:US]; ARC_NA(0.00)[]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; R_DKIM_ALLOW(-0.20)[email-od.com:s=dkim]; FROM_HAS_DN(0.00)[]; RCPT_COUNT_THREE(0.00)[4]; NEURAL_HAM_LONG(-1.00)[-1.000]; MIME_GOOD(-0.10)[text/plain]; SUBJECT_ENDS_QUESTION(1.00)[]; DMARC_NA(0.00)[sohara.org]; SPAMHAUS_ZRD(0.00)[142.0.176.198:from:127.0.2.255]; TO_MATCH_ENVRCPT_SOME(0.00)[]; MAILMAN_DEST(0.00)[freebsd-questions] X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.34 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 31 Mar 2021 20:34:18 -0000 On Tue, 30 Mar 2021 20:31:36 -0500 Valeri Galtsev wrote: > 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. -- Steve O'Hara-Smith