teleren/devto huggingface dataset:
ERD Lab - Free Database Design & Modeling Tool
Tags: webdev, sql, programming, productivity
Published: 2023-02-27 20:01:13

I'm Jerry from ERDLab which is an [ER Diagram Tool](https://www.erdlab.io) **(100% FREE)**

👀 What?
ERDLab is a simple and intuitive entity relationship diagram tool which allows you to develop and visualize database schemas online in collaboration with your team. Saving you a lot of time in your development process.

🤔 Why?
My colleagues and I traditionally used desktop tools but after we switched to remote work, we looked for cloud based solutions. Surprisingly there are many online tools which work but every tool was missing something important. So we decided to create our own by copying the best features of each and adding a few of our own (Makers hate this one weird trick).

🚧 One important thing that sets ERDLab apart from other tools is that ERDLab allows you to draw your diagram two ways. Developers often prefer typing so we made a simple code editor which allows you to create your diagrams fast using your keyboard only. If you prefer no-code solution, you can simply hide/toggle the "Markup" sidebar and you can create your schema without writing a single line of code. This makes ERDLab useful not only for developers but everyone else on the team like analysts, admins and even non-technical stakeholders. 🚧

✅ Current features:

- Markup/Code Editor (Made for developers. If you prefer no-code, just toggle it)
- Sleek and intuitive UI (With keyboard shortcuts)
- Fast & Reliable (Built for enterprise level teams. Can support 1000+ tables)
- Powerful Visualization (Object coloring including table, fields and relationship colors)
- Forward/Reverse Engineering (Import/Export of MySQL, MS SQL, Oracle, PostgreSQL, SQLite and Snowflake)
- Team Collaboration (Read Only + Read/Write)
- Export (PDF + Image)
- Version Control (View edit history and switch as needed)
- Multiple View Types (Table names only + Relationships only + more)
- Multiple Tabs (Work on multiple projects. Copy/Clone between multiple schemas)
- Schema Explorer (View list of all your tables & fields. Hide/Show as needed)
- Notes & Comments (Leave notes on canvas. Use comments to communicate with team)
Too many to list here. Please watch the video above or better yet visit [https://app.erdlab.io/designer/guest](https://app.erdlab.io/designer/guest) yourself (Login as guest, no registration required!)

👀 Coming soon:
- DB Conversions (Convert one DB type to another with one click)
- Embed your schemas
- Templates (100s of ready to use templates)

🚀 Future Roadmap:
- Subject Areas (Great for large schemas)
- Additional View Types
- Real-time Collaboration with edit history
- Support for more DBs including NoSQL DBs
- Migrations and Integrations


🎙 PS — What do you think we should prioritize next? A lot of our features were inspired by our own needs and what other tools were offering but we waited too long to get feedback from real users and would love to learn from the community. Please share your feedback and drop us your ideas in the comments! Thank you again for all your support.

Love,

ERDLab Team
Enable encryption on existing RDS instance
Tags: rds, encryption, aws, awscommunitybuilders
Published: 2023-02-27 19:44:02

**Do you know that it is not possible to enable encryption for an Amazon RDS database after it is created?**


![Unencrypted AWS RDS Instances](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ov9w3sd97nfxcxuiz7l8.png)

Encryption is essential for corporate datas. You must therefore ensure that encryption is enabled for all your Amazon RDS databases at creation.

Imagine the case where a new unencrypted database joins your organization following a merger for example. You will have to catch up.

Don't panic! The solution is quite simple even in a situation where your database is large and is heavily used.

Basically, you will have to do the following:

1.  **Create a snapshot of your database**;

![Create a snapshot of your database](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/qpdiec709y9wyodsu0ko.jpg)

2. **Create an encrypted copy of your snapshot**;
![Create an encrypted copy of your snapshot](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/qg863nsad8dghsxejnfy.png)

![Create an encrypted copy of your snapshot](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/tt1sa77syje5nm32on0f.png)

3.  **Restore your encrypted snapshot in a new database**.

![Restore your encrypted snapshot](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/6jay7ep21ulvt8ibddft.png)

Your Amazon RDS database is now encrypted!


![Encrypted Amazon RDS database](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/5w146kexbg9uh5qeepn5.png)


For more follow this link [Amazon RDS Encryption](https://docs.aws.amazon.com/fr_fr/AmazonRDS/latest/UserGuide/Overview.Encryption.html)
WeatherX-Weather Web Application
Tags: webdev
Published: 2023-02-27 19:41:15

This is My Weather Web Application 
Visit⬇

[WeatherX](https://xanmoy.github.io/WeatherX-Web-Application/)
WeatherX is free and open source Web Application and supports the right to read, distribute and repair.

Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.

Please make sure to update tests as appropriate.

[Repository](https://github.com/xanmoy/WeatherX-Web-Application )
10 maneiras de relaxar depois de um estressante dia em home office.
Published: 2023-02-27 19:31:31

Trabalhar em casa pode ser uma bênção e uma maldição. Por um lado, você pode usar suas pantufas fofas e trabalhar de pijama o dia todo. Por outro lado, é fácil deixar o trabalho invadir seu tempo pessoal. Então, para ajudá-lo a relaxar depois de um longo dia de home office, aqui estão **10 maneiras divertidas de se desconectar do trabalho**.

**1** - Faça uma dança da vitória no final do seu expediente em casa. Use suas pantufas e dance até quem mora com você ficar com inveja do seu rebolado.

**2** - Faça uma competição de quem consegue ficar em silêncio por mais tempo com seus colegas de casa. Quem falar primeiro, tem que pagar a pizza da noite.

**3** - Invente uma nova bebida. Misture todas as bebidas que você tiver na geladeira e dê um nome esquisito. Depois, é só servir para os amigos de casa e esperar as caretas.

**4** - Jogue um jogo de tabuleiro com sua família ou amigos de casa. Se alguém perder, tem que fazer uma dança ridícula para animar a galera.

**5** - Tome um banho de espuma e cante suas músicas favoritas. Se você não sabe cantar, pode tentar dublar as músicas e fingir que é a Beyoncé.

**6** - Faça um churrasco na sua varanda ou quintal. Chame alguns amigos de casa e divirta-se tentando não queimar a carne. 
Obs: É imprescindível chamar o escritor deste artigo. 

**7** - Faça uma maratona de filmes engraçados. Se quiser, pode até criar um jogo de beber: toda vez que alguém fizer uma piada, todos têm que tomar um gole de bebida. 

**8** - Faça uma sessão de pintura com as mãos. Se você não tem tinta, pode usar ketchup ou mostarda. E se fizer bagunça, pelo menos é uma desculpa para não cozinhar hoje.

**9** - Crie uma festa temática com seus amigos de casa. Escolha um tema engraçado e decore sua casa de acordo. E se alguém aparecer sem fantasia, tem que dançar a Macarena.

**10** - Faça uma sessão de karaokê com seus amigos. Cante suas músicas favoritas e divirta-se com as letras erradas. E se alguém desafinar, tem que fazer um solo de beatbox.

Depois de um dia de home office, o que a gente mais precisa é de diversão e risadas para relaxar. Então, solte sua criatividade e divirta-se com seus amigos e familiares em casa. Afinal, o importante é aproveitar o momento e dar boas gargalhadas.
Project ideas that have the potential to significantly improve cyber security
Tags: webdev, projectideas, cybersecurity, top5projects
Published: 2023-02-27 19:07:47

Building a Secure Communication Platform: A project that focuses on building a secure communication platform that can provide end-to-end encryption, secure file sharing, and messaging capabilities. Such a platform can help organizations protect their sensitive information from cyber threats such as eavesdropping, data breaches, and phishing attacks.=

Developing an AI-Based Intrusion Detection System: A project that focuses on developing an AI-based intrusion detection system that can detect and respond to cyber threats in real time. Such a system can use machine learning algorithms to analyze network traffic and identify patterns that could indicate a potential security breach.

Conducting a Penetration Testing Exercise: A project that focuses on conducting a penetration testing exercise can help organizations identify vulnerabilities in their systems and applications. Penetration testing involves simulating a cyber attack on the organization’s systems and applications to identify weaknesses that could be exploited by hackers.

Developing a Password Manager: A project that focuses on developing a password manager that can securely store and manage passwords for various applications and services. Such a tool can help individuals and organizations protect their sensitive information from cyber threats such as credential stuffing, password guessing, and brute-force attacks.

Building a Cybersecurity Training Program: A project that focuses on building a cybersecurity training program can help organizations educate their employees about the latest cyber threats and best practices for protecting sensitive information. Such a program can help reduce the risk of cyber attacks caused by human error, such as phishing scams, social engineering attacks, and password-related issues.
OpenApi Spring 3 NoProviderFoundException
Tags: java, openapi
Published: 2023-02-27 19:02:53

So I started a simple Java 17 and Spring 3 new project with a couple of endpoints and first thing first, I added a Swagger, instantly I discovered that Swagger is not compatible with the new jakarta source of Spring 3.
Than I decided to use Sprindocs' OpenApi. It works by simply adding the dependencies:
`
<dependency>
   <groupId>org.springdoc</groupId>
   <artifactId>springdoc-openapi-starter-webmvc-ui</artifactId>
   <version>2.0.2</version>
</dependency>
<dependency>
   <groupId>org.springdoc</groupId>
   <artifactId>springdoc-openapi-starter-webmvc-api</artifactId>
   <version>2.0.2</version>
</dependency>
`
Source: https://springdoc.org/v2/#javadoc-support

The project was compiling and starting but there were still one exception: 
`jakarta.validation.NoProviderFoundException: Unable to create a Configuration, because no Jakarta Bean Validation provider could be found. Add a provider like Hibernate Validator (RI) to your classpath.`

So to solve this, I had to add a jakarta validation api:

`<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-validation</artifactId>
</dependency>`

PS: solution found at: https://stackoverflow.com/questions/75418394/spring-boot-3-after-add-openapi-dependency-noproviderfoundexception
Selecting duplicate records
Tags: rails, postgres, sql
Published: 2023-02-27 17:55:25

Selecting duplicate records might be useful in cases when you want to introduce new [multi column index](https://www.postgresql.org/docs/current/indexes-multicolumn.html) on existing data.

---

```rb
duplicates = ActiveRecord::Base.connection.execute('
  SELECT items.id, items.name
    FROM items
    WHERE items.id IN (
      SELECT
        id
        FROM (
          SELECT
          id,
          ROW_NUMBER() OVER w AS rnum
          FROM items
          WINDOW w AS (
            PARTITION BY entity_id, barcode
            ORDER BY id
            )
          ) t
          WHERE t.rnum > 1
       );
    ')
```

Our exported data set will have `id` and `name`, so that we can tell which rows we want to delete. And it will only show rows where `entity_id` and `barcode` would **not** be unique. That's an example, yours will be different.

After the cleanup, when the query above would return an empty result set we should be able to create following index without any issues:

```rb
add_index(:items, [:entity_id, :barcode])
```

Inspiration taken from the article [Rails: migration: Adding a unique Index and deleting Duplicates](https://dev.to/nodefiend/rails-migration-adding-a-unique-index-and-deleting-duplicates-5cde)

---

Image generated via Midjourney prompt: `Heap of items where every object is represented twice; --ar 16:9 `
Django All Configuration in single Command
Tags: django, python, mefiz, opensource
Published: 2023-02-27 17:50:25

**quick-django**
**Create django project quickly single command**
1) djnago app
2) urls.py
3) templates folder
4) static folder
5) and add the default code in view.py
6) models.py
7) admin.py
8) index.html

