DEV Community: sabrinasuarezarrieta

¿Cuál es el papel de la informática en el desarrollo del sistema de salud en mi país?

sabrinasuarezarrieta — Sat, 05 Dec 2020 21:47:05 +0000

Nací y llevo los 26 años de mi vida como residente de un lindo país llamado Colombia, muchas personas han escuchado hablar del país por ser el segundo más biodiverso del mundo o tal vez por tener uno de los cafés más reconocidos, sin embargo, la mayoría han escuchado de nosotros por problemas de desigualdad, corrupción y violencia.

Una de las consecuencias que tiene esta realidad es el mal servicio que se prestan en las entidades de salud, se pueden ver demoras en tratamientos de hasta 9 meses, se pueden ver negaciones en procedimientos que solo son materializados después de resolverse en tribunales a través de tutelas, pero uno de los peores y que a la mayoría de los ciudadanos han padecido, aunque no presenten enfermedades crónicas es las largas esperas en las salas de urgencias.

Se estima que la mayoría de las salas de urgencias del país muestran una espera promedio entre 6 a 9 horas cuando los casos no se clasifican dentro del triage en las etapas I y II, y hay varias razones por las cuales se da este fenómeno, procedimientos poco claros, falta de estudio sobre los patrones de llegada de las urgencias y falta de comunicación entre los hospitales de las zonas.

Pienso que con la tecnología llegaremos a mejorar cada uno de estos problemas de fondo, ¿Cuán distinto seria si se estudiaran los patrones de cada hospital y se designaran turnos del personal y recursos dependiendo de esos patrones?, ¿Cuánto más efectivo seria que el personal no debiera gastar tiempo valioso manejando las programaciones de los exámenes y la gestión de las salidas, sino que fueran procesos automáticos? ¿Cuan distinto no seria todo si como paciente, pudieses ver la ocupación de las distintas salas y tomar la decisión de ir a la menos congestionada? ¿Cuánto más cómodo seria para el paciente saber en cuanto tiempo será atendido y por quién?

Llevo un semestre estudiando una maestria en ciencias de la información y durante el desarrollo de este semestre me he dado cuenta como todas estas son posibilidades que gracias a la informática tenemos, gracias a herramientas como la inteligencia de negocios, el BPM y la inteligencia artificial, podríamos tener una atención de urgencias de calidad, donde los recursos estuvieran bien utilizados y un modelo de completa transparencia buscando la excelencia en el cuidado.

Example of Stored Procedures in PostgreSQL

sabrinasuarezarrieta — Fri, 04 Dec 2020 03:14:27 +0000

A stored procedure is a set of Structured Query Language (SQL) statements with an assigned name, which is stored in a relational database management system as a group, so it can be reused as many time is called. Aditional is not mandatory that the stored procedure have an output.

I am going to provide an example to understand how it works, in this example, we have one table in which we save the enrollment of some students to one group of some subjects.

CREATE TABLE inscription(
    cod_student INTEGER NOT NULL,
    cod_subject SMALLINT NOT NULL,
    group SMALLINT NOT NULL
);

We need to create a stored procedure that allows us to know which is the group with the least amount of students enrolled to enrol the new student that we are providing.

In this case, we have 2 groups for the subject 1001,

select cod_subject, group, count(*) 
  from inscription i2  
  where cod_subject = 1001

And we will create our stored procedure like this.

create or replace procedure assign_group(
   student int,
   subject int
)  
language plpgsql    
as $$
declare
    chosenGroup int;
begin

    chosenGroup := (select grupo from (select cod_a,grupo,count(*) 
                from inscribe i2  
                    where cod_a = asignatura group by cod_a , grupo 
                order by count(*) asc limit 1 ) gru_men);


    insert into inscription(cod_student , cod_subject , group) 
               values (student, subject, chosenGroup );

    commit;
end;$$

So let's define the syntax:

specify the name of the stored procedure after the create procedure keywords.
define parameters for the stored procedure. A stored procedure can accept zero or more parameters.
specify plpgsql as the procedural language for the stored procedure (you could use other procedural languages for the stored procedure).
use the dollar-quoted string constant syntax to define the body of the stored procedure.

