mysql dependences

[Pablo Barrera González]

Is it really necessary to use mysql to run massiel scripts?

I don't feel confortable installing a lot of stuff in my machine and I
prefer to stay away from a mysql server.

Is there a workarround to avoid mysql?

Pablo

[Ramón Casero Cañas]

Israel knows this stuff much better, but my understanding is that ASF
project resources are parsed, and the results are saved in a MySQL database.

Then, the scripts read data directly from the database. Ideally, there
should be a framework in place for accessing the data, so that it's not
necessary to have your own databases, but for the moment this is a quick
and dirty way of getting results.

Cheers,

.::r

--
Ramón Casero Cañas

http://www.robots.ox.ac.uk/~rcasero/wiki
http://www.robots.ox.ac.uk/~rcasero/blog

[Israel Herraiz]

Excerpts from Pablo's message on Aug 8, 2008 about 3 PM:

> Is it really necessary to use mysql to run massiel scripts?

Yes. All the FM3 databases are MySQL dumps. And all the data that the
scripts use obtained from FM3 databases.

Cheers,
Israel

[Israel Herraiz]

Excerpts from Ramón's message on Aug 8, 2008 about 3 PM:

> Then, the scripts read data directly from the database. Ideally, there
> should be a framework in place for accessing the data, so that it's not
> necessary to have your own databases, but for the moment this is a quick
> and dirty way of getting results.

FM3 uses the set of Libresoft-tools [1] to parse the repositories of
the ASF (among other projects). Most of those tools create MySQL
databases as output. I guess that the tools might be adapted to obtain
the data in other formats. Actually, some (just a few) tools do
provide data in other formats.

In any case, I would say that MySQL is a de-facto standard in mining
software repositories. For instance, FLOSSMole also provides MySQL
dumps. If someone intends to do mining software repositories, I would
recommend to give a try to MySQL (or any other compatible SQL engine,
if there is any).

Cheers,
Israel

[1] http://forge.morfeo-project.org/projects/libresoft-tools/

[Pablo Barrera González]

The problem with mysql is you need to have a server installed in your
machine and to compile a big database. I like something smaller, like
sqlite but mysql dump is incompatible with everything I know. I just
love sql :-|

Is fm3 providing a mysql access or just dumps?

Pablo

[Israel Herraiz]

Excerpts from Pablo's message on Aug 8, 2008 about 4 PM:

> The problem with mysql is you need to have a server installed in your
> machine and to compile a big database. I like something smaller, like
> sqlite but mysql dump is incompatible with everything I know. I just
> love sql :-|

Yes, you need both the server and the Python library client.

> Is fm3 providing a mysql access or just dumps?

No, only dumps for the moment.

Cheers,
Israel