Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Matt Sheppard's answer is great (mod up), but I would take account these factors when thinking about a spindle:</p> <ol> <li>Structure : does it obviously break into pieces, or are you making tradeoffs?</li> <li>Usage : how will the data be analyzed/retrieved/grokked?</li> <li>Lifetime : how long is the data useful?</li> <li>Size : how much data is there?</li> </ol> <p>One particular advantage of CSV files over RDBMSes is that they can be easy to condense and move around to practically any other machine. We do large data transfers, and everything's simple enough we just use one big CSV file, and easy to script using tools like rsync. To reduce repetition on big CSV files, you could use something like <a href="http://yaml.org" rel="noreferrer">YAML</a>. I'm not sure I'd store anything like JSON or XML, unless you had significant relationship requirements.</p> <p>As far as not-mentioned alternatives, don't discount <a href="http://hadoop.apache.org/core/" rel="noreferrer">Hadoop</a>, which is an open source implementation of MapReduce. This should work well if you have a TON of loosely structured data that needs to be analyzed, and you want to be in a scenario where you can just add 10 more machines to handle data processing.</p> <p>For example, I started trying to analyze performance that was essentially all timing numbers of different functions logged across around 20 machines. After trying to stick everything in a RDBMS, I realized that I really don't need to query the data again once I've aggregated it. And, it's only useful in it's aggregated format to me. So, I keep the log files around, compressed, and then leave the aggregated data in a DB.</p> <p><em>Note</em> I'm more used to thinking with "big" sizes.</p>
    singulars
    1. This table or related slice is empty.
    1. POGood reasons NOT to use a relational database?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USTristan Juricek
    1. USTristan Juricek
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COOne danger of CSV files is escaping needs to be done right; its' easy to implement a CSV reader or writer that doesn't really follow the spec since it looks so deceptively simple and there are a few subtleties: http://en.wikipedia.org/wiki/Comma-separated_values#Specification
      singulars
      1. PO
      1. USJared Updike
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload