Single quote (‘) in MySQL console

This is normal MySQL query

mysql> select database();
+------------+
| database() |
+------------+
| NULL       |
+------------+
1 row in set (0.00 sec)

mysql> 

I notice that when I accidentally put ' in it … the console seems to stuck there.

mysql> '
    '> 
    '> select database();
    '> 
    '> '

SQL query such as select database(); doesn’t work anymore.

The question is why is this happen with '? Is there any explanation for this behavior?

c# – Multiple HttpClients in .NET Core Console Application

I’m building a .NET Core class library wrapper for a REST API that, ideally, could be used in both console applications and ASP.NET Core web applications. So far, I’ve based development on supporting dependency injection for the latter by creating a typed client for each group of REST API methods, i.e. one client for each group of (Index, Create, Destroy, etc.). It may be important to note that in this case, each group has same base address, and in most cases, the same authorization header would be used.

The typed clients inherit from a base client that handles some of the configuration:

public abstract class BaseClient
{
    protected readonly HttpClient _client;

    public BaseClient(IConfigService config, HttpClient client)
    {
        _client = client;
        _client.BaseAddress = new Uri(config.BaseAddress);

       // More configuration
    }
}

So I end up with something like this:

public class ClientA : BaseClient, IClientA
{
    public ClientA(IConfigService config, HttpClient client) : base(config, client) { }

    // Some methods
}

public class ClientB : BaseClient, IClientB
{
    public ClientB(IConfigService config, HttpClient client) : base(config, client) { }

    // More methods
}

And so on. With this I’ve written an IServiceCollection extension that registers all of these services:

public static class WrapperServiceCollectionExtensions
{
    public static IServiceCollection AddWrapper(this IServiceCollection services, string username, string key)
    {
        services.AddSingleton<IConfigService>(new ConfigService(username, key));
        services.AddHttpClient<IClientA, ClientA>();
        services.AddHttpClient<IClientB, ClientB>();

        // More clients

        return services;
    }
}

As I understand it, using this DI pattern, a new HttpClient is instantiated for each typed client, so I see no issue with a typed client being individually responsible for its own configuration. But let’s say I want to create these clients in a console application. Finally, I get to my question: knowing that the clients all have the same base address and all will most likely be using the same credentials for authorization, what would be the recommended way of instantiating them in a console application? I’m inclined to create a new HttpClient for each typed client:

class Program
{
    private static HttpClient _clientA = new HttpClient();
    private static HttpClient _clientB = new HttpClient();

    static void Main(string() args)
    {
        var config = new ConfigService("user", "key");
        var a = new ClientA(config, _clientA);
        var b = new ClientB(config, _clientB);
    }
}

But is this really necessary if the configurations would be the same for both anyways? Should I only worry about one HttpClient unless I’m dealing with multiple configurations? Should I even have multiple typed clients if the configuration would be the same for each? To me, it feels a little hacky to let each typed client successively overwrite a single HttpClient‘s configuration in its constructor, but in terms of behavior, unless different credentials were used, I don’t think it would matter. Seriously stuck here.

architecture – Resources for designing a private, web-based cloud console

Imagine designing a scalable web-based application to manage a Fortune 500 company’s internal, on-prem cloud resources. These resources might be comprised of various underlying infrastructure, some virtual and some physical, mostly managed by software.

  • What would be some things to consider when designing such a system?
  • How would you orchestrate a significant number of asynchronous requests to read or modify underlying resources?
  • How would you design a system to offer up-to-date observability of a huge number of resources?
  • How to handle concurrent modifications and unreliable change requests to such a system?
  • How to handle failed resource modifications?

exclude – google search console excluded urls

I submitted sitemap in google search console. Now in coverage it shows 190 excluded urls. Why google excludes url and how to reduce or minimize excluded urls? why google doesn’t want to indexed that pages?

Strange string in console from wpdb query

I use this code:

   $search = $this->wpdb->prepare("WHERE (name LIKE %s OR tag LIKE %s)", '%'. $this->wpdb->esc_like($word) .'%', '%'. $this->wpdb->esc_like($word) .'%'); 

and in console i get:

name LIKE '{4b9ad9b602bd32ff99324feebaa1883bb3a3e818f587b35198d4e48093375c78}night{4b9ad9b602bd32ff99324feebaa1883bb3a3e818f587b35198d4e48093375c78}' OR tag LIKE '{4b9ad9b602bd32ff99324feebaa1883bb3a3e818f587b35198d4e48093375c78}night{4b9ad9b602bd32ff99324feebaa1883bb3a3e818f587b35198d4e48093375c78}'

how i can remove this strange string?

google search console – error indexing

I have a site built with WordPress. Initially, because the default content of the template was indexed in Google, I decided to remove those urls through the removals section in the Google console search. I also enabled the nofollow and noindex tags for all posts and tabs via the yoast plugin. After that, when I searched site: domain.com, there was no address. When I tried to index the home page again from the Google console search, https://example.com, I came across a noindex error while I had previously removed the tags. Other pages do not provide this error, but I will encounter a URL error that will be indexed only if certain conditions are met in livetest. I don’t know why in the beginning, even though I didn’t create a sitemap, everything was normal and the pages were indexed quickly, but after I deleted the previous urls and added new ones, the pages don’t index. Of course, the last time Google crawled the home page was on May 26.

google search console – Slow WordPress site speed with Bluehost

Probably the best thing to do is get yourself off what looks like a crowded under-resourced hosting server.

It takes almost 1 second for a 301 redirect and then another second before your page even starts to download.

From https://gtmetrix.com…

enter image description here

Generally with hosting. you get what you pay for

google search console – My domain does not show up in any SEO analysis websites

My client’s domain worktrak.in seems to be totally invisible in the SEO analysis websites. Like for example when we query the domain “worktrak.in” for the following…

  1. Organic keywords
  2. Organic monthly keywords
  3. Organic monthly traffic
  4. Domain score
  5. Backlinks

None of these return any results. I have tried in multiple SEO related websites like

  1. NeilPatel.com
  2. SemRush
  3. Moz
  4. SeRanking.com

I am unable to understand why this domain is not being queried by these above sites for the details. While I am able to get the details from google analytics and search console.

Can anyone help on this please?

Does the discussion “console games vs PC” still exist?

As far as I can remember, I’ve observed as teenager an ongoing discussion in the 90s, if not even a flame war, between console and PC gamers.

  • For most, having both a PC and a gaming console was simply not affordable
  • Generally, PC games seemed to have larger variety of game genres and generally provide access to more complex games, but consoled seemed to offer more colorful and vivid experiences.
  • Some games where of course then ported between different platforms, some not.

Now I must admit I am almost out of the world of games since more than two decades.

Today, as far as I can see, really many games releases appear simultaneously for many platform.

My question:

  • Does the discussion still exist in the gaming community, I mean, if yes, what are non-opiniated hard facts in this discussion? (beyond simple taste preference)
  • Or if not can we state for example, consoles have become more or less very specialized PCs (or provide other facts based arguments that such debates have descreased)?

Please note: this is not the question about “which platform is better”.
It a yes/no question about factual existence of noticable debates on this topic.

Does any change in the server require a change in the console

Hi, our site was recently moved to a new server with a different IP due to upgrades and the need for more resources
Now my question is, I have already introduced the site to the console using the possibility of registering a site with Doman. Do I have to do these things again from zero to one hundred after changing the server?