teleren/devto huggingface dataset:
Get the current unix timestamp in oracle
Tags: oracle, snippet, sql, datetime
Published: 2021-01-21 11:21:49

The following expression returns the Unix time in milliseconds independent of the time zone.

It sums the number of days passed from the start of the Unix epoch multiplied by the number of milliseconds in a day (24 * 60 * 60 * 1000 = 86400000) plus number of milliseconds past midnight (`SSSSS` with a precision of 3 `FF3` to express milliseconds).

It uses the `SYS_EXTRACT_UTC` method to extract the UTC (Coordinated Universal Time—formerly Greenwich Mean Time) from the current timestamp  (`systimestamp` in oracle):

```sql
SELECT
     EXTRACT(DAY FROM(sys_extract_utc(systimestamp) - to_timestamp('1970-01-01', 'YYYY-MM-DD'))) * 86400000
    + to_number(TO_CHAR(sys_extract_utc(systimestamp), 'SSSSSFF3'))
  FROM dual;
```

<span style="font-size: 0.3rem">
  <strong>Reference - </strong> <a href="https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/SYS_EXTRACT_UTC.html" target="_blank" style="font-weight: lighter">
     https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/SYS_EXTRACT_UTC.html
  </a>
</span>

<hr/>

<p class="note_normal">
  Shared with love from <a href="https://www.codever.dev/snippets/60092685a4155b6d32a92582/details">Bookmarks.dev</a>.
  Use the <a href="https://www.codever.dev/snippets/60092685a4155b6d32a92582/details" class="copy-to-mine-btn"><i class="fa fa-copy"></i> Copy to mine</a> functionality to copy this snippet to your own personal collection and easy manage your code snippets.
</p>
Google Cloud Run with CI/CD via Terraform Cloud and GitHub actions
Tags: devops, code, tips
Published: 2021-01-21 11:12:44

