machuu

Overview

Internet connection and DNS routing are broken from WSL2 instances, when some VPNs are active.

The root cause seems to be that WSL2 and the VPN use the same IP address block, and the VPN routing clobbers WSL2's network routing.

This problem is tracked in multiple microsoft/WSL issues including, but not limited to:

• microsoft/WSL#5068
• microsoft/WSL#4277

Kautenja

"""Functions for working with remote files using pandas and paramiko (SFTP/SSH)."""
import pandas as pd
import paramiko


def read_csv_sftp(hostname: str, username: str, remotepath: str, *args, **kwargs) -> pd.DataFrame:
    """
    Read a file from a remote host using SFTP over SSH.

    Args:

yzorg

CREATE PROCEDURE [dbo].[spTxnDemo]
  @debug int = NULL
  , @forceError int = NULL
AS
BEGIN
    SET NOCOUNT ON;
    SET @debug = ISNULL(@debug, 0);
    SET @forceError = ISNULL(@forceError, 0);
    BEGIN TRY
        BEGIN TRANSACTION MY_TXN;

ptupitsyn

using System;
using System.Collections.Concurrent;
using System.Collections.Generic;
using System.Threading;
using Apache.Ignite.Core.Cache;
using Apache.Ignite.Core.Cache.Event;
using Apache.Ignite.Core.Cache.Query.Continuous;

namespace IgniteAsyncStreams
{

GeorgeTsiokos

public static KeyValuePair<ushort, string>[] Parse(Span<byte> message)
{
    var values = new List<KeyValuePair<ushort, string>>();
    const byte Soh = 1;
    const byte Equals = 61;
    while (0 < message.Length)
    {
        var soh = message.IndexOf(Soh);
        if (-1 == soh)
            break;

bzerangue

NDJSON is a convenient format for storing or streaming structured data that may be processed one record at a time.

• Each line is a valid JSON value
• Line separator is ‘\n’

1. Convert JSON to NDJSON?

cat test.json | jq -c '.[]' > testNDJSON.json

werneckpaiva

// Get the list of partitions
List<PartitionInfo> partitionInfos = consumer.partitionsFor(topicName);
// Transform PartitionInfo into TopicPartition
List<TopicPartition> topicPartitionList = partitionInfos
  .stream()
  .map(info -> new TopicPartition(topicName, info.partition()))
  .collect(Collectors.toList());
// Assign the consumer to these partitions
consumer.assign(topicPartitionList);
// Look for offsets based on timestamp

bradtraversy

Pipenv Cheat Sheet

Install pipenv

pip3 install pipenv

Activate

pipenv shell

kof

const styles = {
  button: {
    color: 'red'
  }
}

const Button = () => {
  const {classes} = useStyles(styles)
  return <button className={classes.button}>Test<Button>
}

thorsman99

Insert into [server].database.dbo.table
select src.* from table src
	left join [server].database.dbo.table sta
	ON sta.Key = src.Key
	where sta.Key IS NULL