Skip to content

Instantly share code, notes, and snippets.

View Dzoge's full-sized avatar

Toka Gelashvili Dzoge

11 followers · 4 following
  • Tbilisi
View GitHub Profile
@Dzoge
Dzoge / demo.md
Created July 1, 2021 15:55 — forked from danharper/demo.md
Open native Maps apps on iOS and Android in Cordova
iOS (with pin, iOS will lookup address too and show that as label)
maps://?q=LAT,LNG
Android, no pin (just open at location)
geo:LAT,LNG
@Dzoge
Dzoge / generate-nvarchar-data-update-commands
Created January 28, 2021 10:23
Replace text in all NVARCHAR type columns in all tables
SELECT
'UPDATE ['+TABLE_SCHEMA+'].['+table_name+'] SET ['+column_name+'] = REPLACE(['+column_name+'], ''existing-text'', ''new-text'');'
--,table_name as [TableName]
--,column_name as [ColumnName]
--,TABLE_SCHEMA as [SchemaName]
from information_schema.columns
where data_type = 'nvarchar'
and character_maximum_length=-1
@Dzoge
Dzoge / create-centos7-dotnetcore-runtime-prod.sh
Last active July 5, 2019 08:18
Create .NET Core 2.2 runtime production environment on Centos 7
#!/bin/bash
# for a quick installation of this script run the following command
# bash <(curl -L https://gist.github.com/Dzoge/8adb0c80aabb12309c030663247a230a/raw)
# Update Packages
yum upgrade -y
# Install dotnet runtime
rpm -Uvh https://packages.microsoft.com/config/rhel/7/packages-microsoft-prod.rpm
@Dzoge
Dzoge / install-tor-and-nginx-on-centos7.md
Last active January 7, 2024 17:33
Install Tor and Nginx

Installation

Linux

  1. Download latest version Minimal ISO CentOS from https://www.centos.org/
  2. Install centos with minimal required hardware configuration
    • CPU - 1
    • RAM - 1GB
    • HDD - 20GB
  3. optional Create an additional user with the administrator privilages (ex: myuser)