As a side note SQL isn't MySQL :) SQL is a standard, and a lot of application to handle data have been build to use this Standard. MySQL, Oracle, SQL*Server and so on are few of the application built to use this Standard.
Why using it ? Because it allow you to Store, Access, and Manipulate effectively data without having to code all that yourself. It's specially useful when performances and coherent persistence are at stake. Despret Jerome The Sims Online. Oracle Database Architect -----Original Message----- From: Tom Whiting [mailto:[EMAIL PROTECTED] Sent: Saturday, July 13, 2002 6:03 PM To: Rom Subject: Re: Question regarding SQL (newbie) > What is it? < Mysql is a database tool. Much like Excel (sorry, best example I could come up with there), it'll store data in rows and tables. For example, on DR, I have a few of the following tables social_table ban_table area_table mob_table clan_table Each of these tables has it's own selective and independent field of data. > Where can I read about it? < http://www.mysql.org http://www.postgresql.org > Is there any documentation about its application on MUDs? < http://www.kyndig.com/cgi-bin/codes/search.cgi?query=mysql That'll get you started on sql stuff. HOWEVER, if you're going to use sql, I'd suggest going with a persistant connection rather than opening and closing your connection all of the time. Eventually, I'll have something written up in the DR snippets/downloads area with ideas and whatnot for sql and how it can improve performance. While some say "hey, you shouldn't be all that worried about memory usage", I've found that by simply converting helpfiles to an sql database, I've IMPROVED memory usage (because they're not loaded at boot). This is merely one way of doing things. See my last email to the list on who formatting and all for another example. If you're a newbie coder, your best bet is NOT to jump into an sql project , converting your entire mud right away. At least NOT without some serious code help. You can easily lose databases, pfiles, everything if you enter in one value incorrectly. Just a word of caution there. Hope that answered a few of your questions. If not, I'm sure someone else can offer better insight. -- TJW :Head tech, designer, bum:P Mud :http://dreamless.wolfstream.net telnet :telnet://dreamless.wolfstream.net 9275 OLC Pages:http://olc.wolfstream.net -- ROM mailing list [email protected] http://www.rom.org/cgi-bin/mailman/listinfo/rom
