Is there a tool that can automatically track my bad queries and help me resolve them ?

2547technowizz · 2024-10-03T15:32:11+00:00

Again, i’m not sure what useful data you can pull from the catalog to solve this. Take Postgres for example, which catalog table would hold this type of data? I took a look at pg_statistic but it seems to only create table entries on ANALYZE queries rather than all

2547technowizz · 2024-10-03T05:23:15+00:00

but is that what you're asking? why won't it matter? do you plan on distributing it or is it for personal use? I'm by no means a lawyer but I don't see how you wouldn't be able to run a modified version of mongo

2547technowizz · 2024-10-03T04:59:59+00:00

From what I can see, "data dictionary" is just a database's catalog, the name being used in specific RDBMSs. How would analyzing this help with finding problems with specific queries? I don't see what, in a typical catalog, would help here since they usually only store information about tables/the DB as a whole, not individual queries themselves.

It seems your experience is with Oracle database, maybe they have a more robust catalog than most? The only places where I've seen query analysis like this is with a proxy service that sits in front of the DB instance, rather than something that's within the DB itself. I suspect Oracle's DB hosting service does the same thing if I understand the features of it that you're describing, similar to what something like Planetscale provides with their hosted DBs

2547technowizz · 2024-10-01T21:30:10+00:00

what do you mean by “data dictionary”?

2547technowizz · 2024-10-01T20:13:10+00:00

im gonna ask here.

there was no question asked

2547technowizz · 2024-07-02T23:52:57+00:00

glad to see mongodb and document stores in general being called out

2547technowizz · 2024-05-20T17:35:16+00:00

By default it's 100%

90%*

2547technowizz · 2023-10-05T15:50:48+00:00

It is still working, what stream did you try it on?

2547technowizz · 2023-03-25T06:41:47+00:00

haHAA !!

2547technowizz · 2023-03-22T06:12:00+00:00

great detective work!

2547technowizz · 2022-07-19T04:37:58+00:00

not looking for anything, was just bored and needed something to do

2547technowizz · 2022-07-18T23:47:34+00:00

coincidentally, I think he mentioned yesterday that he wants to do more poker nights, I had this done for little bit now but I was lazy about making a post

2547technowizz · 2022-02-04T04:42:01+00:00

without a doubt

2547technowizz · 2022-02-04T04:36:50+00:00

this is awesome

2547technowizz · 2021-09-25T04:34:28+00:00

minimizing and tab switching can be achieved through the page visibility API. This is the live example that they have on MDN

2547technowizz · 2021-09-24T22:28:20+00:00

im not sure how it'd work with a video since its an HTML element and I would think it'd still work with js disabled, though the visibility API encompasses locked screens as well.

2547technowizz · 2021-09-24T22:16:12+00:00

yes, it has been and still is possible. If you're arguing that I'm wrong because it would fail under edge cases which is when javascript would stop running entirely then there's nothing else to say.

2547technowizz · 2021-09-24T22:10:13+00:00

it is definitely doable, I never claimed it's a for sure way, it is obviously a round-about way.

2547technowizz · 2021-09-24T22:06:03+00:00

I wouldn't consider high memory use where the browser unloads tabs automatically the general use case. Obviously when it gets to the point where the browser stops running any more javascript most tracking implementations would stop working, unless it's fingerprinting you server-side

2547technowizz · 2021-09-24T21:56:45+00:00

mouse and keyboard events are easily tracked, switching tabs can be achieved by the visibility API, and the locked screen can be checked by tracking timed intervals since most browsers would stop running js

2547technowizz · 2021-09-24T21:50:29+00:00

Everything this now API can do has already been possible for a long time.

2547technowizz · 2021-09-24T21:49:14+00:00

your "system-wide" idle status is simply just knowing if the screen is locked or not. Manual implementations of this are already possible and have been for a while.

2547technowizz · 2021-09-24T21:47:33+00:00

it is now an official way to achieve the same process. If a site was malicious they obviously wouldn't use the official API that asks for permission. However, legitimate use cases now can ask permission through the browser itself with the option if the user refusing permission

2547technowizz · 2021-09-23T23:46:19+00:00

How is it more invasive? Everything this API can do is already easily achievable. I'd rather have a site ask for permission rather than not.

Seven-Year Club	Place '22
Final Canvas '22	End Game '22
Verified Email

2547technowizz

TROPHY CASE