Laravel News·2yVisual EXPLAIN for MySQL and Laravel
The MySQL Visual Explain tool by Tobias Petry simplifies the analysis of slow queries by providing a visual representation of MySQL's EXPLAIN output. An API and a Laravel package are available, adding methods to the query builder and offering various options to visualize and debug queries easily.
Community Picks·2yLaravel whereJsonContains and WhereJsonOverlaps eloquent methods.
Laravel offers the whereJsonContains method for querying JSON data, allowing searches within JSON-stored data. However, it only matches the first value. To overcome this, Benjamin Ayles created whereJsonOverlaps and whereJsonDoesntOverlap methods for comparing two JSON documents, checking for any common key-value pairs or array elements. Currently, these methods are available only for MySQL.
Awesome Go·2yRuntime Log Level Change using Golang & GoFr
Learn how to dynamically change the log level of your Golang application without restarting it using the GoFr framework. The process involves setting up a remote log level service endpoint that GoFr fetches periodically. This post also covers configurations, setting up a MySQL database, docker commands for MySQL, and the implementation of the log-level service in Golang, complete with code examples.
Lobsters·2yGotchas with SQLite in Production
SQLite is gaining attention as an excellent database for production web applications, especially for those seeking simplicity. Despite its suitability for many applications, it has several 'gotchas' that can pose challenges, including configuration, lack of network connections, issues with network and ephemeral file systems, concurrency limitations, transactional overhead, backup complexities, and migration limitations. While SQLite offers lower operational complexity, applications requiring multiple machines or heavy write workloads may find MySQL or Postgres more suitable.
Hacker News·2yFiring Myself
At 22, the author was a junior engineer at a social gaming startup. Tasked with implementing a significant feature in the company's RPG, they accidentally deleted the USERS table containing critical data for tens of thousands of paying customers. The company had no recent backups, leading to a major crisis and emergency data recovery efforts. The author faced significant emotional and professional fallout, ultimately resigning and moving to New York City.