--- title: "Three database podcast episodes to check out" publication: "DB Weekly" issue: 277 published_at: "2019-10-25" canonical_url: "https://dbweekly.com/issues/277" --- This week's database news #277 — October 25, 2019 [Read on the Web](https://dbweekly.com/issues/277) Database Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/v1562325808/g6ul9s0x1bymmu2rujws.jpg)](https://uwekorn.com/2019/10/19/taking-duckdb-for-a-spin.html) [Taking DuckDB for a Spin](https://uwekorn.com/2019/10/19/taking-duckdb-for-a-spin.html) — Featured back in [issue 261](https://dbweekly.com/issues/261), DuckDB is _billed_ (geddit?) as being like ‘SQLite for analytics’, but does it deliver? Uwe Korn [How DataDome Stores 200,000 Documents Per Second in Elasticsearch](https://datadome.co/store-50-million-event-per-second-in-elasticsearch/) — Datadome, a cybersecurity company, logs 50 million events per second for its customers to analyze and search over for a 30 day period.. which results in them running a pretty significant Elasticsearch cluster. DataDome [Cyberespionage Group Creates a Backdoor Targeting Microsoft SQL Server](https://www.eset.com/int/about/newsroom/press-releases/research/eset-research-cyberespionage-group-winnti-creates-a-backdoor-targeting-microsoft-sql-server/) — skip-2.0 is a backdoor in SQL Server 11 and 12 that allows hackers to go undetected by means of a “magic password”. ESET Research [![\](https://copm.s3.amazonaws.com/6c4d5244.jpg)](https://theartofpostgresql.com) [The Art of PostgreSQL: A Book to Learn How to Best Use SQL from Your App](https://theartofpostgresql.com) — The book that teaches SQL to developers: learn to replace thousands of lines code with simple SQL queries. Worth reading even if you're not using Postgres yet. The Art of PostgreSQL sponsor [PostGIS 3.0.0: Geospatial Objects for PostgreSQL](http://postgis.net/2019/10/20/postgis-3.0.0/) — A long time in the coming, PostGIS 3.0 takes the popular spatial Postgres extension into the Postgres 12 world, moves raster support into a separate extension, and significantly improves performance via parallelization (a bit more about this [here](https://carto.com/blog/postgis-3-release/)). PostGIS Developers [How Shopify Manages Petabyte-Scale MySQL Backup and Restore](https://engineering.shopify.com/blogs/engineering/shopify-manages-petabyte-scale-mysql-backup-restore) — The popular ecommerce platform runs a large fleet of MySQL servers, with numerous replica-sets spread across three Google Cloud Platform (GCP) regions. Shopify Engineering 🎧 Podcasts of the Week There have been a few interesting database related podcast episodes this week that are worth checking out if you have time: ▶[The Power of Time Series Databases with Paul Dix](https://www.screaminginthecloud.com/episodes/the-power-of-time-series-databases-with-paul-dix) — The CTO at InfluxDB, makers of the eponymous open source time-series database, chats with Corey Quinn about _“everything there is to discuss about time-series databases”_. Screaming in the Cloud ▶[Redis with Alvin Richards](https://softwareengineeringdaily.com/2019/10/24/redis-with-alvin-richards/) — Alvin is Chief Product Officer at Redis Labs, a company actively supporting and growing the Redis in-memory data structure server project. Software Engineering Daily ▶[The LinkedIn Data Platform with Carl Steinbach](https://softwareengineeringdaily.com/2019/10/23/linkedin-data-platform-with-carl-steinbach/) — As a social network with petabytes of data, LinkedIn has had to build a pretty serious platform to manage that data. This is a look behind the scenes at how it works. Software Engineering Daily 💻 Jobs [DevOps / System Engineer - Kubernetes, Cloud Foundry, BOSH](https://www.anynines.com/career/devops-system-engineer?utm_source=newsletter&utm_medium=DB%20Weekly&utm_campaign=devops-system-engineer) — You are interested in building and operating highly automated PaaS solutions? Join us. anynines [Have You Tried Vettery?](https://www.vettery.com/tech?utm_source=newsletter&utm_medium=cooper-dbweekly&utm_term=tech&utm_content=grouped&utm_campaign=ad-88878) — Vettery specializes in tech roles and is completely free for job seekers. Create a profile to get started. Vettery 📒 Everything else [9 Techniques to Build Cloud-Native, Geo-Distributed SQL Apps with Low Latency](https://blog.yugabyte.com/9-techniques-to-build-cloud-native-geo-distributed-sql-apps-with-low-latency/) — The various techniques that apps needing low latency and high availability can leverage while using a geo-distributed SQL database like YugabyteDB. Sid Choudhury (YugaByte) [A Beginner’s Guide to Formatting Dates in SQL](https://blog.panoply.io/a-beginners-guide-to-formatting-dates-in-sql) — Date and time types can often throw up challenges in SQL, so it’s good to have tutorials that reflect on the various ways to work with them. Lori Brok [How YugabyteDB Scales to More than 1 Million Inserts Per Sec](https://blog.yugabyte.com/how-yugabytedb-scales-to-more-than-1-million-inserts-per-sec/) Karthik Ranganathan (YugaByte) [Managing Your Database Licensing Relationship with Oracle®](https://info.enterprisedb.com/InfographicPowerYourFutureWithaDifferentOWordOpen.html?utm_source=Cooperpress&utm_medium=ad) — Download this infographic and take a look at the issues of managing a database licensing relationship with Oracle. EnterpriseDB sponsor [RxDB: A Realtime Database for JavaScript Applications](https://github.com/pubkey/rxdb) — You can query the current state but also _subscribe_ to state changes, making it useful for UI-based apps where you want live/real-time updates. It’s not new but it’s had a solid stream of releases recently. pubkey [Aquameta: An Experimental Web Development Platform Built Entirely in Postgres](https://github.com/aquametalabs/aquameta) — I’m a big fan of using the right tools for the right job, but this is an interesting project nonetheless. Apps in Aquameta are _“represented entirely as relational data”_. Aquameta [EuclidesDB: A Multi-Model Machine Learning Feature Database](https://euclidesdb.readthedocs.io/en/latest/) — Tight coupled with PyTorch and provides a backend for including and querying data on the model feature space. Christian S. Perone 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