Mika/Notes: Difference between revisions

From WikiDotMako
(103 intermediate revisions by 17 users not shown)
Line 2: Line 2:
'''
'''


=Public Health=
* I moved Computer Stuff to a [http://wiki.mako.cc/Mika/Notes/Computer_Stuff new page]
* [http://wiki.mako.cc/Mika/Notes/Biking Biking] information on a separate page.
* Moved to [http://wiki.mako.cc/Mika/Notes/Public_Health Public Health].
* Made a [http://wiki.mako.cc/Mika/Notes/Beer Beer] page
=Miscellaneous=


The page got too long, so I moved it to [http://wiki.mako.cc/Mika/Notes/Public_Health Public Health].
* Banach-Tarski paradox.
* minipimer
* Temblor Range
* Khalil Gibran
* Making of 3 'Idiots'
* 野菜寿し ポタジエ Yasai Sushi
* 8tablish
* Sundial Atelier
* MOCORO モコロ vacuum
* 丸ゆべし
* Fly Geyser
* Bar Yamamoto
* Wall bar
* Rage bar
* Tapas Molecular Bar at Mandarin Oriental, Tokyo
* [http://daikokuyu.com/index.html daikokuyu]
* ディマシオ美術館
* MERIDA X BASE
* 御殿場MTBパークFUTAGO
* notNeutral cups


=Movies=
=Gardening=


I liked these movies:
* I can use agar to grow Kaiware seeds etc.


* Trouble the water
=Bicycle=
* Cube
* MST3K Pumaman


=Computer Stuff=
* Brakes
** Change brake pads before the grooves are gone: http://www.jimlangley.net/wrench/brake1.htm
** U-brake (Center pulled calliper brake) are what's on my red bike.
* Items that may be useful for touring trips
** Portable Water Heater - SunRocket Solar Thermos and Kettle - Boil Water With Only Sunlight


==Miscellaneous==  
=Hiking=


Writing down things I've learned. Some miscellaneous stuff are:
* Potential summer hike ideas
:: [http://www.wta.org/go-hiking/seasonal-hikes/summer-destinations/mount-st.-helens-hikes Mt. St. Helens]


* AJAX example: Checks if the username you entered is taken.
=Concert=
* Javascript example: Drag choices up and down.
* The tool to take a screen-videoshot (screencast) is to install recordmydesktop.
* i686 (or i386) are 32 bit. Intel 64 bit processor is usually marked by _64 (really?)
* Add a keyword (i.e. g) to a bookmark (i.e. http://www.google.com/search?q=%s) to make a shortcut in the address bar in Firfox.
* [http://cran.r-project.org/doc/manuals/R-intro.html#Top R tutorial]


==R==
* Chopin Piano Concerto #1
* Ravel Piano Concerto in G major
* Gruppen (Stockhausen)　(2012 May NY Philharmonic?)
* Symphony No. 3 (Górecki)


* expression and assignment
=Piano=


==PHP==
* Balakirev / Glinka "The Lark"
* Liszt "Gnomenreigen"
* Chopin 3rd Sonata
* Beethoven Sonata 31
* ラヴェル／鏡より「道化師の朝の歌」


'''Problem:'''
=Movies=


Again, I was doing [http://php5.seesaa.net/category/4118446-1.html this tutorial]. I got the update/delete working but not insert. Even when I typed in the values, it returned Missing Values.
I liked these movies:


'''Solution'''
* Trouble the water
 
* Cube
I said name="id" in select3.php in the form part for insert3.php but I said _POST[ID] in insert3.php. I changed it to id and it works fine now.
* MST3K Pumaman
 
* Tokyo!
----
* Annabel Chong
 
* I love me
'''Problem:'''
 
I was doing [http://php5.seesaa.net/category/4118446-1.html this tutorial]. First of all, I didn't quite write down the codes right:
 
* incorrect update/delete versions linked from select.php
* <?= is good <? = is not good
* _GET['X'] is good but _GET["X"] is not good.
* Don't free memory in the php that is required_once
 
After fixing all these, I got:
 
"failed query"
SQL:SELECT Name WHERE ID =
 
'''Solution'''
 
Since I got the same message for both update and delete, I figured that the problem was elsewhere. I looked at select3 and after update3.php? I said id= instead ID= . I capitalized the id for bother update3 and delete3 and it works fine now.
 
==MySQL==
 
To be sorted:
 
* http://mysqlweb.net/category/4025593-1.html
* http://dev.mysql.com/doc/refman/5.0/en/join.html
* http://dev.mysql.com/doc/refman/5.1/en/selecting-rows.html
* fetchone() doesn't take an argument: http://python-sybase.sourceforge.net/sybase/node10.html
 
===Cheat Sheet===
 
* mysql_connect()
* mysql_select_db()
* mysql_query()
* mysql_num_rows()
* [http://php.net/manual/en/function.mysql-free-result.php mysql_free_result()]
* mysql_close()
* This is for outputting mysql queries into a text file: mysql > select * from table INTO OUTFILE '/tmp/test.txt';
 
'''Problem:'''
 
I tried to write a php and connect to mysql in it but I got an error:
 
Fatal Error: undefined function mysql_connect()
 
'''Solution:'''
 
[http://www.webmasterworld.com/forum88/5216.htm This page] suggested that mysql isn't enabled by dafault in php5. I installed php5-mysql and restarted apache2 (don't know if that was necessary) and now it works.
 
----
'''Problem:'''
 
I restarted my computer because I couldn't start gimp unless I was root. Clint told me that I should sudo /etc/init.d/dbus restart , which basically restarted my whole computer. Since then, I couldn't use mysql because I kept getting this error:
 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
 
'''Solution:'''
 
I followed [http://forums.mysql.com/read.php?11,42525,46765#msg-46765 this] and restarted mysql by:
 
/etc/init.d/mysql restart
 
But it fails. It seems like I touched my.cnf and didn't restart mysql, so when my computer restarted, it incorporated the changes I made in my.cnf and mysql stopped working. I reinstalled mysql-server through apt-get, restarted mysql and now it's fine.
 
----
'''Problem:'''
 
I have a bunch of text files from USDA, which contain bits and pieces USDA ASCII databases. I want to put them into mysql.
 
'''Solution:'''
 
1. I found schema.sql that Erik created, so I'm going to borrow it rather than creating my own.
 
mysql databasename < schema.sql -p
 
 
'''Problem:'''
 
mysql> create database newdatabase;
 
ERROR 1044 (42000): Access denied for user 'user'@'localhost'...
 
'''Solution:'''
 
[http://dev.mysql.com/doc/refman/5.1/en/creating-database.html mysql]
 
1. Check grants for 'user'@'localhost' in mysql:
 
mysql> show grants for 'user'@'localhost';
 
2. Log into mysql as root (has all privileges) and change grants for a specific user:
 
mysql> grant all privileges on *.* to 'user'@'localhost';
 
Query OK, 0 rows affected (0.00 sec)
 
3. Log back into mysql as user (now has all privileges) and try creating a new database again.
 
----
 
==Python==
 
To be sorted
* http://mysql-python.sourceforge.net/MySQLdb.html
** http://www.devshed.com/c/a/Python/MySQL-Connectivity-With-Python/2/
 
*TypeError: fetchone() takes exactly 1 argument (2 given)
** This really means 1 argument given because each method comes with an argument to begin with.
 
* To obtain input, I can use raw_input().
 
'''Problem:'''
 
I wanted to create a [http://en.wikipedia.org/wiki/Table_markup wiki table] from CIA's Infant Mortality Rate [https://www.cia.gov/library/publications/the-world-factbook/rankorder/2091rank.html ranking] data. I didn't want to change to the wiki table format, so I decided to write a python code.
 
'''Solutions:'''
 
I had to read a text file, make a list for each line, take out the words I need, and print in the wiki table format. I did the following first to change tabs to commas but that was probably not necessary:
    sed 's/\\t/,/g' Desktop/rawIMRdata.text > rawIMRdata2.text
 
 
When I forgot /g, it only outputted the last line.
 
Here's the python code:
 
    imr_data = open("rawIMRdata6.text")
    #f = file("imr_data","r")
    print '''{| class="wikitable" border="1" \n|- \n!  Ranking 1 \n!  Country 2 \n!  IMR \n'''
    for line in imr_data.readlines():
        # To make a list for each line from text file:
        a = line.split(',')
        #print a and strip the space after each word
        one = a[0].strip()
        two = a[1].strip()
        three = a[3].strip()
        combined = '|-\n|' + one + '\n|' + two + '\n|' + three 
        print combined
    print r'''|}'''
 
----
 
==Django==
----
 
*Tried setting up Django on my computer by following this [http://itpro.nikkeibp.co.jp/article/COLUMN/20081031/318265/?ST=develop&P=4 tutorial]
 
'''Problem:'''
 
It worked mostly ok but I couldn't go further than the second to the last coding box on page 4. I kept getting long error messages.
 
'''Solution:'''
 
[http://docs.djangoproject.com/en/dev/intro/tutorial02/ Django tutorial about django.contrib.admin]
 
1. Check if I typed in the correct codes.
 
2. Check if the output are the same everwhere:
 
Although the codes were correct, they didn't create all the necessary things, so it couldn't find the index.html.
 
* I went to setting.py to specify:
** the absolute path for Template_Dir. Don't forget the , after '/path/' .
** two additional Installed_Apps: myprj_myapp (where I save my project) and django.contrib.admin . Run python manage.py syncdb afterwards.
 
This created myapp_post and django_admin_log in mysql database.
 
----
 
==Javascript==
----
 
[http://java-script.seesaa.net/category/2493027-1.html JS Tutorial]
 
----


==HTML==
I want to watch these movies:


'''Problem:'''
* Uncle Boonmee Who Can Recall His Past Lives
* Faust by Alexander Sokurov
* ビルマVJ 消された革命
* Sleeping Beauty (2011)
* Amour
* Pee Wee's big adventure
* White Dog, The Naked Kiss, Shock Corridor by Samuel Fuller
* スープ
* Kings of Pastry
* Streetwise (1984)


I didn't know what <td> meant.
=Books=


'''Solution:'''
* 1Q84
* AIDS and Accusation (Paul Farmer)
* 農協との３０年戦争 岡本重明
* Saturday is for Furnerals (Max Essex)
* クォンタム・ファミリーズ
* Penguin and Leviathan (Yochai Benkler)
* The Price of Civilization (Jeffrey Sachs)
* Godel, Escher, Bach
* 百年の孤独
*Ramesh S. Arunachalam, 2011: The Journey of Indian Micro-Finance: Lessons for the Future.
* 石の花 (坂口尚)
* Reassembling the Social
* reread: biology as ideology
* reread: the structure of scientific revolution
* 最貧困女子
* On Food and Cooking: The Science and Lore of the Kitchen (Hardcover)
* Les Animaux tels qu'ils sont


[http://www.w3schools.com/TAGS/tag_td.asp This website] says: An HTML table has two kinds of cells:
=Articles=


    * Header cells - contains header information (created with the th element)
* Happy Land
    * Standard cells - contains data (created with the td element)
* Ashtrays
* Wasteland


----
=Places=


'''Problem:'''
* Xkeken
* Shark Bay
* スコトラ島
* Kayangan Lake
* Perchten festival in the western Austrian village of Heitwerwang
* 坊主バー　in Yotsuya: http://vowz-bar.com/
* cycling museum in osaka
* キットカット　ショコラトリー
* ベーカリー兎座LEPUS うさぎ型食パン


I didn't know what <form name="form1"> meant.
=Diving=


'''Solution:'''
* Jewfish
* Basking shark
* Mola mola
* Turtles


"A form is an area that can contain form elements.
=Wines=


Form elements are elements that allow the user to enter information (like text fields, textarea fields, drop-down menus, radio buttons, checkboxes, etc.) in a form."
* majo norante "ramitello" rosso biferno molise at Nook. Can't remember the year.
[http://www.tohoho-web.com/js/index.htm　とほほのjavascript]
* Denavolo Dinavolo Vino da Tavola 2007 at The Remedy.


==Command line==
=Traveling tips=


* arch: get architecture info
* How to send things from UK:
* uname -a: print system info
: You can get a small, medium, or large box at post office (haven't tried royal mail but they're similar?). You can send a ''small parcel'' = less than 2kg internationally for a reasonable price. From UK to Japan is about 25 quid for 2kg.
* xev: finds information on the pressed keys
* xmodmap -e "keycode ###=Multi_key": Enter the key number in ### to set the compose key.

Revision as of 07:39, 1 February 2020

This is where I keep notes on things that I will probably need to read again.

Miscellaneous

  • Banach-Tarski paradox.
  • minipimer
  • Temblor Range
  • Khalil Gibran
  • Making of 3 'Idiots'
  • 野菜寿し ポタジエ Yasai Sushi
  • 8tablish
  • Sundial Atelier
  • MOCORO モコロ vacuum
  • 丸ゆべし
  • Fly Geyser
  • Bar Yamamoto
  • Wall bar
  • Rage bar
  • Tapas Molecular Bar at Mandarin Oriental, Tokyo
  • daikokuyu
  • ディマシオ美術館
  • MERIDA X BASE
  • 御殿場MTBパークFUTAGO
  • notNeutral cups

Gardening

  • I can use agar to grow Kaiware seeds etc.

Bicycle

  • Brakes
  • Items that may be useful for touring trips
    • Portable Water Heater - SunRocket Solar Thermos and Kettle - Boil Water With Only Sunlight

Hiking

  • Potential summer hike ideas
Mt. St. Helens

Concert

  • Chopin Piano Concerto #1
  • Ravel Piano Concerto in G major
  • Gruppen (Stockhausen)　(2012 May NY Philharmonic?)
  • Symphony No. 3 (Górecki)

Piano

  • Balakirev / Glinka "The Lark"
  • Liszt "Gnomenreigen"
  • Chopin 3rd Sonata
  • Beethoven Sonata 31
  • ラヴェル／鏡より「道化師の朝の歌」

Movies

I liked these movies:

  • Trouble the water
  • Cube
  • MST3K Pumaman
  • Tokyo!
  • Annabel Chong
  • I love me

I want to watch these movies:

  • Uncle Boonmee Who Can Recall His Past Lives
  • Faust by Alexander Sokurov
  • ビルマVJ 消された革命
  • Sleeping Beauty (2011)
  • Amour
  • Pee Wee's big adventure
  • White Dog, The Naked Kiss, Shock Corridor by Samuel Fuller
  • スープ
  • Kings of Pastry
  • Streetwise (1984)

Books

  • 1Q84
  • AIDS and Accusation (Paul Farmer)
  • 農協との３０年戦争 岡本重明
  • Saturday is for Furnerals (Max Essex)
  • クォンタム・ファミリーズ
  • Penguin and Leviathan (Yochai Benkler)
  • The Price of Civilization (Jeffrey Sachs)
  • Godel, Escher, Bach
  • 百年の孤独
  • Ramesh S. Arunachalam, 2011: The Journey of Indian Micro-Finance: Lessons for the Future.
  • 石の花 (坂口尚)
  • Reassembling the Social
  • reread: biology as ideology
  • reread: the structure of scientific revolution
  • 最貧困女子
  • On Food and Cooking: The Science and Lore of the Kitchen (Hardcover)
  • Les Animaux tels qu'ils sont

Articles

  • Happy Land
  • Ashtrays
  • Wasteland

Places

  • Xkeken
  • Shark Bay
  • スコトラ島
  • Kayangan Lake
  • Perchten festival in the western Austrian village of Heitwerwang
  • 坊主バー　in Yotsuya: http://vowz-bar.com/
  • cycling museum in osaka
  • キットカット　ショコラトリー
  • ベーカリー兎座LEPUS うさぎ型食パン

Diving

  • Jewfish
  • Basking shark
  • Mola mola
  • Turtles

Wines

  • majo norante "ramitello" rosso biferno molise at Nook. Can't remember the year.
  • Denavolo Dinavolo Vino da Tavola 2007 at The Remedy.

Traveling tips

  • How to send things from UK:
You can get a small, medium, or large box at post office (haven't tried royal mail but they're similar?). You can send a small parcel = less than 2kg internationally for a reasonable price. From UK to Japan is about 25 quid for 2kg.
Retrieved from "https://wiki.mako.cc/index.php?title=Mika/Notes&oldid=54528"
Attribution-Share Alike 3.0 Unported
Powered by MediaWiki