CGI/Perl Guide | Learning Center | Forums | Advertise | Login Site Search: in Perl Guide PerlGuru Forums Learning Ctr

	MAIN INDEX	SEARCH POSTS	WHO'S ONLINE	LOG IN

Home: Perl Programming Help: Intermediate: Comparing databases.

patk Deleted Feb 9, 2000, 3:12 PM Post #1 of 4 (1389 views) Comparing databases. Can't Post What are some advantages of using an SQL like database to a flat-file database? I don't know too much about SQL but I am not aware of what all the hype is about.

Cure User Feb 9, 2000, 9:07 PM Post #2 of 4 (1389 views) Re: Comparing databases. [In reply to] Can't Post Hi: SQL stands for Structured Query Language. SQL is used to communicate with a database. The basic difference between the two is that SQL is much MORE powerful, designed for MANY more records. It can store and retrieve large amounts of data alot faster than a flat file. Cure

patk Deleted Feb 10, 2000, 5:16 PM Post #3 of 4 (1389 views) Re: Comparing databases. [In reply to] Can't Post Cool. Do you have an example of a simple SQL database using Perl?

RayStreet Deleted Feb 11, 2000, 1:20 PM Post #4 of 4 (1389 views) Re: Comparing databases. [In reply to] Can't Post Have a look at the mysql posting from 3rd Feb. MySQL is free for personal use. It really depends on how many records/rows you need in your file/table. If you only need 50 then a flat file would proably be OK but you can obviously only access a flat file sequentially. But 50 records isn't many. Updating a flat file is fairly easy - you read the old file in and create a new file with you new data then you rename the new file to the name of your old file and there you are. But an SQL database lets you have thousands/millions of records. The hard part is deciding when a flat file is too slow and a real database is needed (loads of books have been written on this). Remember also that a flat file is easy to administer. A real database is usually trickier (but is not a big deal when you've sorted out what you want to do. Ray

Announcements     PerlGuru Announcements Perl Programming Help     Frequently Asked Questions     Beginner     Intermediate     Advanced     Regular Expressions     mod_perl     DBI     Win32 Programming Help Fun With Perl     Perl Quizzes - Learn Perl the Fun Way     Perl Golf     Perl Poetry Need a Custom or Prewritten Perl Program?     I need a program that...     I Need a Programmer for Freelance Work     Throw Down The Gauntlet General Discussions     General Questions     Feedback     Tutorial/Article Suggestions for The Learning Cent     Internet Security Other Programming Languages     Javascript     PHP

Search this forum this category all forums for All words Any words Whole Phrase (options)

Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives