Archivo

Archivo para la categoría ‘database’

Ubuntu 9.10 for Web Developers

sábado, 7 de noviembre de 2009 Sin comentarios

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

domingo, 1 de noviembre de 2009 Sin comentarios

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

martes, 21 de abril de 2009 Sin comentarios
Categories: business, database, unix/linux, windows Tags: ,

Win32 Developer Dream

viernes, 9 de enero de 2009 Sin comentarios

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

miércoles, 24 de diciembre de 2008 Sin comentarios

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