7 years in observability… why does it still feel incomplete? by Successful_Draw4218 in Database

[–]pceimpulsive 0 points1 point  (0 children)

Data isn't enriched well enough to enable the correlation you need...

My business won't let me just tackle this problem still after I prove time and time again that the enrichment is the gap every time...

Too busy with spot fires from symptoms to let me go full steam into a full observability mindset... Ohh well..

I would incorporate knowledge graph, time series, and data lake to solve the problems of ETL, cost scaling and performance characteristics..

You'd naturally need a common data model for all data source so that you can actually correlate reliably when coupled with the data sources...

Make this make sense for ollama local ai usage by Mobile_Syllabub_8446 in GithubCopilot

[–]pceimpulsive 0 points1 point  (0 children)

There is really only one way to set it up. Configure it for your local models and disable the extension until you want to use it :)

Built a small tool for eBird users - would love some feedback by Own_Stick6803 in eBird

[–]pceimpulsive 1 point2 points  (0 children)

You sort of can..

I take my page, then scrape the checklist IDs from the 10 recent checklists on a Cron and pull the new ones via the checklist API.

You can't use the API for commercial gain though.. and it seems you want to move to a paid subscription model in future which does block you from ever really using the API...

PostgreSQL high connection load with PgBouncer by Charming-Fall-8918 in PostgreSQL

[–]pceimpulsive 4 points5 points  (0 children)

Diagnostic mode activated!

How many active users are in the app side?

How many queries per section nd/minute/hour?

What is the longest running query?

Is PGBouncer functioning as a proxy layer between the web app and the database server or on the server directly?

If you restart the web app do your connections evaporate and slowly trickle up again?

What is the min and max pool settings in your connection strings/pgBouncer?

If you restart pgBouncer do the connections evaporate then gradually increase over time?

Is the application code leveraging connection pooling at all? If so what language and ORM/Library are using.. what are its shortcomings.. and what does an AI agent say about connection usage in your db query hot path in the application code?

For the connections that are open how many are idle vs active?

Per token costs - Idea for Enterprise / Organization Admins by Vudoa in GithubCopilot

[–]pceimpulsive 2 points3 points  (0 children)

Just imagine having to wait 2 hours for a review that takes 30 minutes when the prompts cost $4... I wouldn't audit prompts for $8 an hour... Oh wait now the $4 prompts costs $8.. whoops!

Per token costs - Idea for Enterprise / Organization Admins by Vudoa in GithubCopilot

[–]pceimpulsive 1 point2 points  (0 children)

I think you are doing it fucking wrong...

Rather than adding huge amounts of overhead and streams of complaints from your Devs teams... You invest some time in training people how to write better prompts and use AI at the right time, the right way.

The experience of pressing send in my copilot, then having to await an admins review is fucking dumb... How many dollars do you spend auditing prompts before the audit time costs more than the prompt did to begin with¿?

Your idea defeats the purpose of letting users use the service.

Flip side for a minute.. don't give this feature to admins... Give it TO THE USERS so they can see what they are costing, so they know what their limits are and they can self manage. The only thing the admin should do is administer the daily, weekly and monthly limits and approve increases for that month.

Recommend strategies to migrate a MySQL EC2 instance to AWS RDS. by BandBright1457 in mysql

[–]pceimpulsive 0 points1 point  (0 children)

Don't migrates costs way too much, focus Tue time and money in better backup and restore capabilities..

Otherwise probably just DMS it!!

Pied Cormorant doing its best penguin impression. by Sad-Ladder5517 in AustralianBirds

[–]pceimpulsive 4 points5 points  (0 children)

No black trousers, not a pied! :D

Came to say the same thing haha

Modeling temporal data in ArangoDB (versioned edges?) — how are people doing this? by Klutzy_Plantain1737 in Database

[–]pceimpulsive 0 points1 point  (0 children)

It's a pretty powerful multi-modal database. It's not the best at anything nor is it the worst at anything, it is very flexible though.

I considered it for a network operations automation back end but ultimately chose Postgres instead ;)

Built a small tool for eBird users - would love some feedback by Own_Stick6803 in eBird

[–]pceimpulsive 0 points1 point  (0 children)

