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

OctoPlot is a small command line tool that draws a graph of the Octopus Energy Agile GB electricity pricing in your terminal.

Source (EUPL): https://github.com/jpsingleton/octoplot

Sample output (colour not shown):

  Getting pricing data...
  
  Pricing data from Fri 22 May 13:00 to Sun 24 May 15:00 for region P
  
   18p                                                                                                     
   17p          £ £                                                                                        
   16p          £££                                                                                        
   15p        £ £££                                                                                        
   14p        £££££                                                                                        
   13p        £££££                                           £ £££                                        
   12p        £££££                                           £ £££                                        
   11p       ££££££                                           £££££                                        
   10p       ££££££                                           £££££                                        
   09p       ££££££                                           £££££                                        
   08p       ££££££                                           £££££                                        
   07p       ££££££                                           £££££                                        
   06p       £££££££                                         ££££££                                        
   05p       £££££££ £ £ £                                   ££££££                                        
   04p       £££££££££££££                                   ££££££        £                               
   03p       £££££££££££££                                   ££££££        £ £                             
   02p       £££££££££££££ £                                 ££££££        £ £                    £        
   01p       ££££££££££££££££                                £££££££££££££££££££                 ££        
   00p £     ££££££££££££££££££                ££££          £££££££££££££££££££                 ££   £    
  ---------------------------------------------------------------------------------------------------------
  -01p £     £££££££££££££££££££               ££££          ££££££££££££££££££££                £££££££   
  -02p £££   ££££££££££££££££££££             £££££  £       £££££££££££££££££££££ £        £   ££££££££ £ 
  -03p ££££ ££££££££££££££££££££££            £££££££££      £££££££££££££££££££££ £        £   £££££££££££
  -04p £££££££££££££££££££££££££££          ££££££££££££     £££££££££££££££££££££££      £ £ £ £££££££££££
  -05p £££££££££££££££££££££££££££        £ ££££££££££££     ££££££££££££££££££££££££££   £ £ £££££££££££££
  -06p £££££££££££££££££££££££££££££      £ £££££££££££££    ££££££££££££££££££££££££££££££££££££££££££££££
  -07p £££££££££££££££££££££££££££££     ££ £££££££££££££    ££££££££££££££££££££££££££££££££££££££££££££££
  -08p ££££££££££££££££££££££££££££££    ££ £££££££££££££    ££££££££££££££££££££££££££££££££££££££££££££££
  -09p ££££££££££££££££££££££££££££££    ££ £££££££££££££    ££££££££££££££££££££££££££££££££££££££££££££££
  -10p ££££££££££££££££££££££££££££££££ £££ £££££££££££££    ££££££££££££££££££££££££££££££££££££££££££££££
  -11p ££££££££££££££££££££££££££££££££££££ £££££££££££££    ££££££££££££££££££££££££££££££££££££££££££££££
       1 1 1 1 1 1 1 2 2 2 2                     1 1 1 1 1 1 1 1 1 1 2 2 2 2                     1 1 1 1 1 
       3 4 5 6 7 8 9 0 1 2 3 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 
  
  Paid most for electricity between Sat 23 May 14:30 and Sat 23 May 15:00 (-12.327p/kWh inc. VAT)


Pi-hole® (network-wide tracker/ad blocking) set up as a WiFi repeater/extender. This improves WiFi coverage, allows switching between the unfiltered/filtered connections and forces all traffic through the filter from devices that try to evade it.

Part 2: https://unop.uk/pi-hole-extended-part-2


I made a similar setup with Home Assistant running on a low power Raspberry Pi 3A+ connected to a Xiaomi Mijia Bluetooth Low Energy temperature and humidity sensor (model code LYWSDCGQ). It takes a single AAA battery and it's lasted almost a year on one.

There's a ready-made Home Assistant component but I wrote up a guide on how to read the data from a Linux terminal on your laptop: https://unop.uk/xiaomi-mijia-bluetooth-temperature-and-humid...

I also have Volatile Organic Compounds / equivalent carbon dioxide (Sensirion SGP30) and Particulate Matter (Plantower PMS5003) sensors soldered up to a Raspberry Pi Zero W over I2C/UART for logging. It lasts quite a while on a USB battery so you can take it out and about. An ESP8266/ESP8285 would last longer but it's easy to log with a python script and the SD card gives you loads of storage. I haven't written this up yet but will if anyone is interested?


This is a great long read (if you like log graphs) on how solar prices have dropped more than anyone predicted: https://rameznaam.com/2020/05/14/solars-future-is-insanely-c...

