teleren/devto huggingface dataset:
Why you should use Azure Database for PostGreSQL storage
Tags: sql, azure, cloud, webdev
Published: 2023-01-17 17:37:07

January 13, 2023 by Mike Gearhardt, _CTO @ Fathym_ and Trevor Richardson, _Fathym Architect @ Fathym_



In this article: 

- Azure container instances are not usable to store PostgreSQL databases 
- Changing ownership is not supported with PostgreSQL 
- Azure Database is a better production deployment target for PostgreSQL storage 


## Azure Database for PostgreSQL storage advantages 

Azure provides a fully managed open-source database for PostgreSQL with up to 99.99 percent uptime, AI-powered performance optimization, and advanced security. However, different features of Azure need to be considered for storing your database. 

## Azure Container Instances is not a Solution 

Azure Container Instances (ACI) is a service provided by Microsoft Azure that allows users to easily run containers in the cloud without the need to manage any underlying infrastructure. 

Unfortunately, you can’t just use Azure Container Instances as a storage option for a PostgreSQL database.  

PostgreSQL requires the folder in which the volume is mounted to be owned by a different user, not the “root” user. Azure Container Instances must use Azure FileShares as their volume mounts, and these do NOT support the "chown" command for changing ownership. 

That’s why you can’t simply use Azure Container Instances as a storage option. 

While you could potentially use Azure Container Instances to host a PostgreSQL database by building a custom container image that includes PostgreSQL, this would not be a recommended production deployment target because you would be responsible for managing the database infrastructure yourself. 

## Use Azure Database 

A better option for storing a PostgreSQL database in Azure would be to use a managed service such as Azure Database for PostgreSQL.  

Azure Database for PostgreSQL is a fully managed database service that makes it easy to deploy, scale, and manage PostgreSQL databases in the cloud. It handles the underlying infrastructure and maintenance tasks, such as patching and backups, so you can focus on developing and deploying your applications. Additionally, it offers several performance and availability options that can be tailored to meet the specific needs of your applications. 

Overall, it is not advisable to use Azure Container Instances as a storage option for a PostgreSQL database due to the "chown" requirement of PostgreSQL. Instead, consider using a managed service like Azure Database for PostgreSQL to ensure a reliable and scalable solution for storing your database in Azure.
What is Web Development ?
Published: 2023-01-17 17:16:42

Nowadays as we see we are just doing our work from home for that we do tasks online.
As many people are used to creating their own business , we use websites for interacting with users and showing our project. As we see nowadays, education is going to be online because we have websites or apps in which we take classes and we have many more websites like Amazon and Flipkart for online shopping.
From above we know that for any work we need a website.

**Web development : **
 Web development refers to the creating, building, and maintaining of websites. It includes aspects such as web design, web publishing, web programming, and database management. It is the creation of an application that works over the internet i.e. websites.

_**Web Development can be classified into two ways:**_

**Frontend Development :** The part of a website that the user interacts directly is termed as front end. It is also referred to as the ‘client side’ of the application.

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

**Backend Development :** Backend is the server side of a website. It is the part of the website that users cannot see and interact. It is the portion of software that does not come in direct contact with the users. It is used to store and arrange data.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ybye8hse1aq3cnsbrt21.png)
Connecting to Private RDS Databases From Your Local Machine
Tags: aws, rds, vpc, ssh
Published: 2023-01-17 17:14:10

The following shows you how to connect to Relational Database Service (RDS) database instances in private Virtual Private Cloud (VPC) subnets from a local machine using EC2 bastion hosts and AWS Systems Manager (SSM) instead of using SSH directly. It assumes,

1. You have an EC2 instance running.
1. You have security groups configured so the EC2 instance has access to the RDS database.

If either of those isn't the case, follow those two steps in [this article](https://aws.amazon.com/premiumsupport/knowledge-center/rds-connect-ec2-bastion-host/) and then head back here.

