What is MariaDB Database?

According to the website MariaDB.org, MariaDB is “one of the most popular database servers in the world. It’s made by the original developers of MySQL and guaranteed to stay open source. Notable users include Wikipedia, WordPress.com and Google.”

In the past, I’ve installed MariaDB locally on my CentOS or Ubuntu servers, but didn’t go much further. Now, my ISP (IONOS) offers ability to create MariaDB Databases hosted within their cloud. Here goes creating, accessing and learning more about the system. There could be connections to Apache websites and Python programming. I’ll cross-reference to past posts I wrote, as needed.

I always start by first going to the source website to review documentation high-level. This can set in some overwhelm, so I remember the GTD maxim to focus just on “the Next Action”. One thing I notice, as of 20220116 is the version is 10.6.5. Within IONOS they were only saying version 10, so first thing after installing the database is to check the version.

Posted in Databases, MariaDB | Leave a comment

PG&E – Electricity rate plan changes in October 2021

Objective:
Trying to understand what changes are, options, etc

Disclaimer: I live in Morro Bay, San Luis Obispo County, Central Coast, California – so YMMV.

Rate-Plan: Time-of-use
Note: If I don’t do anything, then it automatically shifts to this plan “Time-of-Use (Peak Pricing 4-9 p.m. Every Day) E-TOU-C” without my input
-Looks like many people are going to do this, and it’s risk-free.

Q: What does Time-of-use mean?
A: Peak Pricing is 4PM to 9PM every day. The rate plan is risk-free for the first 12 months with automatic bill protection.
A: If I pay more during the first year on Time-of-Use vs current rate plan, I would receive a credit for the difference at the end of the 12 months.

Q: What does “Peak” Pricing actually mean?
A: It’s not just about how much electricity I use, but WHEN.
A: I would receive lower electricity pricing during most of the day, when energy demand is lower. In other words, if I’m home during the day, then it would be strategic (for example) to run the dishwasher with it ending before 4PM.
A: Electricity pricing will be either during “Peak” usage times which is 4PM to 9PM.
A: There are two time periods – “Peak” and “Off-Peak”

Q: What does Bill Protection actually mean?
A: If I somehow pay more after a year, compared to my current plan (xxx), then I get a credit for the difference after a year. I can also switch to another rate at any time. Bill protection still applies for the time I’m on the Time-of-use plan.

Q: What is my current rate plan?
A: Short answer is: Tiered Rate Plan E-1
A: This actually really bothers me – I’m looking at my bill on 20210910 and it’s not obvious what it’s called. In hindsight, it became clearer – after spending an hour dissecting everything.
A: I’m seeing two line items – 1. Current PG&E Electric Delivery charges and 2. Central Coast Community Energy Electric Generation charges
A: For Details of PG&E Electric Delivery, it’s “Rate Schedule: E1 T Residential Service”. For August 2021, Tier 1 allowance is 225 kWh, and I’m up to Tier 2 with an additional 132 kWh for a total of 357 kWh. There is a line-item of a “Generation Credit” and one for “Power Charge Indifference Adjustment”.
A: For Details of Central Coast Community Energy Electric Generation charges, it’s “Rate Schedule: MBRETCH1 3Cchoice E1”. There was a Generation total of 357 kWh.

Q: What is description of the various rate plans?
A: “Tiered Rate Plan E-1” – This rate plan is best for you if you are able to conserve electricity throughout the month and are not able to decrease your electricity usage during the late afternoon and early evening hours.

A: “Peak-Pricing” – This rate plan is best for you if you can reduce some of your electricity usage during the higher priced, peak time of 4 p.m. to 9 p.m. every day (including weekends) and can stay below or close to your Baseline Allowance.

