teleren/devto huggingface dataset:
Structure of Postgres Database
Published: 2023-03-15 09:08:57

PostgreSQL is a powerful, open-source object-relational database system that uses and extends the SQL language. It combines many features to safely store and scale even the most complicated data workloads. It is highly reliable, stable, scalable and secure system and it has been around for more than 2 decades.

## Logical Structure
A database cluster is a collection of databases that is managed by a single instance of a running PostgreSQL server. It does not mean "a group of database servers". 

![Logical Structure of Database Cluster](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/xle4adr804ofg9169gic.png)

A database is a collection of database objects, which is a data structure used either to store or to reference data. In PostgreSQL, database themselves are also database objects and are logically separated from each other and other database objects, for example tables, indexes etc. belong to their respective databases.
Databases objects are internally managed by respective **object identifiers (OIDs)**. These are unsigned 4-byte integers. **System catalogs** stores the relation between database objects and OIDs. For example, OID or database is stored in _pg_database_.

## Physical Structure

A database cluster is single directory called as base directory and it contains more subdirectories and files. _initdb_ initializes a new database cluster.
A database is a subdirectory in base subdirectory and tabes and indexes are files stored under the subdirectory of the database.
![Database Cluster](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/51ctv12a86z5ve8xi2vb.png)
A _tablespace_ in PostgreSQL is an additional data area outside the base directory. Its meaning in PostgreSQL is different from other RDBMS. A tablespace is created under the directory with the command CREATE TABLESPACE, and under that directory.

## Heap Table File
Data file is divided into pages of fixed length with the default size of 8192 byte. These pages are numbered sequentially from 0 and are called block numbers. The layout of pages depends on the data file types.

![Layout of heap table file](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/sgej95thqi2fg7zej1zj.png)
A page within a table contains three types of data, heap tuple, line pointer and header data. A heap tuple is a record data itself. They are stacked in order from the bottom of the page. Line pointer holds pointer to each heap tuple. They form a simple array. Header data contains the general information about the page.
There are some empty spaces between end of line pointer and beginning of new tuple. These are called **free space** or **hole**. **Tuple Identifier (TID)** is used to identify a tuple. It comprises of block number of the page that contains the tuple and the offset number of the line pointer that points to tuple.
Missing meta description on crawling
Published: 2023-03-15 10:59:59

Hi,
I'm facing an issue on one of angular project. There are various meta tags and one of them is description one. We used crawler softwares to crawl the Angular website. However the issue that we are facing is that crawling software is not recognising the meta description tag. Hence while searching the site on google, it returns random code/string. Any way to look around it? We built the application using angular 12 and Drupal 9. We used SSR for creating a build.
#Devdoubt-React
Tags: react, frontend, help
Published: 2023-03-15 10:55:29

Hello devs! I hope you are doing well. 

I came across this piece of code from chakra UI, and I'm trying to understand what is the point of doing this or in which cases is it useful? 

```tsx
export function useCallbackRef<T extends (...args: any[]) => any>(
    callback: T | undefined,
    deps: DependencyList = []
) {
    const callbackRef = useRef(callback)

    useEffect(() => {
        callbackRef.current = callback
    })

    // eslint-disable-next-line react-hooks/exhaustive-deps
    return useCallback(((...args) => callbackRef.current?.(...args)) as T, deps)
}
```
Wednesday Links - Edition 2023-03-15
Tags: kotlin, profiling, alpine, gradle
Published: 2023-03-15 10:54:10

Really useful 4 lines of Kotlin code (2 min)✨
https://void2unit.onrender.com/post/inline+password/

Kotlin Isn’t Null-Safe Yet. Here Are 3 Gotchas (5 min)🙈
https://betterprogramming.pub/kotlin-isnt-null-safe-yet-here-are-3-gotchas-23258fada62

Why I Will Never Use Alpine Linux Ever Again (6 min)🙈
https://martinheinz.dev/blog/92

Do You Trust Profilers? I Once Did Too. (6 min)🙈
https://foojay.io/today/do-you-trust-profilers-i-once-did-too/

How Gradle Works Part 3 - Build Script (3 min)⚙️
https://blog.gradle.org/how-gradle-works-3
passing Props through link componet
Tags: webdev, react, javascript, opensource
Published: 2023-03-15 10:51:54

