--- title: "Litetree, an experimental way to bring Git-like branching to SQLite" publication: "DB Weekly" issue: 219 published_at: "2018-08-31" canonical_url: "https://dbweekly.com/issues/219" --- This week's database news #219 — August 31, 2018 [Read on the Web](https://dbweekly.com/issues/219) Database Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/dj5zkewy6t3xpzlydbiy.jpg)](https://www.infoq.com/presentations/paypal-ml-fraud-prevention-2018) ▶[PayPal's ML Data Pipelines for Real-Time Fraud Prevention](https://www.infoq.com/presentations/paypal-ml-fraud-prevention-2018) — A look at the approach PayPal takes with its internal machine learning powered tools which make real-time decisions about transactions for fraud protection purposes. Mikhail Kourjanski [LiteTree: SQLite with Branches](https://github.com/aergoio/litetree) — An interesting modification of the SQLite engine to support Git-like branching. Aergo [![\](https://copm.s3.amazonaws.com/10a7dc69.png)](https://studio3t.com/knowledge-base/articles/create-mongodb-joins-with-sql/?utm_source=studio3t&utm_medium=cooper&utm_campaign=aug2018) [Got SQL Skills? Transfer Them to MongoDB, with SQL Joins from Studio 3T](https://studio3t.com/knowledge-base/articles/create-mongodb-joins-with-sql/?utm_source=studio3t&utm_medium=cooper&utm_campaign=aug2018) — Read “How to Create MongoDB Joins Using SQL”, to see how you too can be a MongoDB master, using Studio 3T. Studio 3T sponsor [It’s Time for the Open Source Community to Get Real](https://www.influxdata.com/blog/its-time-for-the-open-source-community-to-get-real/) — An interesting piece by Paul Dix, of InfluxDB fame, reflecting on last week’s Redis news around RedisLabs relicensing certain Redis modules – _“if a company like RedisLabs happens to be commercializing some part of Redis while still contributing a significant amount to freely available permissive BSD Redis, they should be commended, not attacked.”_ Paul Dix [CNCF (Cloud Native Computing Foundation) to Host TiKV in the Sandbox](https://www.cncf.io/blog/2018/08/28/cncf-to-host-tikv-in-the-sandbox/) — [TiKV](https://github.com/tikv/tikv) is an open source distributed transactional key-value database (inspired by Google Spanner) and it’s being taken under the wing of the CNCF. Kristen Evans [We Need to Resurrect Desktop Databases](https://www.apress.com/us/blog/all-blog-posts/we-need-to-resurrect-desktop-databases/16063812) — _“The time is ripe for desktop database engines to not just be resurrected, but also remembered by users who need to run analytics on slowly changing or informal datasets.”_ Rahul Batra [Cloudian, an Object Storage System Provider, Raises $94M](https://www.datanami.com/2018/08/29/cloudian-sees-94m-for-object-funding/) — The largest ever funding round for an object storage company and Cloudian thinks this shows [object storage is coming of age.](https://cloudian.com/blog/cloudian-announces-94m-series-e-funding-what-this-means-for-object-storage/) Datanami [Building a Serverless App with MongoDB Stitch](http://thecodebarbarian.com/building-a-serverless-app-with-mongodb-stitch.html) — [MongoDB Stitch](https://stitch.mongodb.com/) is a MongoDB-based serverless platform that can make it quicker to build apps in the cloud. This tutorial is a practical demonstration of using it to build a stock price monitoring app. Valeri Karpov [Creating JSON Changelogs with SQLite](https://blog.budgetwithbuckets.com/2018/08/27/sqlite-changelog.html) — A way to add change tracking to a SQLite database using triggers. Buckets Blog [How to Write Multiset Conditions With Oracle VARRAY Types](https://blog.jooq.org/2018/08/15/how-to-write-multiset-conditions-with-oracle-varray-types/) — Oracle is one of the few databases that implement the SQL standard ORDBMS extension. Lukas Eder [From Big Data to Micro-Services: How to Serve Spark-Trained Models Through AWS Lambdas](https://towardsdatascience.com/from-big-data-to-micro-services-how-to-serve-spark-trained-models-through-aws-lambdas-ebe129f4849c) — A quick and Pythonic way to power endpoints with pre-trained Spark models. Jacopo Tagliabue ▶[Building Chat Bots to Monitor and Manage MongoDB Deployments](https://www.youtube.com/watch?v=Pw07cctq-fk) — _Free the DBA!_ by harnessing the power of chat bots to assist with the triage and management of MongoDB related issues. Mike LaSpina (MongoDB, Inc.) [The Most Complete Open Source Database Platform](https://www.enterprisedb.com/products/edb-postgres-platform) — Enterprise proven, multi-model, with rapid deployment in the cloud and on-premises. Learn more today. EnterpriseDB sponsor [IBM Cloud SQL Query Now Generally Available](https://www.ibm.com/blogs/bluemix/2018/08/sql-query-service-announces-general-availability/) — A managed service to query numerous datatypes (stored on IBM Cloud Object Storage) with SQL, a la Amazon’s [Athena](https://aws.amazon.com/athena/). Chris Glew [Couchbase Launches First NoSQL Autonomous Operator for Kubernetes](https://www.couchbase.com/press-releases/couchbase-launches-first-nosql-autonomous-operator-for-kubernetes) Couchbase [Announcing Public Preview Availability of MySQL Online Migration in Azure Database Migration Service](https://blogs.msdn.microsoft.com/datamigration/2018/08/30/announcing-public-preview-availability-of-mysql-online-migration-in-azure-database-migration-service/) Microsoft Data Migration Blog 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