**Install**
`pip install quick-django`
**Open cmd and type**
`python -m quick-django myproject myproject_app `

Github
{% embed https://github.com/MominIqbal-1234/quick-django %}
I am an AWS Community Builder!💪🏾🥳
Tags: aws, community, cloud, machinelearning
Published: 2023-02-27 17:46:15


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/3i4r1vflqorg182jqtzh.png)
I’m beside myself with joy to have been recognized and accepted into the AWS community builders program(ML) as an active builder of the community. The efforts made to learn and understand disruptive tech like Cloud, AI & ML, and Programming is undoubtedly exciting! However, a more significant impact of this knowledge is to make and effect meaningful contributions to the community. A very effective way to do this is by sharing knowledge with the community, that is, for both builders, end users and all stakeholders. The AWS community builders program was designed for this exact purpose and I am delighted to contribute in this cause that gives back to a community that is continually providing excellent resources to deepen our understanding & use of AWS! I’m grateful for the opportunity AWS & I look forward to create more awareness in the community about the innovation and monumental strides that can be achieved with cloud services that are powered by AWS.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/6e774zkj3kanoq80ady9.png)
How to implement Declaretive List Animation in Blazor
Published: 2023-02-27 17:32:53

Blazor requires a little ingenuity to animate list deletions and additions.
The same is true for React, but it can be achieved relatively easily and declaratively by using the react-transition-group library.

