Re: Basic Database?

I would recommend using an SQL server for a few reasons.

file manipulation is somewhat unpleasant, and doesn't scale well
a database will make it easier for your servers to be separated (less replication worries) as your organization grows
a database makes it somewhat easier to separate your code from your data (access from another language or tool is easier)
a database can provide data checking automatically for you

There are probably many more good reasons.

Comment on Re: Basic Database?

Replies are listed 'Best First'.
Re: Basic Database? by pmas (Hermit) on Jun 11, 2001 at 19:46 UTC
One reason using SQL database, rather important IMHO: You wil learn something new and important. Market value of your skills will increase. SQL database is standard way to store data in the industry. SQL is portable enough so next time you are ready to store data in ORACLE. From other point of view, learning ::Storable or other proposed solutions is great if you are already familiar with SQL databases. Obviously I assume you have time to try and learn new tools. Given enough time, and if you are not familiar enough with databases, I will recommennd to go SQL database route. It will be pain to digest database concepts, learn new (SQL) language, but it will benefit you immensely. Database itself looks simple and straightfooward (just one table), excellent for your first project. And maybe you can thought out some related table and JOIN them. This allows you to join SQL DB club... : ) pmas To make errors is human. But to make million errors per second, you need a computer.	[reply]

Replies are listed 'Best First'.

Re: Basic Database?
by pmas (Hermit) on Jun 11, 2001 at 19:46 UTC

You wil learn something new and important. Market value of your skills will increase. SQL database is standard way to store data in the industry. SQL is portable enough so next time you are ready to store data in ORACLE.

From other point of view, learning ::Storable or other proposed solutions is great if you are already familiar with SQL databases.

Obviously I assume you have time to try and learn new tools.

Given enough time, and if you are not familiar enough with databases, I will recommennd to go SQL database route.

It will be pain to digest database concepts, learn new (SQL) language, but it will benefit you immensely. Database itself looks simple and straightfooward (just one table), excellent for your first project. And maybe you can thought out some related table and JOIN them. This allows you to join SQL DB club... : )

pmas

[reply]