[尝鲜] AIGC and Chatgpt

March 24, 2023 Architect, system No comments

属于Chatgpt的“iPhone”时刻来了,伴随着越来越多的模型能力放出,AIGC的场景越发丰富以及明朗,越来越多的业界大神也亲自下场操盘,投资界即将迎来一场技术的历史变革,各方都期待能瓜分到这巨大蛋糕的一角。今天我们就来浅尝一些功能性的应用。。。

OpenAI刚刚宣布推出插件功能,赋予ChatGPT使用工具、联网、运行计算的能力  Chatgpt-plugin

1、昨天该机构开放了第一批 ChatGPT 插件名单。这批插件由 Expedia、FiscalNote、Instacart、KAYAK、Klarna、Milo、OpenTable、Shopify、Slack、Speak、Wolfram 和 Zapier 创建

 

例如,将Wolfram通过插件形式,加载至会话过程中 ,具体见chatgpt-gets-its-wolfram

同时 openai还公布了查询自有知识库和文档库的接口 ChatGPT Retrieval Plugin

 

2、提示工程(Prompt Engineering)这个概念最近被提出,并诞生了多家初创公司,Prompt的原意就是提示、驱使的意思,只不过提示、驱使的对象有点特殊,不是人类,而是类似ChatGPT这样的AI。PromptBase、Krea、PromptHero 、 Promptist 等一些提示词买卖平台已经出现,以下以dall-e-2为例,演示AI作图

 

1) a cat running on the grassland

 

 

2) a very very cute cat running on the grassland

 

 

3) a  beautiful painting of a mountain next to a waterfall

 

 

4) a very very very very very very very very very very beautiful painting of a mountain next to a waterfall

 

 

可以看到,不同的描述,出现的画质还是有区别的,这就是PromptBase的意义,建立一个专业/非专业通道(promptbase建立一个公平交易平台,促成提示词买卖的达成),也算是一种新的商业模式了,可以看到PromptBase网站确实提供了非常多专业的绘画。

 

AIGC的领域远远不止绘画,包括与chatpgt师出同门的 Jasper AI ,可以编写多种博文、脚本、社交媒体帖子等各种类型的文案,Stable Diffusion 、Imagen 、Dall-E、Midjourney 都是能通过文本,直接生成图像的AI应用。

 

当然也包括微软最近推出的Office重磅功能Coplit 以及Github的 Coplit X

 

 

Presto-engine Privileges Control – Architect

January 20, 2022 Architect, bigdata, linux, system No comments

We use presto as the main data query engine to provide data query services for business parties. In our architecture, presto as a core capability requires access to data query permission control, including permission control at the table and column levels. We designed The following scheme to achieve this requirement

(more…)

[Upgrade] MySQL database upgrade to 8.x version tips

December 6, 2021 MYSQL, software, system No comments

Recently we upgrade our database cluster to version 8.x .

Read this PDF to get some  experience    MySQL_8.x_upgrade

Clickhouse Materialized view

April 24, 2021 Architect, bigdata No comments

We are now using Clickhouse for OLTP  streaming computing system.

Read this PDF for some tips for MV of Clickhouse CK-MV

Consul with Redis HA

April 14, 2020 Architect, NoSQL, redis, software No comments

We make a test to see how consul hold redis High Available solution.

In this test we don’t use sentinel to do auto failover.(we simulate sentinel manually)

Read this PDF for detail  Consul_Redis_HA

[Archiving] Antdeck Platform for MySQL

March 5, 2020 Architect, backup, MYSQL, rdbms, storage, system No comments

We use Antdeck paltform to do mysql data archiving jobs. This platform was developed by ruzuojun . He is also the author of  Lepus 

Read this pdf  Antdeck , we use TiDB as secondary storage .

[Hardware] Redis with Intel AEP Test

November 12, 2019 Architect, hardware, redis, storage, system No comments

Based on Netease Test

Read this PDF :AEP_REDIS_TEST

 

Reference:

从Intel Optane SSD和DIMM谈全闪存性能优化
Intel Data-Centric Innovation Day的启示(2)-Intel AEP
Optane DIMM写速度比SSD慢?内存接口可能并非完美
Intel Optane DC持久化内存性能测试、数据库应用优化

[Platform] Database OPS architect

May 29, 2019 Architect No comments

Please download below ppt file,shared in Shenzhen 2019

PDF: JKDB_PLATFORM

online-schema-change tool ddl problem

October 24, 2018 Internals, MYSQL, rdbms No comments

On our job schedule system. Using osc-tool cause deadlock problem.
We investigated the root cause in detail and published this PDF doc.

OSC_DDL_PROBLEM

Redis Cluster tools and source code

April 25, 2018 Architect, NoSQL, redis No comments

From our team @CruePan, Detail explain Redis cluster system tools usage. Deeply mining redis client source code

download this ppt Redis_tools_sourcecode.pptx