this is my line of code where iam mapping some items fetching from API 

```
<div style={{ display:"flex",flexWrap:"wrap",justifyContent:"center"}}>
{games.length===0?<p className='nomatch'>No Matching Results</p>:games.map(({title,thumbnail,id,gameurl,freetogame_profile_url,platform,short_description,publisher,developer
})=>{

  return <div  key={id} style={{display: 'flex', justifyContent: 'center'}} >
  <div style={{width: '300px', height: '300px', backgroundColor: '#fff',margin:"20px", borderRadius: '5px', display: 'flex', flexDirection: 'column', alignItems: 'center', boxShadow: '0px 0px 10px rgba(0, 0, 0, 0.1)',border:"2px solid rgb(245, 6, 133)"}}>
    <img src={thumbnail} alt="Game 1" style={{width:"297px",height:"187px"}} />
    <h3 style={{textAlign: 'center'}}>{title}</h3>
    <div style={{display: 'flex', justifyContent: 'space-around',marginTop:"12px",  width: '100%'}}>
    <Link to={{
  pathname: `/games/${id}`,
  state: {short_description:short_description}
}}>
      <button style={{backgroundColor: 'rgb(245, 6, 133)', color: '#fff', padding: '10px 20px', borderRadius: '5px', border: 'none', cursor: 'pointer'}}>View</button>
     </Link>

```
When we click link componet we will be directed to GameDetail.js Componet in my app how i will used these state values in my GameDetail.js Componet plz help me if there is any particular concept
What are the most trending dev topics for 2023 in your view?
Tags: webdev, discuss
Published: 2023-03-15 10:37:31

Hi, I am new to the dev field and I am searching for ideas for up-to-date articles, so I decided to ask here - what are the most trending dev topics for 2023 according to your point of view? And more importantly, why would you say so? Thanks for all the insights and for having me here :]
Process and Memory Management
Tags: apacheage, postgres
Published: 2023-03-15 10:14:06

## Processes in PostgreSQL
PostgreSQL is a client/server type relational database management system with multi-process architecture, and it runs on a single host. A 'PostgreSQL Server' is a collection of multiple processes that cooperatively manage one database cluster.
Types of Processes:

1. **Postgres server process:** parent of all processes on the database cluster management
2. **Backend Process:** handles all queries and statements issued by a client
3. **Background Processes:** performs process of each feature, e.g. VACUUM and CHECKPOINT
4. **Replication Associated Processes:** performs the streaming replication
5. **Background Worker Process:** performs any processing implemented by users

We will now see 3 of the most important process in detail.

### Postgres Server Process
It is the parent of all the process in the PostgreSQL server. After start up it allocates a shared memory area in memory, starts various background process, starts replication associated processes and background worker processes. It also waits for the connection requests from the clients and on receiving a request it starts the backend process which in turn handles all the requests.
### Backend Process
It is the process which handles all the queries by connected clients. It is started by Postgres Server Process. TCP is used for the communication with the clients. This process is allowed to operate on a single database, so it is important to specify the database for connection. There can be multiple connections up to the _max_connection_.
### Background Process
These processes performs specific functions of the PostgreSQL and all the processes depends on the specific features. For example, _background writer_ writes dirty pages on a shared buffer pool are written to a persistent storage, _checkpointer_ performs the checkpoint function, _WAL writer_ periodically writes and flushes  WAL data from the WAL buffer to the persistent storage, _logger_ writes error messages into log files.


![Process Architecture](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/tjbndnyrqg2s74tx2gj9.png)

## Memory Management in PostgreSQL

![Memory Architecture](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/z5kyul5kzwtbo1241pq9.png)
PostgreSQL has broadly two types of memory:
1. **Local Memory Area:** This is the memory which is allocated by each backend process for its local use like for query processing. The memory is divided into sub-areas with either fixed or variable sizes. For example, _work_mem_ for operations like ORDER BY, DISTINCT or joining, _temp_buffers_ for storing temporary tables.
2. **Shared Memory Area:** It is allocated by a PostgreSQL server at start up. This memory is also divided into sub-areas with either fixed or variable sizes. For example, _share buffer pool_ for loading pages within tables, _WAL buffer_ to implement Write Ahead Logic, _commit log_ to keep states of all transactions. 
PostgreSQL also allocates several areas for access control mechanisms (e.g. semaphores, locks), for background processes and transaction processing.
Tech Event for Women in Japan and around the World
Tags: wecoded, womenintech, career, programming
Published: 2023-03-15 10:13:25

