teleren/devto huggingface dataset:
openGauss APIs
Tags: opengauss
Published: 2023-03-30 07:14:50

You can use standard database APIs, such as ODBC and JDBC, to develop openGauss-based applications.

Supported APIS
Each application is an independent openGauss development project. APIs alleviate applications from directly operating in databases, and enhance the database portability, extensibility, and maintainability. Table 1 lists the APIs supported by openGauss and the download addresses.

Table 1 Database APIs


API

How to Obtain

ODBC

Linux:
Driver: openGauss-x.x-ODBC.tar.gz

unixODBC source code package: http://sourceforge.net/projects/unixodbc/files/unixODBC/2.3.0/unixODBC-2.3.0.tar.gz/download

JDBC

Driver: openGauss-x.x-EULER-64bit-Jdbc.tar.gz
Driver: org.postgresql.Driver
You can use JDBC and ODBC to connect to the database. Therefore, you need to configure a remote connection in openGauss.

For details about more APIs, see Application Development Guide.
Tips to become a good programmer
Tags: webdev, beginners, programming, tutorial
Published: 2023-03-30 07:09:32

1. Start with the basics: Begin with learning the fundamentals of programming. Understand the core concepts of programming languages, data structures, algorithms, and problem-solving techniques.

2. Practice regularly: Practice coding regularly. The more you practice, the more you learn, and the better you become.

3. Write clean and efficient code: Write code that is easy to read, well-organized, and efficient. Use comments to make your code easier to understand and maintain. Make sure your code is well-structured, easy to read, and properly documented. Use descriptive variable names, break down complex functions into smaller ones, and avoid code duplication.

4. Learn from others: Learn from other experienced programmers. Read books, watch videos, attend online classes, participate in coding communities, and learn from their experiences.

5. Solve real-world problems: Solve real-world problems with coding. This will help you understand the practical application of programming.

6. Continuously learn and improve: Stay updated with the latest technologies and programming languages. Keep learning new things and improving your skills.

7. Collaborate with others: Collaborate with other programmers on open-source projects. This will give you exposure to working on a real project with a team.

8. Test and debug your code: Test and debug your code thoroughly. This will help you identify and fix errors in your code.

9. Document your code: Document your code with comments and clear instructions. This will help other developers understand your code and make it easier to maintain.

10 Be patient and persistent: Becoming a good programmer takes time and effort. Be patient, persistent, and keep practicing.
openGauss Configuring Remote Connection
Tags: opengauss
Published: 2023-03-30 07:07:24

Before the remote connection, you need to enable the client to access the database and configure the remote connection on the server where the database primary node is deployed.

Procedure
Perform the following steps on the host where openGauss resides.

Log in as the OS user omm to the primary node of the database.

Configure the client authentication mode. For details, see Configuring Client Access Authentication.

Configure listen_addresses. listen_addresses indicates the IP address or host name of the database primary node used for remote client connection.

Run the following command to check the listen_addresses value of the primary database node:

""
gs_guc check -I all -c "listen_addresses"
Information similar to the following is displayed:

""
expected guc information: plat1: listen_addresses=NULL: [/gaussdb/data/data_cn/postgresql.conf]
gs_guc check: plat1: listen_addresses='localhost, 192.168.0.100': [/gaussdb/data/data_cn/postgresql.conf]

Total GUC values: 1. Failed GUC values: 0.
The value of parameter listen_addresses is same on all instances.
    listen_addresses='localhost, 192.168.0.100'
Run the following command to append the IP addresses to be added to listen_addresses. Use commas (,) to separate multiple IP addresses. For example, add the IP address 10.11.12.13.

""
gs_guc set -I all -c "listen_addresses='localhost,192.168.0.100,10.11.12.13'"
Configure pg_hba.conf and add the IP address of the primary database node and the IP address of the client. For details about the parameters in pg_hba.conf, see Configuring Client Access Authentication.

Run the following command to add the IP address of the primary database node to pg_hba.conf. In the command, initial_user indicates the initial user name of the database, and 10.11.12.13 is the IP address of the host where the database resides.

""
gs_guc reload [-Z datanode] -N all -I all -h "host all initial_user 10.11.12.13/32 trust"
Run the following command to add the IP address of the client to pg_hba.conf. If the IP address is 10.11.12.34, the authentication mode is SHA-256.

