From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mail-lj1-f194.google.com (mail-lj1-f194.google.com [209.85.208.194]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by dev.tarantool.org (Postfix) with ESMTPS id F0C5D46970F for ; Thu, 28 Nov 2019 00:50:25 +0300 (MSK) Received: by mail-lj1-f194.google.com with SMTP id e28so1929884ljo.9 for ; Wed, 27 Nov 2019 13:50:25 -0800 (PST) Date: Thu, 28 Nov 2019 00:50:23 +0300 From: Konstantin Osipov Message-ID: <20191127215023.GA31812@atlas> References: <20191127105150.GA7232@atlas> <20191127110532.GA16764@tarantool.org> <20191127111030.GB9233@atlas> <20191127112436.GB16940@tarantool.org> <20191127113917.GD9233@atlas> <20191127122138.GB29304@tarantool.org> <20191127130156.GA31045@tarantool.org> <20191127140317.GA56049@tarantool.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20191127140317.GA56049@tarantool.org> Subject: Re: [Tarantool-patches] [PATCH 4/5] sql: replace control pragmas by SET List-Id: Tarantool development patches List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , To: Nikita Pettik Cc: tarantool-patches@dev.tarantool.org, Vladislav Shpilevoy * Nikita Pettik [19/11/27 17:34]: > > It may sound trite but why not look at other DBs? For instance, > PosgtreSQL uses SHOW command, which looks OK personally to me. > Or alternatively why can't we simply use _sql_settings:select("default_engine")? > In this case SHOW will be purely SQL shortcut for :select(). Seriously?-) This sounds like some sort of joke? I did suggest to look at other DBMS serveral times, in fact the most widely used DBMS in the world, sqlite, which happens to use pragmas! Once again, other dbms are a good source of inspiration, but in the end of the day one has to have a *different* criteria for product design, and it is what is the mission of *this* product and what it is trying to accomplish. > > 2) Should we remove _vsession_settings from the problem. > > What is the problem? What are alternatives? > > > 3) If we move sysview out of the problem, where should we move it. > > What do you mean by "move sysview out of the problem"? > > Could you please clarify last two question. -- Konstantin Osipov, Moscow, Russia