* Go to: window > preferences > pydev > Interpreter - (Jython/Python).
* 2. Choose the interpreter you have installed in your computer (such as python.exe or jython.jar)
* 3. Select the paths that will be in your SYSTEM PYTHONPATH. It’s important to select […]

PyDev is a plugin that enables users to use Eclipse for Python and Jython development — making Eclipse a first class Python IDE — It comes with many goodies such as code completion, syntax highlighting, syntax analysis, refactor, debug and many others.
http://www.fabioz.com/pydev/manual_101_root.html

http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html
indexes are used to find rows with specific column values quickly. Without an index, MySQL must begin with the first row and then read through the entire table to find the relevant rows. The larger the table, the more this costs. If the table has an index for the columns in question, MySQL can quickly […]

CREATE INDEX is mapped to an ALTER TABLE statement to create indexes. See Section 12.1.2, “ALTER TABLE Syntax”. CREATE INDEX cannot be used to create a PRIMARY KEY; use ALTER TABLE instead. For more information about indexes, see Section 7.4.5, “How MySQL Uses Indexes”.
http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html

CREATE UNIQUE INDEX keyword ON `eEcho`.`keyword` (keyword(128));
http://dev.mysql.com/doc/refman/5.0/en/create-index.html

http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html
BETWEEN … AND … Check whether a value is within a range of values
COALESCE() Return the first non-NULL argument
<=> NULL-safe equal to operator
= Equal operator
>= Greater than or equal operator
> Greater than operator
GREATEST() Return the largest argument
IN() Check whether a value is within a set of values
INTERVAL() Return the index of the argument that is […]

DATETIME, DATE, and TIMESTAMP Types
http://dev.mysql.com/doc/refman/5.0/en/datetime.html
Problems Using DATE Columns ( datetime mysql compare )
http://dev.mysql.com/doc/refman/5.0/en/using-date.html
Date and Time Functions
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

http://code.google.com/android/
http://code.google.com/android/documentation.html
The Open Handset Alliance, a group of more than 30 technology and mobile companies, is developing Android: the first complete, open, and free mobile platform. To help developers get started developing new applications, we’re offering an early look at the Android Software Development Kit.

http://code.google.com/apis/base/
What is the Google Base data API?
The Google Base data API enables developers to :
* query Google Base data to create applications and mashups.
* input and manage Google Base items programmatically.
*
Developer’s Guide
[…]

http://code.google.com/apis/ajaxlanguage/
What is the Google AJAX Language API?
With the AJAX Language API, you can translate and detect the language of blocks of text within a webpage using only Javascript.
The language API is designed to be simple and easy to use to translate and detect languages on the fly when offline translations are not available. We plan […]

http://code.google.com/apis/youtube/overview.html
What are the YouTube APIs and Tools?
The YouTube APIs and Tools open up a full range of YouTube functionality for web pages, software and devices. Users of the API can upload new videos, edit video metadata such as comments and favorites and modify user settings. Your client application can request a list of videos that […]

The format for this command is ifstatus interface-name -o options . To check the only Ethernet connection on my desktop box, without specifying any options, I would enter:
ifstatus eth0
At first I tried ifup eth0, but all it would do is tell me the interface was already up. So I shut down the interface with […]

http://dev.mysql.com/doc/refman/5.0/en/row-subqueries.html
The discussion to this point has been of scalar or column subqueries; that is, subqueries that return a single value or a column of values. A row subquery is a subquery variant that returns a single row and can thus return more than one column value. Here are two examples:

SELECT * FROM t1 WHERE (1,2) […]

http://dev.mysql.com/doc/refman/5.0/en/subqueries.html
Subquery is nested voorbeeld:

SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2);

They allow queries that are structured so that it is possible to isolate each part of a statement.
They provide alternative ways to perform operations that would otherwise require complex joins […]

String lezen van een bestand of een variabele

from xml.dom.minidom import parse, parseString
dom1 = parse(’c:\\temp\\mydata.xml’) # parse an XML file by name
datasource = open(’c:\\temp\\mydata.xml’)
dom2 = parse(datasource) # parse an open file
dom3 = parseString(’Some data some more data‘)

Het is mogelijk om dom (document) object aanmaken met getDOMImplementation

from xml.dom.minidom import getDOMImplementation
impl = getDOMImplementation()
newdoc = impl.createDocument(None, “some_tag”, […]

Om ListBox value te kan opgehaald worden
return keywordListBox.getValue(keywordListBox.getSelectedIndex());
Opmerking:
Zorg ten eerste dat deze ListBox is ingevuld met tenminste 1 Item, anders zal een fout gegenereerd worden.

- Maak een nieuwe project aan. / File / New project / Java Project /
- Geef een naam voor de project, klik “Next”
- In volgende venster /tab Libraries/ klik op de knop “Add externeal JARS”
- Blader naar de map waar mysql-connector-java-X.X.X -bin.jar zich bevind en selecteer hem. “OK” […]

Met sqlite kan een database geëxporteerd worden structuur + populatie. (.sql format )
http://sqlitebrowser.sourceforge.net/
Deze toepassing is platform onafhankelijk.
- Download toepassing.
- Run zonder installatie
- Blader naar Sqlite database
- Selecteer tabellen die geëxporteerd moeten worden
- Kies sql als formaat.
- Open deze (.sql ) bestand met tekst editor (zoals kladblok, geditor, ezv)
- Kies opslaan als
- Kies onderaan codering […]

The try/catch statement encloses some code and is used to handle errors and exceptions that might occur in that code. Here is the general syntax of the try/catch statement:

try {
body-code
} catch (exception-classname variable-name) {
[…]

Example(s)
If you wished to have a script named /root/backup.sh run every day at 3am, my crontab entry would look like as follows:
(a) Install your cronjob:# crontab -e(b)Append following entry:
0 3 * * * /root/backup.sh
Run five minutes after midnight, every day:
5 0 * * * /path/to/commandRun
at 2:15pm on the first of every month:

15 14 1 […]

http://code.google.com/p/gwt-examples/w/list
QuickTips Quick Tips about how things work
GoogleCodeWants Google Code Wants
gwtEclipseFaqs How to configure eclipse for these projects.
gwtTomcat gwt tomcat setup
gwtTomcatWarBuilder gwt Tomcat War Builder
gwtDateTime getting date and time, unix time stamp, start and end of day with Java and GWT.
Projects Eclipse projects listed in trunk
gwtDND tips using gwt-dnd
gwtWidgets GWT wiget links
gwtTutorials GWT Tutorial Links
project_LoginManager […]