作者： admin

linux

Posted on by admin

推荐发行版本
alpine , https://www.alpinelinux.org/
好用，体积小，常放docker 内使用，如果使用非系统自带的服务，得考虑兼容性，

debian, https://www.debian.org/

slitaz,
https://www.slitaz.org/

manjaro
https://manjaro.org/

以下发行版本不适合新手使用
gentoo
https://www.gentoo.org/

arch
https://archlinux.org/

参考友链
https://linux.zone/
https://manjaro.org.cn/

AI-语音转换-TTS

Posted on by admin
标贝科技
https://www.data-baker.com/tts.html#/specs/compose/online

 

Coqui TTS 项目介绍
Coqui 文本转语音（Text-to-Speech，TTS）是新一代基于深度学习的低资源零样本文本转语音模型，具有合成多种语言语音的能力。该模型能够利用共同学习技术，从各语言的训练资料集转换知识，来有效降低需要的训练资料量。

这个模型库现在已经在GitHub上开源，并有高达 20.5K+ 的star量。似乎和以前讲过的Mozilla 的 TTS 有着千丝万缕的联系，但是如今Mozilla TTS 已经停止更新，而 Coqui TTS 更新稳定，是目前少数几个更新比较稳定的开源语音库。

coqui官网：https://coqui.ai/

开源地址：https://github.com/coqui-ai/TTS

 

智能硬件ESP8266-ESP32

Posted on by admin

ESP8266

开发工具
https://esp8266.ru/esplorer/
https://github.com/4refr0nt/ESPlorer
https://gitee.com/apnode/ESPlorer
https://www.espressif.com/zh-hans/support/download/other-tools

  1. 买板子，
  2. 看文档，参考，https://nodemcu.readthedocs.io/en/release/getting-started/#cloud-builder
  3. 烧固件，参考， https://blog.csdn.net/zz531987464/article/details/83447583
  4. helloworld

linux-n2n-remote-远程管理

Posted on by admin

Xming Linux X11 远程图形化管理工具
https://sourceforge.net/projects/xming/files/Xming/6.9.0.31/Xming-6-9-0-31-setup.exe/download

局域网P2PVPN,
OpenVPN , Tapinstall
http://build.openvpn.net/downloads/releases/

原版
https://github.com/ntop/n2n

客户端收集
https://github.com/lucktu/n2n

 

WinSCP
https://winscp.net/eng/downloads.php

SQLServer技巧

Posted on by admin
  1. 查询所有表行数及内容占用空间大小，
    SELECT 
    t.NAME AS TableName,
    p.rows AS RowCounts,
    SUM(a.total_pages) * 8 AS TotalSpaceKB,
    SUM(a.used_pages) * 8 AS UsedSpaceKB,
    (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB
FROM 
    sys.tables AS t
INNER JOIN      
    sys.indexes AS i ON t.OBJECT_ID = i.object_id
INNER JOIN 
    sys.partitions AS p ON i.object_id = p.object_id AND i.index_id = p.index_id
INNER JOIN 
    sys.allocation_units AS a ON p.partition_id = a.container_id
WHERE 
    t.is_ms_shipped = 0 AND i.index_id IN (0, 1)
GROUP BY 
    t.Name, p.Rows
ORDER BY 
    TotalSpaceKB DESC;
  2.  与时俱进，在Linux下运行 SQLServer,
    
# 参考 
# https://github.com/microsoft/mssql-docker 
# https://learn.microsoft.com/zh-cn/sql/linux/quickstart-install-connect-docker?view=sql-server-ver16&tabs=cli&pivots=cs1-bash
# 
# @SQLServer2019 是密码，记得改
docker pull mcr.microsoft.com/mssql/server:2019-latest
docker run  -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=@SQLServer2019" -p 1433:1433 -v /mnt:/mnt   --memory 3072M --name sql2019 -d mcr.microsoft.com/mssql/server:2019-latest

     

3. 常用语句

#1. 创建数据库 kingdee
CREATE DATABASE kingdee;

#2. 创建登录用户 kingdee
CREATE LOGIN kingdee WITH PASSWORD = 'kingdee', CHECK_POLICY = OFF;
CREATE LOGIN king_reader WITH PASSWORD = 'king_reader', CHECK_POLICY = OFF;;

#3. 将登录用户 kingdee 映射到数据库 kingdee 并设置为 dbo
USE kingdee;
CREATE USER kingdee FOR LOGIN kingdee;
EXEC sp_addrolemember 'db_owner', 'kingdee';

#4. 验证设置
USE kingdee;
SELECT name, type_desc, default_schema_name 
FROM sys.database_principals 
WHERE name = 'kingdee';