search

Tempest82 / Pointy-Stick

Pointy sticks are good for scraping and digging through stuff.
GNU Lesser General Public License v3.0
0 stars 0 forks source link

Determine storage subsystem #7

Open Tempest82 opened 9 years ago

Tempest82 commented 9 years ago

Consider SQL and NoSQL . Leaning towards Postgre SQL It's got advanced coordinate processing, full text search, and is open source.

SQL Systems allow for normalization of data where a No SQL database may require secondary caching to normalize.

Tempest82 commented 9 years ago

Testing Postgres SQL and research to determine throughput and limits to make a more informed decision.

Tempest82 commented 9 years ago

Follow-on information indicates that MySQL may be a better alternative due to speed of insertions. Which would be a concern at scale. But either system will require some configuration to use. However, from what I'm seeing and that at one point twitter was using a custom MySQL fork as well as other information.