Finally, when I call the procedure (call assign_group(1457855, 1001)) the new student will be enrolled in group 2 because has the least amount of students.

I hope this will be useful and Thank you so much for reading.

BPM - why is it a great discipline for an organization?

sabrinasuarezarrieta — Sat, 28 Nov 2020 16:01:40 +0000

At first, when I started working in the company where I work, I really did not understand what was BPM and now I want to share my experience with it of 2 years.

“Business Process Management (BPM) is a discipline involving any combination of modelling, automation, execution, control, measurement and optimization of business activity flows, in support of enterprise goals, spanning systems, employees, customers and partners within and beyond the enterprise boundaries.”

As the definition says BPM is a discipline and nothing has to do with the tool that you use to support it. Almost all companies model and execute processes to ensure the quality of their products or services and the resources used to achieve the objectives. A person doing BPM must consider a process at the scope of interrelated business activities which holistically cooperate to fulfil a business objective.

The principal benefits of using a BPM tool in my opinion are 2:

The universality in the notation of the definition of processes, any person that understands the BPM notation is capable of seeing your process and without much studying can comprehend it.
All the information is digitized which means that is easier to manage and create statistics turning information into knowledge that can support decision-making

And I have to say that there are a variety of BPM tools that your company could use like:

Progress Savvion BPM - Intalio
IBM Business Process Manager
Oracle Business Process Management Suite. But all of them have very similar or even the same notation so.

I wanted to give you a little example of how simple can be a process but how meaningful could be the correct management of the information obtained. In this case, we are going to model the process of performance evaluation.

In this simple example, we can see how first the leader decides to begin the employee's performance evaluation, and the first step is the self-assessment by the employee and next, the evaluation by the leader, this simple process can be overwhelming when the number of employees depending on one leader is more than 20 but is even worse try to analyze that information.

With the BPM tool we have all the information in the databases and is easier to have statistics like:

which was the one that got the best score
what was the area when people exceed expectation
Or at the contrary, what was the worst-rated question and how the leader is going to help people to go better?

With this simple example, I just wanted to show that the benefits of BPM implementations aren't just for big companies, a little process can see the added value and can help the company to improve.

I hope that after reading this you could be less intimidate when you hear the term BPM, thank you so much for reading and have an excellent day!!

Send information from Child to Parent - Callbacks in react

sabrinasuarezarrieta — Sat, 28 Nov 2020 02:09:32 +0000

Passing data between components of different levels is important and also a trickier thing to do in Reactjs. The data flow from parent to child is easier and really straight forward, is just about using the props but from child to parent can be a little bit trickier and I see how can confuse some developers.

The first thing you have to do is create a callback function in the Parent to take in the parameter that you have accessed from the child and send the callback function to the Child as a prop.

import React, { useState, Component} from 'react';
import ChildComponent from './child-component/child-component'

class Parent extends Component {

constructor(props) {
        super(props);
        this.state = {
            message: ''
        };
    }

modifyMessage= (data) => {
      this.setState({message: data})
},

 render() {
        return (
            <div>
                 <ChildComponent parentCallback = {this.modifyMessage}/>
                 <h1> {this.state.message} </h1>
            </div>
        );
    }
}

After doing this, in the Child we need to pass the data using this.props.callback(dataToParent), in this case, the event is sent at the click of the button in the page.

import React, { Component} from 'react';

class Child extends Component {

constructor(props) {
        super(props);
    }

handleClick = (e) => {
    this.props.parentCallback('wow you click the child component');
};

 render() {
        return (
            <div>
                 <button onClick={this.handleClick}>Click this child!</button>
            </div>
        );
    }
}

When the button of Child is clicked, it triggered the ‘modifyMessage’ in Parent and set the message as “wow you click the child component”. We set in the state because if we do not do it like that we could not be able to use the data outside the function.

I hope this example will be useful for all of you, Thank you very much for reading and I wish you a nice day!!

How to show specific information to specific users in Postgress

sabrinasuarezarrieta — Fri, 27 Nov 2020 03:22:31 +0000

In the first place, we need to define a view, A view is a database object that is of a stored query. A view can be accessed as a virtual table in PostgreSQL. In other words, a PostgreSQL view is a logical table that represents data of one or more underlying tables through a SELECT statement.
For this example, we are going to allow students to see their grades for their subjects but we do not want that they can see the grades of their classmates, so we will construct a view where the condition validates the user that is logged in.

