teleren/devto huggingface dataset:
Writing complex SQL queries with AND and OR operators
Tags: sql, sqlserver, devart, dbforge
Published: 2024-05-13 13:12:32

To manipulate and retrieve data from SQL databases, one must be familiar with and proficient in using several SQL operators, including arithmetic, comparison, logical, and others. Users can accomplish a variety of tasks, such as data retrieval, string manipulation, comparisons, and mathematical calculations, more easily if they have a firm grasp of the fundamentals. Additionally, for effective database queries, understanding conditional logic in data retrieval is crucial. Conditional logic, which is typically utilized in WHERE clauses, enables you to design dynamic searches, filter and group data according to certain criteria, and alter data as needed.

Continue reading to discover the fundamentals of the AND and OR SQL operators and see how to use dbForge Studio for SQL Server to work through some examples: 
https://www.devart.com/dbforge/sql/studio/sql-server-and-or-operators.html
Manual setup for a minimal Storybook
Tags: storybook, react, designsystem, typescript
Published: 2024-05-13 12:45:17

If you're having issues with the cli or you just want to know what you're installing then this is for you. I've put together what I consider the minimal setup. From there you can browse addons and docs to see how to enhance your setup.

Heres a video of me following the same steps:

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

I'll use bun here but replace with any package manager. 