If you let AWS store your database secrets in **Secrets Manager** when creating the database, all connection information is in the secret.

## From the AWS Console

1. From the **Secrets Manager Console**, select to database secret.
1. Select **Retrieve secret value**, you'll need **host**, **dbname**, **username**, and **password** in the following steps.
   ![Secrets Manager](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/5gn0szlt4jq91bc1has8.png)
1. From the **EC2 Console**, connect to the EC2 instance with access to your database using **Session Manager**.
1. From the launched terminal, run the following. This is specific to PostgreSQL, but you run equivalent commands for your database.

   ```bash
   # Install postgresql
   sudo amazon-linux-extras install -y postgresql14

   # Connect using the values copied in step 2
   # After entering it, you'll be prompted for the password
   psql -h [YOUR_HOST] -d [YOUR_DB_NAME] -U [YOUR_USERNAME] -W
   ```

   ```sql
   -- List tables
   \dt

   -- Run your favorite queries
   SELECT * FROM [YOUR_TABLE];
   ```

You're connected! But we can do better.

## From the command line

1. Run the following to see if you have `session-manager-plugin` installed. If you don't, [run the commands here](https://docs.aws.amazon.com/systems-manager/latest/userguide/session-manager-working-with-install-plugin.html#install-plugin-macos-signed) to install it.

   ```bash
   session-manager-plugin --version
   ```

