Home / Questions

Questions[aplicación-web]

Martin Hope
Paul
Asked: 2022-02-06 15:45:46 +0800 CST
  • 0

For example, I can start an application on port localhost:8080 and if I go to the browser I can see my application. I understand that it is like a communication endpoint but no more.

Can someone explain to me in a simple way how a port works?

For example, what happens when I open Chrome, is it using ports?

aplicación-web
Martin Hope
Juan Rafael
Asked: 2020-09-03 21:57:21 +0800 CST
  • 1

I have a script that reads the information from a spreadsheet, and displays it in HTML. I try to adapt a button to it that activates the updating of the information when changes are made in the spreadsheet. I only manage to execute the part of window.location.reload(true);. But the data is not updated.

These are the codes:

function doGet() {
  return HtmlService
      .createTemplateFromFile('Index')
      .evaluate()
      .setSandboxMode(HtmlService.SandboxMode.IFRAME);
}

function getData() {
  return SpreadsheetApp
      .openById('IDdelaspreadsheet')
      .getActiveSheet()
      .getDataRange()
      .getValues();
}

function onSubmit(e){

  doGet();
  getData();
}

<!DOCTYPE html>
<html>
  <head>
    <base target="_top">

  </head>
  <body>
    <? var data = getData(); ?>
    <table>
      <? for (var i = 0; i < data.length; i++) { ?>
        <tr>
          <? for (var j = 0; j < data[i].length; j++) { ?>
            <td><?= data[i][j] ?></td>
          <? } ?>
        </tr>
      <? } ?>
    </table>

    // no es del código original. Aquí trato de incluir el botón
     <form>
    <input onclick="MostrarResultados()" type="button" value="Mostrar" />
    </form>
    <script type="text/javascript">
    function MostrarResultados() {
    google.script.run.onSubmit();
    window.location.reload(true);
    }
    </script>
    // hasta aquí la parte que inserto, no es del código original
 </body>
</html>
aplicación-web
Martin Hope
Juan Pablo B
Asked: 2020-10-24 05:55:12 +0800 CST
  • 1

I have a web page made with laravel and mysql, and it has enough access to the database, and I would like to know how to measure how many simultaneous users making queries my page can hold.

I have a basic server in digital ocean with the following characteristics:

512MB (1 CPU) 20GB (SSD DISK) 1000GB (Transfer)

and it has many different servers and the highest one has the characteristics:

224GB (1 CPU) 500GB (SSD DISK) 10TB (Transfer)

Really a lot of difference, but beyond that, I don't know when to use one and when to scale to another, which would be scaling vertically. At the same time, I don't know when to scale horizontally, that is, to make replicas of the system, or to have a server that is only for the database.

I would really like to know these questions, before having future problems, even if there are few users.

aplicación-web
Martin Hope
Juan Pinzón
Asked: 2020-08-10 05:57:13 +0800 CST
  • 16

Reviewing the configuration CodeIgniterI came across the following line:

$config['permitted_uri_chars'] = 'a-z 0-9~%.:_\-';

And the documentation for it says:

/*
|--------------------------------------------------------------------------
| Allowed URL Characters
|--------------------------------------------------------------------------
|
| This lets you specify which characters are permitted within your URLs.
| When someone tries to submit a URL with disallowed characters they will
| get a warning message.
|
| As a security measure you are STRONGLY encouraged to restrict URLs to
| as few characters as possible.  By default only these are allowed: a-z 0-9~%.:_-
|
| Leave blank to allow all characters -- but only if you are insane.
|
| The configured value is actually a regular expression character group
| and it will be executed as: ! preg_match('/^[<permitted_uri_chars>]+$/i
|
| DO NOT CHANGE THIS UNLESS YOU FULLY UNDERSTAND THE REPERCUSSIONS!!
|
*/

/*
|--------------------------------------------------------------------------
| Caracteres URL permitidos
|----------------------------------------------------------------------
|
|Esto permite especificar qué caracteres están permitidas dentro de sus URL. 
|Cuando alguien trata de enviar una URL con caracteres no permitidos se les 
|dará un mensaje de advertencia.
|
|Como medida de seguridad, se recomienda enfáticamente restringir las direcciones 
|URL a la menor cantidad de caracteres posible. 
|Por defecto sólo se permiten éstos: a-z ~ 0-9%:. _-
|
|Dejar en blanco para permitir todos los caracteres -- pero sólo si estás loco.
|
|El valor configurado es actualmente una expresión regular de agrupamiento 
|de caracteres y sera ejecutada como: ! preg_match('/^[<permitted_uri_chars>]+$/i
|
|NO CAMBIES ESTO HASTA QUE COMPRENDAS COMPLETAMENTE LAS REPERCUSIONES!!
|
*/

However, it is not entirely clear to me what repercussions or security problems may arise from allowing all characters in a url.

Regardless of the language used, what problems can this situation generate?

aplicación-web