SQL

• Flag
• 其他数据库
• Redis
• MongoDB

Flag

• https://github.com/dunwu/db-tutorial (opens new window)
• https://docs.aws.amazon.com/zh_cn/redshift/latest/dg/cm_chap_SQLCommandRef.html (opens new window)
• https://www.alibabacloud.com/help/zh/analyticdb-for-mysql/latest/sql-manual (opens new window)
• 自学SQL网 http://xuesql.cn (opens new window)
• 数据库压测 https://github.com/akopytov/sysbench (opens new window)
• https://github.com/stcarrez/sql-benchmark (opens new window)
• 优化和改写 https://github.com/XiaoMi/soar (opens new window)
• https://www.1keydata.com/cn/sql (opens new window)
• https://www.twle.cn/l/yufei/sql/sql-basic-index.html (opens new window)
• https://www.begtut.com/sql/sql-ref-keywords.html (opens new window)
• https://wizardforcel.gitbooks.io/w3school-sql (opens new window)
• HiveSQL教程 https://www.gairuo.com/p/hive-sql-tutorial (opens new window)

备份/迁移/同步/导入导出

• https://github.com/topics/binlog (opens new window)
• https://github.com/topics/flashback (opens new window)
• 迁移 https://github.com/topics/migrations (opens new window)
• https://github.com/topics/migration (opens new window)

• 同步 https://github.com/alibaba/DataX (opens new window)
• 日志解析订阅和消费 https://github.com/alibaba/canal (opens new window)
• https://github.com/ucarGroup/DataLink (opens new window)
• 数据库迁移 https://github.com/flyway/flyway (opens new window)
• Go编写的数据库迁移 https://github.com/golang-migrate/migrate (opens new window)
• PostgreSQL迁移 https://github.com/jackc/tern (opens new window)
• https://github.com/DTStack/flinkx (opens new window)
• https://gitee.com/ghi/dbsyncer (opens new window)
• https://github.com/jeessy2/backup-x (opens new window)
• https://github.com/jeessy2/backup-db (opens new window)

数据库分类

1. 关系型数据库(SQL)
2. 非关系型数据库(NoSQL)：键值、列存储、图形、文档、搜索引擎
3. 网状数据库
4. 层次数据库
5. 新型数据库(NewSQL)：关系型数据库与NoSQL的结合 The bridge between SQL and NoSQL (opens new window)
6. 分布式数据库

NoSQL

• 1970: NoSQL = We have no SQL
• 1980: NoSQL = Know SQL
• 2000: NoSQL = No SQL!
• 2005: NoSQL = Not only SQL
• 2013: NoSQL = No, SQL!

其他数据库

• https://github.com/cmu-db/dbdb.io (opens new window)
• https://github.com/polardb (opens new window)
• https://db-engines.com/en/ranking (opens new window)

• sqlite克隆 https://github.com/cstack/db_tutorial (opens new window)
• http://www.h2database.com (opens new window)
• http://hsqldb.org (opens new window)
• https://github.com/FirebirdSQL/firebird (opens new window)
• https://github.com/citusdata/citus (opens new window)
• 分布式 https://github.com/cockroachdb/cockroach (opens new window)
• https://github.com/apache/ignite (opens new window)
  • http://blog.nimblex.cn/archives (opens new window)
  • https://www.ignite-service.cn/doc/java (opens new window)
  • https://github.com/owen-jia/ignite-yardstick (opens new window)
• https://github.com/rethinkdb (opens new window)
• https://github.com/pingcap/tidb (opens new window)
  • https://pingcap.com (opens new window)
• https://github.com/tikv/tikv (opens new window)
• https://github.com/yugabyte/yugabyte-db (opens new window)
• https://github.com/prestodb/presto (opens new window)
• https://github.com/apache/cassandra (opens new window)
• https://github.com/apache/kudu (opens new window)
• DynamoDB
• https://github.com/KvrocksLabs/kvrocks (opens new window)
• CrateDB https://github.com/crate/crate (opens new window)
• https://github.com/influxdata/influxdb (opens new window)
• https://github.com/VictoriaMetrics/VictoriaMetrics (opens new window)
• 使用Raft算法 https://github.com/etcd-io/etcd (opens new window)
• https://github.com/etcd-io/bbolt (opens new window)
• https://github.com/jnwatson/py-lmdb (opens new window)
• https://github.com/basho/riak (opens new window)
• K/V数据库 https://github.com/google/leveldb (opens new window)
• https://github.com/couchbase/moss (opens new window)
• https://github.com/memcached/memcached (opens new window)
• https://github.com/sirixdb (opens new window)
• https://github.com/scylladb/scylla (opens new window)
• https://github.com/erthink/libmdbx (opens new window)
• https://github.com/EQ-Alpha/KeyDB (opens new window)
• https://github.com/apache/incubator-pegasus (opens new window)
• https://github.com/FoundationDB/fdb-record-layer (opens new window)
• https://github.com/flower-corp/rosedb (opens new window)
• https://github.com/hivedb/hive (opens new window)
• https://github.com/facebook/rocksdb (opens new window)
• https://github.com/cockroachdb/pebble (opens new window)
• https://github.com/pmqs/BerkeleyDB (opens new window)
• 面向列的数据库 https://github.com/ClickHouse/ClickHouse (opens new window)
• Go嵌入式(S)QL数据库 https://gitlab.com/cznic/ql (opens new window)
• https://github.com/oceanbase/oceanbase (opens new window)
• https://github.com/roseduan/rosedb (opens new window)
• 时间序列数据库 https://github.com/OpenTSDB/opentsdb (opens new window)
• https://github.com/timescale/timescaledb (opens new window)
• https://github.com/apache/hbase (opens new window)
• https://github.com/baidu/BaikalDB (opens new window)
• https://gitee.com/mirrors/EdgeFS (opens new window)
• https://github.com/Tencent/paxosstore (opens new window)
• https://github.com/taosdata/TDengine (opens new window)
• https://github.com/infinispan/infinispan (opens new window)
• https://github.com/griddb/griddb (opens new window)
• https://github.com/RocksCloud/rocksredis (opens new window)
• 物联网 https://github.com/apache/iotdb (opens new window)
• 内存关系数据库 https://github.com/VoltDB/voltdb (opens new window)
• https://github.com/memsql (opens new window)
  • https://www.singlestore.com (opens new window)
