teleren/devto huggingface dataset:
Set Postgres System Timezone
Tags: postgres, database
Published: 2020-10-21 15:06:38

---
title: Set Postgres System Timezone
published: true
date: 2020-10-20 00:00:00 UTC
tags: postgres, database
canonical_url: https://magistratehq.com/blog/set-postgres-system-timezone/
---

By default, Postgres uses the system timezone as the default. This usually isn't what you want for a database on your local dev machine. Generally, the timezone should be UTC. The database not being in the same timezone as production will cause bugs that don't exist locally but do exist on production.

The most common answer I find when I'm searching for how to do this for the thousandth time is this:

``` sql
SET TIME ZONE 'UTC';
```

This works, but will not persist across restarts.

The more persistent way to accomplish this is to modify `postgresql.conf`. To find where the `postgresql.conf` file is on your system, you can run this query in `psql`:

``` sql
SHOW config_file;
```

Once you have found the location of the file, you can find this line in the file, uncomment it, and change the value to be 'UTC'.

``` toml
#timezone = '(defaults to server environment setting)'
```

This is what the line should look like after the change:

``` toml
timezone = 'UTC'
```

After making the change, we need to reload Postgres so the config change will take effect. This can be done by either running `pg_ctl reload` on the command line, or running `SELECT pg_reload_conf();` from `psql`.
2020 Update & currently recovering from burnout
Tags: burnout, beginners, life
Published: 2020-10-19 20:31:07

Welp. I haven't blogged since the beginning of this year. It's funny, a self reflection blog I wrote back in January, ready to make changes in my life and conquer, then COVID hits right near the end of February. What timing huh? Did I feel I was able to get through things? I wouldn't say the least. So much has happened in these couple of months.

I'll be ranting and just talking about my life update, so if this doesn't interest you, I don't mind if you stop reading and skip this article. This is just another one of my life rants.

March - April:
- Slowed down in productivity progress on personal projects
- Joined and collaborated in a few game jams
- Constant job rejections, no interviews
- Animal Crossing

May:
- Even slower progress on productivity
- Playing games
- Stopped applying jobs

End of May - June:
- George Floyd happened
- Developed and deployed a web app out of anger & remorse for the Black Lives Matter movement
- Submit more job applications, more rejections, no interviews

July:
- Participate game jams
- Work on game projects
- Finally got an interview for a technical sound designer position, submitted the take home technical audio test

August: 
- Waiting for results for the technical sound designer position, sent follow-up emails...no response.
- Work on personal projects
- Submit more job applications, more rejections, no interviews

September:
- Participate in another game jam
- Work on personal projects
- Play games

Now it's October, what am I doing now?:
- I'm participating in yet another game jam, but this time it's a solo game project
- Picked up pixel art drawing, for the game project, but also because I've been wanting to draw too
- Starting FreeCodeCamp's Data Structures & Algorithms Course, because I'm feeling really rusty in those topics, especially since I haven't been practicing coding problems either.
- Started Twitch Streaming 
- Submitting some job applications, rejections as usual

I wish I can share a success story about myself, but no, a year of finishing a coding bootcamp & COVID happening, it feels even harder to find a job. 

My title also mentions my burnout. Well, I'm tired. I'm tired of applying for jobs and just getting rejected. I'm tired of questioning my self-worth because of these rejections, to not even be able to talk to a human being. I would rather get rejected at the interview stage, that way I know I talked to a human and got feedback, but no, just a robot email echoing to me: 

Unfortunately, "Insert Company Name" has moved to the next step in their hiring process, and your application was not selected at this time.

I just want to create stuff. But I'd like to also be able to be financially be stable to create stuff for people.
Welcome Welcome Welcome Welcome Welcome Welcome
Tags: hello, blog, project, introduction
Published: 2020-10-19 23:48:18

Welcome to my page!

My name is Manny. I am a student at the Ohio State University. I'm an electronic musician, a programmer, a bit of a gamer, and a basketball fan. (GO CAVS!) I enjoy playing Minecraft with my friends, eating out together with them, watching films/movies, traveling in Japan, and have a huge fascination with anything to do with electronic music equipment.

I decided to make a blog to discuss about a synthesizer project I'm currently working on. And I wanted to make a good habit of consistently updating my viewers. (...Even though I don't have any yet...) It's definitely not at the stage where I can demonstrate, but I aim to release it by the end of this year if not the end of mid November.

