| github | https://github.com/docteurklein/ |
Views are PostgreSQL's cleanest abstraction and its most rigid one. How rewrite rules, attribute numbers, and the dependency catalog conspire to make every column change a teardown, and what is missing in core that would fix it.
fun fact: you can map a value to a color in #postgres using [width_bucket](https://www.postgresql.org/docs/current/functions-math.html#id-1.5.8.9.6.2.2.33.1.1.1).
I used this to colorize the output of #postgis pgr_dijkstra. A road goes from green to blue the more costly it becomes.
After five months of (on and off) development, I'm glad to announce niri v26.04! It comes packed with features:
- window blur, of course, in all its variations
- mouse cursor in window screencasts
- screencast IPC
- optional includes
- IME users can finally rename files in nautilus
- Eee PC users can finally take screenshots
Enjoy the release notes: https://github.com/niri-wm/niri/releases/tag/v26.04
As I get proficient with #RustLang, I'm becoming of the opinion that #Haskell is good as a prerequisite for Rust.
Like you can get all fancy with Haskell's type system, but the core language is pretty uncomplicated. It just requires you to think in terms of concepts unfamiliar to more mainstream languages... concepts which happen to be very useful in Rust
having fun visualizing driving distances using #pgrouting #postgres #postgis #opendata
```sql
SELECT d.*, v.geom
FROM pgr_drivingDistance(
$$SELECT * FROM highway_edges$$,
989100571,
100000
) d,
vertices v
WHERE d.node=v.id
order by agg_cost;
```
Planet PostgreSQL
Jake Hamilton
Daniel Bohrer
Ivan Molodetskikh
Grégoire Locqueville
Autonomie und Solidarität
BeyondMachines 
