The first alpha of EdgeDB, an interesting new database system
source link: https://www.tuicool.com/articles/hit/AJzmArq
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
#249 — April 12, 2019
Note: We've also got some Google Cloud Next announcements at the end of this issue.
Database Weekly
EdgeDB 1.0 Alpha 1: A Database Attempting to Bridge the NoSQL/SQL Divide — Originallyannounced a year ago, EdgeDB is an open-source object-relational database that bakes in support for working with semi-structured data in an attempt at bringing the simplicity of NoSQL to the relational world.
PostgreSQL is used under the hood with Edge’s own SQL-esque query language (EdgeQL) compiled to SQL behind the scenes, and this post is a great introduction to EdgeQL and how it works from a developer’s perspective.
Yury Selivanov and Elvis Pranskevichus
Stop Managing 100’s of DB Credentials and Keys — Extend your SSO to manage database and server access with strongDM. Every server. Every database (yes, even Druid) . Any environment.See how it works.
strongDM sponsor
Which AWS Technology Should You Use for Your Open Source Database? — Databases are a key part of deploying apps to the cloud and AWS (in)famously has a lot of options in this regard. Here are some of the reasons you might choose between the various options.
The New Stack
The Difference Between SQL's JOIN .. ON
Clause and the WHERE
Clause — Are ON
and WHERE
really the same thing? “They are when you run an inner join. But they are not when you run an outer join.”
Lukas Eder
Scylla Cloud: The Fastest NoSQL Database as a Managed Service — ScyllaDB is a real-time, big data database heavily influenced by Apache Cassandra. This cloud version is AWS only for now, but Azure and GCP are to follow.
ScyllaDB
Cloud Native, 'Chaos-Tolerant' FaunaDB Adds Support for SQL, GraphQL, and CQL —FaunaDB, created by a former, early Twitter employee, is a sort of ‘all-in-one’ database for polyglot persistence.
George Anadiotis (ZDNet)
pganalyze eBook: How to Get a 3x Performance Improvement on Your Postgres Database — Learn our best practices for optimizing Postgres query performance for customers like Atlassian and how to reduce data loaded from disk by 500x.
pganalyze sponsor
How To Improve The Performance of COUNT(*)
— Using count(*)
is often quite slow in Postgres. This article explores a variety of options to make counting rows faster using approximations and other tricks.
Laurenz Albe
rediSQL: Redis Module Providing an SQL Database Inside Redis — We first linked the alpha version two years ago but it’s just hit 1.0 :-)
Simone Mosciatti
:computer: Jobs
Full Stack, Mobile & Infrastructure Engineers — Joining our team means you will be working in our fast paced environment and you are fearless of our next big challenge.
Expensify
Find A DB Job Through Vettery — Vettery specializes in tech roles and is completely free for job seekers. Create a profile to get started.
Vettery
The Google Cloud Next ’19 Announcements Corner
Google to Offer Several Popular Open Source Databases as Managed Services — Google is adopting a collaborative approach with the projects’ creators but offering unified billing for customers. Systems from companies like MongoDB, Elastic, Neo4j and Redis Labs will be in the initial mix.
The New Stack
Google Cloud Unveils Slew of New Data Management and Analytics Services — The biggest release was Cloud Data Fusion , a fully managed ‘data integration service’ complete with over 100 connectors and open source ‘transformations’ for ingesting data, transforming or blending it, and then using BigQuery to analyze it.
Datanami
Google Makes The Power of BigQuery Available in Sheets — BigQuery, Google’s fully managed analytics data warehouse, can now be used from Sheets, the web-based spreadsheet tool. I think we’ll continue to see more integrations of this type in the next few years. Google’s own post from January has more details.
TechCrunch
This isn't sponsored or anything, we just fancied having some fun :-)
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK