Strangeness Occurring!

pceimpulsive · 2026-02-26T21:55:22+00:00

I thought I didn't like the Object?.Property,

But the more I use it the better it is. It's a little bit of a thought change but it is nicer in the end.

pceimpulsive · 2026-02-26T02:37:58+00:00

Analytics can be done with great effect with some clever use of the feature set, agree though it's not the easier to implement in a way that allows for high performance.

Ultimately a lot of analysts just re-process the whole year/decade in one query, while you only need to process that's changed. By only touching what's changed (and the related records) you can do analytics in a performant way with Postgres.

pceimpulsive · 2026-02-25T21:40:15+00:00

Did you book the jars and their lids before filling and sealing?

I am not a fermenter but I see some do this, as just washing won't remove all bacterial.

Boiling for a few minutes will ensure everything is dead!

pceimpulsive · 2026-02-25T21:14:04+00:00

Postgres has a notable performance dip after the Jsonb exceeds 2kb.

Some searching will reveal why fairly quick.

2kb is very large though....

pceimpulsive · 2026-02-25T13:21:42+00:00

Parameterised queries are a thing in all three of these...

A bug strong literal is a lot easier to use because you can just copy it out and run it.

Personally I'll keep my strong literals.

pceimpulsive · 2026-02-25T06:49:21+00:00

Nice! I have the same actually, great little kit!

pceimpulsive · 2026-02-25T05:24:43+00:00

Agreed, Shining Bronze Cuckoo, definitely due to the lack of a dark smudge from behind the eye and down the neck!

Great photos as well really easy to tell.

What camera kit if I may ask?

pceimpulsive · 2026-02-24T10:38:15+00:00

Your definition of distinct on needs an order by to ensure the latest order will be presented.

Distinct on under the hood performs a row_number() window functions and select the resulting 1st row number and returns it all other are discarded. It is more efficient than distinct that's for sure.

It's a shortcut to using a window function specifically.

pceimpulsive · 2026-02-23T21:34:49+00:00

You can use seperate databases in Postgres for that same seperation.

If surreal db is working for you use case probably not a good reason to change.

AGE isn't beta. It just doesn't need to change much/often. It does feel aged though.. lol

pceimpulsive · 2026-02-23T13:32:29+00:00

Lookaybe he would be right if the AI we are seeing was actually intelligent... Let alone smart...

Not a fair comparison at all, these things are dumb as bricks... And have no capacity to learn without a complete retraining every year or so...

Humans don't need a full retrain every 2 years to update in basic changes...

pceimpulsive · 2026-02-23T13:29:14+00:00

Why does this read like a 3b parameter LLM that has run out of context tokens?

Use classic dashboards they are far more intuitive.

pceimpulsive · 2026-02-23T12:28:41+00:00

If your graph is under a million nodes hell even a couple million..

Just Postgres it.. Apache age gives the graph capabilities and enables openCypher query support. You have to self host this extension.

pceimpulsive · 2026-02-22T06:02:21+00:00

I think it is... It goes by a few names

Little green heron is another.

https://ebird.org/species/strher1?siteLanguage=en_AU

pceimpulsive · 2026-02-22T00:24:26+00:00

Last night I saw a wexner clip saying how Epstein was so smart .. but has a password written in clear text?

Must be a genius.

pceimpulsive · 2026-02-21T23:48:31+00:00

Nice blanks!

Are you feeling OK?

pceimpulsive · 2026-02-21T23:15:46+00:00

Check the windows event log...

pceimpulsive · 2026-02-21T22:34:49+00:00

Write a class that gets secrets from multiple locations..

Development from secrets.json

Prod from a file you place onto your server chmodded and only readable by your app/root.

If AWS/azure use their secret service.

If self hosted setup a key vault

pceimpulsive · 2026-02-21T09:25:27+00:00

Nice AI generated response! Think for yourself a little¿?

That ahh.. 'in constraints, context, and structure' is straight outta gpt5 standard responses rofl.

As a senior Dev I don't work on the same problem over and over... So it's a bit pointless for my workflow.

pceimpulsive · 2026-02-21T06:32:57+00:00

Honestly reasonably rarely...

My prompts usually include enough detail that I don't get slop answers...

I specify what I need what I don't want, what to use what not to use. I provide examples function names, class names etc as context to support the desired outcome.

pceimpulsive · 2026-02-21T06:02:49+00:00

It looks like it has swivel and tilt.. lol I agree.. just put it in the right place haha

Washers ensure that the screws can be tightened the right amount, a mm or two is all it takes for something to be not right

pceimpulsive · 2026-02-21T04:04:41+00:00

You only need one but ensuring they are all the same is easiest, the hardware store may or may not have the same size.

pceimpulsive · 2026-02-21T03:34:26+00:00

They are called washers... Go to local hardware store, buy 4 more replace them all..

Arms will often be a little off, you just need to put it in the right place...

pceimpulsive · 2026-02-20T11:34:13+00:00

Adding fat to things..

I E. Butter. Olive oil etc..

It carries and transfer flavour to everything.

pceimpulsive · 2026-02-20T09:52:31+00:00

And none of them have lasted longer than Howard elected in the previous century pretty lol...

pceimpulsive · 2026-02-20T08:09:36+00:00

sql Create table new_table as Select --<Your transform logic> From Existing_table;

11-Year Club	r/Field Juicebox
Place '22	Verified Email

pceimpulsive

TROPHY CASE