# extract — RSS Amplifier Recent posts from the 14 feeds in the RSS Amplifier directory that cover extract. Page: Feed: --- ## [My other favourite new cookbook](https://indiaknight.substack.com/p/my-other-favourite-new-cookbook) _2026-08-18 · India Knight · Home_ Recipes for life ## [Deciphering Date Differences with DATEDIFF](https://connor-mcdonald.com/2026/08/17/deciphering-date-differences-with-datediff/) _2026-08-17 · Connor McDonald · Learning is not a spectator sport_ (Try saying that 5 times quickly in a row) 🙂 There’s an old saying that’s gone around for years in IT circles which is “If you have a text parsing problem you can use a regular expression…now you have two problems“. I’d like to steal that phrase and manipulate it for the sake of today’s \[…\] ## [Weekend supplement](https://indiaknight.substack.com/p/weekend-supplement-af6) _2026-08-15 · India Knight · Home_ - well, the August version ## [“Where are my patches?!?!”](https://connor-mcdonald.com/2026/08/13/where-are-my-patches/) _2026-08-13 · Connor McDonald · Learning is not a spectator sport_ Anyone that follows me on the socials knows that I m pretty keen on security. Whilst all those other day-to-day things like performance and uptime etc etc are all important, rest assured; people will generally forgive you for being down for a while; they will forgive you for being slow for a while, but they will \[ \] ## [Mini supp](https://indiaknight.substack.com/p/mini-supp) _2026-08-08 · India Knight · Home_ can't keep away ## [So, Thermal Desalination is the Future Now? (w. Willian Janssen - Desolenator)](https://podcast.ausha.co/dont-waste-water/so-thermal-desalination-is-the-future-now-w-willian-janssen-desolenator) _2026-08-08 · (don't) Waste Water! | Water Tech to Solve the World_ Thermal desalination lost the water industry to reverse osmosis on one number: boiling seawater takes about ten times more energy than pushing it through a membrane. So why is one of the 20 teams left in the XPRIZE Water Scarcity competition still betting on heat? Desolenator is a Dutch water tech company that desalinates with heat instead of pressure, running on solar energy and industrial waste… [Listen](https://audio.ausha.co/B1KX6tAVpE6p.mp3?t=1786155230) ## [Me & My Desk: Mishal Husain](https://indiaknight.substack.com/p/me-and-my-desk-mishal-husain) _2026-08-06 · India Knight · Home_ writer and broadcasting queen ## [More Gooey-ness from GUIDs](https://connor-mcdonald.com/2026/08/05/more-gooey-ness-from-guids/) _2026-08-05 · Connor McDonald · Learning is not a spectator sport_ I wrote a post a few years back (well, actually it was 2018!) but I ll paraphrase briefly. There are two common schools of thought when it comes to automatic generation of values for a surrogate key in the Oracle database. The first one is using a SEQUENCE, referencing it either directly in your table definition/SQL, \[ \] ## [APEX Collections – Taking More Control](https://connor-mcdonald.com/2026/08/03/apex-collections-taking-more-control/) _2026-08-03 · Connor McDonald · Learning is not a spectator sport_ I posted recently about the usage of APEX collections, a generic structure in APEX that lets you easily store a set of results without having to create a table in advance. It s easy to use and useful but I think it may have fallen into overuse. Good friend Jon Dixon replied on my post saying \[ \] ## [Tabernacle Church – 1/8/26 am – The uncompromising Cross](https://www.tabporth.org/tabernacle-church-1-8-26-am-the-uncompromising-cross/) _2026-08-02 · Taberbacle Baptist Church Porth · Tabernacle Baptist Church Porth Audio Sermons_ Sermon from David Brookes 1 Corinthians 1:17 2/8/26 am – The uncompromising Cross Extract 37 All that the Father gives Me will come to Me, and the one who comes to Me I will \[a\]by no means cast out. Main Points The context The pull of culture The importance of the Cross [Listen](https://www.tabporth.org/wp-content/uploads/2026/08/sermon-2026-h-august-2-am.mp3) ## [Retro Grid Dungeon Crawler (Sponsored)](https://crawlproof.com/a/si87RXdvCETm) _2026-08-02 · **Sponsored**_ Retro grid movement with first-person combat, loot and skill-tree progression. ## [Weekend supplement](https://indiaknight.substack.com/p/weekend-supplement-a95) _2026-08-01 · India Knight · Home_ free edition! ## [3 Days at the Glastonbury of Water (Northumbrian Water Innovation Festival 2026)](https://podcast.ausha.co/dont-waste-water/3-days-at-the-glastonbury-of-water-northumbrian-water-innovation-festival-2026) _2026-08-01 · (don't) Waste Water! | Water Tech to Solve the World_ FREE TOOL ➡️ Get your water tech pitch reviewed: https://app.leviathandata.io/pitch-deck-analyzer More #water insights? Connect with me on Linkedin: https://www.linkedin.com/in/antoinewalter1/ See how the Northumbrian Water Innovation Festival brings together creative minds in Newcastle for collaborative problem solving. Watch the energy of this unique event. This episode takes you inside the… [Listen](https://audio.ausha.co/ykLXMIYV1MAO.mp3?t=1785527410) ## [Lucinda Chambers's picks for August](https://indiaknight.substack.com/p/lucinda-chamberss-picks-for-august-fb5) _2026-07-31 · India Knight · Home_ a hint of autumn ## [A Regency romance 🪭](https://indiaknight.substack.com/p/a-regency-romance) _2026-07-30 · India Knight · Home_ - free extract from Henrietta, 'an official Georgette Heyer novel' ## [Database Features – The Bullet Point Myth](https://connor-mcdonald.com/2026/07/30/database-features-the-bullet-point-myth/) _2026-07-30 · Connor McDonald · Learning is not a spectator sport_ I have a presentation that I ve given from time to time over the years and it s called the bullet point myth . The main thrust of the presentation is that if you look at a high enough level then all databases can be considered equal. At the highest and most generic levels, it s easy to claim \[ \] ## [Tremenheere Gardens, Cornwall](https://markboltonphoto.substack.com/p/tremenheere-gardens-cornwall) _2026-07-29 · The Garden Photographer · The Garden Photographer_ Art and Sculpture garden in Cornwall, with fabulous views of St Michael's Mount ## [The APEX\_COLLECTIONS crash puzzler…](https://connor-mcdonald.com/2026/07/28/the-apex_collections-crash-puzzler/) _2026-07-28 · Connor McDonald · Learning is not a spectator sport_ What would you do if everything in your environment looked perfectly fine, the data looked correct and yet every time you query a table, the query crashes with some sort of error? Yes, here I am back banging the drum about taking care with your data types 😊. In today s example I m going to show \[ \] ## [Tabernacle Sermons – 26/7/26 am – I will never cast out](https://www.tabporth.org/tabernacle-sermons-26-7-26-am-i-will-never-cast-out/) _2026-07-26 · Taberbacle Baptist Church Porth · Tabernacle Baptist Church Porth Audio Sermons_ Sermon from Rev RN Evans John 6:37 26/7/26 am – I will never cast ut Extract 37 All that the Father gives Me will come to Me, and the one who comes to Me I will \[a\]by no means cast out. Main Points I am No one Whoever comes [Listen](https://www.tabporth.org/wp-content/uploads/2026/07/sermon-2026-g-july-26-am.mp3) ## [Saturday morning](https://indiaknight.substack.com/p/saturday-morning) _2026-07-25 · India Knight · Home_ a temporary change of pace ## [Exeter University Botanic Gardens and Grounds, summer photography](https://markboltonphoto.substack.com/p/exeter-university-botanic-gardens) _2026-07-22 · The Garden Photographer · The Garden Photographer_ Wildlife, Architecture and the Polytechnic of Central London ## [World's cheapest GPUs, deployed fast (Sponsored)](https://crawlproof.com/a/FmqE9F0xrWlg) _2026-07-22 · **Sponsored**_ Deploy a live GPU-backed API in minutes for under $10 ## [Tabernacle Church – 19/7/26 pm – I saw Satan fall part 2](https://www.tabporth.org/tabernacle-church-19-7-26-pm-i-saw-satan-fall-part-2/) _2026-07-19 · Taberbacle Baptist Church Porth · Tabernacle Baptist Church Porth Audio Sermons_ Sermon from Rev RN Evans Luke 10:18 19/7/26 pm – I saw Satan fall part 2 Extract 18 And He said to them, “I saw Satan fall like lightning from heaven. Main Points Tyre at the judgement You were I cast you to the ground [Listen](https://www.tabporth.org/wp-content/uploads/2026/07/sermon-2026-g-july-19-pm.mp3) ## [Tabernacle Sermons – 19/7/26 am – Son of man part 3](https://www.tabporth.org/tabernacle-sermons-19-7-26-am-son-of-man-part-3/) _2026-07-19 · Taberbacle Baptist Church Porth · Tabernacle Baptist Church Porth Audio Sermons_ Sermon from Rev RN Evans John 6:53 19/7/26 am – Crown Him the Son of Man Part 3 Extract 53 Then Jesus said to them, “Most assuredly, I say to you, unless you eat the flesh of the Son of Man and drink His blood, you have no life in you. Main Points I am the bread of life No one Whoever [Listen](https://www.tabporth.org/wp-content/uploads/2026/07/sermon-2026-g-july-19-am.mp3) ## [Snail mail](https://indiaknight.substack.com/p/snail-mail) _2026-07-18 · India Knight · Home_ a stream of consciousness ## [Not the post I was expecting](https://connor-mcdonald.com/2026/07/16/not-the-post-i-was-expecting/) _2026-07-16 · Connor McDonald · Learning is not a spectator sport_ I m currently here in India for the Sangam conference, and I m always a fan of coming to India, because there is always an adventure. Coincidentally at breakfast this morning, I was telling one of the first-timer speakers that India is so good for repeat trips, because something is different every time. Now truth be told, \[ \] ## [The “best” tool](https://connor-mcdonald.com/2026/07/13/the-best-tool/) _2026-07-13 · Connor McDonald · Learning is not a spectator sport_ I had a question the other day that constantly pops up on my feed whether it s on social media or people asking Q A at a conference etc. And that question is What is the best tool I should be using for my database management and app development? And it s fair to say I generally get \[ \] ## [Tabernacle Church – 12/7/26 pm – I saw Satan fall](https://www.tabporth.org/tabernacle-church-12-7-26-pm-i-saw-satan-fall/) _2026-07-12 · Taberbacle Baptist Church Porth · Tabernacle Baptist Church Porth Audio Sermons_ Sermon from Rev RN Evans Luke 10:18 12/7/26 pm – I saw Satan fall Extract 18 And He said to them, “I saw Satan fall like lightning from heaven. Main Points Returning with joy Do not rejoice in this Rejoice because your names [Listen](https://www.tabporth.org/wp-content/uploads/2026/07/sermon-2026-g-july-12-pm.mp3) ## [Tabernacle Church – 12/7/26 am – Crown Him the Son of Man part 2](https://www.tabporth.org/tabernacle-church-12-7-26-am-crown-him-the-son-of-man-part-2/) _2026-07-12 · Taberbacle Baptist Church Porth · Tabernacle Baptist Church Porth Audio Sermons_ Sermon from Rev RN Evans John 6:62 12/7/26 am – Crown Him the Son of Man Part 2 Extract 62 What then if you should see the Son of Man ascend where He was before? Main Points The people complain What if you should see Where He was before [Listen](https://www.tabporth.org/wp-content/uploads/2026/07/sermon-2026-g-july-12-am.mp3) ## [Weekend supplement](https://indiaknight.substack.com/p/weekend-supplement-7d5) _2026-07-11 · India Knight · Home_ a few things I loved ## [Letting Nature In](https://markboltonphoto.substack.com/p/letting-nature-in) _2026-07-06 · The Garden Photographer · The Garden Photographer_ extract from my book 'A New Cottage Garden', published by Gemini Publishing 2024 ## [Tabernacle Church – 5/7/2026 pm – The vision of Paradise](https://www.tabporth.org/tabernacle-church-5-7-2026-pm-the-vision-of-paradise/) _2026-07-05 · Taberbacle Baptist Church Porth · Tabernacle Baptist Church Porth Audio Sermons_ Sermon from Rev RN Evans 2 Corinthians 12:4 5/7/26 pm – The vision of Paradise Extract 4 how he was caught up into Paradise and heard inexpressible words, which it is not lawful for a man to utter. Main Points Three times in New Testament The witness of Isaiah and Ezekiel Eye has not seen [Listen](https://www.tabporth.org/wp-content/uploads/2026/07/sermon-2026-g-july-5-pm.mp3) ## [Refer a Friend, Earn Rewards (Sponsored)](https://crawlproof.com/a/7rq4fBGhdmmD) _2026-07-05 · **Sponsored**_ Earn rewards when a friend signs up for the Graphite Business Card ## [Tabernacle Church – 5/7/2026 am – Crown Him the Son of Man](https://www.tabporth.org/tabernacle-church-5-7-2026-am-crown-him-the-son-of-man/) _2026-07-05 · Taberbacle Baptist Church Porth · Tabernacle Baptist Church Porth Audio Sermons_ Sermon from Rev RN Evans John 6:20 5/7/26 am – Crown Him the Son of Man Extract 27 Do not labour for the food which perishes, but for the food which endures to everlasting life, which the Son of Man will give you, because God the Father has set His seal on Him.” Main Points A favourite designation The Old Testament background God the Father’s seal [Listen](https://www.tabporth.org/wp-content/uploads/2026/07/sermon-2026-g-july-5-am.mp3) ## [Tip: Expanding a SQL statement](https://connor-mcdonald.com/2026/07/02/tip-expanding-a-sql-statement/) _2026-07-02 · Connor McDonald · Learning is not a spectator sport_ In all recent versions of the database you can call DBMS\_UTILITY.EXPAND\_SQL\_TEXT to get the true version of a SQL that the database will run. It takes your SQL as input and returns a CLOB, which means its all a bit fiddly if you have a SQL statement already sitting in your SQLcl/SQLPlus buffer. Using a \[ \] ## [WITH clause gets a 26ai boost!](https://connor-mcdonald.com/2026/07/01/with-clause-gets-a-26ai-boost/) _2026-07-01 · Connor McDonald · Learning is not a spectator sport_ By way of background, a while back I did video called My New Favourite Join on the LATERAL clause. The reason I like it is that it lets you solve a problem by composing little pieces together rather than writing one enormous query. Now this post is not about LATERAL, but I ll show a quick \[ \] ## [The Goldilocks problem – Materialized Views](https://connor-mcdonald.com/2026/06/30/the-goldilocks-problem-materialized-views/) _2026-06-30 · Connor McDonald · Learning is not a spectator sport_ I m sure you ve all heard the tale of Goldilocks and the Three Bears, but I d like to apply the Goldilocks principle to a database object-namely, a materialized view. You might be thinking, how does that apply to database objects when it comes to things like not too cold, not too hot, or not too heavy, \[ \] ## [Tabernacle Church – 28/6/2026 pm – Paul’s trip to the Third Heaven](https://www.tabporth.org/tabernacle-church-28-6-2026-pm-pauls-trip-to-the-third-heaven/) _2026-06-28 · Taberbacle Baptist Church Porth · Tabernacle Baptist Church Porth Audio Sermons_ Sermon from Rev RN Evans 2 Corinthians 12:2 28/6/26 pm – Paul’s trip to the third Heaven Extract 2 I know a man in Christ who fourteen years ago—whether in the body I do not know, or whether out of the body I do not know, God knows—such a one was caught up to the third heaven. Main Points Unclean and silenced lips The Holy of Holies and the High Priest Pointing forward to Revelation [Listen](https://www.tabporth.org/wp-content/uploads/2026/06/sermon-2026-f-june-28-pm.mp3) ## [Tabernacle Church – 28/6/2026 am – Jesus walking on the sea](https://www.tabporth.org/tabernacle-church-28-6-2026-am-jesus-walking-on-the-sea/) _2026-06-28 · Taberbacle Baptist Church Porth · Tabernacle Baptist Church Porth Audio Sermons_ Sermon from Rev RN Evans John 6:20 28/6/26 am – Jesus walking on the sea Extract 20 But He said to them, “It is I; do not be afraid.” Main Points Context is everything Contact with the Old Testament Content of Revelation [Listen](https://www.tabporth.org/wp-content/uploads/2026/06/sermon-2026-f-june-28-am.mp3) ## [Blue Sky Programming – The Optimism Trap](https://connor-mcdonald.com/2026/06/26/blue-sky-programming-the-optimism-trap/) _2026-06-26 · Connor McDonald · Learning is not a spectator sport_ Many years ago, before I joined Oracle, I was working on a major modernisation project. We were replacing an existing non-Oracle system with an entirely new Oracle database application written from scratch. Not long after deploying a new version into our test environment, the results came back and a large number of tests had failed. \[ \] ## [Rain](https://markboltonphoto.substack.com/p/rain) _2026-06-20 · The Garden Photographer · The Garden Photographer_ On garden photography in the rain ## [This one is for the 'shedfans' out there](https://markboltonphoto.substack.com/p/this-one-is-for-the-shedfans-out) _2026-06-16 · The Garden Photographer · The Garden Photographer_ An extract from my book 'A New Cottage Garden', published by Gemini and available now ## [Keeping your tech ego in check](https://connor-mcdonald.com/2026/06/08/keeping-your-tech-ego-in-check/) _2026-06-07 · Connor McDonald · Learning is not a spectator sport_ In my usual twitter doom scrolling, I came across this post the other day Now it s pretty obvious to me that this is one of the standard engagement bait posts that are commonplace nowadays. It s designed to polarize opinions and thus the resultant discussion becomes a lot more inflammatory and thus succeeds the goal of \[ \] ## [Magnificent May](https://markboltonphoto.substack.com/p/magnificent-may) _2026-06-03 · The Garden Photographer · The Garden Photographer_ and Elvis Costello ## [The Water VC You Can't Name (How HG Ventures Deployed $48,523,663 in Water Tech)](https://podcast.ausha.co/dont-waste-water/the-water-vc-you-can-t-name-how-hg-ventures-deployed-48-523-663-in-water-tech) _2026-06-03 · (don't) Waste Water! | Water Tech to Solve the World_ How did HG Ventures quietly become one of the most active water tech investors on the planet, without even calling itself a water VC? HG Ventures is the corporate venture capital arm of The Heritage Group, a 100-year-old, family-owned Indianapolis conglomerate active in asphalt, quarries, environmental services and specialty chemicals. With $350M in assets, the fund deploys around $50M a year… [Listen](https://audio.ausha.co/yJz5WCmNznEj.mp3?t=1780446906) ## [A New Cottage Garden on the radio](https://markboltonphoto.substack.com/p/a-new-cottage-garden-on-the-radio) _2026-06-02 · The Garden Photographer · The Garden Photographer_ Toby Buckland's show on BBC radio Devon on sunday ## [600 Private Water Bets - Zero Public Exits. Is This Sector About to Crack? (and will Gradiant IPO?)](https://podcast.ausha.co/dont-waste-water/600-private-water-bets-zero-public-exits-is-this-sector-about-to-crack-and-will-gradiant-ipo) _2026-05-28 · (don't) Waste Water! | Water Tech to Solve the World_ The First Water Sector Unicorn Wants to IPO. But Wall Street kinda forgot how to buy water... Early-stage water tech funding quadrupled in seven years. Private equity's share of water M&A doubled in a decade, with a record 165 PE-led acquisitions in a single year. The bench of PE-owned water platforms grew from 42 companies in 2015 to nearly 600 in 2025. And the sector just minted its first… [Listen](https://audio.ausha.co/bYYrmSj9xPej.mp3?t=1779986689) ## [First dabblings with APEXlang](https://connor-mcdonald.com/2026/05/27/first-dabblings-with-apexlang/) _2026-05-27 · Connor McDonald · Learning is not a spectator sport_ Obviously there are plenty of folks in the Oracle APEX team with waaaayy more experience in APEXlang than I have, so this isn t an in-depth expose into all of the nuts and bolts of APEXlang. For that, I recommend you check out the AskTOM Live sessions where the APEX team are holding regular deep-dives on \[ \] ## [WHAT IS A COTTAGE GARDEN?](https://markboltonphoto.substack.com/p/what-is-a-cottage-garden) _2026-05-22 · The Garden Photographer · The Garden Photographer_ An extract from my book 'A New Cottage Garden' published by Gemini Publishing ## [Chelsea Flower Show 2026](https://markboltonphoto.substack.com/p/chelsea-flower-show-2026) _2026-05-19 · The Garden Photographer · The Garden Photographer_ Gnomes, Stones and Automobiles ## [Vanishing objects; hello ORA-08103](https://connor-mcdonald.com/2026/05/13/vanishing-objects-hello-ora-08103/) _2026-05-13 · Connor McDonald · Learning is not a spectator sport_ In the previous post we saw that even though we had done an exchange partition mid-flights through a query execution, the query kept on running to successful completion. The database managed to find the data from the exchanged partition and keep on executing. The logical next question is is that always the case? What \[ \] ## [A very robust query](https://connor-mcdonald.com/2026/05/12/a-very-robust-query/) _2026-05-12 · Connor McDonald · Learning is not a spectator sport_ Some times I m blown away by how the database will try very hard to save you from yourself :-). Consider the following example: I ve got a table called T. It s got two columns, X and Y, and it s partitioned into four partitions, the values being based on X, 1, 2, 3 and 4 for the \[ \] ## [Mapperton Gardens, Dorset](https://markboltonphoto.substack.com/p/mapperton-gardens-dorset) _2026-05-11 · The Garden Photographer · The Garden Photographer_ Beautifully designed 1920's formal garden near Beaminster