Gossamer Forum
Home : Products : DBMan SQL : Discussion :

SQL Basics

Quote Reply
SQL Basics
Could someone please give me a quick run down on the difference between flat text file system and SQL?
Also, what are the main differences in the scripts between DBMan and DBManSQL? Is it only in the way it writes to files or is it more involved than that? I am currently testing DBMan with a lot of modifications, what problems will I face if I change to SQL? Can the SQL version be modified in the same ways as the standard version?
Thank you.
Simon.

Quote Reply
Re: SQL Basics In reply to
Check out the following web sites for SQL info:

http://www.mysql.com/

http://www.perl.com/ (search for DBI SQL)

http://www.smeal.psu.edu/...tabase/dbmsnote.html

http://www.microsoft.com/technet/default.asp

http://w3.one.net/~jhoffman/sqltut.htm

http://www.sqlcourse.com/

And the basic difference is that Structured Query Language databases are structured differently in terms of the type of fields that can be added to tables and also allow relational databases versus flat files that consume disk space, bandwidth, CPU/Memory and also take a lot more work to make them "relational".

(Found many of these resource searching the Web for SQL flat files databases)

In Reply To:
Also, what are the main differences in the scripts between DBMan and DBManSQL? Is it only in the way it writes to files or is it more involved than that?
Sort of...it is more involved since you need more modules (DBI for one) installed in your server/account and you also need to create DBI compatible tables (like MySQL).

In Reply To:
I am currently testing DBMan with a lot of modifications, what problems will I face if I change to SQL?
You will have to re-write modifications that access and write from the "flat file database" into SQL codes that accesses and writes from the DBI compatible tables.

In Reply To:
Can the SQL version be modified in the same ways as the standard version?
Yes...if you have an understanding of SQL and advanced Perl codes.

Regards,





Eliot Lee
Quote Reply
I will have some of the mods posted... In reply to
jai,

I will post some of the mods I have converted very soon. I'm working out some problems with MySQL right now for my database. Also, after only having my database up 1 day, many of my users are suggesting some changes to look like the "old" way I had it. You can check out my db at:

http://www.thefew.com/cgi-bin/guestbook/db.cgi

It is a US Marine Corps Guestbook with 33,750 entries. I have most of the mods from the flat file that I converted to the SQL versions, plus a few I created myself.

AJ