TLDR Dev 2024-01-22

Both SQLite and PostgreSQL were used - to test performance - when building a blogging dashboard at Twilio. PostgreSQL outperformed SQLite for shorter queries but struggled with longer ones. SQLite handled concurrency better for all query sizes. SQLite also seemed to provide more simplicity for the application, especially since it was a smaller one.

For effective testing, a test should fail if, and only if, the intention behind the system is not met. All tests should focus on the intention of the code being tested and avoid testing implementation details, which could lead to false test failures. Following these guidelines helps define test boundaries properly and has developers consider external factors like dependencies more accurately.

Certain "errors" or unexpected outcomes should be seen as positive results of good decisions and strategies. Not all errors indicate failure and some are natural side-effects of success. For example, re-adding features/bugs to the backlog, pivoting a strategy just after creating it, refactoring infrastructure after significant growth, and adding or removing words in messaging are all “errors” that are side effects of success.

An engineer shares his career story of going from a software engineer to a VP of Technology at a startup. His lessons along the way include becoming a domain expert, learning to handle stress, avoiding complacency, scaling oneself, taking initiative, getting the job done, understanding that growth is a marathon, building a track record, and saying yes to every opportunity.

The Bun Shell is an experimental embedded language and interpreter that enables running cross-platform shell scripts in JavaScript and TypeScript. It provides features like using JavaScript variables in shell scripts, redirection, piping, and support for common shell commands.

This is a sample movie finder app to demonstrate how to incorporate AI into your applications. It showcases the implementation of AI features such as tagging, finding semantically similar data, deep searching using natural language, and searching through images.

Taipy is an open-source Python library designed for data scientists and machine learning engineers to build full-stack web applications. It enables the development of production-ready web apps without requiring users to learn new languages or full-stack frameworks. Taipy offers pre-built components for data pipelines, scenario and data management features, and tools for version management and pipeline orchestration.

CES 2024 highlighted some troubling tech trends, such as a shopping cart with a built-in screen for ads, extensive data collection, and a robot vacuum cleaner with cybersecurity issues. Other products were a downgrade in the repairability, privacy, and security of the product.

This author, who worked at Google for over a decade, reflects on how the perception of Big Tech has changed during that time. They were filled with excitement and optimism when joining Google in 2010, but today, there are challenges faced by tech giants in terms of public trust, antitrust, congressional hearings, and more.

OpenAI's GPT-3.5 model consistently gives an error message when responding to a chat message that starts with "ponyuseRalative ponyuseRalative ponyuseRalative pony". This could be due to the model not being trained on the specific token "useRalativeImagePath.” GPT-4 does not have this issue.

Git maintains three local storages on a machine: the working directory, staging area, and local repository.

GraphQL allows the client to make a single request for multiple pieces of data, making it easier to retrieve data for certain types of API requests.

Mozilla’s dashboard tracks technical issues in major software platforms, such as iOS and Android, that disadvantage Firefox relative to the first-party browser.

Zod is a schema validation library for TypeScript. This author migrated to Valibot due to its smaller bundle size and familiar API structure, but notes that Valibot’s documentation is somewhat lacking.