teleren/devto huggingface dataset:
MS Access Slow Linking Between ODBC and Local Tables? Then Don’t Do It.
Tags: data, msaccess, dataanalystics, sql
Published: 2022-11-04 04:00:00

Often when analyzing data from a SQL Server table via MS Access, I’ll create a local table to specify the values to query. I’ll then link the local table to the SQL Server table (via INNER JOIN).


![MS Access linking Local and Remote tables](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/3jlcqj444jcz0rcat9ys.png)

I’ve noticed, at least in recent versions of MS Access, that when you link a local table with a remote table (ex. ODBC) it’s incredibly slow. Often my MS Access will freeze up, making me think the application will crash.

_I’ve been using MS Access for years, I’ve only noticed this as an issue “recently” — I’m currently using Microsoft 365 Apps for enterprise._


## How To Avoid Local Tables in MS Access


The obvious way is to put your data into another remote (SQL Server) table.

My suggested approach is a little faster: rather than creating (or modifying) a new table every time, add WHERE criteria.

As a web developer, I use an IDE (specifically Sublime Text, but this also works with VS Code). You can **select multiple lines by clicking the mouse wheel**, and then move the cursor over (via “Home” and “End” keys) to surround the text in a single quote and append the word “or”:


![Use the mouse wheel to select multiple rows](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/6cnvmdotaxsl7lro5mvm.png)

You could also do this with an Excel formula:


![Use an Excel formula to specify criteria](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/lbvw102vfjh123ekdqaj.png)

Then query the (one) SQL server table and specify additional criteria:

![New query in MS Access](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/3w8hcrhhbyb2hq319cur.png)


_This approach may not be reasonable for “a lot” of data, but if you’re querying for a handful of items it may be a viable alternative._

This technique greatly speeds up the time it takes me to query a SQL Server table via MS Access when performing data analysis.
Await / Async in .NET
Tags: csharp, dotnet, async, awai
Published: 2022-11-04 03:57:45

Hello everyone, I've worked with await/async recently but I got stuck in there . I dont know how the threads will run in system with keyword async/await?

1. I  declare async and don't use await in the function body (it shows a warning) so is it asynchronous when calling that function?

2. I have 3 async functions A, B, C that I call sequentially
A
B
C
does it run asynchronously without await or need ?
await A
await B
await C

3. I read some Microsoft document it said "when we meet the keyword 'await', the remaining code will be non-blocking  and if i think code with await will cotinue running without response's waiting, is that right?"
ex: 
async A(){
await something - take 5 seconds;
call api();
}
With the above code, is it Async programming ?
Thanks all guys!!!
345. Leetcode solution in cpp
Tags: challenge, cpp
Published: 2022-11-04 03:56:34

```
class Solution {
 public:
  string reverseVowels(string s) {
    const unordered_set<char> vowels{'a', 'e', 'i', 'o', 'u',
                                     'A', 'E', 'I', 'O', 'U'};
    int l = 0;
    int r = s.length() - 1;

    while (l < r) {
      while (l < r && !vowels.count(s[l]))
        ++l;
      while (l < r && !vowels.count(s[r]))
        --r;
      swap(s[l++], s[r--]);
    }

    return s;
  }
};
```
#leetcode
#challenge
Here is the link for the problem:
https://leetcode.com/problems/reverse-vowels-of-a-string/
Use SVGs with Next.js using svgr/webpack
Tags: nextjs, svg, react, typescript
Published: 2022-11-04 03:54:40

So you want to use SVGs in Next.js as SVG and not as an image? Then this tutorial is for you!

