AWS has open-sourced a new query language, based on SQL (“SQL-compatible”, as the blog post puts it). Essentially, it is a super-set of SQL that requires the JRE. This project bears watching, but will only be successful outside AWS if data store query engines add support for PartiQL. To further that aim, AWS is releasing the specification and reference implementation(written in Kotlin). The AWS services that support PartiQL thus far are:

• Amazon S3 Select
• Amazon Glacier Select
• Amazon Redshift Spectrum
• Amazon Quantum Ledger Database

Not yet available for the PostgreSQL-compatible version of Amazon Aurora. Let’s hope it will be.

Per the announcement: “GP2 volumes offer lower latency and higher throughput than Standard volumes.”

August 28. This is a 300-level session.

August 21. A 200-level session.

The author intends this to be the first in a series of posts on using regular expressions (RE) with PostgreSQL. This post overviews four RE operators.

Visual Studio Code has been coming on strong as a popular cross-platform and cross-language IDE. This release furthers the support for Python and Jupyter notebooks.

A pair of posts presenting the ecosystem of packages for R (my cat Cookie’s personal favorite being purrr) that promotes a methodology for data analysis.

Among the fixes are these:

• PostgreSQL:
  • Array data type handler was fixed
  • Indexes metadata reading was fixed
  • Execution plan visualization was fixed for CTE nodes
• SQL Server:
  • Support of identity columns creation was added
  • Session manager was fixed
• Oracle:
  • Scheduled jobs metadata reading was fixed
  • Session management was fixed for RAC mode

Dataframes (think database tables, spreadsheets) are foundational data structures in Python, R, and Spark. This library provides similar functionality when writing Java.

In a sign of the continued strength of Liquibase as a community project, this post announces the hiring of an open source community manager.

Based on the author’s talk at Pycon X, this is a high-level overview of the resurgence of interest in graph-based technology and graph databases.

This is one of a series of O’Reilly-sponsored conferences on big data and data science. There are two coming up next year: Strata Data Conference – San Jose (March 15-18, 2020) and Strata Data Conference – London (April 20-23, 2020).

An Apache 2.0 licensed-project that supports a property graph data model on top of PostgreSQL (version 10.3). AgensGraph supports both ANSI-SQL and openCypher for querying. There’s an enterprise version from Bitnine.