1. To start the SSM session, you need the EC2 instance ID. You can either get it from the AWS Console, or run the following with appropriate filters if you have lots of instances. The following assumes you have [jq](https://stedolan.github.io/jq/) installed and have instance tags.
   ```bash
   aws ec2 describe-instances \
     --profile [YOUR_PROFILE] \
     --filter Name=tag:[YOUR_TAG_KEY],Values=[YOUR_TAG_VALUE] \
     | jq -r '.Reservations[].Instances[].InstanceId'
   ```
1. Given the EC2 instance ID, run the following to start the session,
   ```bash
   aws ssm start-session \
     --profile [YOUR_PROFILE] \
     --target [YOUR_INSTANCE_ID]
   ```

You're connected from your own terminal! Now, run the commands in step 4 above to connect to your database and start executing queries.
Library is my name
Tags: webdev, beginners, codenewbie
Published: 2023-01-17 17:07:59

Hi 👋

**Library** is my name.

I am a modular tool used as part of an app's add-on feature.

In other words, I am like your cloth, which you use as an add-on feature on your body.

![Framework depicted with a skeleton](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/sszolwb46qn7mdqup8nb.jpg)
<figcaption>
Your cloth is your body's add-on feature. Similarly, a library is an app's add-on feature. (Image by Lothar Dieterich)
</figcaption>

Visit [CodeSweetly](https://codesweetly.com/framework-vs-library) to find out more about me.
Display Images In React
Tags: react, webdev
Published: 2023-01-17 17:03:43

While this post is a summary of a longer [post on Medium](https://medium.com/p/8ff1f5b1cf9a), it contains all you need to display images using React.


![React logo](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/sziup4s0n0zsl9khff1c.png)


## Images In Source Folder
The first way to import images in React is by adding them to the source folder of your application.

Thanks to webpack, it is possible to import a file right in a JavaScript module.

```
import logo from './logo.svg'

function App() {
  return (
    <div>
      <img src={logo} className="App-logo" alt="logo" />
    </div>
  );
}

```

### Using CSS
If the image is inside the src folder, you could also add it using CSS as follows:

```
.logo {
  background-image: url(./logo.png);
}
```

## Images In Public Folder
The second way to import images in React is by adding them to the public folder of your application.

Using the public folder allows us to reference the image in an image tag.

This is a key difference! Files placed in the public folder will be accessible to the client at the root of the application.

Everything inside the public folder is available to the app, so we can simply point the src property of the image tag to the correct location of the file.

```
function App() {
  return (
   <div>
     <img src="./logo.svg" className="App-logo" alt="logo" />
   </div>
  );
}
```

## SVG as ReactComponent
If you are using React v16.3 or higher you can also import SVGs directly as React components.

```
import { ReactComponent as Logo } from './logo.svg'

function App() {
  return (
    <div>
       <Logo />  // React Component
    </div>
  );
}

export default App;
```
Resume Writing Secrets: 25 Tips to Get You Hired
Tags: career, webdev, beginners, codenewbie
Published: 2023-01-17 17:02:10

![Hot resume tip](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/91zjwcaexnm71nva4dw3.png)

In the last 5 years I received interview calls from 200+ tech companies.

Over this period I perfected my resume one tiny improvement at a time.

I have documented my learnings in 25 tips that I learnt too late. 🥲

These will help you in leveling up your resume and help past mandatory screening test from recruiters.

Let's dive in 🚀

1. Projects + Results > Any college degree.

2. Prove with your resume that you read the job description.

3. Best resumes are highly scannable.

4. Your resume should be visually appealing.

5. Just mention things that are required for the job role.

6. Add project links in your resume for employers to know more.

7. Technical skills is the most important section. Put it first.

8. Use numbers to quantify your experience but avoid percentages.
<img width="100%" style="width:100%" src="https://media.giphy.com/media/jwFbMfYthIM6pttfjF/giphy.gif">

9. Avoid use of pronouns, long paragraphs, change of tenses.

10. Aim to make your resume 1 page long. Max 2.

11. Spelling mistakes can cost you an interview. Use spell checker.

12. Gather feedback on your resume from peers.

13. Keep information in reverse chronological order. I.e most recent detail first.

14. Don’t try to mislead with your resume. It will hurt in the long term.

15. Less general claims. More specific outcomes.

16. Always test all the mentioned links before sharing your resume.
<img width="100%" style="width:100%" src="https://media.giphy.com/media/l2R098V90nJfuHKg0/giphy.gif">

17. You look more qualified by being concise.

18. Use consistent layout and typography.

19. Outdated resume = Missed opportunity.

20. More than work, highlight what measurable impact it created.

21. Mention explicitly if you are proficient or just familiar with the technology.

22. Make sure stuff in your resume matches with your LinkedIn.

23. Any open source or community contribution is a BIG plus. 

24. Cut the fluff. Aim for simple and to the point details.

25. And most importantly — Be yourself.

That's it!

Hope you found these tips helpful.

If you liked this post, follow me for more of these 🙂
Also, would love to hear your best resume tip in comments 👇
I acquired my first company for $5000
Tags: data, api, nocode, acquisition
Published: 2023-01-17 16:55:32

---
title: I acquired my first company for $5000
published: true
description: Why build when you can buy? The reasons behind my micro-acquisition.
tags: data,api,nocode,acquisition
cover_image: https://dev-to-uploads.s3.amazonaws.com/uploads/articles/3s6nx8zlev0zqbb6q7ji.png
# Use a ratio of 100:42 for best results.
# published_at: 2023-01-17 14:57 +0000
---

Hello there, my name is Louis, and for the first time, I'm not starting (completely) from scratch. I bought [quickapi.io](https://quickapi.io/) from @mddanishyusuf a few weeks ago.
Yes, [I bought a company on Twitter](https://twitter.com/mddanishyusuf/status/1596155000321118208). It may seem risky, but I actually was following Danish's journey for the last year, which contributed a lot to building trust.

## Why build when you can buy?

- Domain name alone is probably worth $5k.
- 250 (free) users
- The product itself is working without requiring dev time
- Side-riding Mohd's recognizable and trustworthy brand.
- Most importantly: I had $5k I could spend without risking my lifestyle.

I've been launching many different projects in the last 2 years, and none have generated significant revenue. So how about I throw even more money out the window, you ask?
aka: so you think this will work this time?

Yes and no.

Yes, because I've learned a ton in the last 2y. Not from people, but from experience. [Practice is the only way](https://www.indiehackers.com/product/jobtitlesai/from-6-months-down-to-1-practice-launching--NImKanen8anpbwvuOr4). For one, I've stopped shipping countless features unless I've understood who they are for.
Also, I wouldn't spend time on it if I didn't think it would work.

No, because I know it's a game of stats. Many know that people considered successful [have launched lots of projects](https://twitter.com/tibo_maker/status/1614967014031822848) before.

Anyway. It's just the start. Happy to answer questions about the acquisition process, Quick API, or any other topic.
IOT Overview
Tags: iot, connecteddevice
Published: 2023-01-17 16:39:57

The Internet of Things (IoT) is a rapidly growing technology that is changing the way we interact with the world around us. IoT refers to the interconnectedness of physical devices, vehicles, buildings, and other items embedded with electronics, software, sensors, and connectivity which enables these objects to connect and exchange data. This connectivity allows for the collection and sharing of data from these devices to improve efficiency, accuracy, and overall quality of life.

IoT technology is being used in a wide range of industries, such as healthcare, transportation, manufacturing, and smart cities. In healthcare, IoT devices such as wearable fitness trackers and smart pills can collect data on a patient's health and transmit it to healthcare providers for analysis. In transportation, IoT technology is being used to improve traffic flow and reduce accidents through connected cars and smart traffic lights. In manufacturing, IoT technology is being used to improve efficiency and reduce downtime through predictive maintenance and automated processes.

IoT technology is also being used to create smart cities, where interconnected devices and systems are used to improve the quality of life for citizens. This includes things like smart streetlights that adjust their brightness based on the time of day and traffic flow, and smart waste management systems that can alert garbage truck drivers to pick up trash only when necessary.

The future of IoT is expected to be even more impactful, as more and more devices become connected and the amount of data generated continues to grow. IoT technology is expected to revolutionize the way we live and work, by providing insights and efficiencies that were previously unimaginable. This is why many companies and governments are investing in IoT, to stay ahead of the competition and to be ready for the future.

Overall, IoT is a promising technology that has the potential to bring about significant changes in various fields. However, as with any new technology, there are also some concerns like security, privacy, and integration with existing systems. It's important to address these concerns and make sure the technology is used in a responsible and ethical way.
FOSS Spotlight: 👻 Ghost
Tags: selfhosted, blogging, opensource, node
Published: 2023-01-17 15:51:57

[Ghost](https://ghost.org/) ([code](https://github.com/TryGhost/Ghost)) is blogging software that rivals [Wordpress](https://wordpress.org/) in it's ease of use – businesses all over the world use Ghost free of charge and also via Ghost's hosted platform [Ghost(Pro)](https://ghost.org/pricing).

Ghost makes it easy to build blogs, newsletters, landing pages, portfolio pages and more. It's extremely flexible, well known and easy to use:

![Ghost screenshot](https://awsmfoss.com/content/images/size/w1000/2022/10/image.png)

Ghost provides an alternative to paid services like [Substack](https://substack.com). In fact, this newsletter itself runs on Ghost – it's great software.

## Running Ghost

Ghost has an [official docker image](https://hub.docker.com/_/ghost) (note the "OG" `/_/<container>` URL!), and is *really* easy to run, as it defaults to SQLite which is a breeze.

If you want to get started *really* quickly:

```console
docker run \
  -d \
  -p 3001:2368 \
  -v /path/to/ghost/blog:/var/lib/ghost/content \
  --name ghost \
  ghost:alpine
```

Make sure to get your content path (and `docker` volumes) straightened out before expecting that setup to stick around!

For large production sites you're probably going to want to use MySQL rather than SQLite, but for most sites SQLite will probably hold up well also!

This was originally posted on [AWSM FOSS](https://awsmfoss.com/ghost-post/) (the first edition!)
Remotely update your Luos Bootloader
Tags: tutorial, community, luos, microservices
Published: 2023-01-17 16:28:17

One of our maintainers Viktoria created a new video about the Luos Bootloader!

💬“I am using the Luos Bootloader to flash my NUCLEO-G431KB, but I want to upgrade the version of the bootloader. I am doing this by first flashing a bootloader updater in the place of the application, which works like the original one. Then, I will reflash the board with the new bootloader in the place of the old one.”

[Check out](https://discord.com/channels/902486791658041364/902937219411607602/1049365592290893914) her video and follow the process
Earn immediate income by answering simple questions about code snippets.
Tags: offers, career, programming, ai
Published: 2023-01-17 16:21:15

We're an AI startup in San Francisco looking to hire a large team of remote reliable programmers. This role will be open for at least 3 months and may continue for longer.

Compensation will be competitive and commensurate with experience. 

Candidates must know at least one major programming language and be fluent in computer science concepts. Your task will be to answer technical questions about code snippets in plain English.

Successful candidates should have strong English skills and a programming background.

Have any friends who might be interested?
Earn $50 per person you refer who we decide to hire!

Link to share: https://airtable.com/shr0vcTJmBn28aYv8
An Introduction to solc-js
Tags: web3, blockchain, solidity, ethereum
Published: 2023-01-17 16:17:27

solc-js is available as a npm package with the name solc. You may install the solc-js npm package locally or globally just like any other npm package. If this package is installed globally, then solc-js, a command-line utility, will be accessible. 

So, to install the command-line utility, perform this command in the command prompt:

```npm install -g solc```

Now go ahead and run this command to see how to compile solidity files using the command-line compiler:

```solcjs —help```

To compile a solidity file and get the byte code, go to the directory where you have stored the .sol file and type the following command:

```solcjs —bin <filename>.sol```

To get the ABI for the file, type the following command in the directory where you have stored the .sol file:

```solcjs —abi <filename>.sol```


For more content, follow me on - https://linktr.ee/shlokkumar2303
Learn how to build apps with LiveChat Developer Platform 🧐
Tags: javascript, beginners, tutorial, career
Published: 2023-01-17 16:16:21

## Hi!

## Welcome to our guide to building LiveChat apps! 👋

This course from our [Developer Program](https://developers.livechat.com/developer-program/?utm_source=dev.to&utm_medium=referral&utm_campaign=LCI-Building-LC-Apps) is a great way to improve your skills as a junior dev, create your first apps and build passive income by selling them to our users via our [Marketplace](https://www.livechat.com/marketplace/?utm_source=dev.to&utm_medium=referral&utm_campaign=LCI-Building-LC-Apps).

If you want to take your first steps in building applications, but don’t feel that you have all the knowledge you need to start, it might be the thing just for you. The course is **entirely free**, shows step-by-step how to build your app in the Developer Console, and gives you some general **programming tips and techniques you can use in the future.**

{% embed https://www.youtube.com/watch?v=kxNtckTJKCQ %}

### During the course, you’ll learn:

- How to create an app from start to finish
- Best programming practices
- How to effectively use the LiveChat API
- Superb developer tools to facilitate your workflow
- Different hosting options and how to use them
- How to excel at the LiveChat app review
- Monetization options at the LiveChat Developer Program

## Lesson 1: Plan out the app development process

We’re glad that you want to go through this journey with us!

**From this lesson you will learn:**
- how to plan your app development.
- the technologies you can build with at LiveChat.
- preparing the environment for the training app.
- the tools useful for app development.
- good practices before you start your work.

{% embed https://www.youtube.com/watch?v=ncKVOy2OSbw %}

Stay calm, tomorrow we’ll be back with the next lesson! We will show you LiveChat API in practice 👌

You can also visit [our site](https://developers.livechat.com/building-apps-crash-course/?utm_source=dev.to&utm_medium=referral&utm_campaign=LCI-Building-LC-Apps) for the whole course 🧐

If you have any questions, let us know in the comments 🙏