HackerTrans
TopNewTrendsCommentsPastAskShowJobs

hgamaral

no profile record

Submissions

China unveils 'mini fridge' AI server that uses 90% less power

scmp.com
13 points·by hgamaral·9 เดือนที่ผ่านมา·2 comments

Sitting Bull

en.wikipedia.org
1 points·by hgamaral·4 ปีที่แล้ว·0 comments

comments

hgamaral
·8 เดือนที่ผ่านมา·discuss
> It's totally possible to get this done with a web based SPA.

Yeah, I guess I could say that before I tried rebinding ctrl-w and some of the Fx keys (like F12).
hgamaral
·4 ปีที่แล้ว·discuss
It might not be the best tool available, but Timescale's columnar capabalities [0][1] looks great to me. I mean, being able to achieve 90%+ compression on a row-oriented database is not something to be ignored.

[0] - https://www.timescale.com/blog/building-columnar-compression... [1] - https://www.timescale.com/blog/timescaledb-2-3-improving-col...
hgamaral
·4 ปีที่แล้ว·discuss
> I think because Postgres writes the entire row even if a single column has been updated.

You might want to have a look at HOT [0] tuples if you haven't already.

[0] - https://www.cybertec-postgresql.com/en/hot-updates-in-postgr...
hgamaral
·4 ปีที่แล้ว·discuss
Sorry, could you please expand on what you mean by "sick"?
hgamaral
·5 ปีที่แล้ว·discuss
Also BR:

- I'm shitting and walking ("estou cagando e andando");

- My as* doesn't even itch ("meu c* nem pinica").

- What about Kiko? ("e o Kiko?" -- trust me this one is hard to explain).

EDIT: formatting
hgamaral
·5 ปีที่แล้ว·discuss
Not on mobile...
hgamaral
·5 ปีที่แล้ว·discuss
I'm not so sure. According to [1], for 1MB data transfer over TLS there's up to 15% overhead used for encryption on WLANs. That's 15% more data you have to process, which is not quite the carbon footprint of your coffee drink if you consider how many requests you serve. And that's just data, not to mention all calculations necessary to actually encrypt stuff.

[1] - https://users.aalto.fi/~siekkine/pub/siekkinen11tls.pdf
hgamaral
·5 ปีที่แล้ว·discuss
I get that TimescaleDB is good for time series and the like. HOWEVER, people are actually using its extension to just improve PostgreSQL performance on OLTP workloads without having to change a big piece of tech. I have experienced it myself: just enable TSDB in a regular PG database and you can expect things to work faster, no code change required.

EDIT: wording, grammar.
hgamaral
·5 ปีที่แล้ว·discuss
I just wonder how much energy does it take to serve content over TLS/SSL. Maybe that's another factor to consider when building a "low tech" website.
hgamaral
·5 ปีที่แล้ว·discuss
Django has always had some magic, although much less than ruby/rails. That kind of magic is the reason why it is a pain to package a Django project with py2exe, for instance.