Mastodawn

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;
```

docteurklein 5d ago

Autonomie und Solidarität Mar 15

That's it!

#Antifa #Antifascism #Fascism

docteurklein Mar 10

BeyondMachines

Mar 10

The protomolecule knew what it was doing

docteurklein Mar 7

Cassandra is only carbon now Mar 7

"It writes boilerplate faster."

Is that all we aspire to now? Not abstraction or templating or better language design, just... output boilerplate faster.

It's depressing.

docteurklein Mar 5

DocAtCDI Mar 5

If the Earth were flat, cats would have pushed everything over the edge already.

docteurklein Feb 27

Douglas J Hunley Feb 26

The real cost of random I/O https://vondra.me/posts/the-real-cost-of-random-io/ #postgresql

The real cost of random I/O

How good is the random_page_cost default, and should you lower it on modern flash storage?

Tomas Vondra

docteurklein Feb 25

codeinabox Feb 24

Row Locks With Joins Can Produce Surprising Results in PostgreSQL

https://programming.dev/post/46277521

Row Locks With Joins Can Produce Surprising Results in PostgreSQL - programming.dev

cross-posted from: https://lemmy.bestiver.se/post/948840 [https://lemmy.bestiver.se/post/948840] > Comments [https://lobste.rs/s/klb2o8/row_locks_with_joins_can_produce]

docteurklein Jan 28

Lynnesbian

Jan 27

sometimes when i feel my code has too many confusing states, i like to stop, take a deep breath, and open the MSDN page for the MsoTrioState enum.

MsoTrioState is "a tri-state Boolean value". it has five possible values. only two of them are supported.

the only supported values are true and false.

docteurklein Jan 28

Prague PostgreSQL Dev Day Jan 28

SQL injection is just the beginning.

Kranthi Kiran Burada & Narendra Tawar uncover advanced PostgreSQL threats—from FDW abuse and side channels to logical replication misuse and RLS pitfalls. https://lnkd.in/duc7FPyD

#PostgreSQL #Security #P2D2

docteurklein Jan 27

vriska, thief of light

Jan 22

STOP IMPORTING DERIVATIONS

EVALS WERE NOT SUPPOSED TO REALIZE OUTPUTS
YEARS OF PACKAGING yet NO REAL-WORLD USE for going further than JSON
Wanted to compute anyway for a laugh? We had a tool for that: It was called "NIXLANG"
"Yes please give me readFile of something. Please give me 1697MB of it" - Statements dreamed up by the utterly Deranged

LOOK at what Users have been demanding your Respect for all this time, with all the evaluators & builders we built for them
(This is REAL IFD, done by REAL Users)

1.7G /nix/store/8k1bzda53zlzrxxl4lyljhcsq66hynvy-pve-qemu-839b53b

"Hello I would like ${builtins.readFile (pkgs.runCommand "out" {} "echo -n $((4**13)) > $out")} apples please"
They have played us for absolute fools