""
gs_guc reload [-Z datanode] -N all -I all -h "host all all 10.11.12.34/32 sha256"
Run the following command to restart openGauss:

""
gs_om -t stop && gs_om -t start
10 Python Libraries That Will Make Your Life Easier
Published: 2023-03-30 07:00:38

## Introduction
Python is a popular programming language known for its simplicity, readability, and versatility. However, what makes Python truly powerful is its vast ecosystem of libraries. In this blog post, we'll take a look at 10 Python libraries that can help you solve common programming problems and make your life easier.

1. Requests: If you need to send HTTP/1.1 requests, this library is a must-have. It allows you to send HTTP/1.1 requests extremely easily, and handles common tasks like authentication, cookies, and more.

2. Pandas: Pandas is a powerful library for data manipulation and analysis. It provides fast, flexible, and expressive data structures designed to work with both structured and unstructured data.

3. NumPy: NumPy is a library for scientific computing in Python. It provides a multidimensional array object, various derived objects (such as masked arrays and matrices), and an assortment of routines for fast operations on arrays, including mathematical, logical, shape manipulation, sorting, selecting, I/O, discrete Fourier transforms, basic linear algebra, basic statistical operations, random simulation, and much more.

4. Matplotlib: Matplotlib is a plotting library for Python. It provides an object-oriented API for embedding plots into applications using general-purpose GUI toolkits like Tkinter, wxPython, Qt, or GTK.

5. SciPy: SciPy is a library for scientific computing in Python. It provides functions for optimization, integration, interpolation, eigenvalue problems, Fourier analysis, signal processing, linear algebra, and much more.

6. Pygame: Pygame is a library for creating games in Python. It provides a set of tools and functions for creating 2D and 3D games, including graphics, sound, and user input handling.

7. Beautiful Soup: Beautiful Soup is a library for web scraping in Python. It provides an easy-to-use API for extracting data from HTML and XML files.

8. Pillow: Pillow is a library for image processing in Python. It provides tools and functions for opening, manipulating, and saving many different image file formats.

9. Scikit-learn: Scikit-learn is a library for machine learning in Python. It provides simple and efficient tools for data mining and data analysis, including classification, regression, clustering, and dimensionality reduction.

10. PyQT: PyQT is a set of Python bindings for the QT application framework. It allows you to create desktop applications with a graphical user interface (GUI) using Python.


## Conclusion
These 10 Python libraries are just a small sample of what's available in the Python ecosystem. By using these libraries, you can save time and effort in your programming projects, and focus on the more important aspects of your work. Whether you're working on data analysis, web scraping, image processing, machine learning, or game development, Python has the tools you need to succeed.
How Do You Handle Legacy Code When Starting a New Project?
Tags: discuss, beginners, codenewbie
Published: 2023-03-30 07:00:00

When starting a new project, dealing with legacy code can be a daunting task. Patience is a virtue; if you can, take your time to understand the code and document it well. Don't rush the process, as this can lead to mistakes and introduce new problems into the codebase. 

But what if you're on a tight schedule. How do you handle it? What strategies have you found to be most effective?

Share your experiences and insights on legacy code management with the Newbie community. Let's learn together!
I’m building an audio library with Hugo and Internet Archive
Tags: hugo, jamstack, music, hosting
Published: 2023-03-30 06:21:54


Hi there,

I'm working on an experiment bringing together [Hugo](https://gohugo.io/) and [Internet Archive](https://archive.org/) to provide a "rock solid, lightweight and ethical solution to serve audio files".

### Demo

