Archive

Archive for the ‘database’ Category

Ubuntu 9.10 for Web Developers

November 7th, 2009 No comments

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

Categories: database, develop, unix/linux, web Tags: ,

OpenSolaris 2009.06 SAMP and Ext2/Ext3

November 1st, 2009 No comments

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" {} \;

Categories: database, unix/linux, web Tags: ,

Oracle Buy Sun

April 21st, 2009 No comments
Categories: business, database, unix/linux, windows Tags: ,

Win32 Developer Dream

January 9th, 2009 No comments

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

Tcl scripting and SQLite

December 24th, 2008 No comments

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

Switch to our mobile site