Ubuntu 9.10 for Web Developers
# LAMP (Linux, Apache, MySQL and PHP)
sudo apt-get install apache2 mysql-server php5 php5-mysql
# phpMyAdmin, choose apache
sudo apt-get install phpmyadmin
# PostgreSQL
sudo apt-get install postgresql php5-pgsql pgadmin3
# Opera
sudo apt-get install libqt3-mt
wget -c "http://get3.opera.com/pub/opera/linux/1001/final/en/i386/opera_10.01.4682.gcc4.qt3_i386.deb"
sudo dpkg -i opera_10.01.4682.gcc4.qt3_i386.deb
Login problems using pgAdminIII and PostgreSQL:
http://www.ubuntugeek.com/howto-setup-database-server-with-postgresql-and-pgadmin3.html
domingo, 1 de noviembre de 2009
Albertux
The second day I’m using OpenSolaris 2009.06
# Install Apache, MySQL and PHP on OpenSolaris
pkg install amp
pkg install webstack-ui
# Read Ext2/Ext3 Filesystem
wget -c "http://www.belenix.org/distributions/belenix_site/binfiles/FSWpart.tar.gz"
wget -c "http://www.belenix.org/distributions/belenix_site/binfiles/FSWfsmisc.tar.gz"
gzip -d FSWpart.tar.gz | tar xvf -
gzip -d FSWfsmisc.tar.gz | tar xvf -
pkgadd -d . FSWpart
pkgadd -d . FSWfsmisc
# Mini HOWTO example
prtpart # LIST Devices
prtpart $DEVICE -ldevs # List parts of the device
mount -F ext2fs /dev/dsk/c12t0d0p3 /root/linux
umount /root/linux
# Recursive grep (like grep -R on Gnu/Linux)
find . -type f -exec grep "something" {} \;
Win32 Developer Dream
DBMS (MS SQL Express 2008, MySQL, SQLite, Oracle Express, etc…)
Dev (Perl, Python, Tcl-TK, Ruby, Java, Visual Basic Express, etc…)
Others (TortoiseSVN, Apache, NetBeans, Cygwin, etc…)
Download Torrent
More info here
miércoles, 24 de diciembre de 2008
Albertux
Tcl scripting and SQLite
Tcl tutorial
Download Tcl/Tk (source/binary)
SQLite API (tclsh)
Download SQlite (source/binary)
A simple example (taken from sqlite.org):
#!/usr/bin/tclsh
if {$argc!=2} {
puts stderr "Usage: %s DATABASE SQL-STATEMENT"
exit 1
}
load /usr/lib/tclsqlite3.so Sqlite3
sqlite3 db [lindex $argv 0]
db eval [lindex $argv 1] x {
foreach v $x(*) {
puts "$v = $x($v)"
}
puts ""
}
db close
