Download the PHP package yangweijie/think-orm-sqlite-remote without Composer

On this page you can find all versions of the php package yangweijie/think-orm-sqlite-remote. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Example code of yangweijie/think-orm-sqlite-remote

Informations about the package think-orm-sqlite-remote

ThinkPHP ORM SQLite Remote

通过 HTTP Tunnel 或 Socket 访问远程 SQLite 数据库的 ThinkPHP ORM 扩展。

特性

架构

安装

要求 PHP >= 8.4（psl 依赖）

配置

HTTP Tunnel 模式（Navicat 连接）

Socket 模式（事务支持）

使用方法

启动 Socket 守护进程

WAL 模式配置（高并发优化）

WAL 配置说明

参数 默认值 说明
--wal-mode WAL 日志模式（WAL/DELETE）
--busy-timeout 5000 锁等待超时(ms)，高并发建议增大
--wal-checkpoint 1000 自动 checkpoint 阈值
--synchronous NORMAL 同步模式：OFF（最快）、NORMAL（推荐）、FULL（最安全）
--transaction-timeout 60 事务超时(s)，防止长事务阻塞

SQLite PRAGMA 说明

基本查询

事务操作（需要 Socket 模式）

使用 Model

字段缓存

服务端部署

方式一：独立脚本

将 ntunnel_sqlite.php 部署到远程服务器。

方式二：ThinkPHP 路由（推荐）

方式三：完整部署（HTTP + Socket）

Navicat 连接配置

  1. 连接类型选择 SQLite
  2. 选择 HTTP 标签页
  3. 勾选 使用 HTTP 隧道
  4. 隧道网址: http://your-server.com/ntunnel-sqlite
  5. 勾选 使用验证，填写用户名和密码
  6. 数据库文件: 服务器上的绝对路径

协议说明

HTTP Tunnel 协议

与 Navicat 的 ntunnel_sqlite.php 兼容：

Socket 协议

基于 JSON 的请求/响应：

开发与测试

安装开发依赖

运行测试

测试覆盖

注意事项

  1. 事务限制: HTTP Tunnel 模式不支持事务，请使用 Socket 模式
  2. 安全: 使用 Basic Auth 或防火墙保护隧道入口
  3. 性能: Socket 模式比 HTTP 模式性能更好
  4. WAL 模式: 高并发场景推荐启用 WAL 模式
  5. 部署: Socket 守护进程需常驻运行（建议用 Supervisor）
  6. 事务超时: 长时间未提交的事务会自动回滚

目录结构

许可证

Apache-2.0 License

All versions of think-orm-sqlite-remote with dependencies

PHP Build Version
Package Version
Requires php Version >=8.4
topthink/framework Version ^8.0
topthink/think-orm Version ^3.0|^4.0
azjezz/psl Version ^5.0
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package yangweijie/think-orm-sqlite-remote contains the following files

Loading the files please wait ...