Thursday, 23 November 2017
Interesting Snippets from 2017-11-23
-
No boundaries: Exfiltration of personal data by session-replay scripts
You may know that most websites have third-party analytics scripts that record which pages you visit and the searches you make. But lately, more and more sites use “session replay” scripts. These scripts record your keystrokes, mouse movements, and scrolling behavior, along with the entire contents of the pages you visit, and send them to third-party servers. Unlike typical analytics services that provide aggregate statistics, these scripts are intended for the recording and playback of individual browsing sessions, as if someone is looking over your shoulder.
Interesting Snippets from 2017-11-16
-
Inside a low budget consumer hardware espionage implant
The S8 data line locator is a GSM listening and location device hidden inside the plug of a standard USB data/charging cable. It supports the 850, 900, 1800 and 1900 MHz GSM frequencies.
Interesting Snippets from 2017-11-14
-
GitHub - k88hudson/git-flight-rules: Flight rules for git
A guide for astronauts (now, programmers using git) about what to do when things go wrong.
-
GitHub - simonw/datasette: An instant JSON API for your SQLite databases
Datasette provides an instant, read-only JSON API for any SQLite database. It also provides tools for packaging the database up as a Docker container and deploying that container to hosting providers such as Zeit Now.
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.
Interesting Snippets from 2017-11-06
-
Security - Airborn OS
We've gone to really great lengths to make sure that even if our server gets hacked, the hackers still can't read your documents. We can't read them either, nor can our hosting provider, our CDN, our storage provider, or the intern we wish we had.
-
GitHub - mbeaudru/modern-js-cheatsheet: Cheatsheet for the JavaScript knowledge you will frequently encounter in modern projects.
This guide is not intended to teach you JavaScript from the ground up, but to help developers with basic knowledge who may struggle to get familiar with modern codebases (or let's say to learn React for instance) because of the JavaScript concepts used.
-
GitHub - vuetifyjs/vuetify: Material Component Framework for Vue.js 2
Vuetify.js is a semantic component framework for Vue.js 2. It aims to provide clean, semantic and reusable components that make building your application a breeze. Vuetify.js uses Google's Material Design design pattern, taking cues from other popular frameworks such as Materialize.css, Material Design Lite, Semantic UI and Bootstrap 4
-
GitHub - naver/billboard.js: Re-usable, easy interface JavaScript chart library based on D3 v4+
billboard.js is a re-usable, easy interface JavaScript chart library, based on D3 v4+. The name "billboard" comes from the famous billboard chart which everybody knows. This project was forked from C3.js v0.4.11.
-
GitHub - IBM/vue-a11y-calendar: Accessible, internationalized Vue calendar
Localized, accessible calendar and datepicker for Vue with no external dependencies.
-
Falcor: One Model Everywhere
Falcor lets you represent all your remote data sources as a single domain model via a virtual JSON graph. You code the same way no matter where the data is, whether in memory on the client or over the network on the server.
-
GitHub - nickpisacane/CsvBuilder: Easily encode complex JSON objects to CSV with CsvBuilder's schema-like API
Easily encode complex JSON objects to CSV with CsvBuilder's schema-like API.
-
GitHub - chipto/regexly: WYSIWYG Regex playground for those who JavaScript
A WYSIWYG Regex Playground for JavaScript Developers
-
GitHub - SelectTransform/st.js: JSON template over JSON
JSON Selector + Transformer
-
GitHub - maptalks/maptalks.js: A light JavaScript library for integrated 2D/3D maps.
maptalks.js was born for a map-centric project to help YUM! China (the most successful food chain in China) manage and analyze spatial data all over the country for choosing locations of new KFC and PizzaHut restaurants. After verified in many projects of government depts and enterprises, we are glad to open source it, and hoping it can help you deliver better mapping projects.
-
Why Prettier? · Prettier
By far the biggest reason for adopting prettier is to stop all the ongoing debates over styles. It is generally accepted that having a common style guide is valuable for a project & team but getting there is a very painful and unrewarding process. People get very emotional around particular ways of writing code and nobody likes spending time writing and receiving nits.
-
GitHub - Nickersoft/push.js: The world's most versatile desktop notifications framework
Push is the fastest way to get up and running with Javascript desktop notifications. A fairly new addition to the official specification, the Notification API allows modern browsers such as Chrome, Safari, Firefox, and IE 9+ to push notifications to a user's desktop. Push acts as a cross-browser solution to this API, falling back to use older implementations if the user's browser does not support the new API.
-
Strapi.io - API creation made simple, secure and fast.
The most advanced open-source Content Management Framework to build powerful API with no effort.