Re: Video game programming????

2001-09-12 Thread Jeremy Zawodny

On Wed, Sep 12, 2001 at 01:31:59AM +0530, Nilesh Parmar wrote:
 Hi
   I was just browsing thru the amazon.com site and just happened to read a
 customer review on the MySQL (other new riders) book by Paul DuBios and
 Michael Widenius.
 It has a wierd review from someone which says
 I was extremely dissapointed to say the least. This book doesn't even begin
 to cover **video game programming in mySQL**, not even the basics. In fact,
 it doesn't cover **video game programming at all**. . blah blah .
 
The line that caught my attention was the one which are inside
 the ** symbols. Now, this was something new to me.So, i just thought if
 anyone could tell me more on this. What's video game programming got to do
 with MySQL ?? and what does he mean by this. Can anyone enlighten me on this
 ??

Ah, the Perl and MySQL for the Web book, I imagine.

Whoever posted that review was an idiot.

As one of the technical reviewers for the book, I bugs me to see that
sort of comment there.  I believe it's a really good book.  I'm sure
that others who have read it will agree.  I've already recommended it
to a few co-workers just for a few specific chapters.

Jeremy
-- 
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.41-max: up 6 days, processed 132,187,796 queries (248/sec. avg)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Video game programming????

2001-09-12 Thread Robert Cross



It has a wierd review from someone which says
I was extremely dissapointed to say the least. This book doesn't even
begin
to cover **video game programming in mySQL**, not even the basics. In
fact,
it doesn't cover **video game programming at all**. . blah blah .
What's video game programming got to do
with MySQL ??

Hi Nilesh, yes I saw that 'review' as well and my first thought was boy,
what a class 1 jerk!
(or a SQL Server advocate - same thing ;-) ! ). But then I got to thinking:
1.   Two of MySQL's strengths are that it's small and fast - pre-requisites
for video game work.
2.   Most (and I would have thought all) games have pretty extensive data
structures for player position, position
of bad guys, ammo etc.

Given this why couldn't MySQL be used as the data backend for a video game?
In fact, once the geniuses at MySQL give us
peer-to-peer replication then this would be ideal for some kind of MUD-type
game, (each player would effectively have a local
copy of the DB, transmit their moves out and receive other peoples moves).
Even without this you could do a type of DOOM, where
all the layout would be stored in the DB, heck, you could even have a
leave-rejoin facility for multiple players, (single player game) since the
DB could be used to store the users configuration, the same way it can be
used to store personalised Web page configuration. Or maybe
something similar to the old SGI flight/dog 'sims', (that was an ace
timewaster and I sure wish someone would port it to Linux!)

Further it occurs to my fevered imagination that you could use Blender to
make the graphics bit for a DOOM clone, and link it to a MySQL backend, or
embed it.
AFAIK Blender uses Python and I seem to remember seeing a Python interface
to MySQL.

Ain't MySQL wonderful, and so flexible too!

Bob Cross, rapidly turning into a major MySQL advocate.
Disclaimer 1: The rabid dribblings above are personal to the author only,
my employer has much more common sense.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
This message is confidential.  It may also be privileged or
protected by other legal rules.  It does not constitute an
offer or acceptance of an offer, nor shall it form any part
of a legally binding contract.  If you have received this
communication in error, please let us know by reply then
destroy it.  You should not use, print, copy the message or
disclose its contents to anyone.

E-mail is subject to possible data corruption, is not
secure, and its content does not necessarily represent the
opinion of this Company.  No representation or warranty is
made as to the accuracy or completeness of the information
and no liability can be accepted for any loss arising from
its use.

This e-mail and any attachments are not guaranteed to be
free from so-called computer viruses and it is recommended
that you check for such viruses before down-loading it to
your computer equipment.  This Company has no control over
other websites to which there may be hypertext links and no
liability can be accepted in relation to those sites.

Scottish  Newcastle plc
Registered in Scotland, Registered Number 16288
Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Video game programming????

2001-09-12 Thread Andrew Murphy

database, sql, query, table
database, sql, query, table
(I hate 123box.co.uk)


Im not gonna go into long discussions of game programming in here.

But the reason most people dont use a database backend for most modern games
is more a matter of speed than anything else.  You cant get an average of
over 45fps in anything but a simple game, if you are storing the data in a
database.
Its much faster to use a c++ class, or good old c struct to store data than
use an interface to a database.

Im sure there are many types of games where a database would be suitable.
But most 'video games' are all about high-speed constant action which
require incredibly fast data processing.

