-
Recent Posts
- At 3:30 AM the doors opened…
- W.O.O.D. – 16 March 2023 – Ukraine Dead Man Walking, Banks Bleeding, Wild Weather
- Some Notes on SVB & Other Bank Runs
- Are “We” The Baddies? Corruption Of The Western Governments…
- Russians More Rational Than The West
- Bill Maher Catches Clue – No, really…
- Growing Well, So Far, In Florida Garden
- I’m In Rain & Thankful For It – California Snow Halt
- Tow Vehicle Saga (sort of) Ends (hopefully)…
- W.O.O.D. – 17 February 2023 – Ukraine Shrinks More, FORD On My Mind, Garden Growing, NATO Smells The Coffee
- Why e-Vehicles, Solar & Wind Will Not “Transition”
- So Close – Missing Convection & Homeostasis
- Oh Dear: ChatGPT Ethical Bypass Hack Zero Day
- Has W.W.III already started?
- My Hispanic Side
- “More” is not a Battle Plan & Logistics is a Requirement
- Covid Code Talking & Natural Substances
- Derangement On Your Part Does Not Constitute A Mandate On My Part
- Ukraine – Going Big or Just A Distractor? New Shelling. Maybe…
- W.O.O.D. – 11 January 2023 – Ukraine Shrinks, Politics Drags on, Garden Begins
Recent Comments
another ian on W.O.O.D. – 16 March 2023… another ian on W.O.O.D. – 16 March 2023… Foyle on At 3:30 AM the doors open… The True Nolan on W.O.O.D. – 16 March 2023… another ian on W.O.O.D. – 16 March 2023… another ian on W.O.O.D. – 16 March 2023… another ian on W.O.O.D. – 16 March 2023… Simon Derricutt on At 3:30 AM the doors open… another ian on W.O.O.D. – 16 March 2023… Ossqss on W.O.O.D. – 16 March 2023… The True Nolan on W.O.O.D. – 16 March 2023… Ossqss on Some Notes on SVB & Other… Ossqss on Some Notes on SVB & Other… E.M.Smith on Some Notes on SVB & Other… E.M.Smith on W.O.O.D. – 16 March 2023… Categories
- AGW and GIStemp Issues (78)
- AGW and Weather News Events (235)
- AGW Climate Perspective (71)
- AGW GIStemp Specific (40)
- AGW Science and Background (360)
- Arts (117)
- Biology Biochem (73)
- Carping Comments (13)
- cooking (103)
- Covid (118)
- CRUt (12)
- dT/dt (44)
- Earth Sciences (190)
- Economics – Trading – and Money (448)
- Emergency Preparation and Risks (267)
- Energy (85)
- Favorites (111)
- Fiction (1)
- FOIA Climategate (10)
- Food (325)
- GCM (20)
- GISStemp Technical and Source Code (64)
- Global Cooling (41)
- Global Warming General (74)
- History (143)
- Human Interest (439)
- Humor (96)
- Meme (14)
- Metrology (18)
- Movies & Media (38)
- NCDC – GHCN Issues (140)
- News Related (363)
- Nukes (15)
- Plants – Seeds – Gardening (87)
- Political Current Events (972)
- Religion (32)
- Science Bits (270)
- Security & Privacy (8)
- SPAM and SCAM disection (3)
- Stock Charts (23)
- Stonehenge (11)
- Tech Bits (497)
- Tips (46)
- Uncategorized (45)
- W.O.O.D. (124)
- Wall Street Week… (70)
- World Economics (119)
Postings By Date
Prior Months; postings by date
Meta
Tag Archives: SQL
GHCN Database Pondering A Redo
Which is better, one BIG table or two smaller ones? Decisions and questions on GHCN handling. Continue reading
Updated GHCN Load Scripts & Reduced Warnings
And inproved version of the MariaDB / MySQL database and data loading scripts, with run times and discussion. Many warnings removed and one data loading bug fixed. Continue reading
GHCN v4 Adding Statistics & Anomaly Tables
I create the anomaly and statistics tables for GHCN v4. Continue reading
Posted in NCDC - GHCN Issues, Tech Bits
Tagged Anomaly, GHCN, MariaDB, SQL, Statistics, V4
22 Comments
Procedural Languages, MySQL, Massively Parallel, and Climate Modeling
A Modest Suggestion of a different way to build an iterative computer model of geographic climate cells using MySQL as the grid defining data store and as the “flow of control” “lock” in parallel processing, plus an interesting video about the very old roots of “modern” programming concepts. Continue reading
Posted in GCM, NCDC - GHCN Issues, Tech Bits
Tagged ALGOL, GHCN, Models, MySQL, Procedural, SQL, USHCN
7 Comments