Hacker Newsnew | past | comments | ask | show | jobs | submit | romski's commentslogin

Find the graph of GW of solar installed over time


Ya agreed about that cost for a backup install - there are some interesting new options that should be less labor from an electrician.

https://us.ecoflow.com/products/delta-pro-transfer-switch


Yeah, there are a lot of more affordably priced solutions out there, but they still need a subpanel or similar cutover switch to be installed and that's where a lot of the electrician's cost is. Plus, the inexpensive ones like this $3300 Ecoflow are 120VAC (up to 3600W), so if you want to be able to power larger household loads like an oven or heat pump, you need to buy two (or more) of them (or a bigger unit), which doubles the price and gets you into the price ranger of other whole-house systems like a Powerwall or Enphase.

With the 120VAC unit, about all I could power in my house is lights, TV's, and maybe some small kitchen appliances, which limits how much power I could shift off of peak, maybe a KWh or two, which makes it harder to get any payback on the investment.

Unless the spread between peak/offpeak power prices becomes larger, I'm not sure that battery storage is going to be a worthwhile investment (for me). Or maybe if the utility bought back power at a reasonable rate during peak periods as the other poster's power company does...But the California PUC doesn't seem to be interested in incentivizing that model.


We don’t need to be “influenced by media” the tweets are there for everyone to see.


What tweets are you referring exactly?

If youre not basing your argument off of sources that means you're influenced most likely by propaganda.


You and the article author sound similar actually, just at different poles. Author doesn't bring up much other than saying that Musk isn't hardcore leftist and is kind of mean, therefore he's a nazi. You are along the same lines, that "with us or against us" attitude characteristic of extremely online types.


no I'm really saying if someone intensely dislikes Elon it's a good way to identify someone who is influenced by propaganda instead of reality


It’s downloaded over a Torrent seems fine


Yes using it in production - Stateless and ephemeral. For sure there’s a learning curve.


I see. Would it be fair to say you treat it almost like Pandas, except that it has a lower memory footprint since data is written to disk instead of memory. IE you use it for on the fly analysis of large frames of data, not like more traditional database/datawarehouse?


I'm not sure they're saying that.

BTW, your questions are exactly those that I've been ask over the last few months, but also with a lot of focus over the last few days. Still learning as much as I can so the following might not be true.

For what it's worth, there's a difference between using duckdb to query a set of files vs loading a bunch of files in to a table. But once the data has been loaded into a table it can be backed up as a duckdb db file.

Therefore it might be more performant to preprocess duckdb db files (perhaps a process that works in conjunction with whatever manages your external tables) and load these db files into duckdb as needed (on the fly analysis) instead of loading datafiles into duckdb, transforming and CTAS every time.

https://duckdb.org/docs/sql/statements/attach

Of course all of this might be introducing more latency esp if you're trying to do NRT analytics.

I assume you could partition your data into multiple db files similar to how you would probably do it with your data files (managing external tables).


Ah, almost like a little bit of a lower level trino, where DuckDB is able to push out queries to different data storage endpoints?


Unfortunately not. At least not without a little intervention. See this blog post for more details about what I mean. They inspect the iceberg table's catalogue to list the related parquet files and then load them into duckdb.

https://www.arecadata.com/getting-started-with-iceberg-using...

You would still need to interact with some kind of catalogue to understand which .db files you need to fetch.

And honestly I don't really know or understand the performance implications of the attach command.

I'm excited to see if the duckdb team will be able to integrate with external tables directly one day. (not that data files would be .db files)

Imagine this:

1) you have an external managed external table (iceberg, delta, etc... managed by Glue, databricks, etc)

2) register this table in duckdb

    CREATE OR REPLACE EXTERNAL TABLE my_table ... TYPE = 'ICEBERG' CATALOG = 's3://...' CREDENTIALS = '...' etc
3) simply interact with table in duckdb as you would any other table


Good thing they will be flying for the next 25 years!


Plastic and glass is ground up


Someone coming from a 350k fang job is not going to work for “35-70k” would you?


Some will have to.

In the big picture, FAANG salaries are outliers. Boom and bust cycles come and go, and when it is booming again - circumstances can have changed.

I worked with people in oil and gas that never came back, probably making only 25%-50% of what did they did during their best years.

Finance, too. Lots of young bankers were forced out back in 08-09, and never returned.

(With that said, tech is a bit more flexible on hiring, and I don’t think a 350k engineer will have to take a 300k pay cut, finding a “normal” ~100k engineering job is very possible. Or even another FAANG job if you’re willing to keep going at it. Could take weeks, months, even years - depending on how bad the market is)


If a significant proportion of developers end up unemployed, the faang salaries will be coming way down anyway. "Reserve Army."


Depends on the quality of the developers you're looking to hire.

The market for the kinds of developers that command ~$350-500k is still incredibly tight. There's a reason that even though Stripe is reducing headcount by 14% engineers are mostly unaffected.


A monthly disinfect helps you feel better how?


I interpreted that as sarcasm.


It was, I should have made that clearer.


You can create a 2nd investment account and start contributing to that while making minimum payments against your loan.


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: