Interesting Snippets from 2017-11-07

• Franchise: a sql notebook

  an open-source notebook for sql

• TigerGraph Emerges with Native Parallel Graph Database

  A startup named TigerGraph emerged from stealth today with a new native parallel graph database that its founder thinks can shake up the analytics market.

• SQL Date Formatting Tool

  This utility is meant to help you parse and format dates when using Microsoft SQL Server.

• Migrating a database from InnoDB to MyRocks | Engineering Blog | Facebook Code | Facebook

  Last year, we introduced MyRocks, our new MySQL database engine, with the goal of improving space and write efficiency beyond what was possible with compressed InnoDB. Our objective was to migrate one of our main databases (UDB) from compressed InnoDB to MyRocks and reduce the amount of storage and number of servers used by half.

• How to Write Efficient TOP N Queries in SQL – Java, SQL and jOOQ.

  A very common type of SQL query is the TOP-N query, where we need the “TOP N” records ordered by some value, possibly per category. In this blog post, we’re going to look into a variety of different aspects to this problem, as well as how to solve them with standard and non-standard SQL.

• Why did we choose Rust over Golang or C/C++ to develop TiKV? · TiDB Blog

  The minimum runtime and efficient C bindings empower Rust to be as efficient as C and C++, thus making it very suitable for the systems programming field where high performance matters the most. The powerful type system and unique life cycle management facilitate the memory management during the compiling, which ensures the memory and thread safety and makes the program run very fast after the compiling. Rust provides pattern matching and type inference like a functional programming language and makes the code simple and elegant.

• Scaling the GitLab database | GitLab

  For a long time GitLab.com used a single PostgreSQL database server and a single replica for disaster recovery purposes. This worked reasonably well for the first few years of GitLab.com's existence, but over time we began seeing more and more problems with this setup. In this article we'll take a look at what we did to help solve these problems for both GitLab.com and self-hosted GitLab instances.

• Learn about different I/O Access Methods and what we chose for Scylla

  When most server application developers think of I/O, they consider network I/O since most resources these days are accessed over the network: databases, object storage, and other microservices. The developer of a database, however, also has to consider file I/O. This article describes the available choices and their tradeoffs and why Scylla chose asynchronous direct I/O (AIO/DIO) as its access method.

• GitHub - hyperia-sk/memcache-info: Simple and efficient way to show information about Memcache.

  memcache-info is a simple and efficient way to show info about Memcache.

• Scalable SQL Made Easy: How CockroachDB Automates Operations | Cockroach Labs

  A modern distributed database should do more than just split data amongst a number of servers; it should correctly manage partitions (or shards). Moreso, it should automatically detect failures, fix itself without any operator intervention, and completely abstract this management from the end user. This post is the first in a series on how CockroachDB handles its data and discusses the mechanisms it uses to rebalance and repair. These systems make managing a CockroachDB cluster significantly easier than managing other databases.

• GitHub - paulfitz/visql: edit slices of SQL databases in vi

  Edit slices of SQL tables in vi. Just specify a table and any filters you want to apply, and the table will show up in vi in csv format. Any edits you make will be applied back to the original source.

• 7 keys to better MySQL performance | InfoWorld

  As size and load grow, performance tends to slow. Keep these keys in mind to keep MySQL running smoothly

• A Minimalist Guide to SQLite

  SQLite is a self-contained, serverless SQL database. Dr. Richard Hipp, the creator of SQLite, first released the software on the 17th of August, 2000. Since then it has gone on to be the second most deployed piece of software in the world. It's used in systems as important as the Airbus A350 so it comes as no surprise the tests for SQLite 3 are aviation-grade. The software itself is very small, the amd64 Debian client and library package is 765 KB when compressed for distribution and 2.3 MB when fully installed.

• How to Optimize MySQL: Indexes, Slow Queries, Configuration — SitePoint

  MySQL is still the world’s most popular relational database, and yet, it’s still the most unoptimized – many people leave it at default values, not bothering to investigate further. In this article, we’ll look at some MySQL optimization tips we’ve covered previously, and combine them with novelties that came out since.

[/snippets] permanent link