Also this example uses [`react` with `vite`](https://storybook.js.org/docs/get-started/react-vite). If you're using a different framework you can swap `@storybook/react` and `@storybook/react-vite` for the alternative.

## Packages

Heres the minimal packages you'll need to get started with a react storybook.

```
bun add @storybook/react @storybook/react-vite @storybook/addon-essentials storybook
```

## Scripts

Add to your scripts in `package.json`

```json
"storybook": "storybook dev -p 6006",
"build-storybook": "storybook build"
```


## Configuration files

Add a `.storybook` folder with a `main.ts` and  `preview.ts`.

### main.ts

[Find the docs here](https://storybook.js.org/docs/configure) 

```ts
// .storybook/main.ts
import type { StorybookConfig } from "@storybook/react-vite";

const config: StorybookConfig = {
  stories: ["../src/**/*.mdx", "../src/**/*.stories.@(js|jsx|mjs|ts|tsx)"],
  addons: ["@storybook/addon-essentials"],
  framework: {
    name: "@storybook/react-vite",
    options: {},
  },
  docs: {
    autodocs: "tag",
  },
};
export default config;
```

### preview.ts

[Start here to learn about the preview](https://storybook.js.org/docs/configure#configure-story-rendering)

```ts
// .storybook/preview.ts
import type { Preview } from "@storybook/react";

const preview: Preview = {
  parameters: {
    controls: {
      matchers: {
        color: /(background|color)$/i,
        date: /Date$/i,
      },
    },
  },
};

export default preview;
```


## Example story

Lets add a component file

```tsx
// src/Button.tsx
export const Button = ({ text }: { text: string }) => {
  return <button>{text}</button>;
};

```

Then we create a stories file and import it there.

[Look here to learn about writing stories](https://storybook.js.org/docs/writing-stories)

```tsx
// src/Button.stories.tsx
import { Button } from "./Button";

export default {
  component: Button,
};

export const Primary = {
  args: {
    text: "Primary Button",
  },
};

```

## Run it!

Now run this to see your storybook in action.

```
bun run storybook
```

The final product should look like this:

![screenshot of the final storybook](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/1xqhkiup56bzobaibd0x.png)


## All done!

Thats the basics, now I recommend you explore the docs to learn more about how to customize storybook for your needs. Especially look into [interactions](https://storybook.js.org/docs/essentials/interactions#play-function-for-interactions) they are really nice.

Find me here:
twitter: [@Danny_H_W](https://twitter.com/Danny_H_W)
github: [dannyhw](https://github.com/dannyhw)
Cyber Resilience Act passed in EU....
Tags: security, canada, ai, customers
Published: 2024-05-13 12:41:14

In my opinion, it is interesting to observe the adoption of the [Cyber Resilience Act](https://www.europarl.europa.eu/doceo/document/TA-9-2024-0130_EN.html#title2) in Strasbourg in March12th (2024), and then to see the Canadian Center for Cyber Security (Cyber Center) [announce](https://cyber.gc.ca/en/news-events/joint-advisory-deploying-ai-systems-securely#defn-cyber-security) in April15th (2024) that they've joined the National Security Agency’s (NSA) Artificial Intelligence Security Centre (AISC), the Federal Bureau of Investigation (FBI) and others in releasing [guidance](https://media.defense.gov/2024/Apr/15/2003439257/-1/-1/0/CSI-DEPLOYING-AI-SYSTEMS-SECURELY.PDF) to deploying AI systems securely.

Based on my understanding, the established regulation addresses the following,

Challenges? 
- A low level of cybersecurity of products, reflected by widespread vulnerabilities, 
- An insufficient understanding & access to information by users preventing them from choosing products with adequate cybersecurity properties, 
- And, a fragmented legal landscape across EU member states.

Objectives?
- Uniformity of cybersecurity requirements,
- Increased transparency for users,
- And, empower businesses to produce a wide range of effective cybersecurity products.

My favorite takeaway is the unification of cybersecurity requirements for all EU businesses, particularly for microenterprises and small and medium-sized enterprises, which cuts red tape, frees up resources for innovation, and fosters a fairer market!

That said, I believe, with innovation accelerating- AI/ML security is a continuous cycle: identify risks, implement controls, and monitor for problems. Kindly refer to the sources below for specific actionable guidance.

Sources:
- Cyber Resilience Act: https://lnkd.in/gZ79UVrg
- Canadian Cyber Center accouncement: https://lnkd.in/gaNJSvhd
- NSA announcement: "Deploying AI Systems Securely", https://lnkd.in/gfWcvqsW
- Full guidence/report by NSA: https://lnkd.in/gSgMmrFB
Gen AI & Modern Data Strategy?
Tags: enterprisearchitecture, dataanlytics, softwaredevelopment, devops
Published: 2024-05-13 12:34:32

Why do some software systems feel siloed and clunky?

Conway's Law offers a surprising explanation: the design of a system often mimics the communication structure of the organization that built it. Siloed teams can lead to fragmented systems. 

To address this challenge, many organizations are turning to internal developer platforms… Gartner predicts that by 2026, 80% of large software engineering organizations will leverage internal developer platforms.

In my opinion, just as high-quality data fuels high-quality GenAI applications, the success of a data platform hinges on strong collaboration between software developers and operators?

Another implication of Conway's Law is that not all communication is helpful, and too much back-and-forth can hinder productivity.

I believe, besides inherent benefits such as smarter risk management and faster product development, a well-architected data(-mesh) platform following the data mesh communication model, can empower your organization to prioritize communication & collaboration! 

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

As illustrated in the image,
- Core Teams: The self-service data platform team and domain teams collaborate frequently for rapid development and efficient value creation.

- Enabler Teams: Governance, assets, and cloud foundation teams provide essential support to the platform while minimizing interaction with domain teams. This avoids overwhelming them with unnecessary communication.

- Executive Leadership: Leadership maintains a high-level view through infrequent updates from core and enabler teams, ensuring strategic alignment without micromanagement.

- Domain teams: Think of lines-of-business teams or team members with highly specialized skills.

In essence, I believe, by implementing a data platform that is simple, scalable, and open- organizations can unify their data and processes, hence, unlock better experiences for end-users, software developers, and operators. 

Sources:
Conway's Law: https://lnkd.in/dBf7TwwD
Gartner report: https://lnkd.in/dZgNmdyM
Data Mesh framework: https://lnkd.in/dm4hnMXy
Information on specific team roles and responsibilities: https://lnkd.in/d6ciAAGj
Mobile Application Development Company in Trichy
Tags: mobileapp, development, trichy, service
Published: 2024-05-13 12:19:50

Elevate your digital presence with 2KD2, a distinguished 
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/27dx60qum2df5lpw53ej.png)(https://2kd2.in/). Our seasoned team specializes in crafting innovative mobile solutions tailored to your unique needs. With a focus on quality and client satisfaction, we strive to deliver exceptional results that propel your business forward in the competitive digital landscape.
The Open Secret of Sovereign AI: Open Source vs. Closed Source Models?
Tags: ai, opensource, machinelearning, nvidia
Published: 2024-05-13 12:11:28

Larger or Smaller LLMs?
Multimodal or Specialized Models?
Inference budget or Training budget?
Latency or Capacity?
Performance & Interoperability or Model Size?
Closedsource or Opensource?
Will Shadow AI continue to rise?

Building on [Arthur Mensch's](https://www.linkedin.com/in/arthur-mensch/?lipi=urn%3Ali%3Apage%3Ad_flagship3_profile_view_base_recent_activity_content_view%3BN6eMikSvS%2Buapo85ncZKug%3D%3D) insights, we see the growing adaptability of models. The key takeaway is to prioritize tools that enable customers to fine-tune these models for their specific needs. This user-driven customization will unlock significant performance gains.

Hence why I also believe in open-sourcing models. 

Through research [Mistral AI](https://www.linkedin.com/company/mistralai/?lipi=urn%3Ali%3Apage%3Ad_flagship3_profile_view_base_recent_activity_content_view%3BN6eMikSvS%2Buapo85ncZKug%3D%3D) found, with better hardware and better models a certain level of latency (overall time taken by LLM to generate full response) can be reached, which shifted their perspective on LLMs as a, in my opinion, "single point of contact" entity to one that can operate in sovereignty?

Smaller, more portable LLMs, I believe have the potential to unlock better user-experience. In the words of Arthur (16:55): "Instead of having assistants that are talking to people... (Multimodal LLM) assistants that think on their own at a sufficient speed with a good user experience."

Excited for whats next!

[Amazing presentation](https://youtu.be/Vhl3Q-Oe5Ug?si=Fz4w9js9PW2rr-v7): 
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/29ewthoi7rdt1frvmtni.PNG)
I will setup baby kids newly born baby and mother shopify dropshipping shopify store
Tags: webdev, javascript, beginners, programming
Published: 2024-05-13 12:10:11

Are you looking for an ecommerce expert that will design high quality Baby Shop. you are at the right place.As a Shopify designer with all the skills and 5+ years of experience creating beautiful, professional, secure, and trustworthy Shopify dropshipping stores. 

If you have an existing Shopify website that needs a redesign, I can work with you to make the necessary changes to improve its performance.

Why Hire Me:

Shopify Certified Expert
5+ years of experience in Shopify Dropshipping Industry
100% Client Satisfaction
100% Professional Work
100% On-time Delivery
What you'll get:

Fully responsive Shopify website with Baby/Kids Clothing & Toys dropshipping products
Premium theme with stock images
Product Research & Supplier Integration
All Legal Pages (Terms of Service, Privacy Policy, Shipping/Refund Policy, FAQ, Contact)
Custom "About Us" Page aligned with your brand
Apps: Upsell, Reviews, Currency Converter, Live Chat, Loyalty Program, Instagram Feed, etc
Shipping Configuration
Professional Logo Design & Branding
Id be happy to discuss your Shopify store design before ordering.

 Order Now From 👉 https://www.fiverr.com/nurulamin099
SODA
Published: 2024-05-13 11:50:59

Soda,[카지노 사이트 주소](https://www.behance.net/denicebela) known as soft drink or carbonated beverage, is a type of beverage that typically contains carbonated water, sweeteners, flavorings, and sometimes caffeine. Here [온카패스](https://denicebela7.wixsite.com/my-site-1)some key components of soda:

Carbonated Water: Carbonated [인터넷카지노순위사이트 ](https://oncapass.com/%ec%98%a8%eb%9d%bc%ec%9d%b8-%ec%b9%b4%ec%a7%80%eb%85%b8-%ec%82%ac%ec%9d%b4%ed%8a%b8/)also known as soda water or seltzer water, is water that has been infused with carbon dioxide gas under pressure. This creates bubbles and[검증사이트](https://eemmaa4646.wixsite.com/all-about-casino) soda its characteristic fizziness.

Sweeteners: [바카라 보증사이트](https://www.tumblr.com/cookspot) sodas contain sweeteners to enhance their flavor and make them more palatable. Common sweeteners [안전365카지노](https://www.behance.net/travelbuddies1)in soda include sugar, high-fructose corn syrup, and artificial sweeteners like aspartame, sucralose, and saccharin.

Flavorings: Sodas come in a wide variety of flavors, ranging from traditional options like cola, lemon-lime, and root beer to more exotic flavors like cherry, grape, and orange. These flavors are typically achieved using natural or artificial flavorings.

Caffeine: Some sodas contain caffeine, a natural stimulant found in coffee, tea, and certain plants. Caffeine content can vary widely among different types of soda, with some containing little to no caffeine and others containing significant amounts.

Preservatives and Additives: Sodas may also contain preservatives, colors, and other additives to enhance their shelf life, appearance, and taste. These additives are often listed on the ingredient label of the soda.

Carbonation Process: The carbonation process involves dissolving carbon dioxide gas into the beverage under pressure. This creates bubbles that give soda its effervescent texture and characteristic fizziness.
Is Butterfly Clicking Good for PVP?
Published: 2024-05-13 11:49:26

Butterfly clicking is a new technique that has been gaining in popularity among PVP (player versus player) gamers. Some people swear by it, while others claim it is nothing more than a fad. So, what’s the verdict? Is butterfly clicking good for PVP?

Butterfly clicking is a very effective technique used by many PVP gamers. It involves two fingers, mainly the index and middle fingers. This technique allows players to move and attack more quickly, making it advantageous during fast-paced fights.
In this blog post, I will look at what butterfly clicking is, how it works, and whether or not it’s beneficial for PVP.

##What is Butterfly Clicking?
Butterfly clicking is a technique used by PVP gamers that involves rapidly slamming both your index and middle fingers, alternatively on the LMB (left mouse button). This technique allows gamers to move and attack quickly and chain combos with less effort.

This technique can increase the speed of your movements, giving you a huge advantage in fast-paced fights. Additionally, some gamers have reported that it decreases the amount of effort needed to chain combos and increases their accuracy.
Randomized Fun with Random.Shared.Shuffle and RandomNumberGenerator.GetString in C#
Tags: dotnet, dotnetcore
Published: 2024-05-13 11:39:50

In .NET 8 and C# 12, handling randomness has become more efficient and robust. The introduction of methods like Random.Shared.Shuffle and RandomNumberGenerator.GetString offers developers convenient and secure options for generating random data, whether it's shuffling an array or creating random strings. This article explores these methods with practical examples, highlighting their benefits. The full code sample is provided in the first comment.

#### Shuffling Arrays with `Random.Shared.Shuffle`

The ability to shuffle an array efficiently can be crucial in many applications, such as gaming or data analysis. Previously, developers often had to implement their own shuffle algorithms. Now, `Random.Shared.Shuffle` simplifies this task significantly.

##### Example:

```csharp
int[] array = { 1, 2, 3, 4, 5 };
Random.Shared.Shuffle(array);

foreach (var item in array)
{
    Console.WriteLine(item);
}
```

This code snippet demonstrates how to shuffle an array using `Random.Shared.Shuffle`. The `Random.Shared` is a thread-safe, shared instance of the `Random` class provided by .NET, suitable for most general purposes.

#### Generating Random Strings with `RandomNumberGenerator.GetString`

Generating cryptographically secure random strings is essential for creating secure passwords, tokens, and identifiers. `RandomNumberGenerator.GetString` allows developers to generate such strings from a specified character set.

##### Example:

```csharp
var allCharacters = "abcdefghijklmnopqrstuvwxyz0123456789";
var randomString = RandomNumberGenerator.GetString(allCharacters, 20);

Console.WriteLine(randomString);
```

Here, `RandomNumberGenerator.GetString` is used to generate a 20-character random string from a specified set of characters. This method ensures the randomness is suitable for security-sensitive applications, which is crucial for avoiding vulnerabilities related to predictable random strings.

### When to Use These Features

- **`Random.Shared.Shuffle`**: Ideal for shuffling arrays in scenarios requiring random order, such as in randomized trials or gaming.
- **`RandomNumberGenerator.GetString`**: Best used when cryptographically secure random strings are needed, such as for passwords, authentication tokens, or other security-sensitive functions.

### Conclusion

.NET 8 and C# 12 introduce robust features like `Random.Shared.Shuffle` and `RandomNumberGenerator.GetString` that enhance the ease and security of working with random data. These improvements not only streamline the development process but also bolster the security and reliability of applications that depend on randomness.

Embrace these new capabilities in your .NET projects to simplify your code and enhance application security.
Multi-Container Local Development Setup using DevContainers in VSCode
Tags: devcontainers, vscode, dockertutorial, docker
Published: 2024-05-20 04:21:09

---
title: Multi-Container Local Development Setup using DevContainers in VSCode
published: true
date: 2024-05-13 11:30:00 UTC
tags: DevContainers, VSCode, DockerTutorial, docker
canonical_url: https://www.devteds.com/devcontainers-for-developers-multi-container-local-dev-setup/
---

As an application or web developer, it’s crucial to have an isolated yet seamless local development setup, especially when managing multiple applications or codebases across various microservice apps built on different programming languages, versions, or frameworks.

{% embed https://www.youtube.com/embed/xfeQ6vDuidA %}

If you’ve used Docker for local development, you might be familiar with Docker Compose for handling multiple container setups. While this is helpful in many ways, it requires an extra step of entering a running container to execute ad hoc commands.

For instance, if you’re a Rails developer, you often need to run commands like rails generators, db migrations, rails runner, and especially the rails console. Similar challenges exist for most frameworks.

Imagine if you could open your editor in a container mode that loads the application environment and allow us to run application commands in the embedded terminal, without needing to run commands like `docker run`, `docker exec`, etc. This would make working within a containerized environment much easier.

One option that has worked well for my local development setup is the Dev Containers extension in VSCode. Not only does it allow you to load the application in VSCode within a container context, but you can also run dependency services (or other tiers of the application stack) as containers. The Dev Containers extension integrates smoothly with Docker Compose.

In this short tutorial, I’ll guide you through setting up a local development environment for an application that uses a database, both running as containers using Docker Compose and Dev Containers in VSCode. Here’s a quick breakdown of the steps you’ll learn in the tutorial:

1. Start by creating a `Dev Container` setup for your application
2. Create a web application using the `Dev Container`
3. Configure a multi-container setup with `Dev Container` for the application and database containers
4. Test and verify, mainly database container, using `Docker Desktop`
5. Link the application running as a container with the database running as another container
6. Conclude with a note on [Multi-Stage Docker Build](/shettigarc/building-production-ready-docker-images-with-multi-stage-builds-3pe4) with DevContainer & Docker Compose

Setting up a reliable local environment can significantly enhance productivity for app developers. I hope this short video tutorial proves helpful!
Illuminate Your Space with Efficiency: Explore the E14 Zigbee Bulb
Tags: bulb, zigbee, zigbeebulb, e14
Published: 2024-05-13 11:23:03

In the realm of smart lighting, the https://smart-in-home.com/product/e14-zigbee-bulb/ stands out as a beacon of innovation and efficiency. Designed to seamlessly integrate into your smart home ecosystem, this bulb offers a myriad of benefits that elevate your lighting experience.

One of the key features of the E14 Zigbee bulb is its compatibility with Zigbee technology. Zigbee enables seamless communication between devices, allowing for effortless control and automation. With the E14 Zigbee bulb, you can easily adjust brightness, set schedules, and create custom lighting scenes directly from your smartphone or smart home hub.

Beyond its connectivity, this bulb is also highly energy-efficient. Equipped with LED technology, it consumes significantly less power than traditional incandescent bulbs, helping you reduce your energy bills while minimizing your carbon footprint.

Installation is a breeze with the E14 Zigbee bulb. Simply screw it into any E14 socket, connect it to your Zigbee network, and you're ready to enjoy personalized lighting at your fingertips. Whether you're looking to set the mood for a cozy night in or brighten up your workspace for maximum productivity, this bulb offers unparalleled versatility.

Moreover, the E14 Zigbee bulb boasts impressive longevity, with a lifespan of up to 25,000 hours. Say goodbye to frequent bulb replacements and hello to years of reliable illumination.

With its blend of cutting-edge technology, energy efficiency, and ease of use, the E14 Zigbee bulb is a must-have for any modern home. Elevate your lighting experience and embrace the future of smart illumination today.