logo
GBase 8s
性能调优
文章
精选
置顶

GBase 8s 技术文章汇总

GBase社区管理员
发表于2023-12-25 17:06:484192次浏览0个评论

本文汇总已经整理完毕的GBase 8s数据库技术文章的链接，文章包括 框架 -工具-接口、语言、语法-函数、功能 - 配置、性能 等，后续会持续更新，希望能为大家提供帮助。

 

  • 框架-工具-接口

序号

名称

文章

1

MybatisMybatis-Plus之使用LocalDateTime等java8新日期时间类型报错https://gbasedbt.com/index.php/archives/514/

2

在mybatis-plus中增加对GBase 8s的支持https://gbasedbt.com/index.php/archives/472/

3

Mybatis操作GBase 8s数据库示例https://gbasedbt.com/index.php/archives/205/

4

QTQT5.12.12通过ODBC连接到GBase 8s数据库（CentOS）https://gbasedbt.com/index.php/archives/493/

5

QT通过ODBC连接GBase 8s数据库（Windows）示例https://gbasedbt.com/index.php/archives/475/

6

C3P0GBase 8s使用C3P0连接池时去除SQLWarning警告https://gbasedbt.com/index.php/archives/468/

7

HibernateHibernate操作GBase 8s数据库示例https://gbasedbt.com/index.php/archives/203/

8

SpringbootSpringboot+JPA+Hibernate+GBase 8s示例https://gbasedbt.com/index.php/archives/414/

9

springboot+mybatisplus怎么操作CRUDgbase8https://gbasedbt.com/index.php/archives/402/

10

SpringBoot 中的 Liquibase 适配GBase 8s数据库简单用例https://www.gbase.cn/community/post/3379

11

DruidGBase 8s数据库连接 - Druid连接池https://gbasedbt.com/index.php/archives/94/

12

TomcatGBase 8s数据库连接 - Tomcat jdbc连接池https://gbasedbt.com/index.php/archives/78/

13

KettleKettle 8.3 资源库（GBase 8s V8.8）表结构https://gbasedbt.com/index.php/archives/551/

14

Kettle连接到GBase 8s数据库https://gbasedbt.com/index.php/archives/546/

15

Sqlalchemy使用sqlalchemy-gbasedbt连接GBase 8s数据库https://gbasedbt.com/index.php/archives/450/

16

JDBCGBase 8s数据库JDBC连接字符串https://gbasedbt.com/index.php/archives/444/

17

GBase 8s Java UDR安装说明https://gbasedbt.com/index.php/archives/436/

18

使用DatabaseMetaData接口查询GBase 8s数据库结构https://liaosnet.com/index.php/archives/99/

19

GCIGBaseGCI demo 运行指南https://www.gbase.cn/community/post/3390

20

WildFlyWildFly配置连接GBase 8shttps://gbasedbt.com/index.php/archives/273/

21

DjangoDjango操作GBase 8s数据库配置(Linux)https://gbasedbt.com/index.php/archives/271/

22

NacosNacos 2.2.3版本适配GBase8s数据库https://www.gbase.cn/community/post/2885

23

——下载中间件（更新中...）中间件下载 | GBase 8s Club

 

  • 语言

序号

名称

文章链接

1

Python三种Python操作GBase 8s数据库数据类型的差异https://gbasedbt.com/index.php/archives/462/

2

Pyodbc对GBase 8s数据库的数据类型的支持https://gbasedbt.com/index.php/archives/455/

3

Python3通过JayDeBeApi(JDBC)连接到数据库https://gbasedbt.com/index.php/archives/386/

4

Linux下Python3通过DbtPy连接到GBase 8s数据库https://gbasedbt.com/index.php/archives/317/

5

Windows下Python3通过DbtPy连接到GBase 8s数据库https://gbasedbt.com/index.php/archives/318/

6

DbtPy对GBase 8s数据库的数据类型的支持https://gbasedbt.com/index.php/archives/453/

7

Linux下Python3通过PYODBC连接到GBase 8s数据库https://gbasedbt.com/index.php/archives/280/

8

当前目录 DbtPy: 高级原生扩展模块https://www.gbase.cn/community/post/2936

9

JayDeBeApi对数据类型的支持https://gbasedbt.com/index.php/archives/459/

10

GBase 8s数据库连接 – Pythonhttps://gbasedbt.com/index.php/archives/13/

11

C++/C#Linux下C#通过ODBC方式连接到GBase 8s数据库https://gbasedbt.com/index.php/archives/382/

12

Linux下C++通过SOCI连接到GBase 8s数据库https://gbasedbt.com/index.php/archives/327/

