Menu
Google’s Logica language addresses SQL’s flaws

Google’s Logica language addresses SQL’s flaws

Open source logic programming language compiles to SQL and runs on Google BigQuery, with experimental support for PostgreSQL and SQLite.

Credit: Dreamstime

Google has unveiled the open source Logica programming language, a logic programming language designed to “solve problems of SQL” by using syntax of mathematical propositional logic rather than natural language.

Introduced on April 12 as a successor to Google’s Yedalog language, Logica is a Datalogic-like logic language. Meant for engineers, data scientists, and other specialists, it compiles code to SQL and runs on the Google BiqQuery cloud-based data warehouse, with experimental support for PostgreSQL and SQLite.

But Logica is more concise and supports reusable abstractions unlike SQL. It also supports modules and imports, can be used from an interactive Python notebook, and makes testing queries easy and natural, Google developers wrote in a blog post.

Logica solves problems of SQL by using syntax of mathematical logic rather than natural English language. Google cited issues with SQL such as the verbosity of constructing statements from English words and limited support for abstraction. Logica extends classical logic programming syntax, notably with aggregation. It is billed as a declarative language for data manipulation.

The Google developers behind the Logica open source project encourage its use in the following scenarios:

  • Where logic programming is already being used but a user needs more computational power
  • Where SQL is being used but the user is not satisfied with its readability
  • Where developers want to learn logic programming and apply it to big data processing

Google has set up a tutorial to help developers learn Logica. To run logic programs on Google Cloud BigQuery, developers will need to open a Google Cloud Project.

Once a project is established, developers can run Logica programs in Colab by providing a project ID. To run Logica locally, developers need Python 3.


Follow Us

Join the newsletter!

Or

Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.

Tags Google

Events

Why experience is the new battleground for partners

Join us for an exclusive webinar, in association with Hewlett Packard Enterprise and Technology Services Industry Association (TSIA) and learn about the latest industry insights and how technology services continue to evolve to deliver differentiated value, and how partners can be successful in 2021 and beyond.

Featured

Slideshows

Channel kicks 2021 into gear as After Hours returns to Auckland

Channel kicks 2021 into gear as After Hours returns to Auckland

After Hours made a welcome return to the channel social calendar with a bumper crowd of partners, distributors and vendors descending on The Pantry at Park Hyatt in Auckland to kick-start 2021.

Channel kicks 2021 into gear as After Hours returns to Auckland
The Kiwi channel gathers for the 2020 Reseller News Women in ICT Awards

The Kiwi channel gathers for the 2020 Reseller News Women in ICT Awards

Hundreds of leaders from the New Zealand IT industry gathered at the Hilton in Auckland on 17 November to celebrate the finest female talent in the Kiwi channel and recognise the winners of the Reseller News Women in ICT Awards (WIICTA) 2020.

The Kiwi channel gathers for the 2020 Reseller News Women in ICT Awards
Leading female front runners honoured at the 2020 Reseller News Women in ICT Awards

Leading female front runners honoured at the 2020 Reseller News Women in ICT Awards

The leading female front runners of the New Zealand ICT industry joined together for the annual Reseller News Women in ICT Awards event at the Hilton in Auckland, during which hundreds of guests celebrated 13 outstanding individuals who won awards, chosen from more than 50 finalists representing over 30 organisations.

Leading female front runners honoured at the 2020 Reseller News Women in ICT Awards
Show Comments