A: Time-of-use (Peak Pricing 5-8 PM Weekday (E-TOU-D). This rate plan is best for you if you typically use a high amount of electricity throughout the month but can reduce your electricity usage during the higher priced, peak time of 5 p.m. to 8 p.m. on weekdays.

A: Home Charging EV2-A – This rate plan is for Electric Vehicle (EV) and/or battery storage customers who can charge during off-peak hours and shift other electricity usage to off-peak hours. Customers using over 800% of Baseline Allowance in the last 12 months are ineligible. Note: This is not me.

Q: Where is the change? Is it only within the PG&E line-item?
A: I “think” it’s only with the PG&E line item

Q: What is 3CE (Central Coast Community Energy)?
A: This is a an org that effectively sources clean energy and is good for the community. The 3CE charge replaces PG&E’s charge for electric generation. This explains the generation credit within the PG&E Section.

Q: How do I decide?
A: Answer appears to be in a behavioral shift within the hours from 4PM to 9PM. For example, ensuring things like dishwasher is done during the day would help. Challenge will always be the cost of heating during the winter – which is typically in the evening. Creative things like the shrink-wrap on the windows goes towards energy conservation.
A: There appears to be a financial forecast of $50 less over the year by going to Time-of-Use — so, might as well all the automated switch to happen.

Posted in Pacific Gas and Edison, Utility Companies | Leave a comment

Automobiles – list of cars I’ve owned with pros and cons

Nissan Sentra (1985)
-First car – which means I got really good at tinkering with it. Stick shift, which was interesting in New York City. Purchased used in 1989. 2-dr coupe. No A/C.
-Pros: Amazing gas mileage – NYC to Toronto on 1-tank. Strong engine.
-Cons: Frequent maintenance required. Was not maintained well by first owner.

Ford Explorer Sport (1996)
-Pros: I had the leather version, and seats were really comfortable for long trips. Also, they had a pull to place right under the knee, which helped reduce strain. You sat very high and could see over everyone.
-Cons: Fuel consumption was bad at around 15 mpg. It had a boxy feel when turning corners at low speed with some oscillation. Tires were expensive. I leased for 2 years, so my monthly was high — don’t lease for 2 years.

Chevrolet Monte Carlo (1998)
-Pros: Very speedy and nimble. Cool looking double pipe exhaust. Looked like a cop car on freeway. Fuel mileage was very good.
-Cons: I’ll never buy a jet black (onyx) car again – was not fun keeping it clean.

Honda Accord (??)
-Pros: Seemed reliable as a Honda is.
-Cons: I’ll never buy a used car again where I have to sign of on issues with odometer. Problem was then when I sold it back to a dealer – was just a messy process.
-Cons: Unlikely I’ll buy used unless from a major dealer. After it rained, all the paint covering came off. Then, it needed a water pump. Then something else. and so forth…

Saturn SL2 (1999)
-Pros: When Saturn was around the big sell was “no haggle”. The SL2 was a good basic sedan.
-Cons: Not much power, but better than the SL1. Took the SL1 for a freeway test-drive and got off the freeway after 1 exit and went back to the dealer.
-Cons: Fuel mileage not good

Chevrolet Impala (2000)
-Pros: Fuel mileage was really good – similar to Monte Carlo. Was the biggest sedan I had driven so far – huge trunk.
-Cons: I had leather seats, and I sensed that because the car was slightly narrow, the seats were also a bit narrow. Wasn’t that comfortable on long trips. When the Impala was in year 1996, it was the classic big and wide cop car. Then they discontinued it for a couple years. By the time it came back, and I was driving the 2000 version, it started looking weird in the rear end (light design) and also it was a bit narrower. Around the same time, the Monte Carlo also had a rear-end refresh which looked really weird.

Saturn L300 (2002)
-Pros: No haggle again by sales guy.
-Cons: Can’t think of anything. Overall it was a good ride and no problems. I suppose the standard bad fuel mileage was a pattern with the Saturn.

Saturn Vue Redline (2004)
-Pros: This was the high-end SUV of Saturn. Was really comfortable. Somehow, I wasn’t up that high compared to Ford Explorer.
-Cons: Fuel mileage really sucked.

Saturn ION2 (2005)
-Pros: Really good replacement of the SL2.
-Cons: Only internal cosmetic issue, which was fixed, was peeling around center console by knee.
-Cons: Fuel mileage bad – Saturn.
-Cons: Felt a bit boxy and stiff, but overall reliable.

Honda Pilot (2008)
-Pros: First Honda for me. Nice to have the additional space for payload
-Pros: Better ride quality than the Ford Explorer (less jumpy on corners), but I think the seats were better in Ford Explorer.
-Cons: Felt heavy. After a while, it felt tired. Fuel mileage not great.
Note: This is the car that those incessant “Auto Warranty” folk keeping call me about. I freakin’ returned it in 2010!!!

Honda Civic 2dr Coupe (2009)
-Pros: Good Honda replacement for Saturn.
-Cons: Had fabric seats, which felt a bit hard
-Cons: Didn’t feel completely comfortable with power.

Toyota Tundra (Full double-cab) (2010)
-Pros: Having the utility of a truck. Sitting really high. Very stable to drive.
-Pros: In my case they added the side runners to step up and also leather seats.
-Cons: Fuel mileage really sucked bad.
-Cons: Tundra Bounce – had to add additional ballast in rear to stop it oscillating on the 101 Freeway.
-Cons: I didn’t actually need it that much for the rear payload of a truck, therefore the need for a truck utility wasn’t there. Won’t do this again – if I really need a truck, then I’ll get one, or I’ll just rent a truck in meantime.
-Cons: Tricky for navigating in parking lots – having to always back into places to get out easily.
-Cons: Overall, I didn’t enjoy having a truck – fuel mileage; way too big.

Toyota Prius2 (2010)
-Pros: First hybrid, which was fun getting about 45 mpg
-Cons: Can’t really think of anything. Seats maybe not as comfortable because transitioned to fabric.

Toyota Highlander (2012)
-Pros: Fast and comfortable. Good mileage. Payload very adequate in back. Nice transition from the Tundra.
-Cons: Mom called it a “Mommy car”, which it was, but I actually liked it.

Toyota Prius2 (2013)
Note: Same as prior Prius2

Toyota Prius C3 (2016)
-Pros: Same hybrid mileage as Prius2 – 45 mpg
-Pros: Considering it was much shorter than everything else I’d drive, I was really amazed how much inside room I had, including leg room – no problems.
-Cons: Can’t really think of anything. All was good.
-Cons: One reason I didn’t keep it was that the C3 model was discontinued. Would have been a risk in future for parts.

Toyota Camry Hybrid LE (2019)
-Pros: The Camry has been well loved for years, so this was a safe bet for long term.
-Pros: 45 mpg is great.
-Pros: Very smooth ride. No complaints. Adequate trunk.
-Cons: Seats are OK if your butt is firmly in the middle of the fabric seat.
-Note: Because of COVID, my mileage is really low. Have one more year – ending around October 2022 for a 3 year lease. If I can’t resolve to an electric-type vehicle by then, then I think I’m strategically going to buy the Camry while waiting for the next move. When I had originally leased it in 2019 I had purchased the additional warranty to 5 years, 45K or something.

Posted in Automobile, Transportation | Leave a comment