Mika/Notes: Difference between revisions

From WikiDotMako
(→‎Miscellaneous: added 狸サイクル)
 
(124 intermediate revisions by 18 users not shown)
Line 1: Line 1:
'''This is where I keep notes on things that I will probably need to read again.
'''This is where I keep notes on things that I will probably need to read again.
'''
'''
* 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=


=Public Health=
* Banach-Tarski paradox.
* minipimer
* Temblor Range
* Khalil Gibran
* Making of 3 'Idiots'
* <strike/> 野菜寿し ポタジエ Yasai Sushi </strike>
* ヴィーガンメニューが提供されているのは、権八の銀座・渋谷・西麻布店
* 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
* おふろcafeハレニワの湯 - cheap fun sento in Saitama
* Kerala Onam festival
* オレンジ食堂
* hijikawa arashi
* 狸サイクル


The page got too long, so I moved it to [http://wiki.mako.cc/Mika/Notes/Public_Health Public Health].
=Gardening=


=Movies=
* I can use agar to grow Kaiware seeds etc.


I liked these movies:
=Bicycle=


* Trouble the water
* Brakes
* Cube
** Change brake pads before the grooves are gone: http://www.jimlangley.net/wrench/brake1.htm
* MST3K Pumaman
** 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


=Computer Stuff=
=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.


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


'''Problem:'''
=Piano=


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.
* Balakirev / Glinka "The Lark"
* Liszt "Gnomenreigen"
* Chopin 3rd Sonata
* Beethoven Sonata 31
* ラヴェル／鏡より「道化師の朝の歌」


'''Solution'''
=Movies=


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.
I liked these movies:


----
* Trouble the water
 
* Cube
'''Problem:'''
* MST3K Pumaman
 
* Tokyo!
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:
* Annabel Chong
 
* I love me
* 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
 
===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/
 
 
'''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 want to watch these movies:


* I went to setting.py to specify:
* Uncle Boonmee Who Can Recall His Past Lives
** the absolute path for Template_Dir. Don't forget the , after '/path/' .
* Faust by Alexander Sokurov
** two additional Installed_Apps: myprj_myapp (where I save my project) and django.contrib.admin . Run python manage.py syncdb afterwards.
* ビルマ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)


This created myapp_post and django_admin_log in mysql database.
=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


==Javascript==
=Articles=
----


[http://java-script.seesaa.net/category/2493027-1.html JS Tutorial]
* Happy Land
* Ashtrays
* Wasteland


----
=Places=


==HTML==
* 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 うさぎ型食パン
* EdiTion Koji Shimomura: French restaurant with some veg options; near Roppongi
* Veganic to go: burger place near Roppongi
* Japanese [https://vegewel.com/ja/cuisine/93 website] for finding veg restaurants


'''Problem:'''
=Diving=


I didn't know what <td> meant.
* Jewfish
* Basking shark
* Mola mola
* Turtles


'''Solution:'''
=Wines=


[http://www.w3schools.com/TAGS/tag_td.asp This website] says: An HTML table has two kinds of cells:
* majo norante "ramitello" rosso biferno molise at Nook. Can't remember the year.
* Denavolo Dinavolo Vino da Tavola 2007 at The Remedy.


    * Header cells - contains header information (created with the th element)
=Traveling tips=
    * Standard cells - contains data (created with the td element)


----
* 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.


'''Problem:'''
==Tokyo Bars==


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


'''Solution:'''
* BAR ORCHARD (Ginza)
* High Five (Ginza)
* Mori Bar (Ginza)
* Bar Hoshi (Ginza)
* Ben Fiddich (Shinjuku)
* The SG Club (Shibuya)


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


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."
Ok:
[http://www.tohoho-web.com/js/index.htm　とほほのjavascript]
* Star Bar (Ginza)
* swrl (Shibuya)
* Gen Yamamoto (Azabujuban)
* グランドファイン (Nakameguro)


==Command line==
List of subpages:


* arch: get architecture info
* [[Mika/Notes/2016]]
* [[Mika/Notes/Beer]]
* [[Mika/Notes/Beer/Imperial IPA 2017]]
* [[Mika/Notes/Computer Stuff]]
* [[Mika/Notes/Computer Stuff/Debian Installation]]
* [[Mika/Notes/Computer Stuff/Debian Maintenance]]
* [[Mika/Notes/Computer Stuff/R]]
* [[Mika/Notes/Phrontistery 2015]]
* [[Mika/Notes/Public Health]]
* [[Mika/Notes/Seattle]]
* [[Mika/Notes/Todo]]
* [[Mika/Notes/Travel]]
* [[Mika/Notes/Travel/2015 FridayHarbor]]
* [[Mika/Notes/moving]]
* [[Mika/Temp/WikiFCD/FCTtemplate]]
* [[Mika Books]]
* [[Modularity and FOSS]]

Latest revision as of 14:12, 21 October 2023

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

Miscellaneous[edit]

  • 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
  • おふろcafeハレニワの湯 - cheap fun sento in Saitama
  • Kerala Onam festival
  • オレンジ食堂
  • hijikawa arashi
  • 狸サイクル

Gardening[edit]

  • I can use agar to grow Kaiware seeds etc.

Bicycle[edit]

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

Hiking[edit]

  • Potential summer hike ideas
Mt. St. Helens

Concert[edit]

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

Piano[edit]

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

Movies[edit]

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[edit]

  • 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[edit]

  • Happy Land
  • Ashtrays
  • Wasteland

Places[edit]

  • 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 うさぎ型食パン
  • EdiTion Koji Shimomura: French restaurant with some veg options; near Roppongi
  • Veganic to go: burger place near Roppongi
  • Japanese website for finding veg restaurants

Diving[edit]

  • Jewfish
  • Basking shark
  • Mola mola
  • Turtles

Wines[edit]

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

Traveling tips[edit]

  • 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.

Tokyo Bars[edit]

Good:

  • BAR ORCHARD (Ginza)
  • High Five (Ginza)
  • Mori Bar (Ginza)
  • Bar Hoshi (Ginza)
  • Ben Fiddich (Shinjuku)
  • The SG Club (Shibuya)


Ok:

  • Star Bar (Ginza)
  • swrl (Shibuya)
  • Gen Yamamoto (Azabujuban)
  • グランドファイン (Nakameguro)

List of subpages:

Retrieved from "https://wiki.mako.cc/index.php?title=Mika/Notes&oldid=77903"
Attribution-Share Alike 3.0 Unported
Powered by MediaWiki