teleren/devto huggingface dataset:
Database backup with onedump
Tags: database, go, databasedump, databasebackup
Published: 2023-02-08 04:11:22

[Onedump](https://github.com/liweiyi88/onedump) is a CLI tool for database backup. It supports database dump from multiple sources( MySQL or PostgreSQL database) and stores it in your preferred storage (Local, S3, Google Drive or Dropbox). It is easy to use and manage, basically, it is just a simple command with a single configuration.

## Motivation

Before I started to implement this tool, I asked myself why I need to create another tool for database backup again. Although there might have had some tools that did a good job with database backup, I rarely found one that fit my needs:

I need a tool to dump MySQL and PostgreSQL databases to different storage with a simple command and a single configuration file. I need this tool not only to be able to dump databases directly via the network (if possible) but also to dump via SSH (if possible).

I want it to be fast to back up databases, concurrently if possible.

I want it to be easy to configure, one configuration file is the goal.

I prefer to store my configuration file in a secure location, ideally with encryption at rest.

## The tool

To resolve my own requirements, as shown above, I am glad that I have delivered the tool and run it for the backup of all my side project databases. I will be more joyful if it helps other people who have similar needs. For more details like how to use it, here is the [instruction](https://github.com/liweiyi88/onedump#readme)
ZigLang The New Kid On The Block (😳)
Tags: beginners, tutorial, programming, zig
Published: 2023-02-08 04:05:03

I know what your thinking, oooh another post advocating for a new programming language that is blazing fast (like rust 🦀) and super safe (like a trojan 💪)

Zig is a modern, general-purpose programming language that aims to make programming as simple and straightforward as possible. With a clean syntax, strong type system, and extensive standard library, Zig provides developers with an enjoyable and productive experience. I mean because who really likes having to configure their build and run commands (that's right I'm looking at you C 🌊) But let's get to it, here are some of the reasons why you should try using Zig.

Easy to learn: Zig has a simple, straightforward syntax that is easy to understand and follow. The language is designed to eliminate confusing constructs and encourage developers to write clean, readable code. For this reason, I believe that Zig is a much easier language to learn and grasp as a beginner than as compared to other languages like Rust or C++. Both are great languages but the learning curve is huge for people who are not as familiar with typed and systems languages. 

Strong type system: Zig has a strong type system that helps catch errors at compile time, making it easier to catch bugs and avoid runtime errors. Anyone who has ever built a large program or tool knows how important it is to have your data structures organized and clear.

Standard library: Zig comes with an extensive standard library that provides common functionality, making it easy to get started with writing programs. Functions such as a random number generator or a print function that most all programming languages provide. 

Concurrency: Zig provides built-in support for concurrent programming, making it easy to write parallel programs that take advantage of multi-core processors.

Interoperability: Zig is designed to be highly interoperable with C, making it easy to use existing C libraries and integrate with other systems.

Here's an example of a Hello World program in Zig:

```
const std = @import("std");
const stdout = std.io.getStdOut();

pub fn main() void {
    stdout.print("Hello, World!\n");
}
```

In this example, we first import the standard library with @import("std"). Then, we use std.io.getStdOut() to get a reference to the standard output stream. Finally, we define the main function, which uses the print method of the stdout stream to print the message "Hello, World!".

Try it out and see for yourself why Zig is a great language to work with!
The official ZigLang website is: https://ziglang.org
Also, check out this informative video by the creator of ZigLang Andrew Kelly: https://youtu.be/Z4oYSByyRak
How to create an Application In ChatGPT using OpenAI API
Tags: openai, chatgpt, python, python3
Published: 2023-02-12 13:29:12

---
title: How to create an Application In ChatGPT using OpenAI API
published: true 
date: 2023-02-08 04:01:16 UTC
tags: openai,chatgpt,python,python3
canonical_url: https://medium.com/geekculture/how-to-create-an-application-in-chatgpt-using-openai-api-5d3f3d4be2d2
---

[![](https://cdn-images-1.medium.com/max/862/1*T7Q-4nCz11hbZ-288wgN9g.png)](https://medium.com/geekculture/how-to-create-an-application-in-chatgpt-using-openai-api-5d3f3d4be2d2?source=rss-17217f29618a------2)

build a ChatGPT application using python

[Continue reading on Geek Culture »](https://medium.com/geekculture/how-to-create-an-application-in-chatgpt-using-openai-api-5d3f3d4be2d2?source=rss-17217f29618a------2)
Call to undefined function GuzzleHttp\Psr7\uri_for() - GuzzleHttp Conflict in Wordpress
Tags: wordpress, php
Published: 2023-02-08 03:53:29

This error occurred when there is plugins conflict. This is cause by guzzlehttp.

First find out how many plugins are there using. guzzlehttp.

In my case there are two, first one using guzzlehttp 7.0 and the latter using 6.4.1

Go to plugin directory and execute this command.
```shell
sudo find . -name "guzzlehttp" -type d
```
Then you will see the results similar to this.

```shell
./woocommerce-xero/vendor/guzzlehttp
./wp-mail-smtp/vendor/guzzlehttp
```

When this plugin is in conflict state, plugins effected can no longer detect the functions.php files in the vendor folder. So we need to make some adjustments to plugins:

In /home/gsc/gscwoo/wp-content/plugins/wp-mail-smtp/vendor/autoload.php 

```php
require_once(__DIR__.'/guzzlehttp/psr7/src/functions.php');
require_once(__DIR__.'/guzzlehttp/guzzle/src/functions.php');
require_once(__DIR__.'/guzzlehttp/promises/src/functions.php');
```

In /home/gsc/gscwoo/wp-content/plugins/woocommerce-xero/vendor/guzzlehttp/guzzle/src/Client.php 

```php
require_once(ABSPATH.'/wp-content/plugins/woocommerce-xero/vendor/guzzlehttp/psr7/src/functions.php');
```

Happy Coding!
"Evolution of Apache Doris in Moka BI"_Apache Doris Summit 2022
Tags: database, opensource, devops, cloud
Published: 2023-02-08 03:47:33

https://www.youtube.com/watch?v=A5-y1Mv_NUk

-------------------------------------------

Moka
As an industry-leading, data-driven intelligent HR SaaS service, Moka BI provides comprehensive data statistics and report support for enterprise human resources. In the research of BI report engine, real-time query, standard SQL and JOIN supports are what we are looking for. After comprehensive comparison of various databases, we finally chose Apache Doris. During more than two years of use, Moka has kept following the latest versions of Doris. The performance of the latest version has been greatly improved compared with the past, and the P95 query is within 3 seconds. In the future, Moka will always use the latest features.

Apache Doris is a real-time analytical database based on MPP architecture, known for its high performance and ease of use. It supports both high-concurrency point queries and high-throughput complex analysis. (https://github.com/apache/doris)

SelectDB is a cloud-native real-time data warehouse developed based on the Apache Doris open source project by the same key developers. The SelectDB company focuses on the enterprise-grade cloud-native distribution for Apache Doris. (Contact US: support@selectdb.com)

Follow us:
https://linktr.ee/apachedoris
Apache Doris @GitHub
https://github.com/apache/doris

Apache Doris Website
https://doris.apache.org/

Apache Doris @ Twitter
https://twitter.com/doris_apache

Apache Doris @ Medium
https://medium.com/@ApacheDoris

Apache Doris @ Dev.to
https://dev.to/apachedoris

Apache Doris @ Reddit
https://www.reddit.com/user/ApacheDoris

SelectDB Website
https://en.selectdb.com/

SelectDB @ Twitter
https://twitter.com/Select_DB

SelectDB @ Reddit
https://www.reddit.com/user/SelectDB

SelectDB @ Dev.to
https://dev.to/selectdb
"Best Practice: The Application of Baidu Palo in ZHIHU.COM"_Apache Doris Summit 2022
Tags: opensource, database, programming, python
Published: 2023-02-08 03:46:23

https://www.youtube.com/watch?v=RRmZcCVQnm0

------------------------------------------

ZHIHU.COM
Refined operations can improve the operating efficiency of enterprises and bring more revenue to enterprises. Effective tools can bring more business value to enterprises. Therefore, the Zhihu data platform was created and became handy in data-driven decision-making for business personnel since it was born. With its outstanding query and data processing performance, Apache Doris meets our needs for fast data ingestion, second-level grouping and insight of hundreds of billions of feature data. At the same time, after the launch of the vectorized execution engine, the grouping performance of billion-level data has increased by 10 times, and the performance of single-table aggregation query and multi-table association query have also increased by 3-5 times. In the future, we also look forward to using Apache Doris to further support our data platform to achieve refined operations, cost reduction and efficiency increase.

Apache Doris is a real-time analytical database based on MPP architecture, known for its high performance and ease of use. It supports both high-concurrency point queries and high-throughput complex analysis. (https://github.com/apache/doris)

SelectDB is a cloud-native real-time data warehouse developed based on the Apache Doris open source project by the same key developers. The SelectDB company focuses on the enterprise-grade cloud-native distribution for Apache Doris. (Contact US: support@selectdb.com)

Follow us:
https://linktr.ee/apachedoris
Apache Doris @GitHub
https://github.com/apache/doris

Apache Doris Website
https://doris.apache.org/

Apache Doris @ Twitter
https://twitter.com/doris_apache

Apache Doris @ Medium
https://medium.com/@ApacheDoris

Apache Doris @ Dev.to
https://dev.to/apachedoris

Apache Doris @ Reddit
https://www.reddit.com/user/ApacheDoris

SelectDB Website
https://en.selectdb.com/

SelectDB @ Twitter
https://twitter.com/Select_DB

SelectDB @ Reddit
https://www.reddit.com/user/SelectDB

SelectDB @ Dev.to
https://dev.to/selectdb
"Application of Apache Doris in 360 Technology Group"_Apache Doris Summit 2022
Tags: opensource, database, datascience, sql
Published: 2023-02-08 03:44:56

https://www.youtube.com/watch?v=YNT4Ps7rchM

------------------------------------------

360 Security
360 Security began to use Apache Doris sinced Version 0.13. In terms of OLAP storage engine, 360 Security experienced various databases. Currently, Apache Doris is the most ideal OLAP storage engine. The excellent query performance and easy-to-use features of Apache Doris make our real-time data warehouse architecture more concise, and ensure the end-to-end consistency of real-time data. In the future, we hope to bring Apache Doris to more business scenarios and we can deeply participate in the Apache Doris community.

Apache Doris is a real-time analytical database based on MPP architecture, known for its high performance and ease of use. It supports both high-concurrency point queries and high-throughput complex analysis. (https://github.com/apache/doris)

SelectDB is a cloud-native real-time data warehouse developed based on the Apache Doris open source project by the same key developers. The SelectDB company focuses on the enterprise-grade cloud-native distribution for Apache Doris. (Contact US: support@selectdb.com)

Follow us:
https://linktr.ee/apachedoris
Apache Doris @GitHub
https://github.com/apache/doris

Apache Doris Website
https://doris.apache.org/

Apache Doris @ Twitter
https://twitter.com/doris_apache

Apache Doris @ Medium
https://medium.com/@ApacheDoris

Apache Doris @ Dev.to
https://dev.to/apachedoris

Apache Doris @ Reddit
https://www.reddit.com/user/ApacheDoris

SelectDB Website
https://en.selectdb.com/

SelectDB @ Twitter
https://twitter.com/Select_DB

SelectDB @ Reddit
https://www.reddit.com/user/SelectDB

SelectDB @ Dev.to
https://dev.to/selectdb
"Application of Apache Doris in Yiguanzhiku Network Technology"_Apache Doris Summit 2022
Tags: database, opensource, computerscience, devops
Published: 2023-02-08 03:43:06

https://www.youtube.com/watch?v=UxyyT6bJdXE

-----------------------------------------

Yiguanzhiku Network Technology
In the early days, Yiguanzhiku Network Technology introduced Greenplum as the OLAP database in query analysis scenarios. With business development and technology changes, Greenplum's performance cannot support real-time analysis of large amounts of data, and the introduction of other components such as Hive/ES has brought new pressure on operation and maintenance. So Yiguanzhiku Network Technology migrated to Apache Doris from Greenplum. With the advantages of Doris’ rich data ecology and ease of use, the daily query time is reduced by 30%, the efficiency of special scenarios is increased by 5 times, and the storage space is saved up to 40%. In the future, the company will look for more feasible solutions together with Apache Doris.

Apache Doris is a real-time analytical database based on MPP architecture, known for its high performance and ease of use. It supports both high-concurrency point queries and high-throughput complex analysis. (https://github.com/apache/doris)

SelectDB is a cloud-native real-time data warehouse developed based on the Apache Doris open source project by the same key developers. The SelectDB company focuses on the enterprise-grade cloud-native distribution for Apache Doris. (Contact US: support@selectdb.com)

Follow us:
https://linktr.ee/apachedoris
Apache Doris @GitHub
https://github.com/apache/doris

Apache Doris Website
https://doris.apache.org/

Apache Doris @ Twitter
https://twitter.com/doris_apache

Apache Doris @ Medium
https://medium.com/@ApacheDoris

Apache Doris @ Dev.to
https://dev.to/apachedoris

Apache Doris @ Reddit
https://www.reddit.com/user/ApacheDoris

SelectDB Website
https://en.selectdb.com/

SelectDB @ Twitter
https://twitter.com/Select_DB

SelectDB @ Reddit
https://www.reddit.com/user/SelectDB

SelectDB @ Dev.to
https://dev.to/selectdb
"Application of Apache Doris in YundaEX"_Apache Doris Summit 2022
Tags: opensource, database, cloud, architecture
Published: 2023-02-08 03:41:46

https://www.youtube.com/watch?v=L7m3csCX0BU

-------------------------------------------

Yunda EX
In recent years, with the vigorous development of the express logistics industry, the amount of data has increased by hundreds of times. In 2022, the number of deliveries has exceeded 100 billion. Faced with such a large amount of data, Yunda has established a data platform based on the business center and data center to provide unified and diversified data services for the business. After detailed research and selection, we decided to build a unified real-time data warehouse with Apache Doris. In this way, the new data warehouse is able to serve multi-department reporting and respond to multi-table related queries in seconds, covering more than 90% of the core indicators. In the future, we will also allow Apache Doris to serve more businesses and further promote the real-time indicators. 

Apache Doris is a real-time analytical database based on MPP architecture, known for its high performance and ease of use. It supports both high-concurrency point queries and high-throughput complex analysis. (https://github.com/apache/doris)

SelectDB is a cloud-native real-time data warehouse developed based on the Apache Doris open source project by the same key developers. The SelectDB company focuses on the enterprise-grade cloud-native distribution for Apache Doris. (Contact US: support@selectdb.com)

Follow us:
https://linktr.ee/apachedoris
Apache Doris @GitHub
https://github.com/apache/doris

Apache Doris Website
https://doris.apache.org/

Apache Doris @ Twitter
https://twitter.com/doris_apache

Apache Doris @ Medium
https://medium.com/@ApacheDoris

Apache Doris @ Dev.to
https://dev.to/apachedoris

Apache Doris @ Reddit
https://www.reddit.com/user/ApacheDoris

SelectDB Website
https://en.selectdb.com/

SelectDB @ Twitter
https://twitter.com/Select_DB

SelectDB @ Reddit
https://www.reddit.com/user/SelectDB

SelectDB @ Dev.to
https://dev.to/selectdb
"Application of Apache Doris in LY Digital"_Apache Doris Summit 2022
Tags: opensource, database, programming, bigdata
Published: 2023-02-08 03:40:21

https://www.youtube.com/watch?v=gx_ybzcUy3k

------------------------------------------

LY Digital
The growing demand for analysis of real-time data has further made real-time data warehouse  an important part of enterprise production systems. In order to achieve a complete real-time analysis capability, we have carried out iterations of various architectures, from offline data warehouses, to real-time data warehouses, and finally to streaming compute & batch processing's integration. Finally, we built a unified data warehouse with Apache Doris, realizing the unification of storage layer, computing layer and data access layer. It not only simplifies the data links and reduces the maintenance cost of the entire data production, but also brings an easier way to use big data just like using databases. In this way, the business team has the ability to self-develop, be efficient in development, and quickly launch new requirements.

Apache Doris is a real-time analytical database based on MPP architecture, known for its high performance and ease of use. It supports both high-concurrency point queries and high-throughput complex analysis. (https://github.com/apache/doris)

SelectDB is a cloud-native real-time data warehouse developed based on the Apache Doris open source project by the same key developers. The SelectDB company focuses on the enterprise-grade cloud-native distribution for Apache Doris. (Contact US: support@selectdb.com)

Follow us:
https://linktr.ee/apachedoris
Apache Doris @GitHub
https://github.com/apache/doris

Apache Doris Website
https://doris.apache.org/

Apache Doris @ Twitter
https://twitter.com/doris_apache

Apache Doris @ Medium
https://medium.com/@ApacheDoris

Apache Doris @ Dev.to
https://dev.to/apachedoris

Apache Doris @ Reddit
https://www.reddit.com/user/ApacheDoris

SelectDB Website
https://en.selectdb.com/

SelectDB @ Twitter
https://twitter.com/Select_DB

SelectDB @ Reddit
https://www.reddit.com/user/SelectDB

SelectDB @ Dev.to
https://dev.to/selectdb
"Application of Apache Doris in JD.COM"_Apache Doris Summit 2022
Tags: database, opensource, programming, java
Published: 2023-02-08 03:39:09

https://www.youtube.com/watch?v=QPsoN6lRJ44

-------------------------------------------

JD.COM
JD.COM's Search & Push Project started in 2019. Its goal is to bring better exposure and clicks to the high-quality goods resources of merchants on the platform through traffic control. Since joining the project, Apache Doris has been responsible for the traffic in JD.COM's Double 11 and 6.18 promotions during the past three years, with the traffic peaks reaching 450 million per minute. The 1.1.5 version released by Apache Doris has made a major breakthrough in performance and stability. The query performance is 2-3 times higher than before, and the overall cluster import throughput is increased by 100%, which greatly solves the problems and optimizes the unity of cost, efficiency and user experience.

Apache Doris is a real-time analytical database based on MPP architecture, known for its high performance and ease of use. It supports both high-concurrency point queries and high-throughput complex analysis. (https://github.com/apache/doris)

SelectDB is a cloud-native real-time data warehouse developed based on the Apache Doris open source project by the same key developers. The SelectDB company focuses on the enterprise-grade cloud-native distribution for Apache Doris. (Contact US: support@selectdb.com)

Follow us:
https://linktr.ee/apachedoris
Apache Doris @GitHub
https://github.com/apache/doris

Apache Doris Website
https://doris.apache.org/

Apache Doris @ Twitter
https://twitter.com/doris_apache

Apache Doris @ Medium
https://medium.com/@ApacheDoris

Apache Doris @ Dev.to
https://dev.to/apachedoris

Apache Doris @ Reddit
https://www.reddit.com/user/ApacheDoris

SelectDB Website
https://en.selectdb.com/

SelectDB @ Twitter
https://twitter.com/Select_DB

SelectDB @ Reddit
https://www.reddit.com/user/SelectDB

SelectDB @ Dev.to
https://dev.to/selectdb
"Application of Apache Doris in Douyu"_Apache Doris Summit 2022
Tags: database, opensource, datascience, bigdata
Published: 2023-02-08 03:37:51

https://www.youtube.com/watch?v=tgeYbF1chXc

------------------------------------------

Douyu
With the rapid development of Douyu's live-streaming business, the demand for business growth analysis and revenue analysis using user behavior data is becoming more and more urgent and sophisticated. To deal with the increasing demand, Douyu introduced Apache Doris to upgrade the real-time data warehouse, standardized and improved the real-time data warehouse, and established a unified HOLAP multi-dimensional analysis platform, which solved the difficulties caused by heavy architecture in the past. At the same time, Douyu rebuilt its tag platform using Apache Doris, realizing a grouping time from minutes to seconds, stable real-time tag tasks, and a 40% decrease in output time.

Apache Doris is a real-time analytical database based on MPP architecture, known for its high performance and ease of use. It supports both high-concurrency point queries and high-throughput complex analysis. (https://github.com/apache/doris)

SelectDB is a cloud-native real-time data warehouse developed based on the Apache Doris open source project by the same key developers. The SelectDB company focuses on the enterprise-grade cloud-native distribution for Apache Doris. (Contact US: support@selectdb.com)

Follow us:
https://linktr.ee/apachedoris
Apache Doris @GitHub
https://github.com/apache/doris

Apache Doris Website
https://doris.apache.org/

Apache Doris @ Twitter
https://twitter.com/doris_apache

Apache Doris @ Medium
https://medium.com/@ApacheDoris

Apache Doris @ Dev.to
https://dev.to/apachedoris

Apache Doris @ Reddit
https://www.reddit.com/user/ApacheDoris

SelectDB Website
https://en.selectdb.com/

SelectDB @ Twitter
https://twitter.com/Select_DB

SelectDB @ Reddit
https://www.reddit.com/user/SelectDB

SelectDB @ Dev.to
https://dev.to/selectdb