**Step 1: Install [@svgr/webpack](https://www.npmjs.com/package/@svgr/webpack)**

This library allows us to import SVG as a React component. You do NOT need to install Webpack separately.
We'll install it as a `dev` dependency. Run the command.

```
npm i @svgr/webpack --save-dev
```

**Step 2: Configure Webpack**

There will be a `next.config.js` file in your project. If you do not have one, just create one.
Your `next.config.js` should look something like this

```
/** @type {import('next').NextConfig} */
const nextConfig = {
  reactStrictMode: true,
  swcMinify: true,
}

module.exports = nextConfig
```
Now add the following Webpack configuration in the `nextConfig` object.

```
webpack(config){
    config.module.rules.push({
      test: /\.svg$/,
      use: [{loader: '@svgr/webpack', options: {icon: true}}]
    })
    return config
}
```
We're basically pre-processing our SVG files using loaders.
Finally, your next.config.js should look like this.

```
/** @type {import('next').NextConfig} */
const nextConfig = {
  reactStrictMode: true,
  swcMinify: true,
  webpack(config){
    config.module.rules.push({
      test: /\.svg$/,
      use: [{loader: '@svgr/webpack', options: {icon: true}}]
    })
    return config
  }
}

module.exports = nextConfig
```

**Step 3: Importing SVG**

Restart the `dev` server first.
You can now import SVG just like any other React component. 

```
import FacebookIcon from './facebook.svg'

export const Home = ()=>{
    return (
        <FacebookIcon/>
    )
}
```
And, that's it 🎉!

I hope you found my article helpful. Thanks for reading my post!
Get npm package's CHANGELOG in one command
Published: 2022-11-04 03:53:29

I often run `npm-check-updates` to update my project's dependencies, but I also want to know what changed.

Traditionally, I need to find the package's GitHub repo, then open GitHub to query its release notes, which is tedious.

Thankfully, GitHub has a [CLI version](https://cli.github.com/), so that we can do something in the terminal! With a [custom extension](https://github.com/tmkx/gh-cl), I can do the same thing in one command: `gh cl react`

![Demo](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/4v1klepjs2dbv0b2skjg.gif)

https://github.com/tmkx/gh-cl
Unable to install Pandas in RHEL7 with python 3.8
Tags: pandas, python, python3
Published: 2022-11-04 03:08:06

Hello Community Team,

I want to run the python script over RHEL7.
I am using pandas in my script and while running the script on RHEL7 box its showing error 

**import pandas as pd
ModuleNotFoundError: No module named 'pandas'**

=========================================================
While installing pandas with pip install python-pandas
>>>Output of command pip install python-pandas<<<
**pip install python-pandas
Defaulting to user installation because normal site-packages is not writeable
ERROR: Could not find a version that satisfies the requirement python-pandas (from versions: none)
ERROR: No matching distribution found for python-pandas**
========================================================
Installing with pip install pandas
>>>output of the command pip install pandas<<<
...
error: Command "gcc -pthread -Wno-unused-result -Wsign-compare -DNDEBUG -g -fwrapv -O3 -Wall -fPIC -Ibuild/src.linux-ppc64le-3.8/numpy/core/src/common -Inumpy/core/include -Ibuild/src.linux-ppc64le-3.8/numpy/core/include/numpy -Inumpy/core/src/common -Inumpy/core/src -Inumpy/core -Inumpy/core/src/npymath -Inumpy/core/src/multiarray -Inumpy/core/src/umath -Inumpy/core/src/npysort -I/usr/local/include/python3.8 -Ibuild/src.linux-ppc64le-3.8/numpy/core/src/common -Ibuild/src.linux-ppc64le-3.8/numpy/core/src/npymath -Ibuild/src.linux-ppc64le-3.8/numpy/core/src/common -Ibuild/src.linux-ppc64le-3.8/numpy/core/src/npymath -c build/src.linux-ppc64le-3.8/numpy/core/src/npysort/radixsort.c -o build/temp.linux-ppc64le-cpython-38/build/src.linux-ppc64le-3.8/numpy/core/src/npysort/radixsort.o -MMD -MF build/temp.linux-ppc64le-cpython-38/build/src.linux-ppc64le-3.8/numpy/core/src/npysort/radixsort.o.d" failed with exit status 1
            [end of output]

        note: This error originates from a subprocess, and is likely not a problem with pip.
      error: legacy-install-failure

      × Encountered error while trying to install package.
      ╰─> numpy

      note: This is an issue with the package mentioned above, not pip.
      hint: See above for output from the failure.
      [end of output]

  note: This error originates from a subprocess, and is likely not a problem with pip.
error: subprocess-exited-with-error

× pip subprocess to install build dependencies did not run successfully.
│ exit code: 1
╰─> See above for output.

note: This error originates from a subprocess, and is likely not a problem with pip.
===============================================================

===============================================================
version of OS:
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/kpmw8fln10invtsw5s5s.png)
===============================================================
python - 3.8.5
pip - 22.3
===============================================================

Can anyone help me with this?
How to install pandas in RHEL7?
===============================================================

Thanks in advance.
Vivek S.
Parkinson's law
Tags: performance
Published: 2022-11-04 02:32:13


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/hs5qgb66exu8rrr4ohkg.png)


