- The Log-Structured Merge-Tree (LSM-Tree)
- B-Tree vs Log-Structured Merge-Tree
- Modern B-tree techniques
- LSM-based Storage Techniques: A Survey
- B-tree Indexes and CPU Caches by Goetz Graefe and Per-Åke Larson
/* Source: http://www.boxofficemojo.com/alltime/world/ */ | |
CREATE TABLE topmovies( | |
Rank INTEGER, | |
Title TEXT, | |
Studio TEXT, | |
Worldwide REAL, | |
Domestic REAL, | |
DomesticPct REAL, | |
Overseas REAL, | |
OverseasPct REAL, |
/* | |
Solar system objects | |
Adapted from: http://en.wikipedia.org/wiki/List_of_Solar_System_objects_by_size | |
Collected by: https://www.khanacademy.org/profile/patrick809/programs | |
*/ | |
CREATE TABLE solar_system_objects( | |
body TEXT | |
, mean_radius NUMERIC /* km */ | |
, mean_radius_rel NUMERIC /* relative to earth */ | |
, volume NUMERIC /* 10^9 km^3 */ |
/* Marvel Heroes and Villains | |
Based on the website http://marvel.wikia.com/Main_Page | |
with popularity data from http://observationdeck.io9.com/something-i-found-marvel-character-popularity-poll-cb-1568108064 | |
and power grid data from http://marvel.wikia.com/Power_Grid#Power | |
Collected by: https://www.khanacademy.org/profile/Mentrasto/ | |
*/ | |
CREATE TABLE marvels (ID INTEGER PRIMARY KEY, | |
name TEXT, | |
popularity INTEGER, |
/* | |
Sales from an online furniture store | |
Collected by: https://www.khanacademy.org/profile/charlesb2000/ | |
*/ | |
CREATE TABLE sales( | |
ID INTEGER NOT NULL PRIMARY KEY | |
, transaction_date TEXT | |
, product TEXT | |
, price INTEGER | |
, payment_type TEXT |
/* Source: | |
https://www.kaggle.com/nasa/astronaut-yearbook | |
*/ | |
CREATE TABLE astronauts( | |
Name TEXT PRIMARY KEY, | |
Year INTEGER, | |
GroupNum INTEGER, | |
Status TEXT, | |
Birth_Date TEXT, | |
Birth_Place TEXT, |
CREATE TABLE pokemon( | |
Number INTEGER, | |
Name TEXT PRIMARY KEY, | |
Type_1 TEXT, | |
Type_2 TEXT, | |
Total INTEGER, | |
HP INTEGER, | |
Attack INTEGER, | |
Defense INTEGER, | |
Sp_Atk INTEGER, |
/* | |
Countries and dependent territories, 2020 | |
Data adapted from | |
http://www.worldometers.info/world-population/population-by-country/ | |
Does not include rows which had "N.A." values, so some territories are missing. | |
*/ | |
CREATE TABLE countries( | |
name TEXT PRIMARY KEY, | |
population INTEGER, |
This should make True Color (24-bit) and italics work in your tmux session and vim/neovim when using Alacritty (and should be compatible with any other terminal emulator, including Kitty).
Running this script should look the same in tmux as without.
curl -s https://gist.githubusercontent.com/lifepillar/09a44b8cf0f9397465614e622979107f/raw/24-bit-color.sh >24-bit-color.sh