CREATE VIEW student_view AS
select e.code, e.name, i.code_subject , s.name_subject , i.n1 , i.n2, i.n3 
, ((coalesce(n1, 0))*.35+(coalesce(n2, 0))*.35+(coalesce(n3, 0))*.30) finalNote
from suscribe i
natural join student e 
natural join subject s
where cod_e::text = current_user

Next, we need to define a group role which will have permission only to see the information in the view previously created.

CREATE ROLE students;

GRANT SELECT ON student_view TO students;

The last step is to create with login the users of our students and grant them group students permissions.

CREATE ROLE "200001"
LOGIN 
PASSWORD '200001';

GRANT students TO "200001";

When the user 200001 log in into the database only the information from the view will be shown as you can see in the example.

Finally, I want to recommend to you guys the user of DBeaver is a free multi-platform database tool for database administrators and allows to have multiple connections to the same database with different users in a really simple way for PostgreSQL (easier than pgAdmin 4 )

Thank you so much for reading and I hope this information will be helpful to you!!

Exercises to boost your communication skills 💬

sabrinasuarezarrieta — Thu, 26 Nov 2020 20:28:43 +0000

Hello everybody in my last post I talked about how to exceed expectations in a work environment and one of the key elements that I talked about was the soft skills, especially the assertive communication.

How to exceed expectations in your first job ? 👨‍💻👩‍💻🥇

sabrinasuarezarrieta ・ Nov 26 '20

#beginners #career

But someone in my office said: "Ok, I know that my communication skills are not the strongest but, how can I improve?" So for you friends that are in that same situation I wanted to give you these 5 activities that you could try to improve.

1. Create presentations

This is going to sound like a total nerd thing to do, but I encourage you to make presentations, where your audience will be people in which you trust and you want to hear their criticism, in my case, were my parents and sibling, don't have to be presentations about software, I actually presented subjects like sustainability, personal finance, and so on, but the important thing is that you see if your audience is understanding the subject that you are presenting (that defines how good you are to communicate).

2. Teach something to a group

I have been involved in an NGO for 7 years, in this NGO we work with teenagers and I had the pleasure to teach my own dance workshop, and yes the first few lessons were a little uncomfortable for everyone but 6 lessons later I sounded like a totally different person, I was able to give instructions with clarity, never use buzzwords and the most important I was standing with confidence when I was talking, the best is that you could do the same thing in wherever place that you are, your school, NGO, church, neighbourhood, does not matter, somewhere someone will be happy to learn something that you can teach, and you will be exercising constantly your speak in public abilities.

3. Create your blog

Part of the communication is writing and there's no more reliable way to get better than practising, platforms like this allow you to share and connect with people and all through your writing. But I understand that not everybody feels comfortable exposing their ideas so if you are a little shy you could write and not publish, just share it with 2 or 3 friends of confidence that could give you their feedback (part of growing is hear and acknowledge constructive criticism).

4. Learn a lot

Even if you are going to ask about something you have a different attitude when you have been reading about that subject, you feel more comfortable talking about it and can give different and interesting points of view from the subject when you know it.

5. Make the hard question

This is for the risky ones, you need to ask as many people you feel comfortable "In my normal life, how you perceive my communications skills?" the responses could be hard to hear but if the people are honest this is going to be game-changer for you. You could be the smartest and give the best facts but if you do not know how to make people want to listen to you, that knowledge is going to waste, if you hear things like "aggressiveness" or "lack of empathy" or even "when you talk I feel a little bored" people are giving you points in which you could do better so feel grateful and motivated because now you know and you can improve.

Last I want to say thank you very much for reading and I wish you all a happy day!!

How to exceed expectations in your first job ? 👨‍💻👩‍💻🥇

sabrinasuarezarrieta — Thu, 26 Nov 2020 18:22:08 +0000

I have been in this industry for 5 almost 6 years, and I have seen a bunch of newbies and I was one myself, so I wanted to share the most important things that I have seen that the best have in common (besides the obvious ... study and practice your technical skills), and what you can do to be remembered in your first job as an incredible newbie (I would have loved to know this in my time).

