Can you supply a household or a 'tiny house' with a battery?

I don't know how to ask the question specifically. But I have e.g. A daily electricity consumption of approx. 2-3 kwh. In any case, well below 1000 kWh per year. I'm very interested in self-sufficient life or tiny houses and such. Now I would have been interested in whether there are energy stores, batteries, etc. That have such a large capacity that you could live weeks or months independently with regard to electricity. (Fridge, television, light, laptop…). How big should a photovoltaic system be that you have a 1000kwh yield, and how quickly does a battery or other storage medium lose stored energy that you have not used?

Larger batteries just lose more energy. It also depends on the quality

How far is the next socket away?

A rather small car battery with a good 40 Ah stores just 1/2 kWh. You would need 4 - 6 of these a day! There are batteries with a higher energy density, but that per volume or per mass, not necessarily per purchase price.

The energy loss of the batteries is a minor problem against longer phases in which neither the sun shines nor wind blows, e.g. In a wintry high pressure situation with high fog. It will hardly be possible without other energy generation or purchases.

As far as solar modules are concerned: Just have a look at the online offer! You can see how much m² you need for which performance. In terms of power, you need 2.4 kWh / 24h, 100 W, on a daily average. 2.4 hours of sunshine a day, then assumed to be 1000 W. I wouldn't expect more sunshine in this country.

And the days / weeks without sun remain. Then you can either go to a buddy every 2 days and charge the batteries, or you need an emergency solution. A biogas-powered gas-steam turbine, a camping gas-powered Stirling engine, a heating oil-powered diesel engine. They would then also supply the heating with heat.

But, you guessed it, these are more solutions for villages or settlements, not for individual households.

In addition, complete self-sufficiency also takes away the possibility of feeding surpluses - which inevitably arise on days like yesterday - into the internet.

You also have to get by with the little daylight in December-February. The north you are, the less it gets. You can make the battery so big that you can use it for days. And the solar system is so big that even a few hours of daylight with diffuse light are enough.
The solar radiation at earth level is 1.3 kW / m2. After loss through the atmosphere at the 50th parallel, still at 1 kW / m2. On a cloudy winter day you might get 200W / m2. With an efficiency of 10% at best, your Sorar panel then makes 20W / m2. Per day average maybe 50.80 Wh / d. The charger has an efficiency of 90%. Perhaps. Rather 70%. Because it is designed for the 100W in summer.
So expect 60 Wh / d x 0.7 = 42 Wh / m2d charging power.
The efficiency of the battery should be 70.90%. Depending on the type. We expect 80%. So Wh / m2d x 0.8 = 33.6 Wh / m2d of "harvesting power". For your 3 kWh / d you need around 90 m2 of solar space. X 160 euro / m2 = 14,400 euro. In addition there's the battery and the assembly.
The electricity from the socket costs you around 300,500 euro / a.

I don't want to feed anything anywhere and it's more of a thought experiment at the moment, and I don't want to deny everyday life self-sufficient, but maybe a weekend house or something similar…

Could you generate so much energy with a bicycle that is connected to a battery or generator or the like that you could e.g. Got energy for a day? Or even energy for several days?

Or another question… Are there 'easy' ways e.g. Are we saying to produce 3 kWh per day?

The orders of magnitude are somewhat unusual. If you are sporty and persevering, you might get 100 W of continuous power. After a 10-hour shift, you then generated 1 kWh, energy worth around 30 cents. Your hourly wage would be 3 cents.

Apart from solar and wind energy, all I can think of is the burning of more or less renewable / fossil fuels.