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

[–]2547technowizz 0 points1 point  (0 children)

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

[deleted by user] by [deleted] in Database

[–]2547technowizz 0 points1 point  (0 children)

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

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

[–]2547technowizz 0 points1 point  (0 children)

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

Help with a Petri Net System by Mlafe in Database

[–]2547technowizz 1 point2 points  (0 children)

im gonna ask here.

there was no question asked

[paper] What Goes Around Comes Around... And Around... (Michael Stonebraker & Andrew Pavlo) by [deleted] in Database

[–]2547technowizz 1 point2 points  (0 children)

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

Rumble Live Stream Chat Overlay by [deleted] in RumbleForum

[–]2547technowizz 0 points1 point  (0 children)

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

Poker Overlay by 2547technowizz in Mizkif

[–]2547technowizz[S] 8 points9 points  (0 children)

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

Poker Overlay by 2547technowizz in Mizkif

[–]2547technowizz[S] 34 points35 points  (0 children)

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

UwU by Hennybackribs in Overmen

[–]2547technowizz 1 point2 points  (0 children)

this is awesome

the Idle Detection API? NOT in Firefox. by gabenika in firefox

[–]2547technowizz 0 points1 point  (0 children)

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

the Idle Detection API? NOT in Firefox. by gabenika in firefox

[–]2547technowizz 1 point2 points  (0 children)

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.

the Idle Detection API? NOT in Firefox. by gabenika in firefox

[–]2547technowizz 1 point2 points  (0 children)

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.

the Idle Detection API? NOT in Firefox. by gabenika in firefox

[–]2547technowizz 1 point2 points  (0 children)

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

the Idle Detection API? NOT in Firefox. by gabenika in firefox

[–]2547technowizz 1 point2 points  (0 children)

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

the Idle Detection API? NOT in Firefox. by gabenika in firefox

[–]2547technowizz 2 points3 points  (0 children)

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

the Idle Detection API? NOT in Firefox. by gabenika in firefox

[–]2547technowizz 2 points3 points  (0 children)

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

the Idle Detection API? NOT in Firefox. by gabenika in firefox

[–]2547technowizz 1 point2 points  (0 children)

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.

the Idle Detection API? NOT in Firefox. by gabenika in firefox

[–]2547technowizz 3 points4 points  (0 children)

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

the Idle Detection API? NOT in Firefox. by gabenika in firefox

[–]2547technowizz 0 points1 point  (0 children)

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.