As I aforementioned, I am a musician. (Not a professional one by any means nor a great one.) I enjoy it as a hobby regardless of my skill level or talent. Eventually, the project will be used to make music tracks with it and will be shared though Soundcloud or Bandcamp. 

I also intend to show every step I took to get the results that I did. I am using an audio programming book to guide me, and the material is lengthy and dense. But I'll try and summarize it's part. Hopefully, someone else can use it for their own ideas and make something even better than mine.
Rapid Delivery Of Business Intelligence Using Power BI - Episode 154
Published: 2020-10-19 23:10:41

<p>Business intelligence efforts are only as useful as the outcomes that they inform. Power BI aims to reduce the time and effort required to go from information to action by providing an interface that encourages rapid iteration. In this episode Rob Collie shares his enthusiasm for the Power BI platform and how it stands out from other options. He explains how he helped to build the platform during his time at Microsoft, and how he continues to support users through his work at Power Pivot Pro. Rob shares some useful insights gained through his consulting work, and why he considers Power BI to be the best option on the market today for business analytics.</p><p><a href='https://www.dataengineeringpodcast.com/power-bi-business-intelligence-episode-154/'>Listen Now!</a></p>
Cloud Native Application Delivery Using GitOps - Episode 284
Published: 2020-10-19 23:09:52

<p>The way that applications are being built and delivered has changed dramatically in recent years with the growing trend toward cloud native software. As part of this movement toward the infrastructure and orchestration that powers your project being defined in software, a new approach to operations is gaining prominence. Commonly called GitOps, the main principle is that all of your automation code lives in version control and is executed automatically as changes are merged. In this episode Victor Farcic shares details on how that workflow brings together developers and operations engineers, the challenges that it poses, and how it influences the architecture of your software. This was an interesting look at an emerging pattern in the development and release cycle of modern applications.</p><p><a href='https://www.pythonpodcast.com/gitops-cloud-native-operations-episode-284/'>Listen Now!</a></p>
And
Published: 2020-10-19 23:08:51

Python has three Boolean operators that are typed out as plain English words: and.
It is on main keyword in python. It is based around Boolean algebra in order of find the truth value of expressions. Depending on the truth value, you can evaluate conditions and decide what operations your programs will execute.
e.g.: (a==true and b==true) is true.
On the other hand, while loops allow you to repeat a piece of code if a given condition remains true.
خمسة مفاهيم أساسية للتعلم عن البرمجة
Published: 2020-10-19 23:06:52

كثيرًا ما أسمع مبرمجين جدد يسألون ، "هل يجب أن أتعلم بايثون؟" أو "هل يجب أن أتعلم جافا أم جافا سكريبت؟" هذا هو نهج خاطئ. يجب أن يركز المبرمجون الجدد على مفاهيم البرمجة الأساسية. وجود أساس متين لهذه المفاهيم يجعل من السهل تعلم أي لغة برمجة ، لأن المفاهيم شائعة بين اللغات المختلفة.

فيما يلي خمسة مفاهيم برمجة أساسية يجب أن يتعلمها المبرمجون الجدد أولاً:

 1. **أنواع البيانات** - تمثل لغات البرمجة البيانات في العالم الحقيقي. تأتي البيانات بأشكال مختلفة مثل الأعداد الصحيحة وأرقام الفاصلة العائمة والأحرف والسلاسل والمنطقية. نظرًا لأن البرامج تحتاج إلى بيانات للمعالجة، فإن فهم أنواع البيانات أمر بالغ الأهمية.
 2. **العوامل** - تعمل العوامل على البيانات لإنشاء بيانات جديدة. هناك عوامل تشغيل رياضية للبيانات الرقمية، والعوامل المنطقية للبيانات المنطقية، والمزيد. تستخدم البرامج العوامل لمعالجة البيانات وإنشاء المعلومات. على سبيل المثال، في العديد من لغات البرمجة ، يمكن للمعامل (+) إما إضافة قيمتين رقميتين أو الجمع بين سلسلتين.
 3. **هياكل التحديد** - توفر هياكل التحديد مسارات متعددة للتنفيذ في البرامج. يعتمد المسار على شرط أو قيمة. على سبيل المثال ، توفر جملة if-else مسارين أو أكثر للتنفيذ، اعتمادًا على شرط صواب/خطأ. ستكون البرامج عديمة الفائدة إلى حد ما بدون هياكل الاختيار.
 4. **هياكل التكرار** - تكرر هياكل التكرار عبارة أو مجموعة من العبارات. هذا مفيد لتنفيذ السلوكيات المتكررة في البرامج. تجعل هياكل التكرار، المعروفة أيضًا باسم الحلقات(Loops)، البرامج ديناميكية عن طريق تنفيذ العبارات عدة مرات.
 5. **الإدخال/الإخراج** - تقبل البرامج الإدخال والإنتاج. يوفر الإدخال البيانات التي تحتاجها البرامج. المخرجات تنقل البيانات والمعلومات للمستخدمين.