react-transition-group
https://github.com/reactjs/react-transition-group

Animations are very important for a better UI/UX.
However, it is also troublesome to have long code for animations, and to have no separation between View and Model.
Currently, there are no libraries that provide the same functionality as react-transition-group.
Therefore, I decided to create our own Blazor library to provide the same features as react-transition-group.

## What I made

I have created a library to realize list animations in Blazor.
It makes it easy to implement animations such as the following.

Exposes a simple component that helps define the start and end of transitions.
It does not animate the styles by itself.
Instead, it exposes transition stages, manages classes and group elements, and manipulates the DOM in a convenient way to make the actual implementation of visual transitions easier.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/82ir8elzc5rt26to2kyo.gif)

See the Github Repository below for more information
(And star me ⭐⭐⭐)

https://github.com/le-nn/blazor-transition-group
AWS Interface Endpoint vs Gateway Endpoint
Published: 2023-02-27 17:30:17

The connections between your apps and AWS services may need to remain within the AWS network due to security or regulatory reasons, ensuring that no malicious party can tamper with your important data. In this situation, VPC Endpoint can be used. However, there are two different VPC Endpoint kinds from which to select. How do you make the best decision? Does that need you to read through the extensive Amazon documentation of those services?

Fortunately, the decision is easy to make:

