5 ms·

The example shown has 14GB of data, which is absolutely tiny, yet it can still rack up $40k in costs per day if used incorrectly (i.e. less than optimal, but no

The example shown has 14GB of data, which is absolutely tiny, yet it can still rack up $40k in costs per day if used incorrectly (i.e. less than optimal, but not egregiously wrong)? Why would you use this?

Foobar8568 4y ago
- sumtechguy 4y ago
  Never ever become 'the SQL guy' in your group. No one wants to learn it. SQL is the intersection of set theory, computational theory, network usage, cpu usage, and laziness. "your table is 120 columns wide and nothing but strings with no rules of the data types and no indexes, sooooo your perf is a bit slow huh?" "yeah how did you know?" "wild guess"
  - Foobar8568 4y ago
    Among my favorites, "NULL" vs NULL, date/timezone/utc and locals, anything related to data warehouse. Transferring everyday billions of records from SaAS applications.
- beckingz 4y ago
  We should start a business selling data intelligence to solve this problem. Maybe call it... business intelligence?
mcphage 4y ago
Plus, on what planet would you be refreshing that query every second of the day?
- pixl97 4y ago
  The one where some dev gets the query in a loop unintentionally and you discover your bankrupt the next day.
  - _peregrine_ 4y ago
    This happens more often than you might think…
- didgetmaster 4y ago
  Would that be the same planet where you can refresh a query every second that takes 2.4s to complete? How does that work?
oefrha 4y ago
Scanned 6.67GB and processed for 2.41s, cost $40340.16 / 86400 = $0.4669. More than the hourly cost of AWS on-demand a1.x4large with 16 vCPU and 32GB of RAM. Can’t think of a worse advertisement for their product.
- altdataseller 4y ago
  Seriously, when i read this, i was like, there is no way i will ever use this example product they mentioned in TinyBird. After reading it, i was curious what the writer’s relationship was with TinyBird. Was he/she a recent user? Then i put my palm over my face..

Foobar8568 4y ago

sumtechguy 4y ago
Never ever become 'the SQL guy' in your group. No one wants to learn it. SQL is the intersection of set theory, computational theory, network usage, cpu usage, and laziness. "your table is 120 columns wide and nothing but strings with no rules of the data types and no indexes, sooooo your perf is a bit slow huh?" "yeah how did you know?" "wild guess"
- Foobar8568 4y ago
  Among my favorites, "NULL" vs NULL, date/timezone/utc and locals, anything related to data warehouse. Transferring everyday billions of records from SaAS applications.
beckingz 4y ago
We should start a business selling data intelligence to solve this problem. Maybe call it... business intelligence?

mcphage 4y ago

Plus, on what planet would you be refreshing that query every second of the day?

pixl97 4y ago
The one where some dev gets the query in a loop unintentionally and you discover your bankrupt the next day.
- _peregrine_ 4y ago
  This happens more often than you might think…
didgetmaster 4y ago
Would that be the same planet where you can refresh a query every second that takes 2.4s to complete? How does that work?

oefrha 4y ago

Scanned 6.67GB and processed for 2.41s, cost $40340.16 / 86400 = $0.4669. More than the hourly cost of AWS on-demand a1.x4large with 16 vCPU and 32GB of RAM. Can’t think of a worse advertisement for their product.

altdataseller 4y ago
Seriously, when i read this, i was like, there is no way i will ever use this example product they mentioned in TinyBird. After reading it, i was curious what the writer’s relationship was with TinyBird. Was he/she a recent user? Then i put my palm over my face..