# clause (blogs) — RSS Amplifier Recent posts from the 8 feeds in the RSS Amplifier directory that cover clause. Page: Feed: --- ## [Dissecting the Ontario Court of Appeal's decision on Bike Lanes and Section 7 of the Charter](https://emmettmacfarlane.substack.com/p/dissecting-the-ontario-court-of-appeals) _2026-08-17 · Emmett Macfarlane · Defending Canadian Democracy_ The Ontario Court of Appeal (ONCA) has overturned a trial court decision finding that the removal of bike lanes violated section 7 of the Charter and the right to life, liberty and security of the person. ## [Another Man In My Bed](https://stolenwives.substack.com/p/another-man-in-my-bed) _2026-08-17 · Maren Vale · Stolen Wives_ Cuckold // Cuck Angst // Explicit // Standalone Story ## [Second Chance Clause - A Hotwife Awakening - Part Four](https://stolenwives.substack.com/p/second-chance-clause-a-hotwife-awakening-5f1) _2026-08-13 · Maren Vale · Stolen Wives_ Part four of my upcoming Hotwife novella. Slow-burn, character driven, explicit. ## [Clean Me Up - A Cuck Angst Story](https://stolenwives.substack.com/p/clean-me-up-a-cuck-angst-story) _2026-08-10 · Maren Vale · Stolen Wives_ Cuckold // Explicit // Domestic // Cuck Angst // Cleanup ## [Ruin My Wife For A Night](https://stolenwives.substack.com/p/ruin-my-wife-for-a-night) _2026-08-07 · Maren Vale · Stolen Wives_ Cuckold/Hotwife Short Story // Standalone // Explicit // Threesome // Older Men ## [Second Chance Clause - A Hotwife Awakening - Part Three](https://stolenwives.substack.com/p/second-chance-clause-a-hotwife-awakening-146) _2026-08-05 · Maren Vale · Stolen Wives_ Part three of my upcoming Hotwife novella. Slow-burn, character driven, explicit. ## [Write Erotica With Me: Part 1 - Catching the Idea](https://stolenwives.substack.com/p/write-erotica-with-me-part-1-catching) _2026-08-03 · Maren Vale · Stolen Wives_ Join me in writing an erotic short story, step by step, behind the scenes ## [Second Chance Clause - A Hotwife Awakening - Part Two](https://stolenwives.substack.com/p/second-chance-clause-a-hotwife-awakening-dfd) _2026-07-30 · Maren Vale · Stolen Wives_ Part Two of my upcoming Hotwife novella. Slow-burn, character driven, explicit. ## [How I Wrote My Most Popular Erotic Story](https://stolenwives.substack.com/p/how-i-wrote-my-most-popular-erotic) _2026-07-28 · Maren Vale · Stolen Wives_ An essay on my writing process for erotica ## [My Wife Forgot I Was in the Hot Tub](https://stolenwives.substack.com/p/my-wife-forgot-i-was-in-the-hot-tub) _2026-07-27 · Maren Vale · Stolen Wives_ Cuckold Erotica // Age Gap // Voyeurism // Explicit ## [CLI-first decentralized GPU compute (Sponsored)](https://crawlproof.com/a/J8aAe9zZzvkI) _2026-07-27 · **Sponsored**_ Pay workers or run your GPU for FFmpeg transcode and AI inference. ## [Second Chance Clause - A Hotwife Awakening](https://stolenwives.substack.com/p/second-chance-clause-a-hotwife-awakening) _2026-07-21 · Maren Vale · Stolen Wives_ Part one of an upcoming novella ## [Mark Carney returns to grubby patronage and damages the renewed Senate](https://emmettmacfarlane.substack.com/p/mark-carney-returns-to-grubby-patronage) _2026-07-07 · Emmett Macfarlane · Defending Canadian Democracy_ In the Golden Age of Twitter, before it was bought up by a white supremacist oligarch and transformed into a wasteland of disinformation and hate, the Canadian politics nerds used to half-joke about how badly Canada needed The Economist Party. ## [The Number Founders Think Is Optional But Investors Treat As The Whole Decision.](https://susanjmontgomery.substack.com/p/the-number-founders-think-is-optional) _2026-07-06 · Susan | Angel Investor · Susan | Angel Investor_ Founders raise on story. Investors quietly reduce the entire pitch to one proof point they almost never say out loud. ## [Structured Primary Keys](https://modern-sql.com/blog/2026-06/structured-primary-keys) _2026-06-24 · Modern SQL_ Structured Primary Keys Sometimes I hit a wall when optimizing a client’s query. Over the years, I realized that most cases fall into two categories: (1) unreasonable expectations based on the cloud bill, not on the infrastructure’s power; (2) the primary key design. This article explains how primary keys can put tables into walled gardens so that the database schema falls apart into disconnected… ## [Five Signals I'm Reading While You're Still Talking](https://susanjmontgomery.substack.com/p/five-signals-im-reading-while-youre) _2026-06-23 · Susan | Angel Investor · Susan | Angel Investor_ Angel investing is more about pattern-matching than data, but what it pattern-matching, and how do you win? ## [There Is No Ideal Founding Team. Here Is What Angel Investors Actually Want.](https://susanjmontgomery.substack.com/p/there-is-no-ideal-founding-team-here) _2026-06-18 · Susan | Angel Investor · Susan | Angel Investor_ Somewhere in every accelerator there is a slide explaining that a startup needs a hacker, a hustler, and a hipster, a formulation that sounds like a sandwich order and predicts roughly as much. ## [The $400M Valuation That Cost the Founder Half the Company](https://susanjmontgomery.substack.com/p/the-400m-valuation-that-cost-the) _2026-06-16 · Susan | Angel Investor · Susan | Angel Investor_ It turns out you can lose your unicorn status. More than 220 companies discovered this year, having assumed a billion-dollar valuation was theirs to keep. ## [Bill C-34's Social Media Ban for under 16s is Unconstitutional](https://emmettmacfarlane.substack.com/p/bill-c-34s-social-media-ban-for-under) _2026-06-12 · Emmett Macfarlane · Defending Canadian Democracy_ Why the courts might, but shouldn't, permit it ## [AI's Phantom ARR](https://susanjmontgomery.substack.com/p/ais-phantom-arr) _2026-06-11 · Susan | Angel Investor · Susan | Angel Investor_ Why the recurring revenue in your AI business does not recur, and the one number that tells you before the cap table does ## [The $60M Exit Where the Founder Took Home $275,000](https://susanjmontgomery.substack.com/p/the-60m-exit-where-the-founder-took) _2026-06-09 · Susan | Angel Investor · Susan | Angel Investor_ A liquidation preference teardown, line by line, on the deal that looked like the win of the year and what you need to do to avoid the same fate. ## [Chovy's Blog: Agentic Coding (Sponsored)](https://crawlproof.com/a/5LpHavPG7yWk) _2026-06-09 · **Sponsored**_ Personal posts on agentic coding, moshcode CLI, and security findings. ## [The Pre-Payment Protocol: What I Check Before I Wire a Cent](https://susanjmontgomery.substack.com/p/pre-payment-protocol-what-angels-check-before-wiring) _2026-06-04 · Susan | Angel Investor · Susan | Angel Investor_ The diligence sequence I run on every deal before I will even agree to a conversation. Run those seven checks against your own pitch now. ## [Inside a $25k Angel Check: One Clause That Quietly Costs Founders 6x the Money.](https://susanjmontgomery.substack.com/p/the-25k-angel-clause-that-costs-founders-6x) _2026-06-02 · Susan | Angel Investor · Susan | Angel Investor_ This is what that one paragraph can do to a $1.5M raise. I am going to walk it forward, stage by stage, with and without the clause. ## [Take a Seat. The Diagnosis Won't Take Long.](https://susanjmontgomery.substack.com/p/take-a-seat-the-diagnosis-wont-take) _2026-05-28 · Susan | Angel Investor · Susan | Angel Investor_ 7 questions from my paid subscribers this quarter. Every one told me exactly where they were about to go wrong. ## [Inside a $2M seed term sheet I just closed and the three clauses that would have cost the founders $4M at exit.](https://susanjmontgomery.substack.com/p/seed-term-sheet-3-clauses-cost-founders-4m) _2026-05-26 · Susan | Angel Investor · Susan | Angel Investor_ What each one does, what it costs you, and how to push back. Open this next to your own term sheet. ## [A new book on the study of law and politics...](https://emmettmacfarlane.substack.com/p/a-new-book-on-the-study-of-law-and) _2026-05-25 · Emmett Macfarlane · Defending Canadian Democracy_ I was delighted to see my latest book, a collection of papers co-edited with my friend Kate Puddister, has been published by the University of Toronto Press. ## [ORDER BY Has Come a Long Way](https://modern-sql.com/blog/2026-05/order-by-history) _2026-05-14 · Modern SQL_ Order by Has Come a Long Way a Limited support in union , except and intersect legs b Expressions must not contain selected columns The order by clause is surely one of the best-known SQL clauses. Yet there are a number of common misunderstandings that are worth clearing up. For that, I’ll walk you through the evolution of the order by clause in ISO/IEC 9075-2:2023—that is, the SQL standard. The… ## [On debates about the Supreme Court, 'consistent' constitutional interpretation, and the notwithstanding clause](https://emmettmacfarlane.substack.com/p/on-debates-about-the-supreme-court) _2026-05-05 · Emmett Macfarlane · Defending Canadian Democracy_ Michael Plaxton has an excellent new post on the apparent whiplash-like oscillations in the Supreme Court of Canada when it comes to describing and applying an approach to constitutional interpretation. ## [The Supreme Court preserves parliamentary privilege, and constitutional coherence](https://emmettmacfarlane.substack.com/p/the-supreme-court-preserves-parliamentary) _2026-05-01 · Emmett Macfarlane · Defending Canadian Democracy_ Justice Rowe's reasons are a masterclass of precision and clarity ## [Order-Equivalent OVER Clauses](https://modern-sql.com/blog/2026-03/order-equivalence-over-clause) _2026-03-10 · Modern SQL_ Order-Equivalent Over Clauses a ⚡Order-equivalent over clause can produce different row orders b Apparently, the framing must be identical too to make over clauses order-equivalent At the heart of this article, there is a simple question: Will the following query always give the same numbering in both columns? SELECT ROW\_NUMBER() OVER (ORDER BY x) , ROW\_NUMBER() OVER (ORDER BY x) FROM ... I did… ## [Danielle Smith is no separatist; she's much, much worse](https://emmettmacfarlane.substack.com/p/danielle-smith-is-no-separatist-shes) _2026-02-20 · Emmett Macfarlane · Defending Canadian Democracy_ In a televised address last night Danielle Smith launched a xenophobic assault on immigration and proposed a set of referendum questions for next Fall advocating a constitutional agenda that would reduce Canada to a rump of pathetic, disaggregated fiefdoms. ## [Open-source Screen Sharing with Control (Sponsored)](https://crawlproof.com/a/y2gE85b0OwzD) _2026-02-20 · **Sponsored**_ WebRTC screen sharing with simultaneous mouse & keyboard control; viewers join in browser. ## [SQL Comments, Please!](https://modern-sql.com/caniuse/comments) _2026-02-10 · Modern SQL_ SQL Comments, Please! In a program, a comment is a part of the source code that is ignored by the system. Comments are generally used for two purposes: (1) provide background information for future readers of that code, including our selves; (2) deactivate some code without deleting it yet—aka. commenting out . SQL supports comments too, of course. While SQL comments are generally ignored by the… ## [Mark Carney must flatly reject Danielle Smith's latest round of anti-constitutional posturing](https://emmettmacfarlane.substack.com/p/mark-carney-must-flatly-reject-danielle) _2026-02-04 · Emmett Macfarlane · Defending Canadian Democracy_ Danielle Smith has threatened to withhold provincial funding for new judicial appointments unless the province gets more of a say in selecting judges. ## [Is the Supreme Court's Secession Reference Still Relevant?](https://emmettmacfarlane.substack.com/p/is-the-supreme-courts-secession-reference) _2026-01-21 · Emmett Macfarlane · Defending Canadian Democracy_ The media has been talking a lot about secession lately, with an organized separatist movement in Alberta (albeit with support that looks increasingly weak), and the spectre of a third Quebec vote possibly on the horizon (although support for independence remains relatively weak in Quebec as well, and the idea of another referendum even less popular ## [WITHOUT OVERLAPS Constraints](https://modern-sql.com/caniuse/without-overlaps-constraints) _2026-01-13 · Modern SQL_ Without Overlaps Constraints a Functionality available with exclusion constraints b Without keyword for : PERIOD FOR BUSINESS\_TIME (…) c Using the btree\_gist extension and a range: BUSINESS\_TIME tsrange GENERATED ALWAYS AS (tsrange(start\_ts, end\_ts)) STORED SQL supports temporal constraints that prevent rows with overlapping time ranges. These constraints are typically used to prevent double… ## [Is Canada morally leaderless?](https://emmettmacfarlane.substack.com/p/is-canada-is-morally-leaderless) _2026-01-12 · Emmett Macfarlane · Defending Canadian Democracy_ For anyone born in the 70s or 80s, it is abundantly clear we’re living in the most perilous period of our lifetimes. ## [2025: A Conlang Year in Review](https://www.quothalinguist.com/2025/12/31/2025-a-conlang-year-in-review/) _2026-01-01 · Jessie Peterson · Quothalinguist_ My goal going into 2025 was to complete the Conlang Year prompts as written—as written and on a daily basis. But I quickly “discovered” something I already knew about myself. It is difficult for me to stay motivated to work on the same project daily and to hold back on work when I have ideas \[…\] ## [Lexember 31 for Nómàk’óla](https://www.quothalinguist.com/2025/12/31/lexember-31-for-nomakola/) _2025-12-31 · Jessie Peterson · Quothalinguist_ Pénýsonačàòkvánàpáhèšỳmínuuttimiíltumo. “Let them bake for 30 minutes or until they brown.” Today was a fun one! I created a reflexive form of sóno “to bake” to use it intransitively in this clause. Paired with the imperative pé- and subject index marker -a, it translates to “let it/them bake”. The preposition čàò- means “near, around”, which \[…\] ## [Lexember 30 for Nómàk’óla](https://www.quothalinguist.com/2025/12/30/lexember-30-for-nomakola/) _2025-12-30 · Jessie Peterson · Quothalinguist_ Àŋósonàhúppétékwep’àỳvówekki. “Make small snips into the top of the pastry.” This clause uses the verb tékwe, a verb meaning “to snip” or “to make a small cut in”, with the core object being the thing that is snipped or cut into. For the core object, I needed to create a word meaning “pastry” and chose \[…\] ## [Lexember 29 for Nómàk’óla](https://www.quothalinguist.com/2025/12/29/lexember-29-for-nomakola/) _2025-12-29 · Jessie Peterson · Quothalinguist_ Àlúpéŋákkaìáákuŋktòŋmémfiwe. “Press and seal edge with a fork.” Today’s Lexember entry includes a few words already existing in the language, such as lú “edge” and ŋákka “to press” (yes, I see now that the little accent mark over the first “a” is missing in the image above!). I needed a verb meaning “to seal”, so \[…\] ## [Lexember 28 for Nómàk’óla](https://www.quothalinguist.com/2025/12/28/lexember-28-for-nomakola/) _2025-12-28 · Jessie Peterson · Quothalinguist_ Àwéspéžítsòŋósanỳjúnnepe. “Fold dough over mixture in a half moon shape.” Today’s Lexember entry starts with pieces already established in the language: core-object-marking à-, wése “dough”, imperative pé-, and žíte “to fold”. Following the verb is a new preposition, sò- “over, above”, which comes from the verb sóno “to cover”. Its object is ŋósahe “mixture”, a \[…\] ## [Lexember 27 for Nómàk’óla](https://www.quothalinguist.com/2025/12/27/lexember-27-for-nomakola/) _2025-12-27 · Jessie Peterson · Quothalinguist_ Àŋósahàsétipé’ássìŋóílsolsìjúnastòŋhóppi. “Spoon apple mixture onto half of a flattened circle of dough.” At first, I created the verb éssoppi, which is the verbal instrumental prefix attached to the nominal root hóppi “spoon”, to create a verb meaning “to spoon”, as in today’s bit of instruction. However, the more I thought about it, the more it \[…\] ## [Lexember 26 for Nómàk’óla](https://www.quothalinguist.com/2025/12/26/lexember-26-for-nomakola/) _2025-12-26 · Jessie Peterson · Quothalinguist_ Àŋóčuppéþólšúho. Àwéhàmválpéhálpàjúnmíse. “Sprinkle flour onto a surface. Roll a ball of dough into a thin disc.” In the first clause, I used the word úho, which means “top” but specifically a top of something standing that is more or less flat, like the top of a table or the back of a four-legged animal. In \[…\] ## [Lexember 25 for Nómàk’óla](https://www.quothalinguist.com/2025/12/25/lexember-25-for-nomakola/) _2025-12-25 · Jessie Peterson · Quothalinguist_ Àwéspékíkkamsìžíkife. “Divide dough into eighths.” I created the verb kíkkame meaning “to divide” or “to separate”, which is a compound of kíke (“to break”) and láme (“to pull”). The core object is the dough (wése), and then žíkife (“eight”) is treated as a nominal element functioning as a non-core object. ## [Lexember 24 for Nómàk’óla](https://www.quothalinguist.com/2025/12/24/lexember-24-for-nomakola/) _2025-12-24 · Jessie Peterson · Quothalinguist_ Àŋúsonàþáppéžísìtésysìvómuno. “Set the oven to (gas) mark 4.” \*\* Today’s Nómàk’óla entry more literally translates to “Set the oven heat to the fourth mark.” While I created a word for “stove” earlier this month, I hadn’t yet created a word for “oven”. I wanted them to be distinct because my nisse historically cooked food on \[…\] ## [Lexember 23 for Nómàk’óla](https://www.quothalinguist.com/2025/12/23/lexember-23-for-nomakola/) _2025-12-23 · Jessie Peterson · Quothalinguist_ Ànómispépéssèþáfe. Pépíllemaŋósahe. “Remove the skillet from heat, and let the mixture cool.” The first clause more literally translates as “move the skillet away from heat”. While all the pieces already existed in the language when I translated this today, I can’t quite remember if I had previously introduced the verb ése “to move”, and I \[…\] ## [Uniformly Random High-Degree Regular Graphs are Asymptotically Almost Surely Link-Irregular](https://jix.one/uniformly-random-high-degree-regular-graphs-are-asymptotically-almost-surely-link-irregular/) _2025-12-21 · jix.one_ A proof that uniformly random high-degree regular graphs are asymptotically almost surely link-irregular, providing another counterexample to a recent conjecture. ## [Adieu Apache Derby, Welcome DuckDB](https://modern-sql.com/blog/2025-12/derby-duckdb) _2025-12-16 · Modern SQL_ Adieu Apache Derby, Welcome DuckDB Apache Derby was once a popular system to mock an SQL-Engine during unit tests. A use-case that vanished by the ease of which “the real SQL systems” are available during development nowadays. Thus, the following note might be sad, but nor surprising: “ On 2025-10-10, the Derby developers voted to retire the project into a read-only state. Derby development and… ## [Reddit is a Browser](https://epic.law/reddit-is-a-browser/) _2025-11-29 · Sean Hogle · epiclaw_ California's recently-enacted "Opt Me Out" Act is intended to require developers of "browsers" to include opt-out signals that tell websites not to sell or share their data. But is the Act's definition broad enough to capture much more than browsers? The post Reddit is a Browser appeared first on epiclaw . ## [GROUP BY ALL](https://modern-sql.com/caniuse/group-by-all) _2025-11-04 · Modern SQL_ Group by All : Generate group by from select a Cannot mix aggregates with non-aggregated columns: a + count(\*) b Removes the group by all clause if it leads to an error that does not happen without group by clause Some Systems allow the special group by all syntax as a shorthand for grouping on all select items that do not have an aggregate function. SELECT customers.id, customers.name,… ## [Avoid New York Law on Force Majeure](https://epic.law/avoid-new-york-law-on-force-majeure/) _2025-09-16 · Sean Hogle · epiclaw_ New York law on force majeure is brutal for vendors and services providers. For better results, select California law instead. The post Avoid New York Law on Force Majeure appeared first on epiclaw .