teleren/devto huggingface dataset:
Where are WordPress Pages and Posts Stored
Published: 2020-07-08 16:38:10

I am going to start to information on WordPress data stored in the database. Additional information ‘<a href="https://wlearnsmart.com/where-are-wordpress-pages-and-posts-stored/">Where are WordPress Pages and Posts Stored</a>’.

There has not the physical file of the data stored in the WordPress directory.

The WordPress showing only Html file structure but WordPress content pages stored functionality in the table. the table namely ‘wp_posts’ and here is the path to file HTML /public_html/wp-content/themes/”here your theme name”/ . So if you more information about in details you can go through <a href="https://wlearnsmart.com/where-are-wordpress-pages-and-posts-stored/">Where are WordPress Pages and Posts Stored</a>
[Help Wanted] tsParticles Options GUI Editor
Tags: html, css, javascript, showdev
Published: 2020-07-08 16:32:00

The [tsParticles](https://github.com/matteobruni/tsparticles) options are becoming huge and I think a GUI editor that can be easily added could help a lot find the right configuration for everyone.

I started with dat.GUI but it didn't fit very well because it handles array really bad, and undefined too.

So I restarted from scratch but it needs a lot of work for creating the right editor components, if you want to start contributing here it's a good place to start because you'll explore all the options combinations.

You can find the editor project here: 

<https://github.com/matteobruni/tsparticles/tree/dev/core/editor>

*(`/core/editor` from this project root folder, for now only in `dev` and `staging` branch)*

This issue for now it's not scheduled for a deadline, but it has a requirement: **No UI frameworks like React, Angular, Vue, jQuery or others**, this must be easily added to all tsParticles installations.

This is also a `good first issue` for everyone because it's not requiring many skill, just some DOM manipulation and creativity to create good looking editor.
4 UI Design styles for modern style trends
Tags: dev, webdev, css, design
Published: 2020-07-08 16:20:06

Most of the design we will look at will be with css as it is the leading styling language for modern digital applications.

Whether you're coding with react, vue html or android or ios, css is the technology of choice when designing applications.

Let's look at 4 widely used design patterns in CSS today.

<h2>1. Subtle shadowing and border radius</h2>
Subtleties is everything in web design, it makes the difference between amateur designs and high end professional skill.
For box shadows use them like this:
```CSS
.box {
   box-shadow: 0 1px 3px rgba(0,0,0,0.1);
}
```
and border-radius usually less than 10px and more than 4px is best
```CSS
.box {
   border-radius: 8px;
}
```


<h2>2. Color gradients</h2> 
Color gradients add a creative and nice touch to elements you can use this free online tool to create beautiful gradients: 
<a href="https://cssgradient.io/">cssgradient.io</a>
```CSS
.box {
   background: linear-gradient(124deg, rgba(2,134,255,1) 0%, rgba(0,255,226,1) 100%);
}
```


<h2>3. Button icons</h2>
Adding icons to buttons and containers brings out modernity to your your site and app. Use them not sparingly but don't overdo it.
Font awesome is my go to icon source for web and apps:
<a href="https://cssgradient.io/">https://fontawesome.com</a>

```HTML
<button><i class="fas fa-bolt"></i> Click Me</button>
}
```

<h2>4. Subtle transitions</h2> 
Transitions can help make your site smooth with animations and adds a modern touch to the user experience. Use animations sparingly and never too slow. One major mistake beginners tend to do is create super slow animations to achieve cool effects but it usually has the opposite effect. Animations should almost always be between 0.1 seconds and 0.3.
```CSS
button {
   transition: all 0.2s;
   background: #000;
}
button:hover {
   background: #444;
}
```

Try and use these tips in your next web or app project and enjoy.
Comment what you think of these and feel free to add your own tips below.
[SERIES] Did you know? AR & VR are the smallest individual software sectors
Tags: ar, vr
Published: 2020-07-08 16:18:40

---
title: [SERIES] Did you know? AR & VR are the smallest individual software sectors
published: true
description: 
tags: #ar #vr 
//cover_image: https://direct_url_to_image.jpg
---
Considered individually, Augmented Reality and Virtual Reality remain the smallest software sectors out of the ones we research (the others being mobile, desktop, web, games, backend, industrial IoT, consumer electronics, data science & machine learning). Even when combined, AR and VR (AR/VR) are only marginally bigger than Consumer Electronics, the next smallest sector. **Only 0.4% of people are involved solely in AR or VR**, the rest are involved with at least one other development area.    

![46% of AR/VR practitioners are involved with both AR and VR ](https://dev-to-uploads.s3.amazonaws.com/i/8c5w676e67zhik3hgy3n.png)   



Of the 9% of people involved with AR or VR almost half (46%) are involved with both AR and VR. This shows that there is a significant overlap in the skills needed to work in these sectors. 

There are more people involved solely with VR (31%) than with AR (24%). AR is slightly less mature than VR and there are some technical challenges in AR (occlusion, optics & object registration, for example) which are still being resolved, this also means that there is a smaller market for AR products, as the technology is less established. This results in a slightly higher barrier to entry and subsequently a smaller number of people involved in AR than in VR only.

What are your biggest pain points in getting into AR/VR development? Let us know in the comments. 

In addition, why not share your experiences in our [State of the AR/VR survey.](https://arvrsurvey.com/?utm_medium=devto&utm_source=dev_to&utm_campaign=individual_software_sectors)
Which computer to choose for Linux OS with good graphical processing power? + UPDATE
Tags: discuss, linux, computer, hardware
Published: 2020-07-08 16:07:37

Currently I use Linuxmint on an average laptop that's custom-built from [PCSpecialist](https://www.pcspecialist.co.uk/), part of the reasons I got it is that I need a physical ENGLISH keyboard but it's hard to find those in Sweden. I got it a few years ago and am thinking about upgrading to a desktop. I would love to explore more on graphic design or 3D modeling in the future, so hopefully I can get something more powerful. I'm not so familiar with hardware, would love some help from experts! Thank you! 🙏

What would you recommend as hardware?
- desktop, physical English keyboard (I have monitor already)
- must be compatible with Linux OS
- can deliver to Sweden without tax and duty (it's damn expensive in Sweden)
- should handle powerful graphical tasks (design, 3d modeling, videos)

Current candidates:
UK:
[PCSpecialist](https://www.pcspecialist.co.uk/)
[JUNO](https://junocomputers.com/) 

Germany:
[TUXEDO](https://www.tuxedocomputers.com/)

Spain:
[Slimbook](https://slimbook.es/en/)

If you don't know anyone else, can perhaps suggest some machines from suppliers I list above? 

---
UPDATE 2020-10-10 

I now got my computer from 
https://www.komplett.se/
Special thanks to @JoelBonetR for suggestion!
They've assembled all the pieces I chose. It took over a month from order to arrival, which is understandable during pandemic period. Here are what I bought for reference:

- computer case: Fractal Design Define C Black
- graphic card: Sapphire Radeon RX 5600 XT PULSE
- processor: AMD Ryzen 5 3600 Processor
- DDR Memory: HyperX Fury DDR4 2666MHz 32GB
- Harddrive: Kingston A2000 500GB NVMe M.2 SSD
- Motherboard: ASUS EX-A320M-GAMING, Socket-AM4
- Powersupply: Corsair CV550, 550W PSU
- Network card: ASUS PCE-AC68 Nätverkskort

Total cost: 11,410 kr / 1,299 USD / 1,098 EUR

Today I installed my Linuxmint 20 and all the applications I need. The process is quite smooth. Although, at the beginning I was not sure how to do as there is no proper boot menu like I normally saw on laptop, through googling I found that if I turn the "realtek PXE Oprom" off then insert the usb stick it will work. Just in case anyone might also run into issue of not seeing the WIFI detected, you just need to insert the usb stick to install the hardware driver after you install the main OS and restart it. For fast installation, if you have wired connection, better use that than WIFI. 

I did a few tests on sites featuring 3D models but since I don't play games I probably haven't tested it to its maximum ability haha... hope I can test something serious soon such as video editing, which has been slow and clumsy on my previous laptop.
Help me with the display of the url
Tags: help, node, mongodb
Published: 2020-07-08 16:07:11

I have a blog and when I want to edit a post the URL becomes "/blog/:title/edit" and when I change the title of the blog and hit submit the URL should become "/blog/:title" and take me to the updated post. But this doesn't happen because when the title is updated in database the ":title" in the URL will not be updated. So my problem is when I click on the submit button the URL should change from "/blog/:title/edit" to "/blog/:newTitle"

Here is the Express code:

```javascript
var express = require("express"),
	methodOverride = require("method-override"),
	bodyParser = require("body-parser"),
	mongoose = require("mongoose"),
	app = express();

mongoose.connect("mongodb://localhost:27017/blog", {useNewUrlParser: true, useUnifiedTopology: true, useFindAndModify: false});
app.use(bodyParser.urlencoded({extended: true}));
app.set("view engine", "ejs");
app.use(express.static("public"));
app.use(methodOverride("_method"));

var blogSchema = new mongoose.Schema({
	title: String,
	image: String,
	body: String,
	created: {type: Date, default: Date.now}
})

var Blog = mongoose.model("Blog", blogSchema);

app.get("/", function(req, res){
	res.redirect("/blog");
})

app.get("/blog", function(req, res){
	Blog.find({}, function(err, blog){
		if(err){
			console.log(err);
		}
		else{
			res.render("index",{blog: blog});
		}
	})
})

app.get("/blog/new", function(req, res){
	res.render("new");
})

app.post("/blog", function(req, res){
	Blog.create(req.body.blog, function(err, newBlog){
		if(err){
			res.render("new");
		}
		else{
			res.redirect("/blog");
		}
	})
})

app.get("/blog/:title", function(req, res){
	Blog.findOne({title: req.params.title}, function(err, foundBlog){
		if(err){
			res.redirect("/blog");
		}
		else{
			res.render("show", {blog: foundBlog});
		}
	})
})

app.get("/blog/:title/edit", function(req, res){
	Blog.findOne({title: req.params.title}, function(err, foundBlog){
		if(err){
			res.redirect("/blog");
		}
		else{
			res.render("edit", {blog: foundBlog});
		}
	})
})

app.put("/blog/:title", function(req, res){
	Blog.findOneAndUpdate({title: req.params.title}, req.body.blog, function(err, updatedBlog){
		if(err){
			res.redirect("/blog");
		}
		else{
			res.redirect("/blog/"+req.params.title);
		}
	})
})

app.listen(3000, function(){
	console.log("server listening at port 3000");
})
```

And here is the edit.ejs code:

```javascript
<%- include("partials/header") %>

<div class="ui main text container segment">
	<div class="ui huge header">Edit <%= blog.title %></div>
	<form class="ui form" action="/blog/<%= blog.title %>?_method=PUT" method="POST">
		<div class="field">
			<label>Title</label>
			<input type="text" name="blog[title]" value="<%= blog.title %>">
		</div>
		<div class="field">
			<label>Image</label>
			<input type="text" name="blog[image]" value="<%= blog.image %>">
		</div>
		<div class="field">
			<label>Blog Content</label>
			<textarea name="blog[body]"><%= blog.body %></textarea>
		</div>
		<input class="ui violet big inverted button" type="submit">
	</form>
</div>

<%- include("partials/footer") %>
```
Introducing Xamarin.Forms Fiddle 
Tags: xamarinforms, typescript, xamarin, showdev
Published: 2020-07-08 15:29:06

# Xamarin.Forms app in JavaScript
With Web Atoms, you can create Xamarin.Forms apps in JavaScript. You can write JSX instead of Xaml and that gives you powerful multibinding and allows you to push code on production.

1. Side by side versioning
2. Divide large app in multiple javascript npm packages
3. No need to create multiple apps and integrate all of them
4. Debug JavaScript in Chrome using V8 Inspector protocol for Android
5. Debug JavaScript in Safari debugger for iOS

# Download the App

Trying and playing with Xamarin.Forms in JavaScript is one step process, download the app.

[![App Store](https://dev-to-uploads.s3.amazonaws.com/i/rxq4nf3l4zxln2hzolrp.png)](https://apps.apple.com/us/app/id1516606498)

[![Play Store](https://dev-to-uploads.s3.amazonaws.com/i/u8xoqg3a7cjafke01jb2.png)](https://play.google.com/store/apps/details?id=in.webatoms.debugger)

# Open Demo

## Shapes

https://www.webatoms.in/play/demo/shapes/1
https://www.webatoms.in/play/demo/rating/4

Explore new feature "Shapes" of Xamarin.Forms 4.7.

## Master Detail

https://www.webatoms.in/play/demo/master-detail

Application with drawer and multiple pages, using navigation service to open pages, retrieve result and load unpacked pages.

## List View

https://www.webatoms.in/play/demo/list

Explore list view with Cell bindings. Using two way binding to update the selection.

## Form

https://www.webatoms.in/play/demo/form/3

Explore validation sample with simple form.

## Tabbed Page

https://www.webatoms.in/play/demo/tabbed-page/3

Explore tabbed pages.


# Scan QR Code
![Scan and Play](https://dev-to-uploads.s3.amazonaws.com/i/17fbafr67i4vsuhpec1m.png)

# Console Logging

You can see console of your device and you can log errors/warnings in the console in your code.
📖 [ebook] Evaluación de 4 Herramientas de Vídeo Llamadas Web
Tags: spanish
Published: 2020-07-08 15:29:02

Hace ya varios meses que vengo trabajando en un proyecto para crear una aplicación web con la cual poder comunicarse con otras personas desde un navegador web. Sobre ese proyecto [escribí en mí blog personal](https://otroespacioblog.wordpress.com/2020/06/03/pasen-a-intrati/). En futuras entradas escribiré acá al respecto.

En esta oportunidad, vengo a comentar sobre un reporte o evaluación que hice sobre 4 herramientas para comunicarnos y colaborar con amigos o colegas **mediante vídeos llamadas desde un navegador web**.

Es gracias a **WebRTC** que se dan estos servicios. Una tecnología con algunos años encima pero que todavía está en evolución y mejorando cada año.

Las herramientas o servicios destacadas son:

- [Whereby](https://whereby.com/)
- [Joinme](https://www.join.me/es)
- [Eyeson](https://www.eyeson.com/)
- [Team Video](https://team.video/)

Todas excelentes opciones que funciona muy bien y tienen una buena variedad de características para trabajar con ellas en equipos pequeños y/o medianos.

De manera gratuita puedes obtener el reporte en [Gumroad](https://gumroad.com/l/4herramientas) o [Leanpub](https://leanpub.com/herramientas-video-llamada-web). Si lees esto, te animo a leerlo y probar alguna de las herramientas mencionadas.
553 vulnerable modules?
Tags: npm, node, packages
Published: 2020-07-08 15:23:15

Want to have some fun? Uninstall node then reinstall it. You'll see something similar to the message above.

Npm Audit Fix didn't get them all.  I'm not a paranoid type of person, but because it does say "vulnerabilities" I guess I should take a look at them (yawn).

Shouldn't node fix this? Yes.

Or perhaps... 

```
npm update --force 
```

there ya' go!
DAY 17: MORE EXCEPTIONS
Tags: python, beginners
Published: 2020-07-08 15:23:07

It's been a while since I posted anything about my progress and I will give my explanation right after explaining what I understood from this challenge.

The challenge was about raising an Exception.Raising an exception is when one forces an exception to occur, it’s identified by the keyword **raise** followed by an exception instance or exception class then add a message to be displayed when the exception occurs. E.g.
```python
raise Exception('I forced this.')
```
**The Task:**
Write a **Calculator** class with a single method: **int power(int,int)**. The power method takes two integers, **n** and **p**, as parameters and returns the integer result of **n^p**. If either **n** or **p** is negative, then the method must throw an exception with the message: **n and p should be non-negative.**

**Solution:** 
```python
class Calculator:
    def power(self,n,p):
        #check if either n or p is negative
        if n < 0 or p < 0:
            #raising the exception if either of the values is negative
            raise Exception('n and p should be non-negative')
        else:
            # returning the value of n to the power of p
            return n ** p


cl1 = Calculator()
T = int(input()) #number of test cases to be input
#looping though every test case
for i in range(T):
    #create two variables as the input is space-separated
    n, p = map(int, input().split())
    try:
        ans = cl1.power(n,p)
        print(ans)
    except Exception as e:
        print(e)


'''
Sample Input

4
3 5
2 4
-1 -2
-1 3
Sample Output

243
16
n and p should be non-negative
n and p should be non-negative
'''
```
I learnt a new concept by this and I look forward to implementing it in my code.

Aside from this, I have to admit that currently I should be in Day 28 of the challenge but I have struggled with some of the questions, some I know bits others I have no clue so this will be my last challenge to post because I have no clear understanding of the others. 

I am still learning them but recently I got a work opportunity which takes most of my time now and uses a different programming language so that means i have to get familiar with that language as well. I'm well aware that learning two or more languages consecutively will be a challenge but I will try to practice even if it's 15 minutes for some days. I will post every bit of new information I learn.
Big CSV exports with Rails: streaming FTW
Tags: ruby, rails, database
Published: 2020-07-08 15:20:25

One of the projects we're working at the moment had a heavy reporting requirement: years of sales and transaction data - all of which needed to be exportable as CSV files. _Big_ CSV files.

Normally, I might look at queuing the export and executing it as a background process - but this time I found a quick win: using a combination of ActiveRecord's [`find_each`](https://api.rubyonrails.org/classes/ActiveRecord/Batches.html#method-i-find_each), and Ruby's [`Enumerator`](https://ruby-doc.org/core-2.6/Enumerator.html) to stream the CSV - in batches, and straight from the controller. As with most things Rails, it was really quite easy:

```ruby
require 'csv'

class ReportsController < ApplicationController
  def index
    headers.delete("Content-Length")
    headers["Cache-Control"] = "no-cache"
    headers["Content-Type"] = "text/csv"
    headers["Content-Disposition"] = "attachment; filename=\"report.csv\""
    headers["X-Accel-Buffering"] = "no"

    response.status = 200

    self.response_body = csv_enumerator
  end

  private

  def csv_enumerator
    @csv_enumerator ||= Enumerator.new do |yielder|
      ReportItem.find_each do |row|
        yielder << CSV.generate_line([
          row.id,
          row.name,
          row.total
        ])
      end
    end
  end
end
```

Using `find_each` saves me from:

* Putting too much load on the database with a heavy query
* Holding too much data in memory

and passing an `Enumerator` to `response_body` forces the browser to keep the connection open while it pipes down whatever data is yielded. I also do the usual stuff like setting the content-type and disposition so that the browser still treats it like a file download.

It worked exceptionally for our use case, and required dramatically less effort than adopting a queue - both in terms of code and UX.
Can't take a single decision at all.
Published: 2020-07-08 15:16:06

I completed my Bachelor's in CS last Year. Now I am going to pursue Masters this year. Till date, I don't know which programming language to choose. Tried Web Designing (Only HTML/CSS) loved it, but when it came to JS, I started hating it. I am not that artistic to make wonderful web pages. Tried Angular and React but I seem to lose interest in them pretty easily. 

Then moved to C#, because Blazor. Fact that you can write webpages without JS but a C-family language is something new for me. 

And then again, left it in the beginning itself, because I started losing interest in it. Tried C# for desktop, that didn't go well yet again. Tried C++, can't do wonders in the language as well. 

Then tried Python, and I seem to get lost into what to do.

And then I have fears that which language to choose because I have little to know practice in any programming language and that's because I don't even know which one to choose. 

And from the above experience, I concluded myself: 
1. Web Is not for me. 
2. I am just sitting useless because I got no project to work on. 


And in Masters I want to pursue Image Processing, GPU Programming most probably.

Help me sort my brain out.
It’s time to fire the way the world hires.
Tags: discuss, career
Published: 2020-07-08 15:06:03

“You’re hired”.

Those two words usually mark the beginning of something beautiful. Unfortunately, everything leading up to it can be a nightmare. 

For both talent and employers, the hiring process can make medieval torture seem like a Sunday stroll. Not only is the current process mentally exhausting for all parties – it’s also extremely inefficient, time consuming and expensive.

You already know this at a gut-level, but here are some statistics that prove the point.

To hire for one role, the typical company spends about 8% to 12% of a candidate’s salary in recruiting costs and hiring managers spend about 60% of their work week sourcing talent. This is the definition of a waste of time and money.

And for talent? Well, the best talent is passive talent. Those who are currently employed, but unhappy with where they’re at. They make up 70% of the job market, but you’ll rarely find them applying to phantom postings on job sites or clicking the “apply” button on LinkedIn because of the lack of transparency. And so, the best talent goes undiscovered.

The current landscape of job sites, LinkedIn and headhunters are not great solutions. Actually, they all kind of suck.

That’s why we’re fixing a broken system by flipping the hiring process on its head: On the Reworking platform, we empower employers to initiate the hiring process directly with vetted talent. 

With a single, fundamental change, everyone wins.

In this world there are no phantom job openings, no payments for enhanced visibility, no percentage fees, no foraging through endless applications, no broken links on outdated job portals and no missed opportunities due to lack of transparency.

Reworking will be completely free to vetted software developers and will cost companies a subscription fee that’s less than the cost of filling one role today.

Fire the old way of working. Join us in reworking work.

We are passionate about Reworking Work, ﻿give us some love ⇾ Reworking

Rework the way we work.

---
Email Zack at zack@reworking.work and tell him what you hate about the current hiring process. It will make his day and he’ll answer your questions, show you a product demo. If you’re nice, he’ll also send you pictures of his two french bulldogs.