Article: Google unveils logic programming language: Logica

Language, Open Data

Google unveils logic programming language: Logica

Google introduced the open-source Logica programming language this week. It is designed to compile to SQL and run on Google BigQuery with experimental support for PostgreSQL and SQLite.  According to the company, the language was created to make it easier for developers who have to deal with the challenges of SQL.

The challenges with coding using SQL often include constructing statements from long chains of English words and limited support for abstraction. SQL is also rarely tested because testing SQL queries” sounds rather esoteric to most engineers.

Read Full Article

Article: Executive Q&A: A Closer Look at Open Data Lake Analytics

Open Data, Open Source

Executive Q&A: A Closer Look at Open Data Lake Analytics

Organizations today have data in multiple systems and most of that data is now up in the cloud, or will be soon. The data is usually a mix of structured and unstructured, static and streaming and in many formats.

It’s dispersed across data warehouses, open source databases, proprietary databases, and cloud warehouses, but increasingly most of the data will end up in data lakes. Given this, enterprises and organizations are trying hard to avoid getting locked into proprietary systems again for running various types of analytics.

Read Full Article

Article: How PostgreSQL has popularized open source enterprise databases [Q&A]

Free, Libre, Open Software, Open Source

How PostgreSQL has popularized open source enterprise databases [Q&A]

Although open source has gained in popularity in recent years, in some circles it’s still viewed as being inaccessible to all but tech experts. But that’s starting to change, the PostgreSQL database has earned a strong reputation among businesses for reliability, feature robustness, and performance and has contributed to the growth in open source.

We spoke to Marc Linster, CTO at PostgreSQL specialist EDB to find out why he believes the open source database may now be coming of age.

Read Full Article

Article: Presto users detail what’s next for open source SQL engine

Code, Open Software, Open Source

Presto users detail what’s next for open source SQL engine

The open source Presto project is gaining adoption beyond just Uber and Facebook as the need to connect and query disparate sources of data continues to be in demand. At the PrestoCon Day virtual event on March 24, Presto users and developers gathered to discuss how the technology is being used and where it is headed in the future.

Presto is a SQL query engine originally developed by Facebook and currently run as an open source project under the governance of the Presto Software Foundation, which itself is operated by the Linux Foundation.

Read Full Article

Article: CrateDB takes distributed SQL DB fully open source with release of v4.5

Free, Libre, Open Software, Open Source

CrateDB takes distributed SQL DB fully open source with release of v4.5

Crate.io has pushed out CrateDB 4.5, the latest version of its clustered SQL database for developers building machine data applications. With this release, the product is also now fully open source with all enterprise features of the database available under the Apache 2.0 license.

Detailing the changes on its blog, Crate.io said it will no longer implement its Enterprise License, under which organisations paid for commercial use of the product. Instead, the complete set of CrateDB features will be available in a single open source version licensed under Apache 2.0.

Read Full Article

Article: Crate.io Open Sources the Entire Codebase of CrateDB – the Database Purpose Built for Machine Data

Free, Libre, Open Software, Open Source

Crate.io Open Sources the Entire Codebase of CrateDB – the Database Purpose Built for Machine Data

With today’s release of CrateDB 4.5, all database capabilities previously included in the enterprise version are available in the community edition; CrateDB will remain fully open source moving forward

Crate.io, developer and supplier of CrateDB, the purpose-built database optimized for machine data use cases, today announced that CrateDB is now a fully open source database solution. With today’s release of CrateDB 4.5, all enterprise features of the database are available under the Apache 2.0 open source license for the self-deploy Community edition.

Read Full Article