Tag: tips

All the articles with the tag "tips".

• How to update a column's type (in PostgreSQL)

  Published:Jan 4, 2020 |  at 04:01 PM

  So, you have a table and you need to modify a column's type. The problem arise when the column is filled and the type change is incompatible, for example, from string to integer, so **how we can update the type and recompute the filled values to the new type?**

• Working with query params in JavaScript with URLSearchParams

  Published:Nov 9, 2019 |  at 09:24 AM

  No matter if you work with JavaScript at client or server side, at some point you'll need to work with urls and its query params. As example, I'm currently using [react-router](https://reacttraining.com/react-router/web) in my project, which is an great tool. I can define dynamic routes with path params and easily react-router returns me these params within the `match` variable and the rest of url information in the `location` variable, but how can I easily access to query params?