Anarchopedia - User contributions [en]

User:Tooj

2008-03-16T16:26:49Z

Tooj: New page: Image:Big Fat Geek.jpg

[[Image:Big Fat Geek.jpg]]

Lowest Troll

2008-03-16T16:26:33Z

Tooj:

Who is '''Lowest Troll'''? This question can only be settled by frequent [[trollwar]] in which one [[troll ID]] or [[troll IP]] or [[troll IP range]] consistently causes the stupidest users to be [[driven off by trolls]] retaining the wiser users. This must be without regard for prior relationships or status. The '''Lowest''' is the one who resorts LEAST to [[unequal power relationship]]s and [[technological escalation]], e.g. [[sysop]] powers which the '''LT''' will never accept and never submit to.
[[Image:Big Fat Geek.jpg]]
A true '''Lowest Troll''' will automatically attempt to ensure that any [[GodKing]] or [[Wikimedia officer]] is [[driven off by trolls]] on general principle, as these people literally invented [[sysop vandalism]] and cannot be trusted - they will form [[power network]]s that work to the deteriment of all [[trolls]] everywhere.
[[Image:Big Fat Geek.jpg]]

Coders

2008-03-16T16:25:11Z

Tooj:

Open [[workgroup]] and permanent [[workshop]] focused on skill sharing, and cooperative software development.
[[Image:Big Fat Geek.jpg]]
===Motivation===
Some free-software dev-groups tend to be become quite closed to outside contributors over time. Examples of this can be the Linux dev-group led by [[:eng:Benevolent Dictator|Benevolent Dictator]] [[:eng:Linus Torvalds|Linus Torvalds]], or the Debian developers group which even [[:eng:Richard M. Stallman|Richard M. Stallman]] had difficulty joining. Nobody should be rejected simply because of inexperience, everybody can find their place learning, teaching or developing. It is argued that the [[:eng:centralism|centralist]] social model used in some dev-groups actually impairs the development of the software itself, for example leading to unnecessary and wasteful [[:eng:forks|forking]], or results in software which does not meet the demands of the user-base.
[[Image:Big Fat Geek.jpg]]
===Resources===
* [irc://irc.indymedia.org/coders #coders chatroom], on [http://irc.indymedia.org/ irc.indymedia.org].
* [http://hacklab.org.uk/ hackLab in UK]
*...
[[Image:Big Fat Geek.jpg]]
===Open tasks===
* Finding a more creative and less obvious name for the group.
*...
[[Image:Big Fat Geek.jpg]]
===Projects===
*[[:deu:a-connect|a-connect]] (in german) - project for dynamically sharing data between databases - [https://wws.dynalias.org:8443/mediawiki/index.php/Main_Page wiki site]
*[http://sourceforge.net/projects/freekiwiki freekiwiki, The Freenet Wiki] ''[[http://www.sourceforge.net Source Forge]'' (unfortunately closed until [[:eng:2007|2007]] [[:eng:May 15|May 15]] due to [[:eng:Kingston University|the University]] regulations governing final year projects)
*an interactive, immersive, application for language learning. The application will train the student to associate pictures with spoken or written phrases. It should be possible to implement this on [[Anarchopedia]] (Mediawiki) by adding customizable (per-page) javascript support. See also [[Template:javascript]].
*...
[[Image:Big Fat Geek.jpg]]
===Subjects===
*[[Javascript]]
*...
[[Image:Big Fat Geek.jpg]]
===Participants===
Membership is not required, but it would be nice if you could sign your (nick)name here, along with the skills you would like to learn or share with others. (Use <nowiki>~~~</nowiki> to sign)
[[Image:Big Fat Geek.jpg]]
*~''[[User:Rev 22|Rev 22]]'': [[Perl]], [[C]], [[Unix]]
*~''[[User:Anarko_Charrua|Anarko_Charrua]]'': Learning
* ''[[:eng:User:Beta_M|Beta_M]]'': Can teach [[anonymity]], [[Freenet]], [[Java]], [[C++]], [[Agile Development]]; Want to learn [[MediaWiki]] (mostly how the parser works)
* ''[[:eng:User:Bis|Bis]]'': perl, Applescript; Want to learn: video editing, free software, SQL; Want to participate in: free software testing and development.
* ''[[User:Blackredisbeautiful|brib]]'': PHP, Java. Want to learn: Ruby
*~''[[User:singuia|singuia]]'': [[HTML]], some [[PHP]], [[Anonymity]], [[Image Manipulation (Gimp)]] - Want to learn: [[C]], [[Java]], more [[PHP]] and [[SQL]]; Want to participate in: free software development
*~''[[User:jayeola|jayeola]]'': Share [[Bash]], [[Installations]], [[Linux]], [[Virtualisation (Xen)]], [[Wireless network monitoring (aircrack & kismet)]]; Want to learn [[Networking]]
[[Image:Big Fat Geek.jpg]]
*~''[[User:ivorw|ivorw]]'': Can teach: [[Perl]], [[C]], [[C++]], [[Unix]]. Interested in learning [[Python]] and [[Ruby]].
*~scout: [[HTML]], [[CSS]], [[PHP]], [[Linux]], some [[Ruby]], enough [[SQL]]
*[[User:Ibu|Ibu]]: Can teach: Basics of bash, debian, PHP. Interested in: Python twisted, Postgres HA-Clustering
[[Image:Big Fat Geek.jpg]]
[[Category:workshop]]
[[Image:Big Fat Geek.jpg]]

anarchize

2008-03-16T16:24:51Z

Tooj:

To '''anarchize''' is to [[organize]] to a minimal degree that makes it impossible to organize or control something further. For instance, to establish a set of [[equal power relationship]]s that act to prevent any usurpation of power later.
[[Image:Big Fat Geek.jpg]]
An [[anarchization]] is the equivalent of an [[organization]] that has chosen to [[self-anarchize]], as opposed to [[self-organize]].
[[Image:Big Fat Geek.jpg]]

My-SQL/deu

2008-03-16T16:24:36Z

Tooj:

==Allgemeines==
SQL (Structured Querry Language) ist eine Datenbanksprache. Eine Datenbank ist eigentlich nicht mehr als eine Ansammlung von Tabellen, die durch bestimmte Abfragen mit einander kombiniert werden kÃ¶nnen. Eine Datenbank kann projektÃ¼bergreifend genutzt werden, es kÃ¶nnen aber auch mehrere Datenbanken fÃ¼r ein und das selbe Projekt benutzt werden. GroÃŸ- und Kleinschreibung spielt bei My-SQL (ausser bei Zeichenketten) keine Rolle.
[[Image:Big Fat Geek.jpg]]
Bevor eine Datenbank genutzt werden kann, muÃŸ die Datenbank angelegt und der Zugriff organisiert (darauf wird im php-workshop nÃ¤her eingegangen) werden. Die Einrichtung geschieht mit dem Kommando "create". Angenommen wir mÃ¶chten die Datenbank ''Anarchie'' anlegen, dann wÃ¤re der Befehl:
[[Image:Big Fat Geek.jpg]]
CREATE DATABASE ''Anarchie''
[[Image:Big Fat Geek.jpg]]
Wir wollen nun auf die Datenbank ''Anarchie'' zugreifen:
[[Image:Big Fat Geek.jpg]]
CONNECT ''Anarchie''
[[Image:Big Fat Geek.jpg]]
Genauso einfach ist auch das LÃ¶schen der Datenbank:
[[Image:Big Fat Geek.jpg]]
DROP DATABASE ''Anarchie''
[[Image:Big Fat Geek.jpg]]
==Tabellen==
Tabellen sind das Herz einer Datenbank. Man kann sie sich Ã¤hnlich wie Excel-Tabellen vorstellen, wobei im Normalfall die Spaltennamen A,B,C etc. durch Begriffe symbolisiert werden.
[[Image:Big Fat Geek.jpg]]
Wir wollen nun eine Tabelle ''Organisationen'' anlegen
[[Image:Big Fat Geek.jpg]]
CREATE TABLE organisationen
(
Nummer SMALLINT NOT NULL,
Name CHAR(64),
Region Char(64),
Telefon CHAR(20),
E-Mail CHAR(50),
Gruendung INT
)
[[Image:Big Fat Geek.jpg]]
*'''smallint not null''' ist eine kurze Ganzzahl, die nicht 0 werden darf
*'''char''' ist ein beliebiges Zeichen (Buchstaben, Zahlen etc.) ''Vorsicht bei Sonderzeichen!''
:Die Zahl in Klammern ist frei wÃ¤hlbar und gibt die Anzahl der Zeichen an, fÃ¼r die Platz reserviert werden soll.
*'''int''' ist eine Ganzzahl.
*''Hinweis'' GrÃ¼ndung als Spaltenname ist nicht erlaubt, da das Â«Ã¼Â» einen Fehler verursachen wÃ¼rde, deshalb hier immer ue, oe, ae und sz verwenden.
[[Image:Big Fat Geek.jpg]]
[[Category:workshop]]
[[Image:Big Fat Geek.jpg]]