3,035
edits
Changes
no edit summary
= Breakpad Database =
* Use PostgreSQL 8.1 or higher will be used because it offers things that MySQL, like everything else (we should revisit this, as it may NOT be the right choice --morgamic)does not have** Arguably better performance for larger data sets** Would we need to make use of stored procedures or views?More precise datatypes** Would Potential for partitioning if we need to do any sort scale the database in the future, which will likely happen if we plan on keeping more than 3 months worth of partitioning?data** Does MySQL scale as well as PgSQL Long-standing support for arbitrarily large data sets?stored procedures (which can be in Python :D)** Any other reason why MySQL would hang us up (table type/storage engine problems)?Views for databases that are heavily normalized
* Define schema that works well with current query/reporting needs
** Need to define metadata that we absolutely have to have
** Other information and common reports that any crash reporting system would have
** [need to dig up all common queries - jay]
* The schema now accounts for the following kinds of information