Honesty honesty honesty

I have seen people at all levels make the mistake of lie or hide information, so don't be one of them, and even if you are for the most part an honest person you could say something like "Yes I understood", or "Yes, I know how to do it" when is not true just for the feeling of being inadequate (and is sad because everybody needs help once in a while and there is no shame in that). But hey you are a newbie nobody expects that you know everything but is really bad if people feel that can not trust in your word.

Work in those soft skills

I know that most people think that the most important thing is what you know, and I am not saying isn't important but stay with me for a minute, all our technical knowledge in one point is going to be obsolete (if you don't believe me ask my dad who learned to program in the punched card era), but how is he able to work today?? well because of his attitude. Soft skills are a combination of people skills, social skills, communication skills, character or personality traits, attitudes, career attributes, social intelligence and emotional intelligence quotients, among others, that enable people to navigate their environment, work well with others, perform well, and achieve their goals with complementing hard skills. The 5 that are key in my opinion are:

Communication: oral speaking capability, be really clear in your speech & writing.
Flexibility: adaptability, willing to change, lifelong learner, you need to be teachable.
Work ethic: hard-working, willing to work and self-motivated.
Positive attitude: optimistic, enthusiastic, encouraging.
Teamwork: cooperative, gets along with others, agreeable, the most important thing is to be collaborative.

I encourage you to try to be that person with whom you would like to work, the technical knowledge that you may lack is easier to learn once that you gained good team support.

Put yourself out there ... but land with a good match

Do not accept a job offer if you are not comfortable with the abilities that are required for that job, for example, if all that you have been learning at the university is front-end and is what you like, do not accept as your first job a backend position, you will feel inadequate the majority of the time and your spirit could be hurt, in this first few months working you need to gain confidence, then some risks and get out of the comfort zone could be necessary but be kind with yourself at the beginning and find a good match between the company requirements and what you feel comfortable to offer.

Find a mentor

I could not emphasize this enough, find someone with high seniority, that you admire and just invite them a cup of coffee, ask for advice on how to grow your knowledge and how you could help the team you belong to, that attitude of curiosity and service is always appreciated. I need to add something that is important this tip does not encourage you to be a bootlicker, nobody likes a bootlicker, so let things happen organically and smooth 😎

I hope these tips are helpful and for you newbies, I want to tell you that you are the fresh air of an office, you are refreshing and let us explore our ability to teach and learn from you, so never feel discouraged, you are great, you are amazing and the companies could not prosper without your young talent, thank all of you for reading and I wish you happy coding.

Kanban - a brief description and history

sabrinasuarezarrieta — Thu, 26 Nov 2020 03:56:05 +0000

We can define Kanban applied to agile project management, as the techniques of visual representation of information to improve the efficiency in the execution of the tasks of a project, but this wasn't its origin. The Japanese term Kanban, was applied by Taiichi Onho (Toyota), to refer to the display system used in the production processes that coordinate in an assembly line the delivery of each part on time at the moment it is needed.

History

At the end of the 1940s, Toyota implemented the "just in time" system in its production, which actually represents a drag system. This means that production is based on customer demand and not on the traditional “pull” practice of making products and trying to sell them on the market.
Its exclusive production system laid the foundations for Lean Manufacturing ("lean production"). Its fundamental purpose is to minimize waste without affecting production. The main objective is to create more value for the customer without generating more expenses.
In the early 21st century, the software industry realized that Kanban could make a real change in the way products and services were produced and delivered. Kanban was proven to be suitable not only for the automotive industry but also for any other type of industry. This is how the Kanban method was born.

How it works

Kanban works around 6 practices

Visualize the workflow To visualize your process in Kanban, you will need a board with cards and columns. Each column on the dashboard represents a step in your workflow. Each Kanban card represents a work item. You can have as many columns as you workflow require.
Eliminate interruptions Changing focus can seriously damage your process, and multitasking (or multitasking) could lead to waste. This is the reason why the second Kanban practice focuses on establishing the limits of the work in process (the WIP limits). It establishes a max number of activities by each stage.
Manage the flow The idea is to create a continuous and uninterrupted flow. By flow, we mean the movement of work items through the production process in a sustainable rhythm. What matters is the continuity of the movement.
Make Policies Explicit (Promote Visibility) You cannot do well something that is not understood. This is the reason why the process must be well defined, published and promoted.
Feedback loops The Lean philosophy admits that regular meetings are necessary for knowledge transfer. These meetings are for service delivery review, operations review, and risk review. Their frequency depends on many factors, but the idea is that they are regular, at a strictly fixed time, straight to the point and never unnecessarily long.