13

DelphiDelphi通过ODBC连接到GBase 8s数据库https://gbasedbt.com/index.php/archives/351/

14

PerlGBase 8s数据库连接 – Perl(DBD::ODBC)https://gbasedbt.com/index.php/archives/108/

15

GBase 8s数据库连接 – Perl(DBD::GBasedbt)https://gbasedbt.com/index.php/archives/107/

16

GoLinux下GO通过ODBC连接到GBase 8s数据库https://gbasedbt.com/index.php/archives/387/

17

PHPGBase 8s数据库连接 - PHP PDO_GBASEDBThttps://gbasedbt.com/index.php/archives/68/

18

GBase 8s数据库连接 - PHP ODBChttps://gbasedbt.com/index.php/archives/63/

19

JAVA在java中调用GBase 8s的函数示例https://gbasedbt.com/index.php/archives/37/

20

使用DatabaseMetaData接口查询GBase 8s数据库结构https://gbasedbt.com/index.php/archives/7/

21

扫描库中是否存在非法字符https://www.gbase.cn/community/post/2935

22

JDBC连接数据库示例https://www.gbase.cn/community/post/2934

 

  • 语法-函数

序号

名称

文章

1

语法GBase 8s重建sysuser库的方法https://gbasedbt.com/index.php/archives/470/

2

GBase 8s中的start with connect by用法https://gbasedbt.com/index.php/archives/466/

3

GBase 8s 创建数据库用户https://gbasedbt.com/index.php/archives/394/

4

GBase 8s 数据库中count(字段) ，count(主键) ，count(1)和count(*)的区别https://gbasedbt.com/index.php/archives/364/

5

GBase 8s 系统表syscolumns字段说明https://gbasedbt.com/index.php/archives/268/

6

GBase 8s 裸表(raw table)https://gbasedbt.com/index.php/archives/375/

7

GBase 8s LIKE 子句https://gbasedbt.com/index.php/archives/249/

8

GBase 8s 正则表达式https://gbasedbt.com/index.php/archives/251/

9

GBase 8s数据库表分片介绍https://gbasedbt.com/index.php/archives/102/

10

merge into的字段限制https://gbasedbt.com/index.php/archives/61/

11

GBase 8s使用内部用户https://gbasedbt.com/index.php/archives/49/

12

GBase 8s回收public权限https://gbasedbt.com/index.php/archives/28/

13

GBase 8s数据库SQL对象中关键字使用https://gbasedbt.com/index.php/archives/307/

14

函数/存储过程GBase 8s内置dbms_lob函数说明https://gbasedbt.com/index.php/archives/452/

15

GBase 8s clob数据类型操作函数https://gbasedbt.com/index.php/archives/440/

16

GBase 8s内置不透明数据类型BSON和JSONhttps://gbasedbt.com/index.php/archives/263/

17

GBase 8s 自定义mysql兼容函数https://gbasedbt.com/index.php/archives/437/

18

GBase 8s自定义使用find_in_set()函数https://gbasedbt.com/index.php/archives/136/

19

GBase 8s自定义使用timestampdiff()函数https://gbasedbt.com/index.php/archives/133/

20

GBase 8s自定义interval类型转number类型函数https://gbasedbt.com/index.php/archives/339/

21

GBase 8s自定义使用hex或者unhex函数https://gbasedbt.com/index.php/archives/328/

22

GBase 8s数据库中的二进制、八进制、十进制、十六进制相互转换函数https://gbasedbt.com/index.php/archives/304/

23

GBase 8s获取第几周、第几天的函数https://gbasedbt.com/index.php/archives/267/

24

GBase 8s 常用函数、表达式https://gbasedbt.com/index.php/archives/216/

25

GBase 8s 时间/日期函数和操作符https://gbasedbt.com/index.php/archives/269/

26

GBase 8s存储过程中获取当前时间https://gbasedbt.com/index.php/archives/306/

27

GBase 8s存储过程通过table(set)实现投影列绑定变量https://gbasedbt.com/index.php/archives/196/

28

GBase 8s 存储过程跟踪示例https://gbasedbt.com/index.php/archives/32/

29

GBase 8s数据库存储过程使用出参示例https://gbasedbt.com/index.php/archives/8/

30

GBase 8s 编写使用UDR(C/Java)https://gbasedbt.com/index.php/archives/244/

31

在GBase 8s上使用java udr实现Oracle兼容的加密解密功能https://gbasedbt.com/index.php/archives/174/

32

GBase 8s使用unix_timestamp()函数https://gbasedbt.com/index.php/archives/36/

33

GBase 8s 自定义split_part函数https://gbasedbt.com/index.php/archives/9/

