Optimizing bulk inserts in MySQL
Link Here
Quite easy actually:
- Plug in
- Power on
- On the remote, press “Open”
- And press on 9 as many times as it takes to get a “9″ displayed on the screen
That’s it.
December 21, 2007
September 6, 2007
How to make a Höher H088 DIVX/DVD zone-free?
August 1, 2007
WORM - aka how to write things in stone
WORM stands for Write Once, Read Many - it’s usually used for archival storage systems, and it’s actually sometimes a legal requirement (typically in SOX).
At least three solutions can be commonly found on the market:
- Centera, by EMC, is a WORM solution featuring a retention policy
- Network Appliance (NetApp) has a software solution which runs on their systems called SnapLock
- HP sells WORM Tape Drives
But there is no Open Source filesystem doing this yet AFAIK…
July 9, 2007
June 29, 2007
SQL Rosetta Stone
aka how to translate commands between MySQL and PostgreSQL
Meta information
| MySQL | PostgreSQL |
|---|---|
| show databases; | \dn |
| show tables; | \dt |
| show columns from t1; | \d t1 |
| show indexes fom t1; | \di |
Time information
| MySQL | PostgreSQL |
|---|---|
| UNIX_TIMESTAMP() | SELECT EXTRACT(EPOCH FROM TIMESTAMP WITH TIME ZONE '2001-02-16 20:38:40-08'); |
| FROM_UNIXTIME() | select 1063147331.843::int4::abstime; |
| NOW() | NOW() |