SQLite is a feature-rich, powerful, yet light and fast database tool that is available for free under the GPL license. The latest version, 3.4.6, has been released as a hotfix to address the urgent problem of a “black SQL code line” from the previous version. This tool is cross-platform, running on Windows, Linux, and MacOS […]
Read more »
The team at UCL created the world’s thinnest spaghetti, 200 times thinner than a human hair, using a technique called electrospinning to make nanofibers out of white flour. These nanofibers have potential uses in medicine and industry, such as wound dressings and tissue scaffolding, due to their porosity and ability to support cell growth. While […]
Summary: The WITH Clause in SQL allows for Common Table Expressions (CTEs) which act as temporary views within a single SQL statement. There are two types of CTEs: ordinary and recursive. Ordinary CTEs simplify queries, while recursive CTEs enable hierarchical and recursive queries not possible in standard SQL. A recursive CTE must follow specific syntax […]
Remotely operated camera traps and drones used in wildlife monitoring are being misused to intimidate women in northern India, where forest rangers fly drones over them without consent while they gather natural resources. This study by Cambridge researchers highlights the unintended negative impact of surveillance technologies on the mental health and safety of local women. […]
The author of this content explores how various applications behave under poor internet conditions, including F-Droid, Steam, Telegram, Discord, and Git. They provide instructions on how to simulate slow internet speeds on Linux and Android devices for testing purposes. Surprisingly, some apps handle slow internet better than others, with F-Droid impressively resuming interrupted downloads and […]
Bluesky, a decentralized protocol, allows users to host websites using the AT Protocol. While not the intended use, the functionality exists due to Bluesky’s infrastructure. Content on Bluesky consists of records and blobs, with blobs being unstructured data such as media assets. The process involves uploading blobs to the PDS, referencing them in records, and […]
OCaml’s “let … = … in …” syntax is confusing and difficult to understand, especially when nested. The language lacks clear indicators of scope, leading to global and local declarations having the same syntax. Function definitions further add to the confusion. In contrast, ML, from which OCaml originates, uses “end” to demarcate expressions, providing clearer […]
This document introduces the Do-Not-Stab header, a proposed HTTP header that allows users to express their preferences about being stabbed by websites. While some users have expressed discomfort with being stabbed, this standard provides a way for users to easily opt-out of all non-mandatory stabbings. Microsoft has committed to supporting this header in the EEA, […]
English is a declarative programming language, not to be confused with various similar languages like ENGLISH or ~English. It’s based on natural language descriptions of program behavior. Examples include the classic “Hello World,” a “99 Bottles of Beer” song generator, and a self-interpreter. English is Turing complete, able to interpret specific knowledge like a Brainfuck […]
Hey there, it’s Wes. In today’s newsletter, I delve into the tricky topic of giving feedback to senior leaders. It’s not easy to navigate, but I’ve got some strategies that might help you tread carefully. Using the “even more” technique and sharing personal experiences can make a big difference in how your feedback is received. […]