1) If the AWS service is either DynamoDB or S3, use Gateway Endpoint.

2) Use the Interface Endpoint for all other purposes.

As most AWS services may be connected privately through this type of endpoint, let's start with Interface VPC Endpoint.

In the diagram below, I have used the private network to link the EC2 instance to the SQS. I created an endpoint network interface in the same subnet as the EC2 instance and attach a security group with the appropriate access permissions to this endpoint networking interface to establish an interface endpoint. The service provider must approve the interface endpoint after it is created. In general, all endpoint requests will be immediately accepted by AWS services and this happens automatically.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/mfutwotnulpa2k8r38ol.png)

Gateway endpoint is a little bit different. In the figure below, the gateway endpoint is created at the VPC level. I need to attach an endpoint policy  to the gateway endpoint that allow access to the S3 service and also specify a route in the route table in subnet 10.18.0.0 so the EC2 instance can find a path to the S3 bucket.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/iolun0zlrcsjj5ytz3b1.png)

In both scenarios, the communications between the service consumer and the service provider never get out of the AWS network hence your data remains secured.
Olymp Trade lanza su Festival de Fútbol
Tags: trade, blockchain
Published: 2023-02-27 17:24:36

Olymp Trade -una plataforma de comercio internacional en línea- ha lanzado un nuevo evento de varios niveles para ponerse al mismo nivel que millones de aficionados al fútbol y al comercio en todo el mundo. El evento, llamado Olymp Trade Football Festival, celebra la mayor copa de fútbol del mundo y ofrece a todos la oportunidad de acercarse a alcanzar sus objetivos financieros
El Festival de Fútbol se celebrará en la plataforma del 14 de noviembre al 20 de diciembre. Durante este tiempo, los usuarios de Olymp Trade podrán participar en la Copa de Comercio de Ronaldinho, el Chalice of Glory y otras actividades con regalos y premios.