• https://github.com/cmu-db/noisepage (opens new window)
• 不可变数据库 https://github.com/codenotary/immudb (opens new window)

• https://github.com/bridgedb/BridgeDb (opens new window)
• 去中心化 https://github.com/dolthub/dolt (opens new window)
  • https://github.com/attic-labs/noms (opens new window)
• 移动数据库 https://github.com/realm/realm-core (opens new window)
• 数据流 https://github.com/mit-pdos/noria (opens new window)
• 矢量数据库 https://github.com/milvus-io/milvus (opens new window)
• https://github.com/topics/spark (opens new window)
  • https://github.com/apache/spark (opens new window)
    • https://github.com/allwefantasy/spark-binlog (opens new window)
  • https://github.com/spark-jobserver (opens new window)
  • https://github.com/JerryLead/SparkInternals (opens new window)
  • https://github.com/lw-lin/CoolplaySpark (opens new window)
  • https://github.com/databricks/koalas (opens new window)
• https://github.com/snowflakedb (opens new window)
• https://www.microsoft.com/zh-cn/sql-server (opens new window)

图数据库 (opens new window)

• 图数据库 https://github.com/neo4j/neo4j (opens new window)
• https://github.com/distributedio/titan (opens new window)
• 分布式图形数据库 https://github.com/JanusGraph (opens new window)
• https://github.com/JanusGraph/janusgraph (opens new window)
• https://github.com/sones/sones (opens new window)
• https://github.com/CodyKochmann/graphdb (opens new window)
• 图形数据库 https://github.com/vesoft-inc/nebula (opens new window)
• https://github.com/orientechnologies/orientdb (opens new window)
• https://github.com/arangodb/arangodb (opens new window)
• 多模型数据库 https://github.com/arangodb/arangodb (opens new window)
• https://github.com/apache/couchdb (opens new window)
• https://github.com/apache/incubator-hugegraph (opens new window)
• https://github.com/TrinityCore/TrinityCore (opens new window)
• https://github.com/cayleygraph/cayley (opens new window)
• https://objectivity.com/infinitegraph (opens new window)
  • https://infinitegraph.com (opens new window)
  • https://github.com/objectivity/JavaULBTraining (opens new window)
• https://allegrograph.com (opens new window)

Redis

• https://github.com/redis (opens new window)
• https://redis.io/documentation (opens new window)

• https://github.com/huangz1990 (opens new window)
  • http://redisdoc.com (opens new window)
  • http://doc.redisfans.com (opens new window)
• https://github.com/antirez/redis-doc (opens new window)
  • http://www.redis.cn/documentation.html (opens new window)
• https://github.com/guodongxiaren/redis-wiki (opens new window)
• https://github.com/yu-linfeng/redis5.x_tutorial (opens new window)
• redis常用特性 https://github.com/LxyTe/redis (opens new window)

• 基于Redis和S3分布式POSIX文件系统 https://github.com/juicedata/juicefs (opens new window)

Java客户端

• https://github.com/redisson (opens new window)
• https://github.com/RedisJSON (opens new window)
• https://github.com/lettuce-io/lettuce-core (opens new window)
  • Lettuce相较于Jedis有哪些优缺点？ (opens new window)

C#客户端

• https://github.com/imperugo/StackExchange.Redis.Extensions (opens new window)

存储方式

• 适合用 String 存储的情况：
  • 每次需要访问大量的字段
  • 存储的结构具有多层嵌套的时候
• 适合用 Hash 存储的情况：
  • 在大多数情况中只需要访问少量字段
  • 自己始终知道哪些字段可用，防止使用 mget 时获取不到想要的数据

安装

wget https://download.redis.io/redis-stable.tar.gz
tar -zvf redis-stable.tar.gz
cd redis-stable
make
make install
cp redis.conf /etc/redis.conf
vi /etc/redis.conf

输入/daemon按A或i把daemonize no改成daemonize yes 允许任意IP访问：输入/NETWORK搜索，替换bind 127.0.0.1为bind 0.0.0.0 设置访问密码：输入/SECURITY搜索，取消注释requirepass foobared 修改protected-mode yes(保护模式，需配置设置访问密码) 为 protected-mode no

# 启动
redis-server /etc/redis.conf
ps -ef | grep redis
# 连接redis
redis-cli -p 端口 -a 密码
# 配置设置密码，不会修改配置文件
config set requirepass 密码
# 单实例关闭redis
redis-cli shutdown
# 多实例关闭，指定端口关闭redis
redis-cli -p 6379 shutdown

MongoDB

• https://github.com/mongodb (opens new window)

• 客户端 https://github.com/Studio3T/robomongo (opens new window)
• 存储引擎模块 https://github.com/mongodb-partners/mongo-rocks (opens new window)
• https://github.com/erikolson186/zangodb (opens new window)

• MongoDB 高级查询 (opens new window)