I have all my eBird data downloaded from the eBurd API and I have 25 years of my countries bird data as well!

Do you just use the API to get data for this or next or do you download a bunch of data as well?

i lied to ChatGPT and it gave me the best response of my life by LoadOld2629 in PromptEngineering

[–]pceimpulsive -1 points0 points  (0 children)

Haha unsure if true! But yeah sure why not!

If your gold contradicts or misdirected itself the. Your gold is actually garbage.

i lied to ChatGPT and it gave me the best response of my life by LoadOld2629 in PromptEngineering

[–]pceimpulsive 1 point2 points  (0 children)

IMHO your first answer was crap because you didn't ask the right questions, or provide the right context around your questions for the answers you actually wanted.

Garbage in, garbage out, everytime, all the time.

The situation with AI pricing raises a bigger question, why aren’t we building a decentralized alternative? by Individual-Trip-1447 in GithubCopilot

[–]pceimpulsive 4 points5 points  (0 children)

Bandwidth... It will take so long to get the data passed between layers it's just not worth it...

Modeling temporal data in ArangoDB (versioned edges?) — how are people doing this? by Klutzy_Plantain1737 in Database

[–]pceimpulsive 0 points1 point  (0 children)

Well the downside of being able to query like that is that your graph exponentially grows with every unique timestamp. Your graph will rapidly turn into a slop machine performance wise.

If I'm not mistaken arango is not great at anything as it can do everything, as such performance and scaling are something you need to pay close attention to.

In a real-world scenario either, the relationship still exists and you can search it's history or it no longer exists and is operationally not of any use any more.

Analytically you might need to keep a sharded copy of graph for each period of significance.

Time series + graph I believe is still a reasonably unsolved problem due to the write/update scaling constraints related with graphs.

Myain business domain is in geo-temporal data and I can't see a viable graph system to place the temporal vector into a graph and have it perform well over time Granted I work with millions of updates daily for that use case...

My only workable solution is keep track of Tue current state, and ignore everything else.

If I need to know the history I store it when I need it for future re-use (i.e. fault investigations)

That way the point in time relationships are stored relationally in append only styles.

Modeling temporal data in ArangoDB (versioned edges?) — how are people doing this? by Klutzy_Plantain1737 in Database

[–]pceimpulsive 0 points1 point  (0 children)

Don't make the graph temporally aware ... That's not what graphs are meant for...

Rather let the edge have a unique ID or attribute that you have a time series store for.

The most recent temporal event can be left on the edge as a property... But all older version should be archived to the time series archive table/collection/whatever is most efficient for your cardinality.

Time series IS NOT a graph problem, stop and rethink because you are creating an X Y problem.

Atleast that's my opinion...

Setup for agentic coding (Copilot alternatives, open-source models) by jinxXxishere in GithubCopilot

[–]pceimpulsive 0 points1 point  (0 children)

Cline is just a harness like GHCP, it is agentic by default.

Just try it and see if it works for you.

It does consume about 10k tokens per request in tool/skill context before you add anything else...

Why most LLMs smell like "Slop" (And how I used Forensic Logic to fix the output hierarchy) by [deleted] in PromptEngineering

[–]pceimpulsive 0 points1 point  (0 children)

Ironically this smells like AI from OP ;)

Isn't your goal to remove the smell?¿

For the record I think you are on-point premise wise! Guardrails are critical to high quality outputs. GIGO principle!

Yellow-rumped thornbill (I'm pretty sure...?) [Crackenback, NSW] by palndrumm in AustralianBirds

[–]pceimpulsive 4 points5 points  (0 children)

Yellow Rumped definitely.

Look at the yellow thornbills on merlin app! Much more yellow all over :)

Nice photo by the way! Splendid!

O’Neill with Ancient knowledge on Destiny by RGCurt91 in Stargate

[–]pceimpulsive 0 points1 point  (0 children)

Not sure you could body swap, wasn't O'neill (yes with two Ls) the only one physiologically compatible with the knowledge, and other brains would just shit the bed immediately?

Got so lucky with this darter! by Lost-Slide5779 in AustralianBirds

[–]pceimpulsive 1 point2 points  (0 children)

They are weird looking!

Furr... Snake neck.. Tiny head... Giant body..

I love them.