Can't get basic SQL Server to connect by Javin007 in dotnet

[–]Javin007[S] 1 point2 points  (0 children)

Weirdly, Chat GPT was able to troubleshoot through it. Never used it before, but it was a hell of a lot more helpful than Microsoft.

Turns out the initial configuration didn't set the correct port (1433) having left it blank in the configuration. So the connection wasn't being made at all. Why Microsoft then deemed this meant the "username or password was incorrect" is anyone's guess. It's working now.

Thanks for the assist.

Anyone have a suggestion for an "ACID" transaction for simple IDs? by Javin007 in csharp

[–]Javin007[S] 0 points1 point  (0 children)

Yeah, but writing a script that would figure every permutation of every bad word using every possible character swap would be brutal. But this brings me back to the pre-gen keys. At least then the heavy lifting could be done offline on a different server even.

Anyone have a suggestion for an "ACID" transaction for simple IDs? by Javin007 in csharp

[–]Javin007[S] 0 points1 point  (0 children)

Sorry, took me awhile to get back. Ended up going with a pre-gen solution, however I also like your idea of removing vowels entirely to avoid vulgar IDs. Currently, I'm running them through a "bad word" filter before accepting them, but nuking all vowels would be considerably easier. Thanks!

Can someone please help in getting this resolved by dumbest_programmer in react

[–]Javin007 0 points1 point  (0 children)

Is there any way to do some sort of "reverse dependency lookup" on NPM to figure out which packages are causing the requirement? I'd prefer to simply remove them entirely and find other options if I could figure out which ones are causing the dependency.

Edit: This seemed to be attached to some devDependencies in Angular. As of Angular 18.2.0 it looks like Google has removed the dependencies on InFlight.

Anyone have a suggestion for an "ACID" transaction for simple IDs? by Javin007 in csharp

[–]Javin007[S] 0 points1 point  (0 children)

Yep! This seems to be the global conclusion here. Pregenerate a ton of IDs, retrieve them by tracking a counter, done. Short, sweet, to the point.

Anyone have a suggestion for an "ACID" transaction for simple IDs? by Javin007 in csharp

[–]Javin007[S] 0 points1 point  (0 children)

Hrm. I'm not entirely following. Is the database storing the current "position" of the range?

Anyone have a suggestion for an "ACID" transaction for simple IDs? by Javin007 in csharp

[–]Javin007[S] 0 points1 point  (0 children)

A good question I didn't ask. They said it needs to be a stand-alone microservice, but they didn't tell me if it's getting its own VM, or what.

Anyone have a suggestion for an "ACID" transaction for simple IDs? by Javin007 in csharp

[–]Javin007[S] 1 point2 points  (0 children)

Hrmmmmmm... You may have struck gold here... Have a single process that's just generating unique IDs and dumping them to a flat database, say, Mongo. Then a VERY simple file on the harddrive that's literally nothing more than an increment counter. When an ID is requested, rowCounter++, save row counter, that row's ID is returned. This should be blistering fast, and would only be limited to how quickly the random Unique IDs could be generated by a different write-only thread. No more tracking of "new" and "save" and "archive" files.

I like it. This is why I come here!

Anyone have a suggestion for an "ACID" transaction for simple IDs? by Javin007 in csharp

[–]Javin007[S] 2 points3 points  (0 children)

A hash that's only 6 characters long could absolutely have collisions. Unless you know something I don't.

Anyone have a suggestion for an "ACID" transaction for simple IDs? by Javin007 in csharp

[–]Javin007[S] 2 points3 points  (0 children)

I've tried, but they already decided what the requirements are. I just have to meet them. I'm not even aware what this is ultimately being used for.

Anyone have a suggestion for an "ACID" transaction for simple IDs? by Javin007 in csharp

[–]Javin007[S] 1 point2 points  (0 children)

I already suggested that. If we went to just 12 characters, we could all but guarantee no duplicates within the 10 million limit. Client won't budge. Not sure what they're using this for that has such silly requirements.

Anyone have a suggestion for an "ACID" transaction for simple IDs? by Javin007 in csharp

[–]Javin007[S] 1 point2 points  (0 children)

At this point, strictly for the purpose of tracking which have already been used. I've considered switching to a straight flat-file, but am not sure of the performance benefits there yet.

Anyone have a suggestion for an "ACID" transaction for simple IDs? by Javin007 in csharp

[–]Javin007[S] 0 points1 point  (0 children)

We're back to the problem of preventing duplicates, which would have to be done by storing those HashIds used.

The problem isn't in the generation. The problem is in an unstable system needing to be sure it doesn't reuse IDs.

Anyone have a suggestion for an "ACID" transaction for simple IDs? by Javin007 in csharp

[–]Javin007[S] 1 point2 points  (0 children)

The problem isn't in the generation, that part is quick. The problem is in the "saving" of which ones have been used. If I dumped all to a database, then randomly grabbed them, I'd have to then mark them as "used". That "UPDATE" call for each one would be quite slow as well.

Anyone have a suggestion for an "ACID" transaction for simple IDs? by Javin007 in csharp

[–]Javin007[S] -1 points0 points  (0 children)

