[Tarantool-patches] [PATCH 4/5] sql: replace control pragmas by SET

[Konstantin Osipov]

* Nikita Pettik <korablev at tarantool.org> [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