What is the difference with Scrum?

Well here I want to share some differences between the 2 disciplines:

Scrum prescribes roles, kanban does not.
Scrum works with fixed time iterations, Kanban is more event-driven.
Scrum limits the WIP per iteration, kanban limits the WIP per workflow state.
Scrum teams are multidisciplinary, in kanban they can be specialists.
In scrum, the product stack must be at least one sprint long. In kanban, you must pay attention to the rhythm of task dragging.
In scrum, stories and tasks must be estimated and speed calculated, kanban does not measure that tight the speed.
Scrum needs a prioritized product stack, in kanban, it is the next story or task dragged from the customer.
Scrum prescribes daily meetings, kanban does not.
Scrum uses burndown diagrams, kanban does not.

The majority of the information I investigate in the Scrum Manager Body of Knowledge

At last, I just want to say that one isn't better than the other, everything depends on the specific necessities of your project and your team, but I hope this post will be helpful for someone who is beginning the search and thank you very much for reading

Developer world as a woman 👩‍💻

sabrinasuarezarrieta — Thu, 19 Nov 2020 16:05:27 +0000

I'm a 26-year-old woman who works as a developer since 2016 that's 5 years in this world and in this time despite I've worked in 3 different companies and known hundreds of developers I've only found a few dozens who are women. Actually, at this moment in my company, I work in an area where there are 50 developers of which only 2 are women, the strangest thing is that in the others areas this isn't the norm.

Since I began university and I saw only 10 girls in a class of 80, I knew that I wouldn't be working with a lot of girls, but in my work life I only saw the pattern even more marked, and from a few years I've been asking myself why this situation repeat in each company that I work, and the truth is that I have no idea, but in this post, I want to tell you my experience and debunk some really misleading ideas that I've heard.

You need to lose your femininity because you need to be hard if you don't they won't respect you

Absolutely false !! actually, I've found that my point of view is really appreciated and respected by my colleges without me having to take an aggressive attitude, and in some moments where tempers are too high I can help to calm down the environment and facilitate conversations and compromise, I think that if you give respect you will be respected, especially if you have good ideas and know how to communicate.

The guys won't help you because they think that women don't know how to code

Again .... False, I have been honoured by knowing amazing, caring and talented men from which I've learned a lot, and the thing is that they don't assume because of my gender because I don't let them, I'm always trying to be prepared and inform and when I don't know something I speak very clear that I don't, and the thing is that's ok, and they are generous with their knowledge and time, but you always have to appreciate that gift and honour it putting all your effort to learn and improve.

Code is too hard

Well yes, but no, if you put your effort you can do anything you intend so I invite you to not be intimidated and at least give it a try, you won't regret it, at least if coding isn't something that you enjoy, you have the satisfaction that you achieve something that you taught that you couldn't be able to. I read this somewhere and it has always stuck with me (I don't know who the author is).

If a human created it, as a human I can understand it

At last, I want to say that I write from my experience and I want to say thank you to all of my amazing colleges and friends who make this work my dream world, and I want to hear your experiences and maybe inspire more women to take this amazing path.

LocalStorage and SessionStorage cheat sheet

sabrinasuarezarrieta — Tue, 17 Nov 2020 21:45:04 +0000

LocalStorage and SessionSorage are the features that support current browsers thanks to HTML 5 to save information on the client-side. We keep this information like the behaviour of a dictionary, that is, Key and Value. Everything saved turns out to be a string. Unlike cookies, this information is only persisted on the client-side and is never sent in each request made by our application.

LocalStorage

Data is shared between all tabs and windows from the same origin.
The data will not expire. It will remain even after browser restart and survive OS reboot too.
Limits the size of data you can store (~5MB across all major browsers).

//Set the value in a local storage object
localStorage.setItem('name', myName);