34

触发器GBase 8s触发存储过程示例https://gbasedbt.com/index.php/archives/58/

35

数据类型GBase 8s数据类型https://gbasedbt.com/index.php/archives/141/

36

GBase 8s 日期时间数据类型https://gbasedbt.com/index.php/archives/381/

37

Oracle与GBase 8s数据类型对比-Number类型https://gbasedbt.com/index.php/archives/303/

38

GBase 8s 中数据类型serial与序列sequence之间的异同https://gbasedbt.com/index.php/archives/300/

39

GBase 8s LIST类型https://gbasedbt.com/index.php/archives/11/

40

索引GBase 8s数据库主键约束、唯一约束和唯一索引的区别https://gbasedbt.com/index.php/archives/365/

41

GBase 8s数据库表和主键索引使用的空间分离方法https://gbasedbt.com/index.php/archives/302/

42

GBase 8s 全文索引功能https://gbasedbt.com/index.php/archives/137/

43

B+ 索引的特点和优缺点https://gbasedbt.com/index.php/archives/183/

44

GBase 8s和oracle的索引分类https://gbasedbt.com/index.php/archives/182/

 

  • 功能-配置

序号

名称

文章

1

8s配置相关GBase 8s数据库配置使用IPv6https://gbasedbt.com/index.php/archives/447/

2

GBase 8s 使用dblink访问远端数据库实例https://gbasedbt.com/index.php/archives/342/

3

GBase 8s中NODEFDAC环境变量或者参数https://gbasedbt.com/index.php/archives/413/

4

GBase 8s 设置数据文件自动扩展https://gbasedbt.com/index.php/archives/345/

5

影响DATE数据类型的环境变量解析https://gbasedbt.com/index.php/archives/298/

6

GBase 8s常见锁错误原因及处理办法https://gbasedbt.com/index.php/archives/332/

7

GBase 8s时间限制版本更换为正式版本操作https://gbasedbt.com/index.php/archives/294/

8

GBase 8s数据库锁表问题检查脚本https://www.gbase.cn/community/post/2861

9

GBase 8s 普通表转换成分片表的方式分析https://gbasedbt.com/index.php/archives/266/

10

GBase 8s 存储加密配置https://gbasedbt.com/index.php/archives/265/

11

GBase 8s 传输加密SSL配置https://gbasedbt.com/index.php/archives/264/

12

GBase 8s TimeSeries（时间序列） 指南https://gbasedbt.com/index.php/archives/257/

13

GBase 8s 存储过程中的异常处理https://gbasedbt.com/index.php/archives/254/

14

GBase 8s 数据库操作指南https://gbasedbt.com/index.php/archives/239/

15

GBase 8s PSM简单配置https://gbasedbt.com/index.php/archives/213/

16

GBase 8s 使用dbaccess工具调试SQL语句https://gbasedbt.com/index.php/archives/162/

17

GBase 8s 通过systemd实现自启动与关闭https://gbasedbt.com/index.php/archives/161/

18

GBase 8s使用emoji表情符号示例https://gbasedbt.com/index.php/archives/151/

19

GBase 8s 传输加密SSL配置https://gbasedbt.com/index.php/archives/379/

20

8s 如何进入 Oracle 模式https://www.gbase.cn/community/post/2894

21

通过SQL检查GBase 8s HDR运行状态https://gbasedbt.com/index.php/archives/99/

22

EFCore连接GBase8s使用操作步骤【Linux版】https://www.gbase.cn/community/post/3604

23

EFCore连接GBase8s使用操作步骤【windows版】https://www.gbase.cn/community/post/3603

24

创建Maven连接数据库https://www.gbase.cn/community/post/3611

25

操作系统相关统信UOS20(1050a)安装GBase 8s数据库问题记录https://gbasedbt.com/index.php/archives/409/

26

统信UOS20(1021a)安装GBase 8s数据库问题记录https://gbasedbt.com/index.php/archives/363/

27

麒麟10SP2（Sword）安装GBase 8s数据库问题记录https://gbasedbt.com/index.php/archives/373/

28

Centos7.x 安装VNC远程桌面https://gbasedbt.com/index.php/archives/367/

29

Docker 搭建 GBase 8s数据库服务https://gbasedbt.com/index.php/archives/259/

30

Qemu安装NeoKylin on Aarch64https://gbasedbt.com/index.php/archives/123/

31

案例分析1213 A character to numeric conversion process failed.https://gbasedbt.com/index.php/archives/226/

32

创建存储过程报错误282: Found a quote for which there is no matching quotehttps://gbasedbt.com/index.php/archives/262/