---
title: Google Cloud Run with CI/CD via Terraform Cloud and GitHub actions
published: true
description: Claimora Case Study
tags: devops, code, tips
cover_image: https://assets.mkdev.me/posts/covers/000/000/012/original/mkdev_article.png
---
In this video, we are going to learn how to deploy an application in Cloud Run, how to use GitHub actions, Terraform Cloud, and how to integrate everything together in a real example, [Claimora](https://claimora.com):

{% youtube JxBSXbmf4F0 %}

***

*You can always hire [our mentors](https://mkdev.me/en/specializations) and learn directly from them!*
[NO JS] Checkable table row with highlighting
Tags: webdev, nojs, css, html
Published: 2021-01-21 11:10:41

---
title: [NO JS] Checkable table row with highlighting
published: true
description: Pure CSS table row highlighting when a checkbox is :checked
tags: webdev, nojs, css, html
cover_image: https://dev-to-uploads.s3.amazonaws.com/i/6dnj6ciy62c1ceexoah5.png
---

> Tips: This approach works for both checkbox and radio table !

Let's start with the classic :

## One selectable line table (radio based):

```html
<table>
	<thead>
		<th></th>
		<th>mono-selection</th>
	</thead>
	<tbody>
		<tr>
			<td><input type=radio name=radio value=radio1 required></td>
			<td>radio1</td>
		</tr>
		<tr>
			<td><input type=radio name=radio value=radio2 required></td>
			<td>radio2</td>
		</tr>
		<tr>
			<td><input type=radio name=radio value=radio3 required></td>
			<td>radio3</td>
		</tr>
	</tbody>
</table>
```

Using the following CSS rules we can highlight the selected row when it input is checked:

```css
tr {
	/* https://github.com/w3c/csswg-drafts/issues/1899 */
	transform: scale(1);
	position: relative;
}

/* The highlight magic is here (webkit only) */
:checked::before {
	content: ' ';
	position: absolute;
	display: block;
	top: 0;
	left: 0;
	bottom: 0;
	right: 0;
	background: yellow;
	opacity: .5;
	z-index: -1;
}

/* Moz hack to enable :before on radio
[type=radio]{appearance: none;}
[type=radio]:not(:checked)::before{content: '⚪';}
[type=radio]:checked::before{content: '🔘';padding: 3px 5px;}
*/
```

> Trick: If the `<table>` belongs to a `<form>`, you can automatically hide/show it actions buttons when a line is selected (but be sure to mark it radio `required` !).


```html
<style>
:invalid .if-valid{
	display: none;
}
</style>
<form>
	<table>...</table>
	<footer class=if-valid>
		<button>You got me !</button>
	</footer>
</form>
```

The highlighting CSS rules also work with checkboxes. But since checkbox are optionals you can forget about the funny hide-show trick.

## Multi selection table (checkbox based):

```html
<table>
	<thead>
		<th><input type=checkbox
				onclick="[...closest('table').querySelectorAll('tbody [type=checkbox]')].forEach(box=>box.checked=checked)">
		</th>
		<th>title</th>
	</thead>
	<tbody>
		<tr>
			<td><input type=checkbox name=chk value=chk1></td>
			<td>chk1</td>
		</tr>
		<tr>
			<td><input type=checkbox name=chk value=chk2></td>
			<td>chk2</td>
		</tr>
		<tr>
			<td><input type=checkbox name=chk value=chk3></td>
			<td>chk3</td>
		</tr>
	</tbody>
</table>

```

## Full Demo:

> Tips: it includes a form submit alert, so you can see selected values that would have been submitted to the form action endpoint

{% codepen https://codepen.io/qxc32034/pen/xxEeLbB %}
NET5: Record Type
Tags: net5, recordtype, record, dotnet
Published: 2021-01-21 10:59:27

## NET5: Record Type 

Tra le novità introdotte in **net5** possiamo trovare i **Record Type** e personalmente li ho trovati molto interessanti.

### In cosa consiste?

Dichiarare un  **Record Type** non risulta molto diverso dal dichiarare una **class** (prendete con le pinze la frase) nella quale vi sono presenti solamente delle proprietà. Sappiate che queste proprietà non saranno modificabili una volta istanziato il nuovo oggetto di tipo **record**.

[Articolo Completo](https://blog.devandreacarratta.it/net5-record-type/?utm_source=devto&utm_medium=coding-tips&utm_campaign=net5&utm_content=net5-record-type)


## Links
- [AndreaCarratta@Linkedin](http://bit.ly/linkedin-acarratta)
- [AndreaCarratta@YouTube](https://bit.ly/devandreacarratta-youtube)
- [DevAndreaCarratta@Facebook](http://bit.ly/devandreacarratta-facebook)
- [DevAndreaCarratta@Telegram](http://bit.ly/telegram-devandreacarratta)
- [Backend Developer Italia@Linkedin](https://bit.ly/linkedin-backend-developer-italia)
Don't Tempt Yourself
Tags: growth, habit, discipline, motivation
Published: 2021-02-09 09:17:06

---
title: Don't Tempt Yourself
published: true
date: 2021-01-21 10:49:55 UTC
tags: growth,habit,discipline,motivation
canonical_url: https://x-team.com/blog/dont-tempt-yourself/
---
Disciplined people don't have more willpower than the average person. They just spend most of their time in environments where good behavior is encouraged and where bad behavior is either invisible or discouraged.

Do you want to become more disciplined? Create a more disciplined environment:

- If you want to drink less, get rid of all the alcohol in your house. 
- If you want to code more, block all distracting websites.
- If you want to watch less TV, hide the batteries of the remote. 

Those who seem to have the most willpower are those who need it the least. Look around. Do you see something that's tempting you into bad behavior? Something that you continuously need to resist?

Put it away. Block it. Make it invisible. Clean up your environments this way and you'll become a more disciplined person.

{% twitter 1151763581005963264 %}
Beat On App
Published: 2021-01-21 10:41:33

this app is basically a video streaming app that i design in react native (only frontend)
in this app i use the following strategies and dependencies
- Navigation 5 (Stack, Top Navigation)
- React Native Paper (For Theme Change)
- Splash 
- Icon
- Video Storage in firebase realtime
- Facebook auth
-Google Auth
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/pb2akxlvt44iorwagjxu.png)![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/z8tbmg0gjji5sl01odts.png)![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/nqj6ljinje0fi6orv1ik.png)![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/mu06d1b4rax3wljb5at6.png)
Agile Methodology, Four Core Concept of Agile Methodology, Agile Manifesto.
Tags: beginners, testing, devops, tutorial
Published: 2021-01-21 10:34:46

**What Is Agile Methodology?**
The Agile SDLC model is a mix of iterative and incremental process models focused on process adaptability and customer satisfaction through the rapid delivery of the product with working software. Usually, each iteration lasts from about **one to four weeks**.

**Four Core Concept** *of Agile Methodology:*
1. Interactions between individuals and teams over tools and procedures.
2. Working software on detailed documentation.
3. Customer cooperation in negotiating contracts.
4. Responding to change according to a project.

![Post 12](https://dev-to-uploads.s3.amazonaws.com/i/n41kuqdthq1wwx27ltyf.png)

**Agile manifesto:**

1. Our highest priority is to please the client by providing useful applications early and consistently.
2. Welcome changing demands, even late in creation. Agile method harness adjustment for the strategic benefit of the customer
3. Deliver working applications regularly, with a preference for the shorter time scale, from a few weeks to a few months.
4. Throughout the project, business people and developers must work together daily.
5. Create projects around people who are inspired. Offer them the atmosphere and support their needs, and trust them to do the job.
6. Face-to-face conversation is the most powerful and productive way of communicating information to and inside a production team.
7. The important aspect of development is working software.
8. Agile methods encourage sustainable development. It should be possible for sponsors, developers, and users to maintain a steady speed indefinitely.
9. Agility is improved by a constant commitment to technological quality and good design.
10. It is important to have simplicity-the art of minimizing the amount of work not completed.
11. From self-organizing teams, the best architectures, specifications, and prototypes emerge.
12. The team focuses on how to become more productive at regular intervals, then tunes and modifies its actions accordingly.

*Agile Methodology Example:*
**-->Scrum.
-->Extreme Programming (XP).
-->Dynamic Systems Development Method (DSDM).
-->Crystal Methods.
-->Feature-Driven Development (FDD).
-->Lean Development (LD).
-->Adaptive Software Development (ASD).**
About World Stream SEO
Tags: startup, seo
Published: 2021-01-21 10:20:48

<h2>Our Mission</h2>
We use Facebook to share ongoing articles, and breaking news with our locale and to cultivate energetic, connecting with conversations encompassing this substance and substantially more.

<h2>Company Overview</h2>
 
World Stream SEO is your one-stop look for new news and post about web crawler promoting (SEM), site improvement (SEO), nearby hunt, versatile inquiry, voice search, and online networking advertising (SMO). We distribute breaking news, tips, and the stunt, refreshed substance, item declarations, most recent research, and studies, inside and out investigations, how-to aides, and that's only the tip of the iceberg.
 
<h2>About World Stream SEO</h2>
 
World Stream SEO is a world-class digital publication that covers all aspects of the search marketing industry like- SEO, SEM, Mobile, Local, Retail, Social, Voice – our content encompasses it all.

Daily news coverage includes breaking stories related to search engine optimization (SEO) and social media marketing (SMM), industry trends, feature announcements, and product changes at popular platforms used by search marketers to reach consumers online.

We also publish articles/Posts by industry experts across all digital marketing disciplines, filled with practical tips, and strategies for running successful marketing programs in today’s fast-paced and ever-changing environment.

World Stream SEO parent sites, Technical Education, drill down into more specific aspects of the industry. The trio of sites was founded by Mr. Alimam Miya (C.E.0 & Founder).
Like what you see? Visit for our newsletters here: <a href="https://worldstreamseo.com/">World Stream SEO</a>
  
<h3>Products</h3>
 
Information about SEO, SEM, SMO, PPC, search engines, local search, mobile devices, e-commerce, social media, Voice search & more.

<b>Happy reading!</b>
Key Factors That Can Affect Cost of Your eCommerce Mobile App
Tags: webdev, reactnative, wordpress
Published: 2021-01-21 10:15:48

It is surprising how things we cannot even imagine that affect our lives. Just look at the new strain of coronavirus! A few weeks back, nations have started absorbing the new normal and began their lives. But the new strain has shaken the lives of individuals once again. While the uncontrolled and unpredictable circumstances posed by COVID-19 have badly hit most businesses, some businesses like eCommerce have shown tremendous growth in the past couple of months.
 
Having an eCommerce app & website is a convenient option for both the consumers and the companies. It is predicted that by 2021 mobile purchases will be worth $3.56 trillion. It clearly shows that eCommerce app development is a far better option than creating an online store website in the future.

The mobile app for eCommerce business boosts brand awareness, marketing, and brings excellent user experience and helps retailers enable personalized engagement with the target audience. And therefore, more and more retailers are opting for eCommerce mobile app development instead of creating an online store website.

Maybe you are aware of the process of developing an eCommerce app, but what about the cost? Are you aware of how much an eCommerce app development cost? If no, then keep reading the blog post to know the different factors affecting the cost of developing an eCommerce app.

Major factors that decide the cost of mobile apps for eCommerce business

eCommerce app Platform
eCommerce mobile app Design
Size of an eCommerce app
eCommerce development company or developer cost
App maintenance

Anything else???

Yes, of course! Apart from the factors discussed above, there are a few other things that may lift your eCommerce mobile app's budget. It would be best if you also considered marketing, license, third-party integration, and app support costs while deciding on a budget of your eCommerce app. In general, you can consider the cost of each of these activities approximately $500 to $2000. However, there is another way you can save huge on your eCommerce app development, and that is to opt for a readymade eCommerce app builder like AddWeb Shop. Such ready-to-use platforms simplify the overall process to launch your mobile app in a short time.

If you consider all these factors discussed in the blog post, the approximate cost to develop an eCommerce app ranges between $30000 to $170000. On the other hand, eCommerce app builders like AddWeb Shop can significantly reduce your eCommerce app development cost. Are you looking for an eCommerce development company to help you get the right mobile app for your eCommerce business? Or looking for a React Native eCommerce app? Get in touch with our experts now to know more.

Want to create your own eCommerce app? Contact us: https://addwebsolution.com/contact-us

Source: https://addwebsolution.com/blog/key-factors-can-affect-cost-your-ecommerce-mobile-app
How to install or convert APK Files?
Tags: android, devops, discuss
Published: 2021-01-21 10:14:33

On the off chance that you are an Android telephone holder, you generally download the applications for your gadget from Google Play Store. Notwithstanding, outsider sources additionally offer Android applications as an MHAPKS  record to download and introduce. Introducing an MHAPKS document in Android is straightforward, however, it requires doing a few settings prior to introducing Mhapks on Android. Above all else, you need to set up your gadget's settings to introduce the MHAPKS document from outside sources. Second, download the MHAPKS record on your Android cell phone. Lastly, open the downloaded MHAPKS record to introduce it to your gadget. 
 
In the event that you are an Android telephone holder, you generally download the applications for your gadget from Google Play Store. In any case, outsider sources additionally offer Android applications as an MHAPKS record to download and introduce. Introducing an MHAPKS document in Android is straightforward, yet it requires doing a few settings prior to introducing MHAPKS on Android. Most importantly, you need to set up your gadget's settings to introduce the MHAPKS document from outside sources. Second, download the <ahref='https://mhapks.com/'>Mhapks</a> document on your Android cell phone. Lastly, open the downloaded MHAPKS record to introduce to your gadget. In the event that you have ever introduced an application from Google Play Store previously, at that point, this undertaking accidentally introduced the application's MHAPKS record in your Android gadget.
https://mhapks.com/
Matthew Brannelly -Technology Transform Accounting During And Beyond Covid 19
Tags: matthewbrannelly, covidandaccount, accounttechnologies, growthstrategies
Published: 2021-01-21 09:56:15

According to Matthew Brannelly Strategic Advisor Clayfield Brisbane Australia, accounting firms, more than ever,need to embrace these technologies to innovate and evolve in order to sail their way to success during and beyond Covid 19. 

Here, Matthew Brannelly looks at the role of technology in accounting. Why cloud computing is important and why skills remains a priority amidst the pandemic.
Rust Report Card - Get a badge for your Rust open source project
Tags: rust, github, programming
Published: 2021-01-21 09:43:01

---
title: Rust Report Card - Get a badge for your Rust open source project
published: true
description: Get a badge for your Rust open source project
tags: Rust,GitHub,programming
//cover_image: https://direct_url_to_image.jpg
---
A web application that generates a report on the quality of an open-source Rust project. This project inspired and based on the Go report card. It uses `rust-clippy` measures. To get a report on your own project, try using the [https://rust-reportcard.xuri.me](https://rust-reportcard.xuri.me).

![Rust Report Card](https://dev-to-uploads.s3.amazonaws.com/i/celrchfo54qofvm057ri.png)
POST request in redux-saga not working
Tags: react, redux
Published: 2021-01-21 09:39:45

I would like to make post request in `redux-saga`. My code looks like:

    var formdata = new FormData();
        formdata.append("points", "a,b");
        formdata.append("pid", "someid");
        formdata.append("tions", "cses");
        formdata.append("exp", "cx");
    const ans = yield call(fetch,
    'http://localhost:8000/api',
    {
        method: "POST",
        headers: { 'Authorization': 'Token tokenid',
                    "Content-Type": "application/json",},
        body : formdata
    });

**In Postman it is working fine(selected `form-data` in body)** but in saga, the POST request is giving error as `the server responded with a status of 400 (Bad Request)`

Please suggest where I am doing wrong as the API is working fine and all the parameters are correct?
Speed up your CircleCI pipeline by using the RAM disk
Tags: ci, circleci, optimization
Published: 2021-01-21 09:31:29

---
title: Speed up your CircleCI pipeline by using the RAM disk
published: true
description: By using the RAM disk on CircleCI, we can reduce the time for restoring the cache. In my current project, it has reduced the time to run the pipeline by 2 minutes.
tags: CI, CircleCI, optimization
canonical_url: https://kewah.com/faster-circleci-pipeline-using-the-ram-disk/
---

During a presentation—held internally at [Acast](https://www.acast.com) by my
colleague [Daniel Grefberg](https://www.linkedin.com/in/danielgrefberg/)—I discovered a one-line change that reduced by 2 minutes the execution time of my current project's CI pipeline.

```diff
- working_directory: ~/my-project-name
+ working_directory: /mnt/ramdisk/my-project-name
```

[CircleCI](https://circleci.com/) allows us to mount the project on the [RAM disk](https://circleci.com/docs/2.0/executor-types/#ram-disks) and use it as a "[temporary file storage paradigm](https://en.wikipedia.org/wiki/Tmpfs)." That means, when caching a project's dependencies, CircleCI will use the RAM disk instead of the disk drive.

When working on a Node.js project, it is common to cache the `node_modules` folder. It allows us to re-use it in the other jobs to avoid running the install command every time. On paper, that should be faster than running `npm ci` (or `yarn install --frozen-lockfile`) for each job, but that's not necessarily the case. It usually takes ~2 minutes to restore the cache of ~400MB. This time is mainly taken for decompressing the thousands of files from the folder on the disk. But, this step gets down to ~20 seconds by moving it to the RAM disk.

This change is a quick win to save a few minutes for running our pipeline. The only drawback is that we are limited to the RAM capacity—defined by the [job's resource_class attribute](https://circleci.com/docs/2.0/configuration-reference/#resource_class). By default, it runs on a 4GB RAM (medium resource class), so depending on our project and the dependencies' size, we might need to increase the resource class.

```yaml
version: 2.1

aliases:
  - &default_image
    working_directory: /mnt/ramdisk/my-project
    docker:
      - image: cimg/node:12.20

  - &cache_key v1-cache-{{checksum ".circleci/config.yml"}}-{{checksum
    "yarn.lock"}}
  - &restore_cache
    restore_cache:
      keys:
        - *cache_key

jobs:
  initialize:
    <<: *default_image
    steps:
      - checkout
      - *restore_cache
      - run: yarn install --frozen-lockfile
      - save_cache:
          name: Save cache
          key: *cache_key
          paths:
            - node_modules

  test_unit:
    <<: *default_image
    steps:
      - checkout
      - *restore_cache
      - run: yarn test:unit --maxWorkers=2
```