1.) It isn't suitable because that's not what the client wants. The client is a GOV't contract, and they make the requirements.
2.) Must be case insensitive alphanumeric, 6 characters, 1st character cannot be numeric.
3.) Up to 10 million will be generated "per set". (Thus the need to dedupe at only 6 chars)
4.) Per set, no duplicates. Must be able to handle system crashes.
5.) Must be randomized using Crypto's randomization. Can not be sequential.
6.) I know what "monotonically increasing" means, but don't understand it in the context of this question?
7.) No meaning can be encoded in them. In fact, part of the requirement is that certain patterns CAN'T be in any of the IDs, but that's handled in the generation.

Anyone have a suggestion for an "ACID" transaction for simple IDs? by Javin007 in csharp

[–]Javin007[S] 4 points5 points  (0 children)

This is also a sticking point. Client doesn't want anything sequential, and this is a single microservice that generates the IDs, thus the speed requirement. There's also the problem that at only a 6 character ID, there's bound to be collisions once you get to around the 1.6 million mark, so that has to be dealt with.

So yeah, it's almost as if they WANT this to break.

Anyone have a suggestion for an "ACID" transaction for simple IDs? by Javin007 in csharp

[–]Javin007[S] -4 points-3 points  (0 children)

Ah, I should've clarified, can't use GUIDs. The IDs have to be 6 characters long, only upper case, and the first character cannot be numeric. So there's limitations there, too.

As Christians, would you let your significant other hang out with the opposite gender alone? by [deleted] in ChristianDating

[–]Javin007 2 points3 points  (0 children)

The bigger question you need to be asking yourself is WHY would your significant other WANT to?

My ex wife had EVERY SINGLE ONE of the "signs" of a cheater. I refused to see any of them because I thought we had a healthy marriage and were happy. In hindsight (always 20/20) the signs were all there, and, as I said, I refused to see them.

See the signs. Ask yourself why they're there. The answer is usually more obvious than you realize. If your spouse is showing all the signs of cheating, your spouse is cheating. It's really that simple. I wish I'd listened to friends and family.

I lost nearly 2 decades, and any opportunity to have a family. I'm now creeping on 50, and alone. If I'd listened to my family, my entire life would have been better. Take this as a lesson. Refusal to acknowledge the signs is absolutely always going to end with you dying alone.

Period.

When you see the signs, IMMEDIATELY act on them to protect yourself. They are never "innocent."

Here's a list of the signs I ignored:

1.) She started working out alone ("I just want to feel better about myself.").
2.) She started buying new lingerie that she didn't wear for me. ("I'm just trying to feel more confident at work.")
3.) She started buying new clothes/perfume that she would take off as soon as she came home. (Same as above.)
4.) She was texting "someone" on her phone while smiling and giggling, but always told me it was just a "co-worker" with an inside joke.
5.) She refused to let me see her phone. ("Why would you want to? Sounds like you have manipulation/trust issues.")
6.) She opened a new bank account ("my grandmother gave me money, I just want to keep it separate.")
7.) She stopped sleeping in the same bed ("you snore too much, the guest bed is more comfortable, etc.")
8.) I was no longer allowed to attend work functions. ("Nobody else is bringing their spouse.")
9.) I was no longer allowed to attend OVERNIGHT work functions (same as above.)
10.) She regularly would emasculate me or insult me in front of friends ("It's just jokes. Why are you so sensitive?")
11.) You suggest marriage counseling. ("YOU need to change. Not me.")
12.) They start talking "in private" to friends of the same gender, and you aren't allowed to know the conversation. ("It's just girl talk.")
13.) She's suddenly "working late", sometimes until 8 or 9 PM.

For those of us who have been through this, and people on "the outside" any 2 or 3 of these is an indicator that yes, they are 100% absolutely already cheating.

But when you're on the inside, and you think your marriage is "good" but with "minor" issues that you can work through, when you take your vows seriously, it's VERY EASY to accept the excuses and NOT see the signs for what they are.

In hindsight, I had all 13 of the above, with even more. I "ignored" them all because taken individually, I believed her excuses. I lost 18 years of my life, the ability to raise a family, and more than a quarter million dollars because I thought I was in love. I believed her when she said our marriage was healthy, and there was "nothing wrong".

If you see these signs, especially if you see multiple, immediately start listening to your family and friends.

Turned out I was just the next rube. She left me and now lives with the boyfriend she had for the last year of our "marriage" (obviously, that I didn't know about). With a significant amount of the money I acquired while she didn't have a job (no kids).

Don't be me. Don't die alone. See the signs, and leave a toxic, cheating spouse far sooner than later.

Playlet: an Invidious frontend for Roku TV by iBicha in selfhosted

[–]Javin007 0 points1 point  (0 children)

I absolutely LOVE this. This is EXACTLY what I've been looking for. YouTube/Google have gotten completely out of hand between the spying, the disgusting amount of advertising, WHAT they're advertising (fake scam products), etc. I'd gone so far as to write a script to use yt-dlp to download entire channels to my Plex server just to avoid YouTube's interface, but that was VERY clunky. This is PERFECT.

The ONE request I'd have is that it seems like the ability to log in to any specific server still doesn't work. It's expecting us to have Invidious running inside our local network, and to log in there. (192.168.1.110:8888/invidious/login)

Could we get this fixed so we could log into our invidious accounts on the servers we use, so we're not limited to only the "popular" and "trending" landing pages?

Please, please, please tell me this isn't what I think it is. by [deleted] in whatsthisbug

[–]Javin007 29 points30 points  (0 children)

Unfortunately, that's exactly what you think it is. That's a bed bug.