33

GBase 8s数据库安装常见问题解析https://gbasedbt.com/index.php/archives/190/

34

GBase 8s常见问题——字符集相关问题https://www.gbase.cn/community/post/2883

35

GBase 8s常见问题——no more pages/no more extentshttps://www.gbase.cn/community/post/2884

36

GBase 8s常见问题 -- 查看表中数据量与表占用空间https://www.gbase.cn/community/post/2896

 

  • 性能

序号

名称

文章

1

性能相关TPC-H对GBase 8s数据库基础能力测试https://gbasedbt.com/index.php/archives/336/

2

GBase 8s 使用sqltrace跟踪sql性能https://gbasedbt.com/index.php/archives/346/

3

BenchMarkSQL 5.0测试GBase 8shttps://gbasedbt.com/index.php/archives/283/

4

GBase 8s性能调优流程https://gbasedbt.com/index.php/archives/275/

5

GBase 8s提高SQL查询效率的一些方法https://gbasedbt.com/index.php/archives/272/

6

硬件延时指标小结https://gbasedbt.com/index.php/archives/185/

7

核心参数优化https://www.gbase.cn/community/post/2937

8

GBase8s 多列IN改写 简述https://www.gbase.cn/community/post/3610

9

GBase 8s数据库参数配置最佳实践https://www.gbase.cn/community/post/3657

10

GBase 8s开发利器之Datablade模块https://www.gbase.cn/community/post/3661

 

  • 迁移问题

序号

名称

文章

1

迁移oracle与gbase8s迁移数据类型对照https://www.gbase.cn/community/post/2890

 

  • 运维管理

序号

名称

文章

1

安装配置SSC共享磁盘集群安装（进阶）https://www.gbase.cn/community/post/2965

2

单机规范安装详解（进阶）https://www.gbase.cn/community/post/2964

3

监控巡检检查逻辑日志【onstat -l】https://www.gbase.cn/community/post/2963

4

检查空间使用率【onstat -d】https://www.gbase.cn/community/post/2962

5

检查实例状态【onstat -】https://www.gbase.cn/community/post/2961

6

检查事务【onstat -x】https://www.gbase.cn/community/post/2960

7

巡检脚本【linux】https://www.gbase.cn/community/post/2959

8

Prometheus配置GBase 8s exporterhttps://www.gbase.cn/community/post/2958

9

管理工具新国标字符集乱码https://www.gbase.cn/community/post/2957

10

运维管理跨网段数据库连接慢https://www.gbase.cn/community/post/2956

11

数据库字符集管理https://www.gbase.cn/community/post/2955

12

大事务处理https://www.gbase.cn/community/post/2954

 

  • 错误处理

序号

名称

文章

1

错误处理【onlinelog错误处理】signal 9 receivedhttps://www.gbase.cn/community/post/2953

2

【onlinelog错误处理】当前目录 Lock table overflowhttps://www.gbase.cn/community/post/2952

3

【onlinelog错误处理】listener-thread: err = -25580https://www.gbase.cn/community/post/2951

4

【onlinelog错误处理】Dynamically allocated new virtual shared memory segmenthttps://www.gbase.cn/community/post/2950

5

【错误处理】-79783 Encoding or code set not supportedhttps://www.gbase.cn/community/post/2949

6

【错误处理】-79716 System or internal errorhttps://www.gbase.cn/community/post/2948

7

【错误处理】-588 Invalid host variable numberhttps://www.gbase.cn/community/post/2947

8

【错误处理】-567 Cannot write sorted rows.https://www.gbase.cn/community/post/2946

9

【错误处理】-34389 Illegal character has been found in the input stringhttps://www.gbase.cn/community/post/2945

10

【错误处理】-26021 No operations allowed after truncate or online alter fragment in a transaction.https://www.gbase.cn/community/post/2944

11

【错误处理】-252 Cannot get system information for table.https://www.gbase.cn/community/post/2943

12

【错误处理】-244 Could not do a physical-order read to fetch next rowhttps://www.gbase.cn/community/post/2942

13

【错误处理】-242 Could not open database tablehttps://www.gbase.cn/community/post/2941

14

【错误处理】-211 Cannot read system cataloghttps://www.gbase.cn/community/post/2940

15

【错误处理】-202 An illegal character has been found in the statementhttps://www.gbase.cn/community/post/2939

16

【错误处理】-19849: Error in unload due to invalid data:row number 1https://www.gbase.cn/community/post/2938

17

方言包hibernate3适配时报错https://www.gbase.cn/community/post/3679

 

 

 

 

评论已关闭
图片
图片

热门帖子