[Libreoffice-bugs] [Bug 112801] Improve LO SQL parser to allow GUI Query editor usage with more SQL connection varieties

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=112801

--- Comment #5 from Howard Johnson <BridgeportContractor at gmail.com> ---
Hi Robert,

>> Query-editor should first allow all the SQL-conditions for internal databases. These are at this moment HSQLDB 1.8 and Firebird 3.0.

I don't expect to change your mind, but some of the things you say seem more a
matter of taste rather than based on facts.  So can we start with some facts.

I think any comparative discussion of databases should start here, with what
the world is actually using:

  https://db-engines.com/en/ranking
 
https://blog.jooq.org/2013/10/03/the-10-most-popular-db-engines-sql-and-nosql/

Of note is that MySQL is #2 with a huge market saturation, way behind is
Firebird at #30, and HSQLDB (not sure which version) at #49.  To put this in
some perspective, for every person using HyperSQL there are 200 others using
MySQL.  I have used MySQL for large application in a production environment and
found it very good.  I also think HSQLDB 1.8 and Firebird are good and fun
toys, but only for students or hobbyists.  They are easy to get going in LO,
but they are also not very capable.  And furthermore Firebird was buggy when I
last tried it.

This is not to say that everyone should use the same thing.  My personal
preference these days is open source.  linux is that leader but only has 3%
share of usage.  see:
https://www.netmarketshare.com/operating-system-market-share.aspx?qprid=10&qpcustomd=0
 But the good thing about going with a leader like Linux or MySQL is that when
I have a question there are lots of other folks who have answers.

MySQL, and now it's binary open source twin MariaDB, are production databases
with a long history behind them and far more features available.  Also of note
is that MariaDB is now shipped as the default open source database with Debian
and it's derivatives like for example the open source leader: Ubuntu.  See:
https://mariadb.org/debian-9-released-mariadb-mysql-variant/


>> If there is anybody who will use special code for his database he should switch to SQL. 

With so many databases out there I understand your confusion, but MariaDB is
MySQL which is SQL.  See: https://en.wikipedia.org/wiki/MariaDB


>>I have read the thread in ask.libreoffice.org and  must say: I haven't understand where the code of this bug should be used for.

AND and OR are the two most fundamental boolean operators from which all other
boolean logic is derived.  In this case they are used to join two conditional
expressions inside an IF statement and produce a result as follows:  

If(x AND y)  --- true when both   x and y are true.
If(x OR y)   --- true when either x or  y is  true.

Imagine if the + (plus) or - (minus) operator didn't exist?  Well, AND and OR
are the boolean equivalents to + and -.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171003/83763572/attachment-0001.html>