Welcome to NewsBits where you'll find the database and developer news from around the net for the week ending February 23rd:
- Scylla 2.1 gets experimental secondary indexing
- The maximum table size for PostgreSQL is increasing.
- PostgreSQL query internals explained.
- Version 6.2.2 of Elasticsearch released.
- MySQL 8: the exciting bits.
- A Qt upgrade is core to a new Robo 3T.
- JupyterLab is "ready for users".
- Ready to Go 1.10 and future versioning.
- Asciicinema 2.0 gets incremental.
- Doing it their way: Sinatra 2.0.1 lands.
- And finally.... CSS for keylogging and profit?
And now, those bits in full:
Scylla 2.1: The Cassandra-compatible-but-faster database has seen a new minor update with release of Scylla 2.1. This update includes a new compaction strategy (TWCS), CQL cast functions, support for durations and proper eviction for prepared statements to avoid out-of-memory events. There's also more efficient handling of CompressionInfo.db files and transitional auth support so you can turn on access control without locking everyone out. 2.1 also sees the arrival, in experimental form, of secondary indexing with a Cassandra compatible syntax. Secondary indexes let you search efficiently on fields that aren't the partition keys.
PostgreSQL 11: As development settles out, PostgreSQL 11's features and limits are being clarified. One limit is the maximum size of a table and in this Simon Riggs blog post, we see how PostgreSQL's long-standing 32TB maximum table size was boosted to 2 Exabytes in PostgreSQL 10... and with a recent fix of a 22 year old bug, will go to 131 Yottabytes in PostgreSQL 11.
PostgreSQL Internals: Just under a year ago, we talked about the rather splendid "The Internals of PostgreSQL". It's an online book, being translated from Japanese, which delves deep into how PostgreSQL works. Back then though the chapter on Query Processing was yet to be translated. Well, now the Query Processing chapter has been put online and carries on delving into how PostgreSQL interprets, plans and operates on SQL queries. A must for any PostgreSQL developer or DBA.
Elasticsearch: Mentioned last week in NewsBits, Elasticsearch 6.2.2 is now available. The release notes cover the various fixes such as handling results from script field parsing in the Java High-Level REST client. There is also a matching Kibana release.
MySQL 8: FOSDEM was at the start of the month and we're working through the many videos of presentations there. This one - Why we're excited about MySQL 8 - looks at the yet-to-be-GA MySQL 8 and ops related features like the Native Data Dictionary, UTF8mb4 as defalt character set, use of OpenSSL, roles, breaking down SUPER privileges, encrypted logs, persistent auto-increment, auto-tuning InnoDB, in-place partial JSON updates, a storage engine for temporary tables and much, much more.
Robo 3T: Robo 3T 1.2 is the latest release of the popular MongoDB client, previously known as RoboMongo. The new release now builds and runs on Ubuntu 17.x and macOS High Sierra, thanks to a Qt upgrade. It includes some fixes that display big doubles correctly and can avoid data overwriting when working with a projected view.
JupyterLab: It's not at version 1.0 yet, but the collaborative version of Jupyter Notebooks, JupyterLab, has been declared "ready for users". Notebooks are composite living documents which bring code, visualization and text together to create documented, reproducible data science. Collaboration is the challenge for Notebooks and JupyterLabs is the Project Jupyter developers answer to that. The plan is that JupyterLab will go 1.0 later this year and eventually replace Jupyter itself with a smooth transition and support for the same notebook format files.
Go: Just as we published NewsBits last week, Go 1.10 arrived. This update is predominantly about better tooling and toolchain operation with smarter selection of files to compile, defaulted GOROOT and a new GOTMPDIR setting, caching of test results for unchanged paths and so on. Full details over in the Go 1.10 release notes. Meanwhile, the Go community are talking about Russ Cox's proposal on Go package versioning - vgo. The introduction describes the history and reasoning behind the proposal. Expect it all to loom large in future Go developments.
Asciicinema: The open source terminal-centric session recording and playback tool Asciicinema has reached version 2.0. It comes with a new recording format based on newline delimited JSON which opens up opportunities for incremental reading and writing and for making even more epic terminal replays to complement documentation and provide guidance.
Sinatra: Sinatra, the small yet smooth DSL that thinks it's a web framework, has been updated. Sinatra 2.0.1 comes around ten months after Sinatra 2.0 arrived. It includes a fix for CVE-2018-7212 which affected Sinatra on Windows. The full changelog has the rest of the details.
And finally... a keylogger in CSS? Sure, here's a tweet from Jordan Eldredge showing how to harness event generation and use image requests to covertly pass characters to other sites.
NewsBits. News in bits, every Friday at Compose.
Read more articles about Compose databases - use our Curated Collections Guide for articles on each database type. If you have any feedback about this or any other Compose article, drop the Compose Articles team a line at firstname.lastname@example.org. We're happy to hear from you.
attribution G. Crescoli