> This incredible pace of solar cost decline, with average prices in sunny parts of the world down to a penny or two by 2030 or 2035, is just remarkable. Building new solar would routinely be cheaper than operating already built fossil fuel plants, even in the world of ultra-cheap natural gas we live in now. This is what I’ve called the third phase of clean energy, where building new clean energy is cheaper than keeping fossil fuel plants running. Even in places like Northern Europe, by the later 2030s we’d see solar costs below the operating cost of fossil fuels, providing cheap electricity in summer months with their very long days in the high latitudes. These prices would be disruptive to a large fraction of already operating fossil fuel power plants – particularly coal power plants, that are far less able to ramp their power flexibly...

(hat tip to the Forge the Future newsletter: https://forgethefuture.substack.com/?no_cover=true)

I predict a lot of fossil plants will convert to simply providing inertia for grid stabilisation and charge for the service. They won't burn anything any more and may even demolish their stacks and cooling towers. They will just keep their generators and turbines connected to the grid as a big virtual flywheel to dampen spikes in demand / supply and maintain the AC frequency within tolerance.


Seems like that role will also be moved over to battery installations, as they have an instant response time vs long minutes for a plant.


Battery installations are still relatively expensive right for the capacity they offer right?


That's a very general statement, but solar plus lithium battery storage is now competitive with gas peaker plants and those can grid balance as an extra service.


That is true, but prices have been dropping rapidly.


Inertia is slightly different to supply response and most inverters use grid coupling for frequency and phase synchronisation so are not suitable. The slow response of old plants is an asset in this case and only a problem if they are generating rather than just providing inertia, which is instant.


Currently it would probably be better to generate hydrogen if there is excess power in the gridit would probably be a lot more economical than batteries though roughly 66% is lost in conversion


If anyone is interested in how to set up a network-wide tracker blocker then I've written some guides on how to configure Pi-hole as a router and Wi-Fi range extender. This means you can force all traffic through your custom DNS, even devices from Google and Amazon that don't respect DHCP.

https://unop.uk/pi-hole-extended-part-1/

https://unop.uk/pi-hole-extended-part-2/

It's still worth installing privacy add-ons to Firefox but this helps with some profiling intrusions in mobile apps and Chromecasts etc. It also helps protect your less technical family members a little, although it obviously can't keep them completely safe from surveillance. Education is an important aspect too.


Huxley 2 is a CORS enabled cross-platform JSON ReST proxy for the GB NRE LDB WCF SOAP XML API (called Darwin). It supports both the Public Version (PV) and the Staff Version (SV). It's built with ASP.NET Core LTS, C# 8.0 and lots of abbreviations!

V2 is a reimplementation on ASP.NET Core, allowing Huxley to run on Windows, macOS and Linux. You can now use Huxley on any platform (pun intended)!

Demo server: https://huxley2.azurewebsites.net/

No token needed e.g.: https://huxley2.azurewebsites.net/all/old/1

Source code (EUPL 1.2): https://github.com/jpsingleton/Huxley2

Guide to set up an instance on Azure with Azure DevOps YAML pipelines: https://unop.uk/huxley-2-release/


Not a geographical map but https://oneplanet.com/ has a tool to visualise the connections in a sustainability plan.


The air quality in Westminster this week is excellent. :)


This also covers CSV as well as APIs.

Links:

https://openapi.tools/

https://tools.ietf.org/html/rfc4180

While using the open API spec is good, I'd say the standardisation of CSV data will have more impact. More of the open data available is in the form of historic reports rather than real-time: https://data.gov.uk/ (e.g. https://data.gov.uk/dataset/27dd8d7f-c58b-4de3-bf0d-81058465...)


I spent a while looking through the registered birth names data for about 5 years while we were naming our kids. Each year was in Excel sheets, which changed format repeatedly. It was really annoying.

Moving over to providing everything as well formatted CSVs is going to be so much nicer.


I can't find any mention of CSV in the OpenAPI documentation or the first link you provided, can you elaborate a bit how this works?


I think he means that the UK govt has mandated a particular CSV standard for tabular data, at the same time. I think you're right that OpenAPI has nothing to do with CSV.


Yes. CSV with the obvious extra conditions "UTF-8" and "one header row" is fairly interoperable, but note: "when you’re using Excel for Windows to load a file that is UTF-8 without a BOM, you can resolve the display of non-ASCII characters by using the ‘import text’ option". If a Windows user just clicks on the file then sometimes UTF-8 is interpreted as some 8-bit encoding and you get mojibake. Nevertheless, you shouldn't add a BOM because the standard doesn't permit that and it might cause all sorts of problems on other systems.



Is that true? Iirc Openapi lets you define schemata for csv payloads in POST body sections. Whether they are validated by the backends is another question...


The page title is actually "Improve CSVs and API descriptions with these Open Standards Board recommendations"


Yes. The cost of action is dwarfed by the cost of inaction, but that cost is felt (not so) far in the future. It's a problem with short-term thinking creating a false economy and building up a huge debt.


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

Search: