NewsBits for the week ending March 10th - PostgreSQL 10's latest features, Google betas PostgreSQL, MySQL's Shell approaches release, ScyllaDB gets series B funding, Kaggle goes Google, a deep dive in the Redis Pub/Sub, Blockchains explained in code, the length of emojis and how to store data in your DNA.
We gather all the database, development, cloud and data news from the past week, for you to enjoy. This is NewsBits and here are the bits.
PostgreSQL 10 developments
We're tracking what's landing in the PostgreSQL code base for the release of 10 at the end of the year. First up is XMLTABLE support. XMLTABLE is a powerful command that lets you turn XML data into relational columns. Once in a relational form, you can bring the rest of SQL to bear on the data.
Second up, SCRAM Authentication has now been added to boost the password security when logging into PostgreSQL by encoding the stored passwords more securely than the current MD5 password hashing. There's still work to be done, though, on this much-wanted feature.
Google goes PostgreSQL
Google have added PostgreSQL to Google Cloud - the beta product is missing some features, like replications, high availability and the ability to import and export CSV data.
MySQL Shell gets a release candidate
ScyllaDB's Serious Bee
Compose's friends at ScyllaDB have announced they've closed $16million of series b funding for their high-performance Cassandra replacement. The funding is destined to expand sales and marketing to bring the C++ based distributed database to a wider audience.
Kaggle now part of Google
Crowdsourcing, machine learning, and data science company Kaggle is joining Google. Kaggle's specialty is running open competitions to solve specific problems using particular datasets, and it appears that's what they'll continue doing, as Kaggle within Google.
Deep into Redis Pub/Sub
A deep dive under the hood of Redis's Pub/Sub architecture is the latest article published by Pusher. And when we say deep, we mean down to the ANSI C code and through the data structures behind one of Redis's more potent features.
Blockchains in 200 lines
How big 💩?
It's a question asked by Jon New as he dives into the challenge of working out how long a string is. How long is the 💩 emoji? The answer is not one, but two thanks to the wonders of codepoints and surrogate pairs. This conundrum isn't an abstract issue; a bug in Chromium has it displaying two dots for a single emoji character, and it's a good example to remind people that strings are composed of complex characters and care should be taken when measuring and storing them.
And finally, DNA storage
People have asked if we can store data on DNA and now a paper from the University of Washington and Microsoft Research(pdf) is answering that question. They've come up with a method for using DNA as an archival storage system and done the lab work to show they can do it creating 151kB of synthesized DNA and a 42kB random-access set. While access time is likely to be in the tens of hours, the durability of DNA could see data stored for centuries. Hold on to your media for now, though. The biotechnology isn't quite there yet for large-scale data sets but could be soon.
If you have any feedback about this or any other Compose article, drop the Compose Articles team a line at email@example.com. We're happy to hear from you.