TLDR WEB DEV 2024-04-19

→ Download the DevOps Kit here

WHY SQLITE PERFORMANCE TUNING MADE BENCHER 1200X FASTER

A developer found that a webpage that was used for performance tracking was really slow. They discovered that inefficient SQL queries were causing long delays. By understanding the SQLite query planner, the developer added indexes and a materialized view to improve the database query performance and thereby speed up the page load time.

THE ART OF SVG FILTERS AND WHY IT IS AWESOME

SVG filters are a way to apply image-like effects (blur, color shifts, distortion, etc.) to web vector graphics and even HTML elements. They can be used to add effects to text on the web, including borders, bevels, textures, and more. This article shows how through code examples.

WHAT WAS THE MOST GENIUS HACK YOU DID IN WEBDEV? (REDDIT THREAD)

Developers share their web dev “hacks” and stories. One developer improved a slow SQL scheduling algorithm by refactoring the code and converting sub-selects to joins. Others found creative ways to work around limitations in older web tech, like using system commands for a school prank or inventing a precursor to AJAX for a chat application.

WHY YOU NEED A "WTF NOTEBOOK"

A “WTF Notebook” is used to write down observed issues you may encounter while working. After a few weeks, you'll have a list of problems that will resonate with teammates and now you can present solutions to the team for those problems. This lets you take ownership and initiative within the team, allowing you to make changes and show impact effectively.

MOST MICROMANAGERS ARE BLIND TO BEING SEEN AS ONE

LLAMA 3

Meta has released Llama 3, an open-source LLM. It performs better on many benchmarks - its various-sized models have similar or better performance compared to Google's, Anthropic's, and Mistral's models.

RIPL

Ripl is a library that simplifies 2D graphics rendering in web browsers by providing a unified API for both canvas and SVG elements. It focuses on high performance and interactive data visualization.

I ACCIDENTALLY BUILT A MEME SEARCH ENGINE

This developer built a meme search engine as a way to learn about vector embeddings and image encoding. They used OpenAI's CLIP model to encode images into vector embeddings, which are a way to represent images or text as numerical vectors, for similarity searches. These embeddings were stored in a vector database, which then made memes searchable with just natural language.

VULNERABILITIES FOR AI AND ML APPLICATIONS ARE SKYROCKETING

The number of vulnerabilities in AI and ML applications is increasing rapidly. In April 2024 so far, 48 vulnerabilities were discovered in popular open-source projects, which is a 220% increase since November 2023.

GOOGLE IS COMBINING ITS ANDROID AND HARDWARE TEAMS — AND IT'S ALL ABOUT AI

Google is reorganizing its teams to focus on integrating AI into its products. Its newly formed Platforms and Devices team will oversee Pixel products, Android, Chrome, ChromeOS, Photos, and more, while integrating AI natively into all of them.

SOFTWARE DEVELOPMENT JOB POSTINGS ON INDEED IN THE UNITED STATES

The number of software development job postings peaked in early-to-mid 2022 and has dropped since then.

SUPABASE STORAGE: NOW SUPPORTS THE S3 PROTOCOL

Supabase Storage now supports the S3 protocol with a new API and newly supported multipart uploads with the S3 protocol.

CFPB TAKES ACTION AGAINST CODING BOOT CAMP BLOOMTECH AND CEO AUSTEN ALLRED FOR DECEIVING STUDENTS AND HIDING LOAN COSTS

The CFPB issued an order against BloomTech and its CEO, Austen Allred, for misleading students about the costs and risks of "income share" loans and falsely advertising job placement rates.

THE MICROSOFT-DILEMMA - EUROPE AS A SOFTWARE COLONY (44 MINUTE VIDEO)

A documentary on how governments across Europe are reliant on Microsoft software, which can be seen as a conflict of interest.