Skip to content

Instantly share code, notes, and snippets.

View brain90's full-sized avatar
💭
Waiting tesla roadster

Gibrain brain90

💭
Waiting tesla roadster
View GitHub Profile
@brain90
brain90 / Nuclear topic study
Created May 12, 2023 02:52
Nuclear topic study
# Nuclear Power Plants Topic Study
## Basics of Nuclear Power
- Nuclear fission
- Nuclear fusion
- Radioactive decay
- Energy release in nuclear reactions
## Components of a Nuclear Power Plant
- Nuclear reactor
@brain90
brain90 / dump-image.php
Created August 10, 2021 10:50
os ticket dump whole attachment to file system
<?php
// path to restore image
$path = '/data/helpdesk';
// db config
$host = 'localhost';
$dbname = 'helpdesk';
$user = 'your_user';
$pass = 'your_pass';
@brain90
brain90 / load_csv_to_sql_server.sql
Created June 28, 2021 01:43
Fastest way to load data into sql server
--- Load from table dump_1.csv to dump_100.csv
--- *.csv has million records
DECLARE @i int = 0
DECLARE @fromTable VARCHAR(MAX)
declare @sql varchar(max)
WHILE @i < 100
BEGIN
print @i
+-----------------+-------+
| word | count |
+-----------------+-------+
| nga | 1 |
| ngaceng | 3 |
| ngadem | 1 |
| ngadimig | 1 |
| ngadimiks | 1 |
| ngadimix | 4 |
| ngadmin | 2 |
@brain90
brain90 / hcs_deploy_to_client.sh
Last active April 18, 2016 17:00
Deploy DB ke client, dengan preloaded data hanya sistem dan master table.
##### Pada SOURCE_DB #####
# Dump hanya schema saja dari seluruh object
$ pg_dump -Fc -U hcsuser -h localhost -s hcs_latest > hcs_latest_schema_only.dump --verbose
# Dump hanya konten dari object yg diinginkan (ex: sys tables, dan master table)
$ pg_dump -U hcsuser -h localhost -a -t user -t roles -t menu_roles -t master_* hcs_latest > hcs_master_content.sql --verbose
##### Pada TARGET_DB #####
#!/bin/bash
set -x
echo 'Processing...'
# Script ini dijalankan dari staging server
# Dump latest db di Production
ssh brain@bojong-production -v <<'ENDSSH' pg_dump -Fc -U knuth -N sym -T sym* -h 192.168.3.1 spacex_production -p 5433 >
$(date +"%Y%m%d")_spacex_production.backup --verbose
@brain90
brain90 / kernel-commit-log
Created March 15, 2015 06:56
linus commit log
commit 36bef88380037288d5b575ed2029de694533b1ec
Merge: e93df63 e6441ba
Author: Linus Torvalds &lt;torvalds@linux-foundation.org&gt;
Date: Mon Mar 9 18:17:21 2015 -0700
Merge git://git.kernel.org/pub/scm/linux/kernel/git/davem/net
this issue to me and supplied a patch. When I tested this on my x86
test box, it caused thousands of backtraces and warnings to appear in
dmesg, which also caused a denial of service (a warning for every
<?
function trimSpace($rowFromCSV)
{
$cleanRow = array();
array_walk($rowFromCSV, function ($val, $key) use (&$cleanRow) {
$cleanData[trim($key)] = trim($val);
});
return $cleanRow;
}
Array
(
[Indonesia] => Array
(
[Bali] => Array
(
[0] => Legian
[1] => Tanah Lot
[2] => Seminyak
)
<?
$ObjekWisata = array(
"Indonesia" => array("Bali" => array("Legian","Tanah Lot","Seminyak"),
"Jawa Barat" => array("Grand Canyon","Ranca Upas","Curug Dago")),
"Eropa" => array("Spanyol" => array("Granada","Andalusia","Navarra"),
"Turki" => array("Fethiye","Nemrut","Belek")
));
?>