teleren/devto huggingface dataset:
🔖 Get started with Apigee Management ⏱️
Tags: api, apigee, googlecloud, cloud
Published: 2023-04-19 21:20:06

## ❔ About

In this post you'll find a set of **very useful intros** contents to [Google Apigee](https://cloud.google.com/apigee).

Below are listed the episodes **I found the most useful** to explain around me what can (and will) be achieved during our Apigee journey at [`opt-nc`](https://dev.to/optnc).

Hopefully you'll find as useful as I do 😅.

## ☝️ Notice

Transforming APIs from an "obscure developer concern" to an organizational strategic asset to achieve Digital Business Transformation can be a challenging task.

👉 The main purpose of this post it to **help anyone engaged in this journey with helpful resources** by:

🗣️ Being able to **share the knowledge** around you
🛣️ Transforming an **API to a product**


## 🎯 What you'll learn (in less than 20')

You'll find the following topics:

🛡️ Security
🛑 Quotas
⚡ Caching
🦾 Transformations
❗ Error handling
🗠 Monitoring
🪙 API product, service plan, monetization 
➿ Lifecycle management


## 🚀 Intro

ℹ️ If you have to **talk about API management or explain what Apigee is**, this is the right content :

{% youtube vGe38icp0n4 %}

## 🏬 Developer portal

ℹ️ If you have to explain what you can achieve and **how Apigee can help develop and share services with developers or partners**, this is the right content :

{% youtube Zrxn247FqtM %}

## 🧰 API proxy

ℹ️ Learn how to **create and customize** an API proxy.

{% youtube t_E2_xs6Nns %}

## 📊  Monitoring

ℹ️ Know **where developers are**, API popularity, traffic patterns, **detect customer issues**, cache performance, Error code analysis, **latency** (response time analysis), developers engagement, End users device driven statistics & Geomap

{% youtube yDbYSj8XaT8 %}

💡 You may also take a glance at [Apigee API Analytics](https://youtu.be/A2KQ3GJvb98)

## ✏️ Apigee on `mingrammer/diagrams`

As any other service, it is important to be **able to document architecture... with code.**

Therefore, you can follow this dedicated issue:

{% twitter 1646792983579344901 %}

## 📑 Related resources

- Dedicated and complete [Youtube playlist](https://goo.gle/386ZycJ)
- [Full Apigee demo](https://youtu.be/58smxQu3P5k)
- [Steps on how to create an API proxy](https://goo.gle/2UkN6Cr)
- [Accessing your API proxies (create an internal virtual machine or external load balancer)](https://goo.gle/3x6hbEt)
- [Go deeper with policies in API proxies](https://goo.gle/3y85vkC)
- [Addressing your API use cases: Choosing between Apigee, API Gateway, and Cloud Endpoints](https://cloud.google.com/blog/products/application-modernization/choosing-between-apigee-api-gateway-and-cloud-endpoints/)
Changing Remote in Git Repositories
Tags: webdev, git, github, beginners
Published: 2023-04-19 21:08:59

![Photo by [Lorenzo Herrera](https://unsplash.com/@lorenzoherrera?utm_source=unsplash&utm_medium=referral&utm_content=creditCopyText) on [Unsplash](https://unsplash.com/photos/p0j-mE6mGo4?utm_source=unsplash&utm_medium=referral&utm_content=creditCopyText)](https://cdn-images-1.medium.com/max/12096/1*eNiQG0u2bcQsciKS8zCw-w.jpeg)

Git is a powerful version control system that allows developers to collaborate on code and track changes made to a project over time.

Sometimes, you may need to change the remote URL associated with a Git repository. In this article, we’ll explore how to change the remote URL of a Git repository with code samples.

-----

## Checking the Current Remote URL

Before changing the remote URL, it’s essential to verify the current remote URL associated with your Git repository.

You can do this by using the following command:

    # Verify the current remote URL
    git remote -v

This command will display the current remote URL associated with your Git repository.

-----

## Adding a New Remote URL

To add a new remote URL to your Git repository, you can use the following command:

    # Add a new remote URL
    git remote add <name> <URL>

Replace <name> with a name for your new remote and <URL> with the URL of your new remote repository.

    git remote add newRemote https://github.com/user/newrepo.git

-----

## Removing an Old Remote URL

To remove an old remote URL from your Git repository, you can use the following command:

    # Remove an old remote URL
    git remote rm <name>

Replace <name> with the name of the old remote repository, you want to remove.

    git remote rm oldRemote

-----

## Setting a New Remote URL as Default

To set a new remote URL as the default for your Git repository, you can use the following command:

    # Set a new remote URL as default
    git remote set-url origin <URL>

Replace <URL> with the URL of your new remote repository.

    git remote set-url origin https://github.com/user/newrepo.git

-----

## Conclusion

Changing the remote URL of a Git repository can be done easily with the right commands without losing any of your existing code.

Make sure to check the current remote URL before making any changes, and set the new remote URL as default to avoid any confusion in the future.
HTTPie vs Curl
Published: 2023-04-19 21:06:24

Both HTTPie and cURL are useful tools for making HTTP requests to web servers, but they differ in some features and functionality.

Here are some advantages and disadvantages of each tool:

### HTTPie:

#### Benefits:
- Simple and easy to use command line interface
- Support formatting HTTP response output in various formats such as JSON and XML
- Support for basic and digest authentication
- Support for uploading files
- Displays response headers in color for easy reading

#### Disadvantages:
- Less support for advanced HTTP settings like setting custom headers or sending cookies
- May be less widely used than cURL, which can make finding solutions to specific problems difficult.

### cURL:

#### Benefits:
- Support for a wide variety of protocols including HTTP, FTP and SMTP
- Support advanced HTTP settings such as sending cookies and custom headers
- Support for large and digest file transfers
- A large community of users and developers, which can make it easier to find solutions to problems

#### Disadvantages:
- More complex and less intuitive command line interface than HTTPie
- HTTP response output less formatted and harder to read than HTTPie
- Less support for formatting HTTP response output in various formats such as JSON and XML

In summary, HTTPie may be a good choice if you need a simple and intuitive command-line interface for making basic HTTP requests, while cURL may be better suited for users who need advanced HTTP settings or support a wide range of HTTP requests. variety of protocols.

## Examples of using HTTPie:

- Make a GET request:
   `http https://jsonplaceholder.typicode.com/todos/1`

- Make a POST request with data in JSON format:
   `http --json POST https://jsonplaceholder.typicode.com/posts title="Test" body="Test Content"`

- Make a POST request with data in form format:
   `http --form POST https://example.com/submit name=John age=30`

- Send custom headers in a request:
   `http https://example.com Authorization:"Bearer token123" User-Agent:"MyClient/1.0"`

- Send a file in a POST request:
   `http --form POST https://example.com/upload file@/path/to/the/file`

- Make a PUT request with data in JSON format:
   `http --json PUT https://jsonplaceholder.typicode.com/posts/1 title="New title" body="New content"`

<br />

[![Texto alternativo da imagem](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ds4alkts3uxq0dsco0nv.png)](https://www.linkedin.com/in/israel-lopes-419a32189)
Custom tent canopy
Published: 2023-04-19 21:02:21

PVC is one of the form of plastics. Plastics are very beneficial in everyday lifestyles as it provides extra resistance in opposition to one of a kind reagents and are very long lasting with long lasting outcomes.
**_[Custom tent canopy](https://www.linyangpvc.com/pvc-tarpaulin-for-push-and-pull-canopy-tent)_**

PVC strip curtains are a form of top exceptional plastic, that are in brilliant call for within the recent days. In this the plastic is made thin sheets and are usually observed in on the doors and allows loads in lowering the effect of lack of temperature and protects the environment from other special sorts of pollutants.
Different types of PVC strips

There are specific sorts of PVC strip curtains to be had inside the marketplace and they're:

Anti static PVC curtain
This kind of curtains is used to shield the additives from the release of electrostatic fees. It facilitates in protective the semiconductors from damages due to immoderate float of costs. There many producers which produce this product and are in incredible demand in latest marketplace.

Cold garage PVC strips
These curtains help in controlling the loss of temperature from exclusive bloodless areas like freezers. This helps in increasing the efficiency of by lowering the loss of strength. In India this curtain finds its software in distinctive regions of cold garage.

Welding PVC curtains
This sort of curtains finds its utility in the mechanical workshops, where the system of welding is completed. This allows in shielding from the UV rays, sparks of welding. Different mechanical workshop is PVC strips curtain providers.

Transparent curtains
The principal feature of this type of curtain is that it gives extraordinary transparent impact, which are helpful in loading and unloading different things at exceptional workplaces.
These are some of the critical and well-known PVC curtains synthetic in India in distinctive industries and find exceptional applications.

Applications of PVC curtains
PVC curtains reveals its application in unique field making proper market for the PVC strips curtain providers. The common dialogue of trendy generation is set the methods to manipulate electricity crisis. In this element, PVC curtains play an crucial position in reducing the loss of energy. In many areas, it facilitates in lowering the lack of temperature, hence growing the performance and lowering the strength loss circuitously.
Keep Watch on SQL Query in Intellij/Goland or DataGrip
Tags: jetbrains, database, programming, tooling
Published: 2023-04-19 20:56:33

Are you an Intellij, Goland or DataGrip User? Like me, are you running the SQL statements every time you want to see the change reflected on the table?

If Yes, I found a small trick in Intellij and DataGrip that could watch your SQL query results. It was always there but I overlooked it. Once I discovered it, it changed my life for debugging or development.

It’s not a trick actually 😅 but a feature built within the IntelliJ products. It could easily go ignored but let’s see how to use it

When you run any query you will see the Result window below:

![result window](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/dogsoktti9stwee8fmmt.png)

You would see this clock icon in the toolbar that does all the trick. It was always there but I never thought it would be so useful 😍

![Clock Icon](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/rdepts4r4w7qeol2xiyq.png)

When you click on it, the below options would be available. Each choice you select will refresh the query results after the selected delay.


![predefined interval](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/mxshlxtp3bu75sgg44xq.png)

A small tip to remember is to make sure you “Pin” 📌 the result window. When you do it, you could run other queries along with the watch window.

The below video shows a small demo of this feature. In the demo, I am watching the result of a `SELECT` query. When I update a record it is shown in the result window without running the `SELECT` query again.


![demo](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/i9c5flu4y854kuckhpsf.gif)

`5s` seem long? What if I want to keep the watch period lower than `5s`? You could use the `Custom` option provided. With this, you could also monitor your query changes at a 1s rate interval


![custom interval](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/rcn6idzexpjucux0ffhl.png)

Well, that's all for this post. I hope next time this small utility will come in handy for you. Don’t run the query every time to see the change. IntelliJ tools are a powerhouse of such small utilities which are very easily ignored by us.

Thanks! and Happy Coding! Don’t forget to [follow me](https://medium.com/@iamninad), like (❤️) for motivation and comment on some IntelliJ utilities that helped you! 🍻
Directivas ngFor, ngIf.
Published: 2023-04-19 20:47:57

En angular existe directivas estructurales que modifican el DOM segun las condiciones y variables de todo tipo, incluyendo arreglos. Estas directivas son *ngFor, *ngIf. 
Ejemplo: 

```
<li *ngFor = "let numeros of ArrayNumeros">numeros</li>
```
Aquí se crean tantos items para mostar en el DOM como los elementos existentes en el arreglo: ArrayNumeros. 
otra opcion posible es mostrar o no algún bloque con *ngIf.
*ngIf="true".
El emprendedor deportivo
Published: 2023-04-19 20:45:37

Había una vez un joven emprendedor llamado Juan que quería montar su propio negocio de ropa deportiva. Tenía muchas ideas y estaba emocionado de comenzar, pero no estaba seguro de si su producto sería conocido en el mercado. Fue entonces cuando decidí hacer una investigación de mercado para entender. 

  

Gracias a una [agencia de investigación de mercado](https://investigaciondemercadosqueretaro.com/) le permitió a Juan establecer desde el principio qué productos ofrecer, a qué costo y cómo promocionarlos. También pudimos estudiar cuidadosamente a nuestros consumidores para averiguar qué tipos de productos y servicios tienen más demanda. Esta información vital ayudó a Juan a minimizar el riesgo y tomar decisiones comerciales más informadas. 

  

En última instancia, la investigación de mercado permitió a Juan lanzar con éxito un negocio para satisfacer las necesidades de los consumidores. Desde entonces, ha apreciado constantemente el valor de la investigación de mercado en cada plan de negocios.
THE ROLE OF ARTIFICIAL INTELLIGENCE (AI) IN NETWORK HARDWARE AND SOFTWARE
Tags: ai, network, performance
Published: 2023-04-19 20:45:10

The role of [artificial intelligence](https://en.wikipedia.org/wiki/Artificial_intelligence) (AI) in network hardware and software is rapidly growing, and is expected to have a significant impact on the future of networking:

- AI can be used to automate network management tasks, reducing the workload on network administrators and improving efficiency.
- AI can be used to [optimize network performance](https://www.networking-hardware.com/juniper/service-gateway), by predicting and preempting network congestion or failures, and optimizing routing and load balancing.
- AI can be used to improve network security, by detecting and responding to security threats more quickly and effectively.

Here are two tables that illustrate the use of AI in [network hardware and software](https://rsfsupply.com/blogs/news/the-role-of-artificial-intelligence-ai-in-network-hardware-and-software).
Full Stack open 2023 Part 13
Tags: postgres, beginners, tutorial
Published: 2023-04-19 20:39:48

PostgreSQL, it is truly amazing an open source DB can be so good.

I have some mixed feelings about this part of FSO. The best part is that it allowed me to stop being afraid of SQL.

## Background
I started this tutorial with absolutely no SQL experience. Because of that, the first step for me was to lean some SQL using [SQL Bolt](https://sqlbolt.com/). It did it's job. That is to teach me some basic queries in browser.

## Review
Part 13 is quite long. I started with deploying a PostgreSQL instance on [fly.io ](https://fly.io/docs/postgres/).
Then, a low point of the tutorial IMO is the fact that the author went with Sequelize, a popular ORM. I simply do not see the value of an ORM to learn SQL. You have to use it for all exercises. 

The bones of the tutorial are good, you learn about one-to-many and many-to-many relationships in detail. You learn about migrations using [umzug](https://github.com/sequelize/umzug). That is a part I loved because it solves so many problems with your schema. Each change of your schema is a .js file in your filesystem.

A nice touch was the last exercise where you need to use a server side session instead of a JWT for auth. You have more freedom here. I ended up using plain old cookies. You don't learn this in the original part of FSO.

## Pros and cons

Pros:

- It cured me of the fear of databases
- I learned about database migrations
- I learned basic SQL
- I learned the tools of the trade

Cons:
- You use raw SQL rarely
- Sequelize (I had to fight it)
- No stored procedures/functions

Part 13 score: **7/10**
I moved to indieweb.social 👋🏻
Tags: fediverse, mastodon, socialmedia
Published: 2023-04-19 20:23:50

After plenty of consideration, I've made a new home in the Fediverse!

{% embed https://indieweb.social/@erinposting %}

I've just migrated my account from the general, massive, barely moderated [mastodon.social](https://mastodon.social) to [indieweb.social](https://indieweb.social/about), a smaller server dedicated to evolving the open web and humane tech. I'm excited to build new connections in the space and see where it takes me!

_PS — in case you missed it, follow the link below to read about DEV's switch to [Fosstodon.org](https://fosstodon.org) a few months back..._

{% embed https://dev.to/devteam/weve-moved-to-fosstodon-53e1 %}

What about you, brave Fediverse explorers? Have you switched servers before? Do you like where you've landed?
Mobile app development company in india
Tags: programming, react, javascript, python
Published: 2023-04-19 20:06:01

We are the [top mobile app development company in India](url=https://www.wamatechnology.com/top-mobile-app-development-companies-india/), and we have helped both established businesses and start-ups succeed with mobile apps across a variety of industries. We only allow innovative people to join our team so that we can always build with the newest mobile trends and technologies. For example, we use cutting-edge tools like Flutter and React that are enhanced to meet the needs of your customers, resulting in a solid mobile application with enticing and useful UI/UX Designs for iOS and Android. One of our numerous digital strengths makes us one of the most reputable Indian mobile app developers.

**Our Services**

- Android App Development
- iOS / iPhone App Development
- Hybrid App Development
- PHP Web Development
- Node.Js Development
- E-Commerce Website
- Hire Dedicated Developers

**Contact now**

info@wamatechnology.com
+91-9870815661
Creating a new project in #AndroidStudio + Android Studio interface overview
Published: 2023-04-19 20:05:51

To create a new project in Android Studio, click on File -> new -> new project. Doing that, a page pop up as shown below

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/7i55j6lltp1hkz02ati6.jpg)

As shown in the picture, we have different templates to use, this case, we will use Empty Activity templates as a beginner. Click on it, then you will be directed to the next page as shown below


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/5nffmdb3sesrlz86muo8.jpg)

Here, you have your Application name as 'My Application'; a name your app will be recognized with.

Followed by your package name, your package name will be different from mine, so you can leave it at default. This package name is unique as it'll be associated with your app on Play-Store or where you publish your app.

Then, we have a 'Save Location' of your app on your PC, it'll be advised a a good practice to save your project on an external drive because of virus and other malicious threat.

'Language' is the PL(Programming Language) to code. I'll chose 'java' as it is the language I use to code and we will be using.

'Minimum SDK' will also be left at default.

Click on 'Finish', then you see the Android Studio User Interface where Gradle build as shown below, and make sure your PC is connected to the internet to download necessary plugins and dependencies.


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/127gid0srs2g6vbeux0z.jpg)

Now that we have our project set up, let's take a look at the Android Studio user interface. The Android Studio user interface consists of several main components:

1. Toolbar: The toolbar contains buttons for common actions, such as building and running your app, debugging, and creating new files.

2. Project Explorer: The project explorer displays the files and folders in your project. You can use it to navigate your project, create new files, and organize your code.

3. Code Editor: The code editor is where you write your code. It provides features such as syntax highlighting, auto-completion, and code analysis.

4. Preview Window: The preview window displays a preview of your app's user interface, allowing you to see how your app will look on different devices.

5. Logcat: Logcat is a tool that displays the logs generated by your app. You can use it to debug your app and troubleshoot issues.

6. Gradle Console: The Gradle console displays the output of the Gradle build system, which is used to compile and package your app.

You can navigate on top of each icon to know it name or function.

Initially, creating a new empty project, it comes with two files
'MainActivity.java' to write our java codes, and a corresponding xml file 'activity_main.xml' that depicts the layout or design of our app.

Explore it and see what you have there. In the next post, we will be creating our first Android app together, so stay tuned for my next post by following me.

Over and out. Peace.
When to Use Database Triggers and How They Work
Published: 2023-04-21 20:29:49

---
title: When to Use Database Triggers and How They Work
published: true
date: 2023-04-19 19:50:52 UTC
tags: 
canonical_url: https://harshmange.hashnode.dev/when-to-use-database-triggers-and-how-they-work
---

A trigger is a database object that automatically executes a specific action in response to certain database events or changes, such as a data insertion, update or deletion. Triggers are often used in database management systems to maintain data integrity, enforce business rules, or perform custom operations in response to specific events.

## Example

Let's say you have a database that stores order information, including the order date, customer ID, and total amount. You want to create a trigger that will update the customer's account balance whenever a new order is inserted into the database.

First, you would write the SQL statement for updating the customer's account balance. For example, you might want to add the total amount of the new order to the customer's current balance:

```
UPDATE customers
SET account_balance = account_balance + @total_amount
WHERE customer_id = @customer_id;

```

Next, you would create a trigger that encapsulates this SQL statement:

```
CREATE TRIGGER UpdateCustomerAccountBalance
ON orders
AFTER INSERT
AS
BEGIN
  DECLARE @customer_id int;
  DECLARE @total_amount decimal(10,2);

  SELECT @customer_id = customer_id, @total_amount = total_amount
  FROM inserted;

  UPDATE customers
  SET account_balance = account_balance + @total_amount
  WHERE customer_id = @customer_id;
END

```

Now, whenever a new order is inserted into the database, the trigger will automatically execute and update the customer's account balance accordingly.

## Basic Use Cases

1. Data integrity: Triggers can be used to enforce data integrity rules, such as preventing the insertion of invalid data or updating related data when a record is changed.

2. Business rules: Triggers can be used to enforce business rules, such as updating customer balances or sending notifications when certain events occur.

3. Audit trails: Triggers can be used to create audit trails or log changes to the database.

4. Custom operations: Triggers can be used to perform custom operations in response to specific events, such as updating a search index or sending a notification.

In summary, triggers are a powerful tool for managing database events and maintaining data integrity in a database management system. They can be used to enforce business rules, perform custom operations, and create audit trails, among other things.