تعلم جيدا هذه المفاهيم الخمسة الأساسية للبرمجة. مارسها بلغة البرمجة التي تختارها. عندما يحين الوقت لتعلم لغة برمجة جديدة، ستعرف المفاهيم بالفعل. ستحتاج فقط إلى تعلم كيفية استخدامها في اللغة الجديدة.
Hacktoberfest - Week 2 (To be continued...)
Tags: hacktoberfest, javascript, github, opensource
Published: 2020-10-19 23:05:02

Here comes my second PR.

This is a tough one for me. I was planning to find one issue that is just slightly more difficult than my first one. However, while I found out that this issue might take me a longer time than I expected, I've been working on it for more than 2 days. It is a bit late to just give up and looking for a new one.

This issue is to [add keyboard shortcuts to filter the image search results](https://github.com/infokiller/web-search-navigator/issues/91) to an amazing chrome extension called [Web Search Navigator](https://chrome.google.com/webstore/detail/web-search-navigator/cohamjploocgoejdfanacfgkhjkhdkek). As I mentioned in the [Hacktoberfest - Week 1](https://dev.to/yuanleemidori/hacktoberfest-week-1-l9j) post, I want to work with browser extension repos to gain the experience and hopefully start my browser extension project by the end of 2020. This is the second browser extension repo that I contribute to.

I started this feature by viewing the other feature such as keyboard shortcuts for switching *all*, *image*, *video* tabs. My goal is to find out the name of the trigger to toggle between different sizes of image search results. It is more difficult than I thought. While using the developer tool to check to element attribute names. However, I noticed that I can't find the pattern or relevant logic of those attribute names, which means that, there is a big chance that Google might change these property names in the future. Moreover, since I can't seem to find the logic of calling these image sizes, I'll have to select these elements and click them to get the functionalities work. The thing is, this makes my code very ugly, and it might be broken if Google changes these seem-to-be-randomlly assigned attribute names.

I wanted to send the PR until I am satisfied with my code. However, I still need to keep myself on the schedule, which means I have to send the PR by the end of the second week, and that was Oct 18th. After ensuring the functionalities work fine, I submitted the [PR](https://github.com/infokiller/web-search-navigator/pull/221). To be honest, I am not happy with the code that I sent.

I need to find the third and the fourth PR to accomplish my Hacktoberfest. To me, it is a bit overwhelmed and I'm not always satisfied with what I contribute. I think this is the challenge that I have to overcome. Not only to improve my skills for providing better quality work in a limited time but also, to get used to the stress and some negative mood. I'll keep working on this PR in week 3 and maybe week 4 while working on the last 2 PRs. The new challenge for me in the upcoming weeks will be time management. Fingers crossed!
Love to write code, don't like writing comments...Intro to Docly
Tags: python, codequality
Published: 2020-10-19 22:19:49

**Docly** is a useful code commenting tool. It generates docstrings for your python functions to improve readability and maintainability.


It can be run in two ways. The first one just **checks** to see if there are any comments that need to be modified. The second way actually **modifies** the comments. 

Beta is now open, you can test Docly on your own code 👉http://thedocly.io/


Docly yours 😉,
Take Care of Your Eyes
Published: 2020-10-19 21:59:49

As a lifelong glasses wearer, I can tell you, your eyes matter!  As an avid lifelong video game player who sat a little too close to the TV as a child, I can tell you staring at a screen for hours on end without breaks is not a good idea. According to the Vision Council of America, nearly 75% of American adults have some form of vision correction.  So how can we programmers protect our eye sight - especially since staring at a digital screen for long periods of time can lead to digital eye strain? Turns out there are a bunch of tools and actions we can utilize to preserve our eyes!

1. Proper lighting is a must!  Too much harsh light is bad for your eyes. In fact the recommended amount of light is about half of what is found in the average office space. Close drapes, use less overhead lights, try to sit perpendicular to a window rather than facing it.

2. Reflections are the enemy! Glare produced on your screen makes it harder for your eyes to focus.  Try to pair this with the lighting tip to minimize the amount of glare on your screen and even the desk next to your screen.  That harsh light reflected back into your eyes adds strain and makes your eyes work harder to focus.

3. Blink!  Doctor who fans may have a problem with this, especially if they feel like a weeping angel is around the corner, but make sure to blink.  When you stare at a screen you blink less often - roughly one third as often - and deprive your eyes of liquid.  This may lead to agitating dry eye symptoms.

4. Take a break.  Remember to stand and stretch every 20 to 30 minutes.  Similarly, your eyes should be given a break.  Follow the 20/20/20 rule.  Roughly every 20 minutes, look at an object 20 feet away for 20 seconds.  This allows your eyes to focus on something much farther away than the average computer screen and gives them a break from the bright light of the display.

5. Adjust your display.  Install a blue light filter app such as f.lux.  Increase the size of the text on your display.  Buy a display with flicker free technology. All of these can help reduce strain.

6. Think about your posture.  Spending all day hunched forward at a desk typing on a keyboard can be detrimental for you. Back pain, leg pain, stressed nerves in the neck. All of this adds up and can agitate your eyes as well.

7. Take REAL breaks.  Keep in mind that ALL displays can be harmful. Phones, tablets, e-readers. You name it. Staring at all of these displays for too long can cause harm and substituting one for the other is not a legitimate break.

Coding is important and fun. You can use technology to accomplish incredible things.  But don't forget to take care of yourself.
Day 237: Change
Tags: hiphop, code, coding, lifelongdev
Published: 2020-10-19 21:59:27

_liner notes_:
- Saturday : So I decided to take a road trip during my vacation. A coworker from outside the US came to visit family and wanted to meetup. Thought it would be a good time also to see family in South Florida. Had a really good time and got to hang out at a pretty cool park! I talk about it in the latest show. You can check it out at https://kNOwBETTERHIPHOP.com

![Radio show episode image of a 3 story jungle gym in Sugar Sand Park in Boca Raton, Florida with the words Oct 17th 2020, Rat Mouth](https://dev-to-uploads.s3.amazonaws.com/i/i159vdwwcsuioqblnpl3.jpg)

- Sunday : Basically spent the day driving back to Orlando and doing laundry. I also FINALLY figured out the problem I was having in being able to get my private key so I could use it to use an SDK. Now if I ever need to change my private key, I can just upload it to storage instead of using an environment variable and have to deploy my code again.

- Professional : Today was pretty productive even though I had a lot of meetings. Got to review a pull request from a user for Hacktoberfest. It was a really good contribution. Pushed my code that I wrote on the live stream to a repo so other people could see it. Signed up to PluralSight to learn React Native.

- Personal : It started to rain towards the end of the day and I took a nap. Feeling pretty good. It's been a pretty cloudy day so my battery hasn't charged up like normally. Hopefully tomorrow will be better. Going to hang out at the park for a little longer.

![Overhead view of a beach with a large rock in the ocean at Big Sur in California](https://dev-to-uploads.s3.amazonaws.com/i/ldrs8jb8eq3etv6b5qbb.jpg)

So my manager said I need to take more days off. haha That's a change from previous jobs. haha Thinking I may take off every Friday for the rest of the year so I have 3 day weekends. Going to continue working on my side project now that I got past a pretty big hurdle.

Have a great night!

peace piece
Dwane / conshus
https://dwane.io / https://HIPHOPandCODE.com
{% youtube usSXUmJAtu8 %}
My first Hacktoberfest!
Tags: hacktoberfest
Published: 2020-10-19 21:45:13

## What I Learned From Hacktoberfest 2020

This was my first Hacktoberfest! It gave me a kickstart into open source development. I learned a lot in this short period.
By looking at issues that projects had, by finding solutions to that, I learnt development temperament and problem solving.
Also observing other's style of programming and putting things to work, taught me how different approaches can be and how to be more flexible with our solutions.
The community is just awesome. During the entire period of the fest there are hundreds of online workshops and meetups to attend. We can always learn something new from every session!
Lastly, after such a great experience, I'm definitely going to participate even the next year!
Five Basic Programming Concepts To Learn First
Tags: programming, learning, beginners
Published: 2020-10-19 21:31:26

---
title: Five Basic Programming Concepts To Learn First
published: true
description: Learn concepts first, not languages.
tags: programming,learning,beginners
cover_image: https://dev-to-uploads.s3.amazonaws.com/i/0n1uvy4pbpowutiibekb.png
---
I often hear new programmers ask, "Should I learn Python?" or "Should I learn Java or JavaScript?" This is the wrong approach. New programmers should focus on fundamental programming concepts. Having a solid foundation of these concepts makes it easy to learn *any* programming language, because the concepts are common among the different languages.

Here are five basic programming concepts that new programmers should learn first:
1. **Data types** - Programming languages represent data in the real world. Data come in different forms such as integers, floating-point numbers, characters, strings, and Boolean. Since programs need data to process, understanding data types is crucial.
1. **Operators** - Operators operate on data to create new data. There are mathematical operators for numeric data, logical operators for Boolean data, and more. Programs use operators to process data and create information. For example, in many programming languages the + operator can either add two numeric values or combine two strings.
1. **Selection structures** - Selection structures provide multiple paths of execution in programs. The path depends on a condition or value. For example, the if-then-else statement provides two paths of execution, depending on a true/false condition. Programs would be somewhat useless without selection structures.
1. **Repetition structures** - Repetition structures repeat a statement or block of statements. This is useful for implementing repetitive behaviors in programs. Repetition structures, also known as loops, make programs dynamic by executing statements a number of times.
1. **Input/output** - Programs accept input and produce output. Input provides data that programs need. Output communicates data and information to the users.

Learn these five basic programming concepts well. Practice them in your programming language of choice. When it is time to learn a new programming language, you will already know the concepts. You will just need to learn how to use them in the new language.

Thanks for reading. 😃

*Follow me on Twitter [`@realEdwinTorres`](https://twitter.com/realEdwinTorres) for more programming tips and help.*
<sub><sup>Photo credit: [https://images.app.goo.gl/W12kxGcxyo4TwH8A6](https://images.app.goo.gl/W12kxGcxyo4TwH8A6)</sup></sub>
Javascript ES6: Arrow Functions
Tags: javascript
Published: 2020-10-19 21:28:30

**Arrow Functions**

Sometimes when coding our projects in javascript we will create anonymous functions instead of named functions. We usually do this for functions we only plan on using once, such as when using a function as an argument. 

Before ES6 we would code our anonymous functions like this:

```
const myFunc = function(){
  const myDog = "Penny";
  return `My dogs name is ${myDog}`
}

myFunc() // My dogs name is Penny

``` 

ES6 provides us with arrow functions which allow us to write these anonymous functions in a with less code:

```
const myFunc = () => {
  const myDog = "Penny";
  return `My dogs name is ${myDog}`
}

myFunc() // My dogs name is Penny
```

Even better if there is there is no function body and only a return value, arrow function syntax allows you to omit the return keyword and the brackets.

```
const myFunc = () =>  "My dogs name is Penny"
myFunc() // My dogs name is Penny

```

**Writing Arrow Functions With Parameters**
Just as with regular functions you can pass arguments as parameters in arrow functions:

```
const addFive = (num) => num + 5
addFive(1) // 6
```
If there is only one argument you can shorten the code even more by omitting the parentheses around the argument.

```
const addFive = num => num + 5
addFive(1) // 6
```
You can also still pass multiple arguments into an arrow functions

```
const addNums = (num1,num2) => num1 + num2
addNums(10,5) // 15
```
AI-powered tab manager
Tags: javascript, plugin, chrome, extension
Published: 2020-10-19 20:57:21

Hey!

We're a team of 3 friends and we decided to take on the challenge of having "too many tabs open" on the browser. We developed tabby, an AI-powered tab manager that detects unnecessary tabs, and that removes them automatically and silently - with a 1 click tab-restore.

The goal is simple: no more clicking on tabs and searching for them, just auto and accurate interface cleaning. 

So if stackoverflow tabs or duplicate of documentation accumulate on your browser view...and if you're tired of clicking and searching for a tab, then it's worth trying the tool https://www.tabby.us/ :)

It's the first time we build a chrome extension, so we'd love to have your feedback and we'll read more about your awesome blog posts too!

Product demonstration: https://www.youtube.com/watch?v=9v4XbJop918

n°4 Product of the Week on Product Hunt: https://www.producthunt.com/posts/tabby-2