For a while I have wanted to get MySQL up and running for my personal use, but it appears it is non-free so I have tried to install PostgresQL.
I really hate the dselect interface for Debian, unless you use it all the time it is far to confusing and unfriendly.
It also appears that I have the server installed which is a bit unsettling, not that I can find it anywhere !!.
The non Twain webcam software appears to be having no problem keeping the camera alive, only that the auto balance settings do not work so when it gets dark IT GETS DARK!
Now if I was a SQL server where would I hide ?
Ah, postgreSQL IS in /etc/init.d but when I run it
It runs a process called postmaster.
The docs for postgreSQL say I should be able to just type 'createdb test' and a test database will be created but I get.
FATAL 1: SetUserId: user 'root' is not in 'pg_shadow'
Some more googling and I type
su - postgres
no errors !!
and I am in the test database !!
Now to research how to get stuff done and I also want to secure the db !
I have been playing the excellent Dreamcast game Toy Commander, the first game I got (I think I even had it before the Dreamcast !) from nocliche.
This game is CLASS ! it has amazingly detailed environments, transparency, reflection, shading, colored lighting and above all imagination.
Where else can you find a game that pits you against a giant Godzilla in a bunny suit one minute and rescuing toys from ufo transporters the next !
Not to mention racing, shooting, flying, adventuring, thinking, blind charging and FUN !!
So many vehicles! just a few are F1 car, helicopter, hippy bus, tank, jeep, jet,bomber and so many more, all uniquely different in there handling and caperbilities!
Even the screen saver is quality! but like the Wreckless (XBox) I have talked about so much neither game EVER received the acclaim there deserved :(
Back to the DB, it took my forever to work out how to create an IDENTITY column :( in ms TSQL it is a piece of cake in postgreSQL you have to create a 'sequence' which you then apply to a column !
http://www.thinkgeek.com/stuff/computing/5b05.shtml - dream come true !