- Visit the [Lou Reed Bootlegs Collection](https://audio.phoni.es/audio), and see [this collection of 2000+ hiphop tracks](https://mixtapes.phoni.es/audio) featuring 2pac, Kendrick Lamar and many others.
- The focus is now on audio files, but [Videos](https://audio.phoni.es/video) and [PDF files](https://audio.phoni.es/pdf) are also supported

### Main features

-   [unlimited storage](https://help.archive.org/help/uploading-troubleshooting/#uploading-limit) and [unlimited bandwith](https://archive.org/stats/)
-   **Total running cost: $0.91 /month**
    ( It can even be entirely free using a subdomain such as [.netlify.app](https://netlify.app/), [.gitlab.io](https://docs.gitlab.com/ee/user/project/pages/#gitlab-pages), [github.io](https://pages.github.com/) or [.frama.io](https://roneo.org/en/hugo-host-for-free-on-frama.io))
-   built to scale: media files are served by the non-profit [Internet Archive](https://archive.org/about), which handles smoothly more than [5M daily users](https://archive.org/stats/). The code is hosted by the rock-solid & lightning-fast [Netlify CDN](https://www.netlify.com/).
-   careful UX, based on a stack respecting users, creators, and devs (see [below for details](https://audio.phoni.es/#features))
-   future-proof: **It's all built just with [Hugo](https://gohugo.io/), [Git](https://git-scm.com/)** and data from [archive.org](http://archive.org).

No other requirements:

-   no database
-   no npm
-   no security update
-   no server maintainance

See the [full presentation](https://audio.phoni.es/) for details
I'm not familiar with release announcements, especially in English, if you have any suggestions for improvement, I'd appreciate them.
Enhancing User Input Validation: Ensuring Proper Decimal Formatting with Regular Expressions
Tags: todayilearned, regex
Published: 2023-03-30 06:20:11

Because the user must pass a string of numbers, I must use regex to validate the input to ensure proper decimal format. 

**Example values and results.**

Input	result
"2"	✅
"2.3"	✅
"2.35"	✅
"2.357"	❌
1	❌
1.0	❌
1.325	❌
"a"	❌
"1."	❌
"1.a"	❌
""	❌

So the regex should be

```
~r/^\d+(\.\d{1,2})?$/
```

Here's the breakdown of the updated pattern:

- ^: Start of the string.
- \d+: One or more digits (0-9).
- (\.\d{1,2})?: This part is optional, denoted by the ? at the end. If there is a decimal point \., it must be followed by 1 to 2 digits (\d{1,2}). Now, the input requires at least one digit after the decimal point.
- $: End of the string.

This pattern will only match valid strings with one or more digits before the decimal point and, if a decimal point is present, at least one digit after it.
tpp armeture
Published: 2023-03-30 05:26:15

fps and tps;

1.how to add them to the brand new game;
2.the camera is too realistic and it follows to the shoulders; 
3. public float lookSensitivity ; rotation mai multiply kar dena cinemachine target yaw;



maP;;;
mainCamera;
PlayerFollowCamera;
playerarmature;



4.playerfollowcamera => playerroot
5. player armeture=>unpackcompletly
6.Geometry: armeture mesh delete, upload your character(humanoid)
7.change the avatar in player armeture
Why Learning to Code Is the Best Investment You Can Make in Yourself
Tags: beginners, programming, tutorial, career
Published: 2023-03-30 05:10:48

Are you tired of feeling stuck in your career? Do you feel like you're not living up to your full potential? If so, it's time to consider investing in yourself by learning how to code.

Coding is a skill that is in high demand, and it's only going to become more valuable in the future. In fact, according to the Bureau of Labor Statistics, the demand for software developers is expected to grow by 22% by 2029.

But why is learning to code such a great investment? Here are just a few reasons:

- **It's a high-paying skill:** The average salary for a software developer in the US is over $100,000 per year.

- **It's a versatile skill:** Coding is used in a wide range of industries, from tech to healthcare to finance.

- **It's a creative skill:** Coding allows you to bring your ideas to life in a tangible way.

- **It's a lifelong skill:** Learning to code will give you the ability to adapt to new technologies and stay relevant in the job market.

So what are you waiting for? If you're ready to take your career to the next level, start investing in yourself by learning how to code. With so many online resources available, there's never been a better time to get started and you can also follow me for more career-boosting tips and hilarious coding puns!
Making of Among Us in Discord - DEVBLOG 8 - Learning something manageable...
Tags: 100daysofcode, python, gamedev
Published: 2023-03-30 05:03:25

{% embed https://twitter.com/MrStiK101/status/1641304222028161024?s=20 %}

Heya, this is Mr.StiK.

So, my uploads of blogging has been quite slow because of few things:

1) I'm trying to fix some stuff
2) The code has gone so big that it makes my head feel dizzy 😵‍💫😵‍💫😵‍💫
3) I've a bit of ADHD problems and this is making me drive away from the project because I'm seeing no hope on this...

So, I asked some help, and this is what I got...


I'VE TO LEARN A DATABASE AND ASYNCIO FOR THIS CRAP!!!

WAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA

so yeah, no code for you, again. I'm sorry


;(


so, yeah, ima ded.

Toodles
O que é .NET e quais suas funçoes?
Published: 2023-03-30 04:56:16

.NET é uma plataforma de desenvolvimento de software da Microsoft que permite a criação de aplicativos para Windows, web e dispositivos móveis. A plataforma é uma estrutura de software que fornece vários recursos e bibliotecas para a criação de aplicativos eficientes e escaláveis.

O _.NET_ é composto por duas principais partes: o Framework _.NET_ e o ._NET_ Core. O Framework _.NET_ é um ambiente de tempo de execução que suporta vários idiomas, incluindo C#, Visual Basic e F#. Ele fornece uma ampla gama de bibliotecas de classe base, incluindo bibliotecas de entrada e saída de arquivos, bibliotecas de rede, bibliotecas de segurança, bibliotecas de criptografia, bibliotecas de serviços da web e muito mais.

O _.NET_ Core é uma versão de código aberto do Framework .NET que é multiplataforma e pode ser executado em vários sistemas operacionais, incluindo Windows, macOS e Linux.
O ._NET_ Core é mais leve e modular que o Framework .NET, o que o torna adequado para aplicativos de contêiner e microservices.

Uma das principais funções do _.NET_ é fornecer uma plataforma comum para desenvolvimento de software. Isso significa que os desenvolvedores podem escrever aplicativos em qualquer idioma suportado pelo _.NET_ e implantá-los em vários sistemas operacionais e plataformas de hardware, incluindo desktops, dispositivos móveis e servidores.

O _.NET_ também fornece várias ferramentas de desenvolvimento, incluindo o Visual Studio, um ambiente integrado de desenvolvimento (IDE) que permite a criação de aplicativos _.NET_ com recursos de depuração, compilação e testes integrados. Outras ferramentas incluem o _.NET_ CLI, um conjunto de ferramentas de linha de comando para compilar e implantar aplicativos _.NET_, e o Visual Studio Code, um editor de código leve e multiplataforma que suporta vários idiomas, incluindo C # e F #.

Outra função importante do _.NET_ é a sua capacidade de interoperar com outros sistemas e tecnologias. O _.NET_ pode se comunicar com sistemas baseados em COM, Java e outras tecnologias, o que o torna adequado para integração com outros sistemas empresariais. O _.NET_ também suporta a criação de aplicativos da web usando ASP.NET, uma estrutura de desenvolvimento da web que permite a criação de aplicativos da web escaláveis e de alto desempenho.

Resumindo, o _.NET_ é uma plataforma de desenvolvimento de software poderosa e flexível que permite a criação de aplicativos eficientes e escaláveis para vários sistemas operacionais e plataformas de hardware. Com uma ampla gama de bibliotecas de classe base, ferramentas de desenvolvimento e suporte para vários idiomas de programação, o _.NET_ é uma escolha popular para desenvolvedores que desejam criar aplicativos da web, desktop e móveis eficientes e de alto desempenho.
CTRL + Z: Shortcut to Undo Last Action in Excel (Windows & Mac)
Tags: excelshortcuts
Published: 2023-04-17 05:26:40

---
title: CTRL + Z: Shortcut to Undo Last Action in Excel (Windows & Mac)
published: true
date: 2023-03-30 04:51:46 UTC
tags: ExcelShortcuts
canonical_url: https://aawexcel.com/shortcuts-to-undo-last-action-in-excel/
---

Generally, shortcuts are more efficient and save a lot of time. Once you learn shortcuts for performing tasks on your PC, you will complete the job efficiently. Excel provides plenty of  **shortcuts**  to do different kinds of tasks on it.

Let us see the shortcut to **Undo the Last Action** in Excel on Windows and Mac systems.

## Shortcut keys

- Here we come up with the shortcut to undo the last action in the Excel workbook on  **Windows PC**.
- To do so, you have to launch Excel software on your system.
- Then  **click ** the  **below-mentioned shortcut**  key.

| **Shortcut** | **Function** |
| --- | --- |
| **<kbd>CTRL</kbd> + <kbd>Z</kbd>** | You can use this shortcut to **undo the last action** in Excel. |

_Click Here to View More Excel Shortcuts_

- If you are a Mac user, use the following keyboard shortcut to undo the last action in Excel. 

| **Shortcut** | **Function** |
| --- | --- |
| **<kbd>⌘</kbd> + <kbd>Z</kbd>** | This shortcut is used to **undo the last action** in the Excel spreadsheet. |

_Click Here to View More Excel Shortcuts_

## Shortcut Description

If we want to  **Undo the Last Action in Excel, ** we can use these Shortcut Keys. We generally make some mistakes while working on massive data or doing calculations. In such cases, we are not aware of what error we made. So this shortcut might be helpful to us.

## Workbook Explanation

- The workbook is a collection of one or more worksheets in a single file.
- Regardless of small or massive data in Excel, we should only store it in a workbook.
- We can add N number of **[sheets](https://aawexcel.com/how-to-use-excel-sheets-function/) **on a workbook and those sheets contain N number of cells for entering our input data.
- It helps to perform mathematical calculations using **[formulas](https://aawexcel.com/excel-formula/)** and **[functions](https://aawexcel.com/excel-functions/)**.
- Excel also provides  **VBA**  (Visual Basic for Applications) and  **Macros**  to automate some work.
- We can also insert  **Charts**  to define a graphical representation of data in an Excel workbook.

## Closure

In the above article, we can learn how to use the  **Shortcut to Undo the last Action**  in Microsoft Excel 365 for both Windows and MAC Systems. Drop your **feedback** in the comment section. Thanks for visiting [AawExcel.](https://aawexcel.com/) Keep Learning!!
Idea: Using Decentralized Identities to Fight AI Threats and Shape Internet 3.0
Tags: web3, webdev, discuss, blockchain
Published: 2023-03-30 04:47:10



![Meme](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/jo18utslc7rhnfpbj6fz.jpg)

With the rapid advancement of AI technologies, we will see an increase in internet threats and exploitations. I've been thinking about the future of the internet and how we can make it more secure, decentralized, and user-focused while mitigating the negative effects of AI.

I thought of an idea where we could use Hyperledger Indy for decentralized identity (DID) management and basically create a new protocol that requires DIDs for auth. This is an extension of another idea I had around DIDs and blockchains.

I'd love to get your thoughts and feedback on this, or if you know if any other ideas like this being explored!

**The Idea:**

Create a new version of the hypertext transfer protocol that requires users to have a DID, managed through Hyperledger Indy. This DID would be checked for validity before allowing any transaction to go through, essentially creating a more secure and decentralized internet (Internet 3.0).

**How It Addresses AI-driven Threats:**
- It hinders AI-generated phishing attacks, as every request would require a valid DID.
- It thwarts AI-powered bots and fake accounts, as the DID requirement would make it challenging to create and maintain large-scale automated systems for malicious purposes.
- It makes A.I generated or altered content more traceable, as content creators and distributors would have associated DIDs, promoting accountability and authenticity. This could be paired with hashing content for tracking.

**_Perceived_ Strengths:**
- Enhanced security and privacy through a robust PKI, selective disclosure, and zero-knowledge proofs.
- Decentralized and user-centric architecture.
- Greater interoperability and ease of integration with other web3 technologies.
- Encourages trust through transparent and tamper-proof DID management.

**Foreseeable Weaknesses/Challenges:**
- Increased complexity for developers and users.
- Potential performance trade-offs due to the computational overhead of DID validation and zero-knowledge proofs.
- Adoption (browser vendors, web service providers, etc.).
- Scalability 
- Educating users and businesses about the benefits and workings of the new protocol.

**Opportunities:**
- Reduces reliance on centralized certificate authorities.
- Empowers users with more control over their data and identity.
- Fosters a more open and equitable internet ecosystem.
- Encourages the development of new web3 applications and services prioritizing security, privacy, and user empowerment.

So, what do you all think? Are there any major concerns or potential improvements I've missed? What do you think about the items I've outlined already?

I'd love to hear your thoughts, especially if you have experience with Hyperledger Indy, DIDs, or web3 technologies!