Live data from Hacker News

How I store server logs in Google Spreadsheets

hakanu.net

11–16 of 16 posts

Re: How I store server logs in Google Spreadsheets

#11
post #5

If those server logs could contain customer-identifiable and/or confidential data, storing them in a cloud service might not be a good idea.

The spreadsheets are not open to world. They are restricted to the certain gmail accounts. Don't you think this is safe? Plus, what is the difference between storing in the spreadsheets or parse.com or loggly.com etc? in-house storing is cool but so costly and hard to analyze.

Re: How I store server logs in Google Spreadsheets

#13
post #4

I'm pretty disappointed with google sheet at the moment. I built some mildly complex spreadsheets for time tracking, nutrition, planning and such. They worked fine a year ago but I have experienced a massive drop in performance over the past few months. They take a minute to open and awfully slow to update calculations and no longer work reliably offline either. This is on an quad core desktop ffs. This will kill clo…

Have you upgraded to the newest version of google spreadsheets? We were having some performance issues that sound just like what you're experiencing and as soon as we made the switch, our sheets were super fast.

The best was definitely the remove of cell limits and row limits. If I remember correctly, it used to be at 50k linrs , which you reach in no time. The new spreadsheets are way faster indeed!

Re: How I store server logs in Google Spreadsheets

#14
post #13
post #4

Earlier quoted context omitted.

Have you upgraded to the newest version of google spreadsheets? We were having some performance issues that sound just like what you're experiencing and as soon as we made the switch, our sheets were super fast.

The best was definitely the remove of cell limits and row limits. If I remember correctly, it used to be at 50k linrs , which you reach in no time. The new spreadsheets are way faster indeed!

New limits are here: https://support.google.com/drive/answer/37603?hl=en Number of cells: 400,000 total cells across all sheets - this is the one i don't like. If you log substantial amount of columns, it fills up pretty quickly Number of columns: 256 columns per sheet Number of formulas: 40,000 cells containing formulas across all sheets Number of tabs: 200 sheets per workbook GoogleFinance formulas: 1,000 GoogleFinance formulas

Re: How I store server logs in Google Spreadsheets

#15
post #14
post #13

Earlier quoted context omitted.

The best was definitely the remove of cell limits and row limits. If I remember correctly, it used to be at 50k linrs , which you reach in no time. The new spreadsheets are way faster indeed!

New limits are here: https://support.google.com/drive/answer/37603?hl=en Number of cells: 400,000 total cells across all sheets - this is the one i don't like. If you log substantial amount of columns, it fills up pretty quickly Number of columns: 256 columns per sheet Number of formulas: 40,000 cells containing formulas across all sheets Number of tabs: 200 sheets per workbook GoogleFinance formulas: 1,000 GoogleFin…

You needed to read one more paragraph,

"All spreadsheet limits mentioned above have been removed in the new version of Google Sheets. The new version of Google Sheets should support 2 million cells of data, though please note that extremely large spreadsheets may have slower performance. Learn more about switching to the new version of Google Sheets."

Re: How I store server logs in Google Spreadsheets

#16
post #11
post #5

If those server logs could contain customer-identifiable and/or confidential data, storing them in a cloud service might not be a good idea.

The spreadsheets are not open to world. They are restricted to the certain gmail accounts. Don't you think this is safe? Plus, what is the difference between storing in the spreadsheets or parse.com or loggly.com etc? in-house storing is cool but so costly and hard to analyze.

No, this is not safe — Google still has access, and can give additional access to whoever compels them to do so.

This is, indeed, no different from other cloud-based solutions. In-house storage “costly”? Really? Well, what is security worth?

Post reply on HN