更新于：2024-12-05

数据库

trdsql

trdsql一个可以在CSV和LTSV上执行SQL查询的工具 https://github.com/noborus/trdsqlhttps://github.com/noborus/trdsql

trdsql 使用示例

./trdsql -oat -config config.json "select * from table_example where id=1"

config.json 配置示例

{
  "db": "mdb",
  "database": {
    "sdb": {
      "driver": "sqlite3",
      "dsn": ""
    },
    "pdb": {
      "driver": "postgres",
      "dsn": "user=test dbname=test"
    },
    "mdb": {
      "driver": "mysql",
      "dsn": "test:test@tcp(ubuntu.wsl:4000)/example?charset=utf8mb4"
    }
  }
}