# @sundawning/sqlite-database-server

> SQLite 数据库服务器，用一堆 SQLite 格式的文件来搭建服务器，以HTTP的方式来管理数据库。

Latest version **1.0.1** (published 2022-10-22) · MIT license · 0 weekly downloads

## Install

```sh
npm install @sundawning/sqlite-database-server
pnpm add @sundawning/sqlite-database-server
yarn add @sundawning/sqlite-database-server
bun add @sundawning/sqlite-database-server
```

Provides the command `sundawning-sqlite-database-server`.

## Health

**Score 15/100 (F)** — status: abandoned.

Positive: no vulnerabilities.

Warnings: low downloads; no types; no esm support.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 1.0.1 |
| Published | 2022-10-22 |
| First published | 2022-09-24 |
| Weekly downloads | 0 |
| License | MIT |
| TypeScript types | none |
| Module format | CommonJS |
| Dependencies | 7 |
| Unpacked size | 5 KB |
| Known vulnerabilities | 0 |
| Install scripts | no |
| GitHub stars | 0 |
| Author | sundawning |
| Maintainers | sundawning |
| Keywords | sundawning, sqlite, database, server |

## Links

- npm: https://www.npmjs.com/package/@sundawning/sqlite-database-server
- Repository: https://github.com/sundawning/sundawning.github.io
- Homepage: https://github.com/sundawning/sundawning.github.io/tree/master/projects/node/npm/@sundawning/sqlite-database-server
- Issues: https://github.com/sundawning/sundawning.github.io/issues
- npm.io page: https://npm.io/package/@sundawning/sqlite-database-server

## Dependencies (7)

- [koa](https://npm.io/package/koa.md) ^2.13.4
- [sqlite](https://npm.io/package/sqlite.md) ^4.1.2
- [sqlite3](https://npm.io/package/sqlite3.md) ^5.1.1
- [fs-extra](https://npm.io/package/fs-extra.md) ^10.1.0
- [koa-body](https://npm.io/package/koa-body.md) ^5.0.0
- [minimist](https://npm.io/package/minimist.md) ^1.2.7
- [koa-router](https://npm.io/package/koa-router.md) ^12.0.0

## Alternatives

- [@libsql/sqlite3](https://npm.io/package/@libsql/sqlite3.md) — 39.8K weekly downloads
- [@fortemi/core](https://npm.io/package/@fortemi/core.md) — 461 weekly downloads
- [cdb-converter](https://npm.io/package/cdb-converter.md) — 341 weekly downloads
- [@uplo/adapter-prisma](https://npm.io/package/@uplo/adapter-prisma.md) — 75 weekly downloads
- [typeorm-aios](https://npm.io/package/typeorm-aios.md) — 30 weekly downloads

## Recent versions

- 1.0.1 (latest) — 2022-10-22
- 1.0.0 — 2022-09-24

## README

SQLite 数据库服务器，用一堆 SQLite 格式的文件来搭建服务器，以 HTTP 的方式来管理数据库。

2022-09-21 20:19:25

# 安装

```sh
pnpm add @sundawning/sqlite-database-server
```

# 使用

启动服务器：

```js
const SQLiteServer = require("@sudnawning/sqlite-database-server");
SQLiteServer.start({
  port: 1234,
});
```

可以处理如下请求：

- POST /api/databases/:database_name

## POST /api/databases/:database_name

查询 hello 数据库的所有表名：

POST /api/databases/hello

Content-Type: application/json

```json
{
  "sql": "SELECT * FROM sqlite_master WHERE type = 'table'"
}
```

会返回：

```json
[
  {
    "type": "table",
    "name": "table_1",
    "tbl_name": "table_1",
    "rootpage": 2,
    "sql": "CREATE TABLE table_1 ( key INTEGER PRIMARY KEY AUTOINCREMENT )"
  },
  {
    "type": "table",
    "name": "sqlite_sequence",
    "tbl_name": "sqlite_sequence",
    "rootpage": 3,
    "sql": "CREATE TABLE sqlite_sequence(name,seq)"
  }
]
```

# 命令行

## 安装

```sh
pnpm add -g @sundawning/sqlite-database-server
```

## 使用

参数与包在代码里的参数保持一致，在命令行中以“--”开头即可。

比如 28080 端口，数据库文件夹在“./files”（默认是“./databases”）：

```sh
sundawning-sqlite-database-server --port 28080 --databases_directory ./files
```

---
_Source: https://npm.io/package/@sundawning/sqlite-database-server · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._