Parkinson's Law is the old adage that work expands to fill the allotted time for completion.

This law may be adopted in some areas.

It can be paired with **Student syndrome** refers to planned procrastination, when, for example, a student only starts performing a task at the last possible moment before his deadline. 

This eliminates any possible margin of safety and puts the individual under stress and pressure.
AWS: Uso de Reachabiliy Analyzer
Tags: aws, networking
Published: 2022-11-04 02:22:00

En la actualidad pocas personas conocen este servicio, e incluso siguen usando Lambda para temas de troubleshooting.

Pues ahora tenemos esta herramienta que nos permite realizar un analisis de la configuracion para las pruebas de conectividad.

---

Su uso es muy intuitivo ya que debemos colocar el origen y destino ya sea un TGW, TGW Attach, VPN, ENI o Peering. Incluso colocar un puerto especifico.

Ingresamos al servicio de VPC

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/cd6kapcp62pjtux45pd6.png)

Dentro de este, abajaremos en el aparto de la izquiera y buscamos Reachabilily Analyzer

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/lzx14b2ottrmsedeuupv.png)

Luego clic en Create

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/25vbopku14xx6cq8w33e.png)

Ahi ingresaremos y seleccionaremos los datos correspondientes que deseamos analizar.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/iw18nslcywm73xtxqe51.png)

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/shko5iq8vtpo358hbwjw.png)


Como recomendación ayuda mucho tener claro el diagrama de arquitectura para conocer como va la comunicacion entre recursos y el cual desearemos analizar.

Cuando en analisis es correcto aparecera el mensaje Reachable (Accesible)

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/zb1gv86l94nc9m692pti.png
)

En la parte de abajo tendremos el detalle de la comunicacion que realiza

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/g5inob19hqgvoaltrclk.png)

Esto nos ayudara a poder realizar pruebas con mayor rapidez y tener la visión de la comunicacion general y los recursos que intervienen.

- Solucionar problemas de conectividad causados ​​por una mala configuración de la red.
- Verifique que la configuración de su red coincida con su conectividad prevista.
- Automatice la verificación de su intención de conectividad a medida que cambia la configuración de su red.
A Series on Bash Scripting
Tags: bash, programming, linux, script
Published: 2022-11-04 00:44:30

## What is Bash?

Bash is a type of shell that allows running commands on Linux.


## What is Bash Script?

A Bash script is a plain text file that contains a series of commands.


## Use Cases of Bash Scripting

Bash scripts can be used for various purposes, such as executing a shell command, running multiple commands together, customizing administrative tasks, performing task automation, etc.


## How to learn?

You can start your bash scripting journey today. Following are the lists of articles :

