967 karma · joined January 14, 2012
* wind energy deployment decreased massively in the last 3-4 years due to bureaucracy.
* Solar was always complicated, if you had it on the roof of your own house you would need to register a small business regardless and declare extra taxes every 3 month.
a.) there are not enough skilled workers that know how to deploy these. in fact it was just published in the news that due to boomers going in pension the workforce in this area already reduced over 10% in the last years and projected to sink even more. b.) most houses that are using Gas heating are not isolated well enough to make a switch to heat pumps financially viable.
The use case is storing trace/profiling data, where we use one sqlite file for each customer per day. This way its easy to implement retention based cleanup and also there is little contention in write locking. We store about 1 terrabyte of data over the course of 2 weeks this way.
Metadata is stored in Elasticsearch for querying the search results and then displaying a trace hits the Sqlite database. As looking at traces is a somewhat rare occurence we iterate over all fileservers and query them for trace data given an ID until we find the result.
Reference https://www.sqlite.org/fasterthanfs.html
In reverse, you probably know a lot names of startup or IT personalities, that nobody outside our field would ever need to know
Never modify a column Never drop a column or table
This must be highlighted.
Pick a job based on people that can catapult you to the next levels.
The performance improvements where not directly sponsored by Facebook.
How is that not much better on all fronts?