There is an programming event for women in Japan. At first, I assumed this was due to the low number of female engineers in Japan, but I have since discovered that similar events take place all around the world. 

🎯 CTF for GIRLS (Japan) [1]
🎯 Women Coders Contest Indeed 2022 (Japan, Singapore, India) [2]
🎯 Women in ML Symposium 2022 (Online) [3]

Various other women-only events are also listed on womenhack [4].

Our lab has many female members, including current and alumni. If you know of any events in your country that align with the philosophy of WeCoded 2023, we would appreciate it if you could share that information with us. Such knowledge will undoubtedly benefit others.

Lastly, it's not just women who face obstacles in the tech industry. LGBT individuals also experience discrimination. Although I am only a student and cannot do much, I hope for progress and acceptance for everyone in the field.

## P.S.
In the well-known Pokemon series that everyone is familiar with, it is no longer necessary to choose a gender. I think it's a great consideration by Nintendo, a leading technology company in Japan. I hope that other companies will follow suit in the future.


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



## Reference

[1] CTF for GIRLS, <http://girls.seccon.jp/>, Last Access:2023/03/15

[2] Women Coders Contest Indeed, <https://womencodersindeed.com/india?utm_source=&utm_medium=&utm_campaign=&utm_term=&utm_content=>, Last Access:2023/03/15

[3] Women in ML Symposium 2022, <https://eventsonair.withgoogle.com/events/women-in-machine-learning-2022>, Last Access:2023/03/15

[4] womenhack, <https://womenhack.com/events/>, Last Access:2023/03/15
2023 IoT Webinar Starts 5 hours from now
Published: 2023-03-15 10:11:16

Hi Engineer,

The 2023 IoT Webinar Starts in 5 hours from now, be there with us!

Discover the latest trends in IoT with expert engineers from RT-Thread, NXP Semiconductors, STMicroelectronics, and WCH Electronics. It's going to be an exciting session, don't miss out!

Free register to join us: http://bit.ly/3RQGvcV

The 2023 IoT Contest follows the IoT Webinar that will be launching today, there are over **60 free hardware and cash prize** prepared for the participants. We are already in the Party spirit see you all soon!
Tell us about your success stories with a GitHub Copilot subscription
Tags: githubcopilot, webdev, programming
Published: 2023-03-15 10:03:54

Over the past month, I've been seriously thinking of paying the yearly $100 subscription for GitHub Copilot, but I really want to be convinced it's worth that amount of money.

Can you share any examples where and how GitHub Copilot actually helped you in your project (ideally a big one, at your workplace)?

I've read a lot about it, gained decent understanding, even used it during my free trial period on a work project, and my opinion is really split - it can help a lot, but I can also find a solution myself, unless I'm working on a less familiar library/framework/programming language.

Thank you so much, and I'm looking forward to engaging with you!
Flexify v0.1.4 has been released🔥
Published: 2023-03-15 09:54:23

---
cover_image: https://dev-to-uploads.s3.amazonaws.com/uploads/articles/itqwmlc5o5ejvjp3ijmq.png
---

New release everyone,

Today, I have added the following features:

- Allow users to change the font weight, and style.
- Hide the cursor in ADHD mode for readability.
- Add align justify option.

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

## Resources

