Big data: google publishes new programming language logica
Google has presented a new free programming language with logica, which is to be used as declarative, logical language for processing data. For example, the company liked data scientists, engineers and other data specialists who want to use a logical programming syntax when writing queries and pipelines for google’s cloud data warehouse bigquery.
As a successor of the yedalog language designed by google, logica should be compiled to SQL and run on google bigquery. Logica is an open source under apache-2.0 license square affordable and brings experimental support for postgresql and sqlite with. With logica, google is pursuing the goal of simplifying the readability of queries compared to SQL. At the same time, the programming language should be better for the handling of big data.
Logica = logic + aggregation
Google’s latest programming language is intended to support the abstraction mechanisms that seem to be missing SQL. Because despite the popularity of the structured query language, it is important to some places to overcome coarse hurden. For example, SQL trap the processing of long word chains in english. According to the blog post SQL also supports abstractions only limited.
With SQL, it’s hard to convert the logic into suitable happens, resulting in complicated, lengthy queries, copied code-blocking, and finally a hard to wait for a SQL codebase. To achieve the problems, numerous alternative query languages and libraries were then developed based on logical programming languages. Such languages often result from cooperation with mathematics. In contrast to natural languages, they obviously have the advantage that they should facilitate the expression of complex statements. Google’s logica sets a slurry on this point and extends the classic logical syntax by aggregation (logica = logic + aggregation).
Tutorial and other information
Logica supports modules and imports, and can be used by an interactive python notebook. In addition, queries should also be tested. Google makes a tutorial for learning the language. Clear information about the investigation can also be found in the logica open source repository as well as in the article on the open-source blog from google.