Im not against MySQL at all, its great for my work requirements, im just not
sure its suitable for a 'video game'.

Andrew


-Original Message-
From: Robert Cross [mailto:[EMAIL PROTECTED]]
Sent: 12 September 2001 10:31 am
To: Nilesh Parmar
Cc: [EMAIL PROTECTED]
Subject: Re: Video game programming




It has a wierd review from someone which says
I was extremely dissapointed to say the least. This book doesn't even
begin
to cover **video game programming in mySQL**, not even the basics. In
fact,
it doesn't cover **video game programming at all**. . blah blah .
What's video game programming got to do
with MySQL ??

Hi Nilesh, yes I saw that 'review' as well and my first thought was boy,
what a class 1 jerk!
(or a SQL Server advocate - same thing ;-) ! ). But then I got to thinking:
1.   Two of MySQL's strengths are that it's small and fast - pre-requisites
for video game work.
2.   Most (and I would have thought all) games have pretty extensive data
structures for player position, position
of bad guys, ammo etc.

Given this why couldn't MySQL be used as the data backend for a video game?
In fact, once the geniuses at MySQL give us
peer-to-peer replication then this would be ideal for some kind of MUD-type
game, (each player would effectively have a local
copy of the DB, transmit their moves out and receive other peoples moves).
Even without this you could do a type of DOOM, where
all the layout would be stored in the DB, heck, you could even have a
leave-rejoin facility for multiple players, (single player game) since the
DB could be used to store the users configuration, the same way it can be
used to store personalised Web page configuration. Or maybe
something similar to the old SGI flight/dog 'sims', (that was an ace
timewaster and I sure wish someone would port it to Linux!)

Further it occurs to my fevered imagination that you could use Blender to
make the graphics bit for a DOOM clone, and link it to a MySQL backend, or
embed it.
AFAIK Blender uses Python and I seem to remember seeing a Python interface
to MySQL.

Ain't MySQL wonderful, and so flexible too!

Bob Cross, rapidly turning into a major MySQL advocate.
Disclaimer 1: The rabid dribblings above are personal to the author only,
my employer has much more common sense.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
This message is confidential.  It may also be privileged or
protected by other legal rules.  It does not constitute an
offer or acceptance of an offer, nor shall it form any part
of a legally binding contract.  If you have received this
communication in error, please let us know by reply then
destroy it.  You should not use, print, copy the message or
disclose its contents to anyone.

E-mail is subject to possible data corruption, is not
secure, and its content does not necessarily represent the
opinion of this Company.  No representation or warranty is
made as to the accuracy or completeness of the information
and no liability can be accepted for any loss arising from
its use.

This e-mail and any attachments are not guaranteed to be
free from so-called computer viruses and it is recommended
that you check for such viruses before down-loading it to
your computer equipment.  This Company has no control over
other websites to which there may be hypertext links and no
liability can be accepted in relation to those sites.

Scottish  Newcastle plc
Registered in Scotland, Registered Number 16288
Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Video game programming????

2001-09-12 Thread Paul DuBois

At 1:31 AM +0530 9/12/01, Nilesh Parmar wrote:
Hi
   I was just browsing thru the amazon.com site and just happened to read a
customer review on the MySQL (other new riders) book by Paul DuBios and
Michael Widenius.
It has a wierd review from someone which says
I was extremely dissapointed to say the least. This book doesn't even begin
to cover **video game programming in mySQL**, not even the basics. In fact,
it doesn't cover **video game programming at all**. . blah blah .

The line that caught my attention was the one which are inside
the ** symbols. Now, this was something new to me.So, i just thought if
anyone could tell me more on this. What's video game programming got to do
with MySQL ?? and what does he mean by this. Can anyone enlighten me on this
??

Thanx in advance.
Nilesh

Just a follow-up on the various theories that have been posted about
this review.  (It refers to MySQL and not MySQL and Perl for the Web,
by the way.)

Here's the review in its entirety:

[1 star] Don't waste your time...,
April 17, 2001 Reviewer: Joey Ramone (see more about me) from Loves Park, IL

I was extremely dissapointed to say the least. This book doesn't even
begin to cover video game programming in mySQL, not even the basics. In
fact, it doesn't cover video game programming at all. The section on
compiling for DOS must have been lost on the way to the printing
press... While the plot had substance to it, the ending was 
predictable and unoriginal...


The review is a satire.  Note who it's by: Joey Ramone (of The Ramones).
It was posted the day after Joey Ramone died, perhaps as some sort of weird
tribute, and it's deliberately got nothing to do with what the book's
really about.

-- 
Paul DuBois, [EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php