分类： 便签

VSCode, 升级插件后运行java 提示要11版本之上,
But,作为老人, 咱只需要用java-8即可, 不想升级11, 咋整,
打开主站, 这里找插件
https://marketplace.visualstudio.com/
查找JAVA,
https://marketplace.visualstudio.com/items?itemName=redhat.java
找到Changelog,
https://marketplace.visualstudio.com/items/redhat.java/changelog
0.65.0 (July 22nd, 2020)
enhancement – Require Java 11 to run the extension. See #1524.
0.65.0 后即提示需要java-11了, 所以,找之前的版本,
找到下载连接,更高版本号
https://marketplace.visualstudio.com/_apis/public/gallery/publishers/redhat/vsextensions/java/0.64.1/vspackage
下载后为文件
redhat.java-0.64.1.vsix
复制到 VSCode 安装目录下, 运行CMD , Code.exe –install-extension redhat.java-0.64.1.vsix

插件扩展, 右上角选 install from vsix, 选择刚下载的文件,
视安装情况, 会要求reload几次

推荐发行版本
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/

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

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';

netcat
https://eternallybored.org/misc/netcat/
netcat-配合cygwin,
https://mirrors.aliyun.com/cygwin/x86_64/release/netcat/