Tech Insights

<p>How to install and configure PostgreSQL on Ubuntu </p>

<p>Reasons to consider smaller desktop viewports on your responsive designs </p>

<p>Microlink API enables you to get structured data from any website, and its SDK enables you to create previews from any link (and has integration with React) </p>

<p>Amazing Kubernetes set of tutorials by DigitalOcean: </p>

<p>When you commit with Commitizen, you'll be prompted to fill out any required commit fields at commit time. </p>

<p>a great overview on usability research: </p>

<p>Vaurien, the Chaos TCP Proxy </p>

<p>Updated git flow guide </p>

<p>how to design better for left-handed users </p>

<p>Cheat Sheets: UI Terms used by Product Designers </p>

<p>how long people stay at giant tech companies, how diverse is their workforce and other interesting data: </p>

<p>Migrate tables from one PostgreSQL database to another using the INFORMATION_SCHEMA </p>

<p>"DataError: integer out of range" in psycopg may be caused when you have a table with an integer auto-incrementing id and you insert more than 2^31-1 records. Note that if you TRUNCATE the table, the id sequence DOES NOT reset. Use <code>ALTER SEQUENCE sequence-name RESTART WITH 1;</code> for that. Find out the sequence name with <code>\d+ table_name</code>.</p>

<p>Chrome plans to give slow websites a new badge of shame </p>

<p>A curl-like tool for GraphQL with autocomplete, subscriptions and GraphiQL </p>

<p>How to design better error pages </p>

<p>"An Even Over Statement should feel like it costs you something. Because of opportunity costs, every choice you make is a sacrifice." Even-over statements as a way to simplify and clarify strategy: </p>

<p>Best way to select random rows PostgreSQL: </p>

<p>Moderated vs Unmoderated usability test: which is better? </p>

<p>When should engineering managers write code? </p>

<p>A huge repository for free Sketch mockups, icons, plugins, UI kits </p>

<p>Flexbox techniques - Breaking to a new row with flexbox </p>

<p>Nubank's hiring designers process </p>

<p>derivation of the rice framework that incorporates a more complete notion of value and that leaves risk explicit </p>