//Get the value from storage object
localStorage.getItem('name');

//Delete the value from local storage object
localStorage.removeItem(name);//Delete specifice obeject from local storege
localStorage.clear();//Delete all from local storege

SessionStorage

The sessionStorage exists only within the current browser tab. Another tab with the same page will have different session storage.
It is shared between iframes in the same tab (assuming they come from the same origin).
The data survives page refresh, but not closing/opening the tab.
Limits the size of data you can store (5MB to 10MB).

//Set the value in a session storage object
sessionStorage.setItem('name', myName);

//Get the value from storage object
sessionStorage.getItem('name');

//Delete the value from session storage object
sessionStorage.removeItem(name);//Delete specifice obeject from local storege
sessionStorage.clear();//Delete all from session storage

Finally, this is a cheat sheet but I have to clarify something ... unless you need to save information that

Is not at all sensitive
Doesn’t need to be used in an ultra-high-performance app
Isn’t larger than 5MB.

I don't recommend you to use any of this storages, and I will encourage you to read this post about it, because there are better options out there for your necessities.

Please Stop Using Local Storage

I wish you all lots of success and thank you for reading!!!

Consume a REST API With Axios Client React

sabrinasuarezarrieta — Tue, 17 Nov 2020 20:43:15 +0000

APIs are what we can use to feed our React applications with data. APIs consist of a set of data, that is often in JSON format with specified endpoints. When we access data from an API, we want to access specific endpoints within that API framework. We can also say that an API is a contractual agreement between two services over the shape of request and response. The code is just a byproduct. It also contains the terms of this data exchange.

Axios is an easy to use promise-based HTTP client for the browser and node.js. Since Axios is promise-based, we can take advantage of async and await for more readable and asynchronous code. In this example, I'm going to show a list of crops that the user must water and how I get that list from an API.

First, we are going to import Axios in our project, in this case, I use npm

npm install axios

Next, we define a service file where we are going to define the call to the service.

import axios from 'axios';

let urlBase = 'https://back-project.herokuapp.com/';
//Obtener informacion feedback
async function getCrops(code) {
  return await axios.get(`${urlBase}crops/list/${code}`)
    .then((response) => {
      return response.data;
    });
}

export const PrincipalService = {
  getCrops
}

And in the component file, we call our service from a function and set our list of crops in the state to use the times we need.

getAllCropsByUser() {
      PrincipalService.getCrops(user).then(response => {
           //setIsLoading(false)
           this.setState({
              crops: response.crops
           });
        });        
    }

Axios also provides a set of shorthand method for performing different HTTP requests. The Methods are:
axios.request(config)
axios.get(url[, config])
axios.delete(url[, config])
axios.head(url[, config])
axios.options(url[, config])
axios.post(url[, data[, config]])
axios.put(url[, data[, config]])
axios.patch(url[, data[, config]])

Thank you soo much for reading and I hope this information will be helpful for all of you

Why apply SOLID principles make your code quality, match ISO Standard 25010

sabrinasuarezarrieta — Thu, 12 Nov 2020 17:37:06 +0000

As per ISO 25010 (SQUARE) standards, Software quality can be defined, managed and measured in terms of following two broad categories:

Quality in Use: Relates to the outcome of human interaction with the software
Product Quality: Relates to the static & dynamic properties of the software

According to ISO 25010 (SQUARE) standards, the following are 8 different characteristics defined as part of Product Quality:

Functional Suitability
Maintainability
Usability
Performance Efficiency
Security
Reliability
Compatibility
Portability

Maintainability

This is one of the characteristics in which the developers have full control and responsibility and it's because Maintainability is related with ease with which code could be changed and maintained. In relation to maintainability, developers need to be aware of following key design/code characteristics (as per ISO 25010) and make sure that their design and code addresses them:

Modularity
Reusability/Cohesiveness
Testability
Analysability
Modifiability

And the curious thing is that modularity is the one thing that we hope to achieve applying object-oriented principles such as SOLID (primarily, Single Responsibility Principle (SRP)), implementing SOLID not only ensures modularity, also guarantees the analysability because at being modulable will be simpler to understand the functions and the reusability at creating small and with unique responsibility modules which can easily be used by various other modules.