[● Start Your Scripting Journey Today | Bash Script — Part 1](https://levelup.gitconnected.com/start-your-scripting-journey-today-bash-script-part-1-46cbddf4e4e7)

[● Start Your Scripting Journey Today | Bash Script — Part 2](https://medium.com/geekculture/start-your-scripting-journey-today-bash-script-part-2-4d93ecb59249)

[● Start Your Scripting Journey Today | Bash Script — Part 3](https://medium.com/geekculture/start-your-scripting-journey-today-bash-script-part-3-9779ac0abea2)

------------------------------------------------------------------

> [Follow ](https://medium.com/@shamimice03)me to get more articles like this.
Five common pitfalls every QA manager should avoid
Tags: testdev, testing, ai
Published: 2022-11-04 00:15:25

Daniel Knott, a software quality assurance expert, recently made an interesting point about why total automation is unhealthy — "Customers don't care if your software is automated to 100%. They care, for example, if the final product still has critical issues."

When preparing a test team for automation, be sure to allow enough time for them to work with the system before the start of actual testing. Daniel Knott offers the following advice to avoid making this mistake:

- Start by sitting down and making a plan. What do you want to automate? What are the critical parts of your product that needs to be automated? 
- Determine the things that are likely to change often, and start simple — don't write too many tests for complicated features. 
- Check those features that people interact with first. 
- Talk to your developers; they know how a product is supposed to work. Discuss with them what features you should focus on first and what features can be tested later.

Conclusion: automation is great, but you must be careful not to go overboard.

Learn more common mistakes every QA manager should avoid - in my team’s recent [blog article](https://aqua-cloud.io/pitfalls-qa-manager-should-avoid/?utm_source=devto&utm_medium=article&utm_content=post&utm_campaign=share
). 

---

If you want to follow my testing learning journey, follow the "Software Testing Talks" groups I created on Reddit and Linkedin. I share the most interesting QA discussions I find on the web and insights I get during testing work and studies there.

I am also happy to hear your feedback, suggestions, or ideas about what you would like me to write more about. Don't hesitate to text me if you want to say hi or discuss something.

---

If you want to follow my testing learning journey, follow the "Software Testing Talks" groups I created on Reddit and Linkedin. I share the most interesting QA discussions I find on the web and insights I get during testing work and studies there.

I am also happy to hear your feedback, suggestions, or ideas about what you would like me to write more about. Don't hesitate to text me if you want to say hi or discuss something.
Bootcamp first post
Published: 2022-11-03 23:20:00

Module 2.1.3 Post
I took about 20 minutes to read over a few development blogs and news sites and what I learned is that there is a lot to learn. I understood some of the more beginner friendly posts/articles but the majority were too advanced and I had a hard time understanding what they were trying to show. Seeing how much is out there to learn is one of the most intimidating aspects of pursuing a career as a software developer. But in time I'm sure I will start to understand more things.
7 React Challenges
Tags: react, challenge, beginners
Published: 2022-11-03 22:49:43

Hello there!

I've been collecting different _interesting challenges_ that could be implemented for practice in ReactJS. The list is big and is growing whenever I encounter an interesting piece of UI or functionality. 

Initially, I planned to come up with a course with video materials, where I would show an end result and explain how to do it in ReactJS. However, I figured out it is _not that simple_ to create a video course. So, I decided to come up with a **list of curated challenges**, which will cover important topics in ReactJS and guide with relevant hints(but not provide implementation itself). That turned out into 7 challenges and 18 pages PDF.

So, I am presenting you ["7 React Challenges you can build Today"](https://aibolik.com/7-react-challenges) PDF. Feel free to grab it on my website and leave me feedback.

I might still come up with a full-blown course, which will present 20+ ReactJS challenges with the guidance on implementation, so stay tuned for further updates.

That's it from me. Thanks for your attention.
Hey guys
Published: 2022-11-03 22:48:07

Getting ready to start the GTRI full stack coding bootcamp. This community/forum was mentioned in the pre-requisites. 
Background is EE, but after 4 years of looking at circuits, I realized I like writing code way more lol. The realization happened about a year ago when I got involved in crypto/started writing solidity contracts. Now I got bit by the javascript bug and doing cool things I learned back in high school during my C++ and AP Java courses.
The Promise of Platform Engineering
Tags: devops, podcast, management, techtalks
Published: 2022-11-03 22:34:33

Live from Interact, we're bringing you an interview with our favorite CTO, Charity Majors.

Never one to be shy about speaking her mind, Charity is an outspoken advocate for devs everywhere - and this passion made her a fan favorite at Interact.

Listen as Charity discusses her career, why the hierarchy is bullshit (disclaimer: she likes to swear - we like that about her), and why platform engineering is the most exciting place to sit in computing today.

{% spotify spotify:episode:6BOw1SClbIRCYDZlEE0nmq %}

## Episode Highlights Include:
* (3:05) Charity's career journey
* (9:25) Why the hierarchy is bullshit
* (13:37) The future of ops is platform engineering
* (20:08) How to build an amazing platform engineering team
* (24:51) Movement around developer experience (DX)
* (35:03) 15 minutes or bust
* (41:57) Routing pull requests with gitStream

***While you’re here, check out this video from our [YouTube channel](https://www.youtube.com/c/DevInterrupted?sub_confirmation=1), and be sure to like and [subscribe](https://www.youtube.com/c/DevInterrupted?sub_confirmation=1) when you do!*** 

{% youtube oRdxzdg2vqk %}

### *Engineering Insights before anyone else....*
*The Weekly Interruption is a newsletter designed for engineering leaders, by engineering leaders.*

*We get it. You're busy. So are we. That's why our newsletter is light, informative and oftentimes irreverent. No BS or fluff. Each week we deliver actionable advice to help make you - whether you're a CTO, VP of Engineering, team lead or IC  - a better leader.*

*It's also the best way to stay up-to-date on all things Dev Interrupted - from our podcast, to trending articles, [Interact](https://devinterrupted.com/event/interact/) & our [community Discord.](https://discord.com/invite/devinterrupted)*

[***Get interrupted.***](https://devinterrupted.com/subscribe/)

![Subscribe to the Weekly Interruption](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/81b4hu463juqwf1bixfe.png)
Day 650 : Stay Away
Tags: hiphop, code, coding, lifelongdev
Published: 2022-11-03 22:17:43

_liner notes_:
- Professional : Had bunch of meetings and then spent the rest of the time working on my hackathon project. I think I got it working good enough to record a demo. A lot of my time was actually spent trying to figure out how to record the demo. haha Tried a bunch of things, even put a small scratch on a lens. Luckily it's not really noticeable unless I'm really looking for it. It kind of looks like a small smudge. A small reminder to be careful. I think I may have found a software solution so I'll see if it works out after dinner.

- Personal : Just worked on my hackthon project. Pretty much it.

![An overhead view of a beach in the Maldives with white sands and turquoise water](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/sqx72g4gbi3zcze2ykqo.png)

Going to work on the finalizing the application, demo and presentation. Depending on when I finish, I want to watch some anime and work on the radio show. Going to eat dinner and back to work. Can't stay away, haha.

Have a great night!

peace piece
Dwane / conshus
https://dwane.io / https://HIPHOPandCODE.com
{% youtube CvtqFUdp5b0 %}
Ng-News: Episode 22/43
Tags: javascript, angular, webdev, programming
Published: 2022-11-03 22:05:14

An introduction into the popular CSS Framework Tailwind and the release of Webpack's successor Turbopack are the main features of this episode.

{% embed https://youtu.be/8fDUrcr8HFE %}

## Introduction into Tailwind

If you've ever asked yourself how it is to work with Tailwind in Angular applications, you should watch the latest episode of AngularAir. Alyssa Nicholl, together with Mike Brocchi, gave an introduction to this CSS framework.

Next to showcasing the basic elements, she also mentioned that Tailwind should primarily be seen as a set of utility classes. If you already have a team that implemented their own utility classes, then Tailwind might not be really necessary.

{% embed https://youtu.be/deg2FPU01YQ %}

## Turbopack

Webpack is the bundler behind Angular and powers most of the build process.

In previous episodes, I've mentioned that we see alternatives popping up, which are considerably faster because they are not written in JavaScript but in Go or Rust.

Since last week, a new player has entered the game. Turbopack is the official successor to Webpack, is written in Rust, and it was announced at the Next.js conf.

By the way: Next.js is the most popular meta-framework for React. Next.js 13 was released last week. It comes with React Server components, which is a fascinating technology.

React Server components are, as in SSR, rendered on the server. The difference is that their JavaScript is never sent to the browser, resulting in a significant reduced bundle size.

It will be interesting to see if Angular has plans to come up with something similar.

{% embed https://youtu.be/NiknNI_0J48 %}

## Minor Releases

Other then that, we had new minor version releases. Cypress, a testing framework, to 10.11.

[Cypress 10.11](https://docs.cypress.io/guides/references/changelog#10-11-0)

And if you use the NgRx component store, a lightweight state management library, you can now also embed the router. Router Component Store was released in version 0.2.

[Router Component Store](https://github.com/ngworker/router-component-store
)