HackerNews Summary (2023-06-02 02AM)

Source: Arduino based engine management

Summary
Speeduino is a flexible, low-cost Engine Management System based on the Arduino platform for hobbyists and enthusiasts. With an online manual and a supportive community, it provides the hardware, firmware, and software required for an engine management system.

Fact

🚘 Speeduino is a low-cost Engine Management System based on the open-source Arduino platform for DIY enthusiasts.

📚 An online manual for Speeduino is available at https://wiki.speeduino.com for reference.

💻 The design files provided by the Speeduino project are open source and allow for creating your own hardware.

🤝 Sales from official resellers of Speeduino units contribute a portion of sales back to continued development.

🌟 The Speeduino community is supportive and ready to help with setup or questions.

---

Source: PostgreSQL and SQL:2023

Summary
PostgreSQL supports most of the features in SQL:2023, with some exceptions and variations.

Facts

👍 SQL-scoped role is supported since PostgreSQL 13.

👍 An implementation of the temporal tables feature for SQL:2011, or some subset of it, has been committed to PostgreSQL 14.

👍 PostgreSQL 14 has added the ability to use SQL-standard MERGE statements to update a table using data from another table.

👍 Table sample system is conformed to SQL:2016.

👍 The implementation of JSON features mostly conforms to SQL:2023 features T879 ff.

👍 Row-level security is more powerful than the SQL standard since it allows policies to be written using SQL expressions that reference the current row.

👎 ARRAY_DML is not planned.

👎 Polymorphic table functions, also known as TAPFs, are not planned.

👎 Materialized path navigation is not planned.

👎 Indexed expression is not planned.

👎 Unique constraint with a non-constant expression is not planned.

---

Source: Step Into a Midcentury Map of New York, Packed With Weird Local Lore

Summary
Nils Hansell’s “The Wonders of New York” map illustrated over 300 attractions in Manhattan. The map sold the idea of Manhattan through its smaller less-known sights and wackiest facts, made the most from the mid-20th century advertising boom, and noted the city’s most rakish characters and least-plausible lore.

Fact

🎨 Hansell’s illustration captured the “gleaming modernist skyscrapers and the new United Nations building, trans-Atlantic liners, and newly introduced jet passenger planes” which made Manhattan the place to be.

🗺️ Nils Hansell mapped more than 300 diversions, from Manhattan’s southern tip up to 96th Street. .

🔬 Anyone can explore Manhattan’s weirder sights and half-truths such as dragons (in Chinatown), ships inside green glass bottles, and a nearly-nude opera singer hoisting a severed head on a platter. .

💰 The spots accessible only to men with fat pockets also extended an invitation to their glittering wives.

⛸️Hansell also declared Central Park’s ice rink had the best skating in town, and a stroll across the Brooklyn Bridge would make for the best Sunday walk.

---