Skip to content

Instantly share code, notes, and snippets.

View gorkie's full-sized avatar
🏠
Working from home

GORKEM YILDIRIM gorkie

🏠
Working from home
View GitHub Profile
@meseven
meseven / unique_username.sql
Last active February 16, 2021 17:57
Generates a unique username based on the first and last name entered.
drop trigger if exists unique_username on users;
drop function if exists unique_username();
drop table if exists users;
create table users (
id serial primary key,
username varchar unique,
name varchar not null,
surname varchar not null,
check (username is not null and username != '')
@aozisik
aozisik / macos-mojave-php72-v8js.sh
Last active June 14, 2023 12:28
Installing PHP v8js on Ubuntu 18.04 Bionic or Mac OS Mojave (brew)
# This will retrieve v8 7.4.288.25 when installled
wget https://raw.githubusercontent.com/Homebrew/homebrew-core/0a6171330678879285f2c566db9349da421d6f62/Formula/v8.rb
brew install v8.rb
brew list v8
# You will see this:
# /usr/local/Cellar/v8/7.4.288.25/bin/d8
# /usr/local/Cellar/v8/7.4.288.25/libexec/include/ (21 files)
# /usr/local/Cellar/v8/7.4.288.25/libexec/ (7 files)