--- title: "So much enterprise, it could be Star Trek" publication: "DB Weekly" issue: 304 published_at: "2020-05-15" canonical_url: "https://dbweekly.com/issues/304" --- Plus more database news, views, and links. #304 — May 15, 2020 [Read on the Web](https://dbweekly.com/issues/304) Database Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/t5mvb6xs5oqnaqlzjv6h.jpg)](https://memgraph.com/blog/announcing-memgraph-1-0-enterprise-ready-real-time-graph-database) [Memgraph 1.0: An Enterprise-Ready In-Memory Graph Database](https://memgraph.com/blog/announcing-memgraph-1-0-enterprise-ready-real-time-graph-database) — Now approaching 4 years old, Memgraph, a high performance in-memory graph database, has reached v1.0. It’s compatible with the Cypher query language and the Bolt protocol so you can use it from any language that has a [Bolt](https://en.wikipedia.org/wiki/Bolt_%28network_protocol%29) driver. Does ‘enterprise-ready’ mean expensive? Not necessarily. It’s not open source but there is a free ‘community’ licensed version. Memgraph Ltd [Understanding Cost Models](http://justinjaffray.com/understanding-cost-models/) — Query planners in database systems frequently use _cost models_ to determine which algorithms to use for a given query by which have the lowest ‘cost’. This post looks at a little of what’s involved and gives what I think is a neat bit of insight into how TPC-H stresses the best of databases. Justin Jaffray [![\](https://copm.s3.amazonaws.com/dd086c42.png)](https://retool.com/customers?utm_source=dbweekly&utm_medium=newsletter&utm_campaign=may_15&utm_content=customers) [Build Internal Tools in Hours, Not Days](https://retool.com/customers?utm_source=dbweekly&utm_medium=newsletter&utm_campaign=may_15&utm_content=customers) — Retool provides UI building blocks that connect to any DB and API. Hackable by design — you can use JavaScript anywhere and query JSON with SQL. See how engineers at companies like Doordash, Coinbase and Brex use Retool to quickly build tools. Retool sponsor [Reinventing Enterprise Search: Amazon Kendra Now Generally Available](https://aws.amazon.com/blogs/aws/reinventing-enterprise-search-amazon-kendra-is-now-generally-available/) — Two featured items with ‘enterprise’ in the title? Sorry 😂 However, [Kendra](https://aws.amazon.com/kendra/) is a new search service on AWS that uses machine learning to answer natural language queries from end users. There’s a free tier, but [the pricing table](https://aws.amazon.com/kendra/pricing/) is more complex than most AWS services, hence the ‘enterprise’ moniker 😏 Julien Simon (AWS) [Advanced SQL and Database Books and Resources](https://www.neilwithdata.com/advanced-sql) — Once you’ve got a pretty good grasp of SQL, where can you head next to get a bit deeper into the weeds and become a true SQL expert? Neil has some ideas in video and book form. Neil Sainsbury [immudb: A Lightweight, High-Speed _Immutable_ Database](https://github.com/codenotary/immudb) — Data can’t be changed in this database so it’s well suited for storing every update to _other_ databases for auditing purposes, perhaps, or maybe log streams or public certificates. Written in Go. CodeNotary [Comparing CQL and the DynamoDB API](https://www.scylladb.com/2020/05/12/comparing-cql-and-the-dynamodb-api/) — A comparison of the Cassandra Query Language (CQL) with DynamoDB’s API, both of which are now supported in Scylla Open Source (we featured the release of [Scylla 4.0](https://www.scylladb.com/2020/05/07/introducing-scylla-open-source-4-0/) last week). Nadav Har'El (Scylla) [How Network Latency Makes a Big Difference to Database Performance](https://www.cybertec-postgresql.com/en/postgresql-network-latency-does-make-a-big-difference/) — Getting your queries as fast as possible is great, but network latency is important too. Hans-Jürgen demonstrates how to measure its impact in a situation with simulated latency. Hans-Jürgen Schönig [SQLite Helper Queries: Simplifying Queries with Common Table Expressions](https://www.alecstrong.com/2020/05/cte/) — If you didn’t know SQLite supports CTEs (in 3.8.3 and higher), this might be an eye opener. Alec Strong ▶[Databases on Kubernetes: Why You Should Care](https://www.youtube.com/watch?v=yoj_vSTPB54) — Now Kubernetes supports StatefulSets and CRDs, one of the next logical steps is to run databases on it.. Denis Rosa [Real-Time APIs Using SQL for MongoDB](https://rockset.com/solutions/mongodb/) — Rockset’s indexing layer gives developers fast search, joins and aggregations on MongoDB data. Rockset sponsor [Tuning MySQL/InnoDB Flushing for a Write-Intensive Workload](https://www.percona.com/blog/2020/05/14/tuning-mysql-innodb-flushing-for-a-write-intensive-workload/) Yves Trudeau [Microsoft and Redis Labs Collaborate to Give Developers New Azure Cache for Redis Capabilities](https://azure.microsoft.com/en-us/blog/microsoft-and-redis-labs-collaborate-to-give-developers-new-azure-cache-for-redis-capabilities/) — A new partnership between Microsoft and Redis Labs to bring their industry-leading technology and expertise to Azure Cache for Redis. Julia Liuson (Microsoft) [Introducing MongoDB for VS Code](https://www.mongodb.com/blog/post/introducing-mongodb-for-vs-code) — MongoDB has rolled out an official extension that makes it easy to work with MongoDB directly from Visual Studio Code. You can navigate data, play in a MongoDB playground, and get quick access to the MongoDB shell. MongoDB, Inc. [PostgreSQL 12.3, 11.8, 10.13, 9.6.18, and 9.5.22 Released](https://www.postgresql.org/about/news/2038/) — Fixes 75 bugs reported since the last mass release, but one key Windows-only security issue. PostgreSQL Global Development Group A **[Cooperpress](https://cooperpress.com/)** publication. [Change your email address](https://dbweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://dbweekly.com/leave/*|UID|*) © Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom ![](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/ocamglrb31el0eklg3et.jpg)