{% embed https://github.com/wiseaidev/flexify %}

{% embed https://github.com/wiseaidev/flexify-landing-page %}

Until next time!
A Curated directory of open source Kubernetes tools & resources
Tags: kubernetes, opensource, microservices, programming
Published: 2023-03-15 09:30:46

Hey there 👋

I've been trying to wrap my head around the Kubernetes tool ecosystem for the past few days, and decided to put together a list of interesting open source tools to explore and eventually try.

You can [check it out here](https://www.fyck.io/resources/kubernetes-tools).

I'll try to keep this list updated by adding 10 new tools & resources every month as well as removing deprecated/outdated ones.

I'd love your help growing and improving the directory. So if you have any suggestions, [send them my way](https://forms.gle/23PHdgudRo8CiKms8) :D

Cheers!
Integrate Facebook Conversion API and Meta Pixel with a click
Tags: wordpress, startup, beginners, tooling
Published: 2023-03-15 09:14:04

Hello Everyone,

We have built a no-code tool to integrate Facebook CAPI and Meta Pixel along with GA4, and 6 other marketing pixels. Our tool helps you to sync 100,000+ products to GMC with a click.


Checkout our product at https://www.conversios.io/
I asked ChatGPT to generate a song about centering a div
Tags: watercooler
Published: 2023-03-15 09:07:28

[Verse 1]
I'm a Frontend dev, with my code so tight
I'm gonna center this div and make it look just right
No matter the browser, no matter the view
I'll make sure it's centered for both me and you  

[Chorus]
Centering divs, it's my bread and butter
Centering divs, making everything smoother
With Margin auto and Text align in sight
I'll keep on coding until the design is just right

[Verse 2]
I'm a Frontend dev, with skills that run deep
I'll squash those bugs and make the layout so neat
With my CSS skills, I'm not afraid to take a chance
And keep coding until the site is a visual dance

[Chorus]
Centering divs, it's my daily routine
Centering divs, making the website gleam
With Flexbox, Margin auto and Text align
I'll keep on coding until the design is divine

[Bridge]
Whether it's a website, an app, or a game
I'll make sure it looks good and always the same
Centered, aligned, and with style in tow
My CSS skills will make it shine and glow

[Chorus]
Centering divs, it's the name of the game
Centering divs, always making it look the same
With Flexbox, Margin auto, and Text align
I'll code until the design is simply divine.
Inspiration for your coding journey
Published: 2023-03-15 09:00:55


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/qld89yow2hl16a1quhzg.png)
In the first episode of our Developer Nation Broadcast we welcomed Lars Bergstrom, Director of Engineering at Google who gave us an idea of how he approaches interviews in his current position and what are the things he is expecting to see from a candidate and/or an new recruit. 

_“When we're doing our interviews, what we're looking for is, whether you can take an understand a problem and begin to work on it with some amount of mentoring and guidance, but generally in a productive way where you can do a bunch of work independently, given enough of the structure for what that particular problem is.”_

Listen to the entire episode [here](https://podcasters.spotify.com/pod/show/developer-nation-br/episodes/EP-02-Featuring-Lars-Bergstrom--Director-Of-Engineering-at-Google-e1vo3mc/a-a9dvstj?utm_source=DN_devto&utm_medium=DN_Social&utm_campaign=Podcast_2023_Episode)
Dockerfile for a node app
Published: 2023-03-15 08:51:51

```
FROM public.ecr.aws/docker/library/node:16 as builder
WORKDIR /app
COPY . .
RUN npm ci
RUN npm run build

# Using multi-stage build, take only static web assets and place them in a nginx container
# Bundle static assets with nginx
FROM nginx:1.23.2-alpine as production
# Copy built assets from `builder` image
COPY --from=builder /app/build /usr/share/nginx/html
COPY nginx.conf /etc/nginx/conf.d/default.conf
EXPOSE 80
# Start nginx
CMD ["nginx", "-g", "daemon off;"]
```

nginx.conf

```
server {
  listen 80;

  location / {
    root /usr/share/nginx/html/;
    include /etc/nginx/mime.types;
    try_files $uri $uri/ /index.html;
  }
}
```
Furr Facts
Tags: android, flutter
Published: 2023-03-15 08:49:14

[Play store link](https://play.google.com/store/apps/details?id=com.theuntoldapps.furrfact)
Furr Facts is just for fun. We love both cats and dogs.
- Do you just love cat/dogs or know someone who does?
- Do you want to start a conversation with someone and looking for an ice-breaker?
- Do you want to annoy your friends with some random trivia?
We have got you covered!
This app is a collection of fun and educational facts about our favorites - dogs and cats


This app is free of cost with only one optional ad. We have made our best efforts to not let it interfere with your experience.

Features
- View hundreds of facts about your favorite fur animals
- Collect your favorites separately
- Share a fact that you find interesting with your friends and family
- Choose from the limited collection of background images for your viewing experience

Tech Stack:
 - Flutter
 - Data is largely stored on app package itself. 

Future vision:

If this experience gets good feedback add more content, and variety of topics to choose from.

Current implementation stores things on app package itself(objectbox primarily). It can be easily extended to use something like firebase.
Recent Learnings
Tags: webdev, programming, journey, learnings
Published: 2023-03-10 22:36:01


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

As a web developer, I constantly update my knowledge and skills to keep pace with the dynamic web development industry. Recently, I have broadened my skill set by learning various web development technologies and tools. Here's a list of the things I've learned and am currently learning:

I'm exploring Wagtail CMS, which is a content management system built on Django, to create robust websites with custom templates and modules.

I'm using React and TypeScript together to build efficient and maintainable front-end applications.

I'm learning Stimulus, a lightweight JavaScript framework that enhances HTML-based websites by adding interactivity and animation, to improve user experience.

I'm learning to design and implement REST APIs using various tools and frameworks.

I'm using Docker to simplify my development workflow and to deploy applications to different environments.

I'm using Figma, a powerful design tool, to create wireframes and prototypes for my projects.

I'm using Git to track changes and collaborate with my team members.

Keeping up-to-date with the latest technologies and tools is essential for success in web development. My recent learning journey has been both exciting and challenging. I'm looking forward to using these skills to create innovative and engaging web applications.
789 Club - Game 789Club đổi thưởng tiền thật, thẻ cào online uy tín 2022 - Tải 789Game
Published: 2023-03-15 08:44:47

https://789club.city/ 789Club là game đánh bài đổi thưởng ăn tiền thật uy tín 2022✔️ Tặng +50K khi tham gia 789 Game✔️ Link tải 789Club mới nhất✔️✔️✔️
https://heylink.me/789clubcity/
https://pbase.com/789clubcity/789clubcity
https://plaza.rakuten.co.jp/789clubcity
https://app.bountysource.com/people/114526-789club-city
https://matters.news/@789clubcity
https://penzu.com/p/b654c119
https://789clubcity.amebaownd.com/
https://peatix.com/user/16415709
Build Flask App For Image Recognition Using DL Model In Python
Tags: deeplearning, flask, python, machinelearning
Published: 2023-03-15 08:44:07

**Here's a preview of the app.**

{% embed https://vimeo.com/808224541 %}

**To access the step by step tutorial on how to make this flask app using Python, Visit the article below👇👇**

{% embed https://geekpython.in/flask-app-for-image-recognition %}

**Here's the full source code on GitHub👇👇**

{% embed https://github.com/Sachin-crypto/Flask_Image_Recognition %}

**🏆Other article you might like**

{% embed https://geekpython.in/using-transfer-learning-for-deep-learning-model %}

{% embed https://geekpython.in/render-images-from-flask %}

{% embed https://geekpython.in/data-augmentation-in-deep-learning %}
Object Oriented Programming explained with PHP
Tags: php, oop, programming, beginners
Published: 2023-03-15 08:43:33

The ability to separate something into objects is one of the most important skills when you create programs. In this tutorial we are going to create a Car and add some separated components. 

1. Build Car class.
The Car class has the following properties: Color - which is fundamental for any object and Lights. The constructor of the require all fundamental parts and properties of the car. In this case the Lights are not fundamental, so we can add them on later phase to our objects. For now we allow adding of lights trough a method. We also allow changing of the color.

2. Car Components - Light class.
As any object in the real world, the Car has many related components. In OOP separating the components into classes is a good practice. Lets crete the Light class.

3. Front left light and Front right light.
The Car has many light - on the front, on the back, on the left and right side sometimes. We are creating a class that hold all kind of light in the car.
In this case front lights. The both lights are required in class constructor because they are fundamental.

4. Add lights collection to the Car object.
Now we have the lights collection and we can add them to the car. We gone use BMW object created earlier. Lets turn the left light ON and see what's happen.

5. Create Road class for multiple car objects.
When you have particular class, you are able to create as much objects as you want. In this case we can create many car objects and attach them to the Road class as it in the real world - one Road has many cars.

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