search

ltscomputingllc / faersdbstats

Generate safety signal statistics from FDA FAERS data
Apache License 2.0
45 stars 29 forks source link

SQL version in AEOLUS README.txt #2

Closed rossdb closed 7 years ago

rossdb commented 7 years ago

Apologies if this question is completely off-base. The paper by Banda et al. in _Scientific _Data__ mentions PostgreSQL 9.3 as the SQL version used for AEOLUS. However, the code in the README.txt file at gives an error when I try to run it on a PostgreSQL server, and seems to use mySQL vocabulary and syntax (e.g., INT(11) in the CREATE TABLE statements and LOAD DATA INFILE in the statements used to populate the tables).

Should I switch to mySQL, or is the code on GitHub in PostgreSQL (or am I completely missing something else)? Thanks!

leeevans commented 7 years ago

The converted data is in a mySQL database.
The database conversion was done in a PostgreSQL database using Postgres SQL.

If you just want to use the converted data, load it into a mySQL database. If you want to run the conversion yourself using the SQL code in this github repo then you will need to use a Postgres database.

rossdb commented 7 years ago

Got it - thanks!

David

On Wed, Mar 15, 2017 at 9:04 AM, Lee Evans notifications@github.com wrote:

The converted data is in a mySQL database. The database conversion was done in a PostgreSQL database using Postgres SQL.

If you just want to use the converted data, load it into a mySQL database. If you want to run the conversion yourself using the SQL code in this github repo then you will need to use a Postgres database.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/ltscomputingllc/faersdbstats/issues/2#issuecomment-286734889, or mute the thread https://github.com/notifications/unsubscribe-auth/AZNdqMLiCPjG74vqzSjDi8_EwYHyjfWLks5rl-HkgaJpZM4Md576 .