Chalice of Glory
La campaña Chalice of Glory es un regalo exclusivo para los Olymp Traders ubicados en Latinoamérica.

Entre el 25 y el 27 de noviembre, podrán disfrutar de bebidas gratis en varios bares participantes de Ciudad de México, Guadalajara, Bogotá, Medellín o Buenos Aires.

Lo único que hay que hacer es realizar una operación rentable en la plataforma, hacer una captura de pantalla y compartirla en Facebook, Twitter o Instagram etiquetando la cuenta de Olymp Trade. Un Bar Bot especial en Telegram ayudará a los usuarios a encontrar un bar participante en su ciudad y reclamar una bebida de Olymp Trade.

Encontrar la información detallada sobre esta campaña aquí.

Estar preparado
Las actividades mencionadas anteriormente son sólo algunas de las que forman parte del Festival de Fútbol de Olymp Trade. Hay mucho más por venir, incluyendo concursos y sorteos en las redes sociales, mercancía de edición limitada, Salas de Batalla, Tarjetas de Liga, productos con temática de fútbol en la plataforma y otras innovaciones.

Olymp Trade, una plataforma con unos 88 millones de usuarios, está disponible en 14 idiomas, incluidos el español y el portugués. Su diversa comunidad está unida por la idea de la libertad financiera que se hace posible a través del comercio.

https://www.enlineanoticias.mx
https://www.tiemponoticias.mx
https://www.realidadmexico.mx
CHIMBA Blockchain lanza página web
Tags: blockchain
Published: 2023-02-27 17:19:21

Es un token para la plataforma, CHIMBA Blockchain también cuenta con una criptomoneda o token nativo de nombre CHIMBA (CMBA). Dicho token tiene el papel fundamental de crear un ecosistema económico que incentive el trabajo que sostiene toda la red. En primer lugar, la red CHIMBA depende del trabajo de los validadores, quienes tienen la responsabilidad de usar el protocolo Tendermint para realizar el proceso de generación y validación de bloques dentro de la red. Este límite es un límite inicial que puede ser alterado por la gobernanza del protocolo en cualquier momento.

El trabajo de los validadores en todo caso debe ser recompensando, y como en la mayoría de las blockchain, esa recompensa se da en tokens nativos, en este caso CHIMBA tokens. Pero esa selección de validadores respeta las reglas de todo protocolo de consenso PoS, así que para ser elegido se debe tener un staking importante para poder participar. Esto significa que los validadores deben almacenar y bloquear saldos en CHIMBA para obtener dicha participación.

Junto a ello, el token CHIMBA sirve como un mecanismo para prevenir el mal uso de la red, es decir, desincentivar el spam, así como para acceder a los servicios de la red y como sistema de gobernanza dentro de la red, ya que los usuarios que posean tokens CHIMBA pueden emitir votos en proporción a sus staking en CHIMBA.

Por otro lado, la emisión de tokens CHIMBAS es ilimitada, y la generación de los mismos por los validadores, es decidida de forma dinámica por la red de acuerdo a las directrices de la gobernanza del protocolo. En estos momentos, las recompensas por bloques se calculan entre el 7% y el 30% del rendimiento anual del suministro total de CHIMBA. Además, se suman las tarifas de transacción, que suman la totalidad de las recompensas para los validadores. La generación de bloques en la red sucede casa 5-6 segundos, siendo una de las redes blockchain más rápidas en este ecosistema.

https://www.enlineanoticias.mx
https://www.tiemponoticias.mx
https://www.realidadmexico.mx