teleren/devto huggingface dataset:
Updated dbForge Studio for PostgreSQL Helps Standardizing SQL Code
Tags: postgres, sql, database, databasetools
Published: 2019-10-01 13:15:51

---
title: Updated dbForge Studio for PostgreSQL Helps Standardizing SQL Code
published: true
description: Devart rolled out the next version of dbForge Studio for PostgreSQL v.2.2 with SQL Code Formatter, ‘Generate Script As’ functionality, improved performance of large script execution, and a bunch of other notable features. 
tags: PostgreSQL, SQL, database, database tools
---

*Devart rolled out the next version of dbForge Studio for PostgreSQL v.2.2 with SQL Code Formatter, ‘Generate Script As’ functionality, improved performance of large script execution, and a bunch of other notable features.*

![PostgreSQL Code Formatter](https://blog.devart.com/wp-content/uploads/2019/09/sql-code-formatter-1.png)

Devart, a Czech software vendor of database tools and data connectivity solutions  for developers and DBAs, released the new, significantly updated, version of [dbForge Studio for PostgreSQL v.2.2](https://blog.devart.com/standardize-your-sql-code-with-dbforge-studio-for-postgresql-2-2.html). The solution is powered by SQL Code Formatter, ‘Generate Script AS’ feature, and other eagerly awaited improvements.

The SQL Code Formatter will widen the range of formatting options for beautifying or customizing legacy SQL statements. While ‘Generate Script AS’ feature will allow generating a script for the CREATE statements for specific database objects (views, materialized views, triggers, functions, procedures). These and other updated features, such as the improved performance of script execution, for example, are aimed to help development teams achieve next-level productivity. 

The new features coming in the version of dbForge Studio for PostgreSQL v.2.2 include:

◘ SQL Code Formatter;
◘ Generate Script AS CREATE; 
◘ Cached Updates Mode in Data Editor;
◘ Dramatically Improved Performance of Large Script Execution;
◘ PostgreSQL 12 Connectivity Support;
◘ Extended Amazon RedShift Support;
◘ New Modern Application Skins.

**dbForge Studio for PostgreSQL** is a GUI tool for database development and management. This IDE for PostgreSQL allows users to create, develop, and execute queries, edit and adjust the code to specific requirements in a convenient and user-friendly interface. Learn more about the new version of dbForge Studio for PostgreSQL at the Devart official blog – [https://blog.devart.com/standardize-your-sql-code-with-dbforge-studio-for-postgresql-2-2.html](https://blog.devart.com/standardize-your-sql-code-with-dbforge-studio-for-postgresql-2-2.html).

**About Devart**

Devart is one of the leading developers of database tools and administration software, ALM solutions, data providers for various database servers, data integration and backup solutions. The company also implements Web and Mobile development projects.
For additional information about Devart, visit https://www.devart.com/
Let's Build React and TypeScript Documentation Together
Tags: hacktoberfest, typescript, react, contributorswanted
Published: 2019-10-01 13:09:56

{% github aryanj-nyc/reactandtypescript.dev %}

# How It Started

It seemed as if every time I tried to start a React project using TypeScript, I'd take way too much time on getting the TypeScript right. I started my [unofficial React and TypeScript documentation](http://reactandtypescript.dev) as a way to keep my own notes on using TypeScript with React (and as a way to play with Gatsby and [docz](http://docz.site/)).

# Inspiration

The idea and a lot of the material is admittedly heavily based off [@swyx](https://twitter.com/swyx)'s [TypeScript Cheatsheet](https://github.com/typescript-cheatsheets/react-typescript-cheatsheet). I believe a website can add more functionality (search, for instance) than a standard GitHub README.

# Prerequisites to Contributing

I do not foresee contributing to the project to be exceptionally difficult. However, some React and Markdown experience is required:

1. A contributor will need React experience to validate that the documentation they submit to the repository.
2. A contributor will need Markdown experience to actually write the documentation (the entire repository is basically a bunch of mdx files)

# Hopes for This Project

I hope [React and TypeScript](http://reactandtypescript.dev) becomes the de facto place for users to find React and TypeScript documentation. Additionally, I hope this provides a safe place for beginners to submit pull requests and learn how to use TypeScript with React by actually writing the documentation.

# Ways to Help

The greatest help will come from an active GitHub community full of new ideas (issues) and contributors. However, I understand that that may not be possible for some people. It's all good though! Show me some love by sharing this article, sharing the GitHub repo or even just clicking "Star" on the GitHub repo.

{% github aryanj-nyc/reactandtypescript.dev %}
Enabling Geo Replication on Azure SQL Server Database
Tags: azure, azuresqldatabase, azuresqlserver, georeplication
Published: 2019-10-01 13:05:47

In this [tutorial](https://github.com/patricksameerajayalath/AzureTutorials/blob/master/Enabling%20Geo%20Replication%20on%20Azure%20SQL%20Server%20Database.pdf) I’m going to show how to:

•	Enable Geo Replication
•	Test out Geo Replication


![Alt Text](https://thepracticaldev.s3.amazonaws.com/i/dvwhronc9jzk7q6p6t68.jpg)

You can find the PDF version of this tutorial [here](https://github.com/patricksameerajayalath/AzureTutorials/blob/master/Enabling%20Geo%20Replication%20on%20Azure%20SQL%20Server%20Database.pdf).

You can find all my Azure/.Net tutorials [here](https://dev.to/patricksameerajayalath) and [here](http://sameerajayalath.blogspot.com/).

Enjoy !!
Hacktberfest 2019 REPOSITORY
Tags: hacktoberfest, github, digitalocean
Published: 2019-10-01 13:03:13

https://github.com/computerwala/hacktober2019
This Repo is for all the fresher/starter who want to start their journey in contributing to Open-Source Community. Submitting a Pull request here will help to get you familiar with the process.
Spaces, a coworking spaces Bootstrap 4 template
Tags: coworking, bootstrap, nomad, template
Published: 2019-10-01 13:02:44


Spaces is one of the most advanced Co-working Listing Web Templates we ever created. It is built on the popular Bootstrap 4 CSS Framework and includes beautiful and practical pages to best showcase co-working spaces for awesome workers.

Spaces comes with 13 advanced pages with a focus on providing high quality content in the field of co-working spaces across the world. Not only that, but this product also comes with a vast collection of custom UI Elements including buttons, alerts, navigation bars, pricing cards, profile cards and many more. All of these components are thoroughly documented and have examples provided for their usage.

Let us present you a list of all the available unique pages:

- Homepage
- Space details (details, reviews, video, gallery, location, contact user)
- Listing of spaces (search, filter, sidebar & multiple views)
- Submit a space
- About page
- Contact page
- Blog
- Article
- Sign in
- Sign up
- Reset password
- Coming soon page
- Legal page (terms & conditions, privacy)
- 404 error
- 500 error

We used the infamous Gulp to process dev tasks such as creating a distribution (minified) version of the product which skyrockets the Google PageSpeed scores to almost a perfect 100 score. At the same time, we also provide a simple classic HTML5, CSS & Javascript version of Spaces without all the other preprocessor languages such as Sass.

![Spaces Coworking Template](https://thepracticaldev.s3.amazonaws.com/i/al2zx0qrn2vsj7v7yooc.jpg)

This co-working listing web template comes with the most popular CSS extension language called Sass, which empowers developers to effectively use variables, mixins and well modularized files to have a seamless workflow. Changing colors, fonts, spacings and shadows is just a few clicks away.

Spaces is also a 100% responsive Bootstrap 4 website with a special care for all devices including custom layouts for tablets. The HTML5 templates are all 100% W3C validated and all assets such as images, fonts and icons are free to use.

Useful links:

 - [Demo](https://demo.themesberg.com/spaces/index.html)
 - [Download](https://themesberg.com/product/bootstrap-themes/spaces-coworking-listings-template)

This product was proudly brought to you by the official Themesberg development and designer team.
How to set the home page in ShopAmaze Responsive Opencart 3 Theme
Tags: opencartthemes, creativeopencarttheme, opencartresponsivetheme, opencartmarketplacetheme
Published: 2019-10-01 12:37:44

ShopAmaze is 100% responsive, lightweight and Ultra-Fast, Simple yet Beautiful OpenCart 3x theme. ShopAmaze opencart theme provides many home page and product page module. Home page module like Featured product module, Top rated product module, Floating popup module, Popular Category module and Product page module like recently view product module, Cross sale module. This module makes your website home page more attractive and beautiful. ShopAmaze theme easy to install and theme setting is very easy.
Home page setting
First of all, install the theme as per user guide and go to the left navigation menu and select the extension and click on it After that, go to extension > select Theme edit your default store theme and change Theme Directory default to ShopAmaze. After that, click on the Save button.
Go to Extensions>Extensions>select module and install PurpleTree ShopAmaze Theme Settings module click on the edit button. Here you can set your website main menu as per your choice like standard Menu and Megamenu Menu. You can also set the Megamenu image dimension and your website social link. After the theme setting, you can click on the Save button.
Again go to Extensions>Extensions>select module and install all home page modules like PurpleTree ShopAmaze Best Seller products module, PurpleTree ShopAmaze New Arrivals, PurpleTree ShopAmaze Parallax Block module, PurpleTree ShopAmaze Popup module, PurpleTree ShopAmaze Top Rated Products, etc. After installing all modules edit all home page modules and give all the required information and save it.
PurpleTree ShopAmaze Best Seller products Module
This Module shows all Bestseller product base of product sell.
PurpleTree ShopAmaze New Arrivals Module
This module shows a new arrivals product. In PurpleTree ShopAmaze Module you can select new arrivals products by using the drop-down list and give limit, height, width, and status.
PurpleTree ShopAmaze Parallax Block Module
Using this module you can set your store parallax block. In this module edit page, you can enter the background image, foreground image, Description and status of the module.
PurpleTree ShopAmaze Popup Module
You can use this model to show a module in the Popup box. When you edit this module you can give height and width of Popup box and Select module for Popup box, Add custom CSS and set module status.
PurpleTree ShopAmaze Top Rated Products Module
This Module shows top-rated products based on the product rating. When you can edit this module setting you can give Module name, Product limit, No of product in Slide, Height, width, and status of the module.
For set, all home page modules go to navigation menu>design> Layout > select home page and edit set all module using add module button in Content Top field as your choice. After setting all module your home page looks like this.
Get the theme at: https://www.purpletreesoftware.com/shopamaze-theme-opencart.html
My First Hacktoberfest PR's
Tags: hacktoberfest, git, beginners
Published: 2019-10-01 12:34:05

There's plenty of text only repo's to contribute to. The first one that had a merged PR was this [Hacktoberfest Swag](https://github.com/crweiner/hacktoberfest-swag-list) list. I discovered it looking to see if any other companies had incentives for completing PR's. Turns out they do, also, turns out most require a little more work than just updating a couple text documents. :D

The second one I discovered and contributed to appears to have been created simply for folks to complete easy text contributions [Hello World in different languages](https://github.com/piyush97/Hacktoberfest) in which I submitted a powershell file. 

Day 1 and I'm 50% to getting my t-shirt.  How are you doing?
Hacktoberfest Done 💥 but Not Done 🚀
Tags: hacktoberfest, github, opensource
Published: 2019-10-01 12:33:27

---
title: Hacktoberfest Done 💥 but Not Done 🚀
published: true
description: 
tags: hacktoberfest , github , opensource
---

![Alt Text](https://thepracticaldev.s3.amazonaws.com/i/y5hawwvcnvjquiz7y72n.jpg)
Hacktoberfest: share your favorite Angular resource
Tags: hacktoberfest, angular, opensource, contributorswanted
Published: 2019-10-01 12:11:23

---
title: Hacktoberfest: share your favorite Angular resource
published: true
cover_image: https://thepracticaldev.s3.amazonaws.com/i/z57etutx17mrb8zecygx.png
description: Share your favorite Angular resource and earn a contribution!
tags: hacktoberfest, angular, opensource, contributorswanted
---


It's the first of October, that means [Hacktoberfest](https://hacktoberfest.digitalocean.com/) has officially started!
Do you want to earn a contribution or do you want to make your first Pull Request?

Then I might have the perfect project for you!
Share your favorite Angular resource of 2019 at 

{% github timdeschryver/hacktoberfest-2019-angular %}

Feel free to DM me if you have a question, I'm glad to help you.

To view the list of resources head over to https://timdeschryver.github.io/hacktoberfest-2019-angular, once your Pull Request is merged it will become visible on the same site.

While this repository is aimed for "people getting started", it does not mean a more experienced contributor can't add their favorite resource!

-------

Follow me on Twitter at [@tim_deschryver](https://twitter.com/tim_deschryver).
From bash to zsh. My little adventure
Tags: macos, terminal, bash, zsh
Published: 2019-10-01 11:39:24

A few months ago Apple announced the upcoming version of its desktop OS macOS Catalina, which is going to replace the default command line shell `bash` with `zsh` for all newly created accounts. This was the start of my “adventure”. It wasn’t so long, however it was full of pitfalls. So I came here in the hope to save a few hours for someone.

First of all lets change a command line shell for your user. To do that we need locate `zsh` and set as default shell:

```
# get path to `zsh` on your machine and use it with `chsh` command
$ which zsh
/bin/zsh
$ chsh -s /bin/zsh $USER
```

Restart Terminal.app and make sure that your changes applied:

```
$ ps -p $$ -oargs=
-zsh
```

Now we can make some customizations. Every day I operate with `git` from terminal so there are two important things for me: git-prompt and git-autocomplete. Zsh provides git-autocomplete out of the box. So there is some commands to set up prompt:

```
$ cd ~/
$ curl -o .git-prompt.sh https://raw.githubusercontent.com/git/git/master/contrib/completion/git-prompt.sh
$ touch ~/.zshrc
```

We almost done 😁 Open `~/.zshrc` in your favourite text editor and put there:

```
#!/bin/zsh

# Set up git-prompt
source ~/.git-prompt.sh
setopt PROMPT_SUBST; PS1='%~ $(__git_ps1 "(%s)")\$ '

autoload -U compinit; compinit

# If you have aliases or $PATH extensions  in your .bash_profile paste it below
```

Restart your terminal one more time and enjoy your new shell.

![A terminal's preview after restart](https://thepracticaldev.s3.amazonaws.com/i/pm1cwryg94egexu0gd82.png)
Day 2 : Action
Tags: hiphop, code, blog, coding
Published: 2019-10-01 11:25:42

_liner notes_:
- Professional : Pretty action packed first day! Had a morning meeting with my manager (morning for me, afternoon for him) to help with my on-boarding. Of course my internet decides to cut out on me in the beginning of it. (Things could only go up from here, right? haha) Got signed up and logged into a bunch of different services. Hopped into the team Slack and everyone was super welcoming. My task for the day was to review 2 tutorials for an upcoming product. Some pretty cool stuff. Got one finished and sent my notes to my manager so I could get some feedback. He wrote back "This is amazing!" so that was cool. haha Also got an email being recognized for my contributions today. Spent the rest of the day finishing up reviewing the other tutorial and other on-boarding tasks.
- Personal : After work, I hopped into working on my personal site (https://lifelong.dev). I switched it over to not pull from my Medium blog but this dev.to feed. Since it's new, I guess my feed's endpoint wasn't ready yet, so I had to use a stand-in to set things up in my code. When it was ready, I just had to switch the username and everything worked. I'll have to rework some styling since the format is different from Medium. Cool. Also finally got my applications approved by Meetup so I can now use their new API to get the upcoming events section of the site working again. The problem is that I have to be on the Pro plan to have access to the endpoints I need. There's a month trial so we'll see how it goes. My site is now fully functional again. Going to do some clean up and refactoring to speed it up. There's something I've been wanting to try so this will be interesting.

![Campagna, Italy country side photo](https://thepracticaldev.s3.amazonaws.com/i/s4wdivqfy48juvpzlof5.jpg)
Yesterday was a whirlwind! Looking forward to seeing what's in store for me today. Still need to get used to all the different sites/services I signed up to. There's more on-boarding to do. So we'll see what I get into.

After work, I want to start the refactoring of my site to hopefully have it load faster and clean up the code I did yesterday to get the upcoming events working and integrating my dev.to feed.

Think that's it for now. Going to get ready to start work.

Have a great day!

peace piece
Dwane / conshus
https://dwane.io / https://HIPHOPandCODE.com
{% youtube _DIU2PvHs5U %}
How to add AdMob to Android app
Tags: android, admob
Published: 2019-10-01 10:24:36

---
title: How to add AdMob to Android app
published: true
description: 
tags: android,admob
---

## Use AdMob with Firebase

- https://firebase.google.com/docs/admob/android/quick-start

`build.gradle`
```groovy
buildscript {
    repositories {
        google()
        jcenter()
        
    }
    dependencies {
        classpath 'com.google.gms:google-services:4.3.2'
    }
}
```

`app/build.gradle`
```groovy
class Version {
    class Firebase {
        static def analytics = "17.2.0"
        static def ads = "18.2.0"
    }
}

dependencies {
    implementation "com.google.firebase:firebase-analytics:$Version.Firebase.analytics"
    implementation "com.google.firebase:firebase-ads:$Version.Firebase.ads"
}

apply plugin: 'com.google.gms.google-services'
```

`Manifest.xml`
```xml
<manifest>
    <application>
        <!-- Sample AdMob App ID: ca-app-pub-3940256099942544~3347511713 -->
        <meta-data
            android:name="com.google.android.gms.ads.APPLICATION_ID"
            android:value="[ADMOB_APP_ID]"/>
    </application>
</manifest>
```

`MyApplication.kt`
```kt
class MyApplication: Application() {
    override fun onCreate() {
        super.onCreate()

        MobileAds.initialize(this)
    }
}
```

## AdView

`fragment.xml`
```xml
<com.google.android.gms.ads.AdView
        xmlns:ads="http://schemas.android.com/apk/res-auto"
        android:id="@+id/adView"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        ads:adSize="BANNER"
        ads:adUnitId="ca-app-pub-123456/123456"
        ads:layout_constraintBottom_toBottomOf="parent"
        ads:layout_constraintLeft_toLeftOf="parent"
        ads:layout_constraintRight_toRightOf="parent"/>
```

`Fragment.kt`
```kt
import com.google.android.gms.ads.AdRequest
import com.google.android.gms.ads.AdView

val request = AdRequest.Builder().build()
adView.loadAd(request)
```

## Troubleshooting

### Link your app to Firebase option not showing

- https://support.google.com/admob/answer/6383165?authuser=0
- Use standalone AdMob https://developers.google.com/admob/android/quick-start

`app/build.gradle`
```groovy
dependencies {
    implementation 'com.google.android.gms:play-services-ads:18.2.0'
}
```

### Cannot fit requested classes in a single dex file

- https://stackoverflow.com/questions/48249633/errorcannot-fit-requested-classes-in-a-single-dex-file-try-supplying-a-main-dex

`app/build.gradle`
```groovy

android {
    defaultConfig {
        multiDexEnabled true
    }
}

dependencies {
    implementation 'com.android.support:multidex:1.0.3'
}
```

## Read more

- http://thetechnocafe.com/a-complete-guide-to-integrating-admob-in-your-android-app/

Original post https://github.com/onmyway133/blog/issues/431
Security, meet Agile; Reviewing code you dislike; and Web Performance KPIs
Tags: security, codenewbie, webperf
Published: 2019-10-01 11:15:15

*My TL;DR style notes from articles I read today.* 


### [Integrating Security With Agile Development](http://bit.ly/agile-security)

- Create an up to date threat model and data flow diagram. Focus on one security story in each development sprint. 
- Teach your team basic threat modeling. Get them to think about it in each sprint cycle.
- Integrate a static analysis tool into IDE & Dependency / Open source security checks into local build processes whenever possible.
- Integrate both of these into a CI/CD pipeline, and break the build on issue thresholds. 
- Configure dynamic test tools into the CI/CD pipeline on deploys.

*[Full post here](http://bit.ly/agile-security), 6 mins read*

-----

### [10 tips for reviewing code you don’t like](http://bit.ly/codereview101)

- Discuss. Don’t critique. Don’t argue. 
- Talk facts. Talk respectfully. No snarky remarks. 
- Don’t say something is obvious just because it is obvious to you. 
- Ask questions. Ask for clarifications. Ask why someone did what they did. 
- Share what you expect and set time aside for reviews in advance. 

*[Full post here](http://bit.ly/codereview101), 5 mins read* 

-----

### [The Importance of Web Performance Benchmarking](http://bit.ly/web-performance-benchmark)

Focus on these web performance benchmarking KPIs for online applications:
- Page load time
- Application availability
- Webpage size & content
- Third-party services performance
- User engagement &/or transactions 

*[Full post here](http://bit.ly/web-performance-benchmark), 5 mins read* 

-----

*I share these TL;DR versions of articles on software engineering that I read every weekday through my newsletter - in.snippets(). [Sign up here](https://mailchi.mp/appsmith/insnippets?utm_source=devto&utm_medium=post08&utm_campaign=is) if you liked what you just read.*