Database

[mdnky]

Starting a major project which I can't go to far into detail here. My main questions is has anyone here used 10.2 running SQL for the backend of a large database?

We're trying to bring in the information from various sources, reorganize it, and store it. This will probably contain 50,000 to 100,000 entries as a bare minimum in multiple tables, all overlaping from various sources. Eventually this will scale to millions of entries, all constantly updated.

We're thinking of using SQL or OpenBase SQL. We'd like to keep it as cheap as possible, yet be able to convert it into a major app if need be later on. We will be mining the data for use in determining probability based on certain factors.


Anyone know any good sources in the open source community?

[gatorparrots]

Did you see the article on PHP & MySQL in November's MacWorld? It's a very good primer written by former BeOS backer Scot Hacker.

The AMP combination (Apache, MySQL, & PHP) is a tough one to beat. It is probably your ideal solution.

You can get a pre-compiled PKG installer for MySQL here:
http://www.entropy.ch/software/macosx

[mdnky]

This is going to be more of a Client/Server than web database.

We're looking to use this locally on the machine to record, query, and mine specific "targets" then we'll take the finalized data and distribute it.