<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Ejaz Arain</title>
    <description>The latest articles on DEV Community by Ejaz Arain (@ejazarain).</description>
    <link>https://dev.to/ejazarain</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4219227%2F0fc5f6d1-7f25-4213-b8a7-3399efdb908a.jpg</url>
      <title>DEV Community: Ejaz Arain</title>
      <link>https://dev.to/ejazarain</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/ejazarain"/>
    <language>en</language>
    <item>
      <title>Leaving Oracle: the licence is the easy part</title>
      <dc:creator>Ejaz Arain</dc:creator>
      <pubDate>Thu, 19 Nov 2026 15:12:31 +0000</pubDate>
      <link>https://dev.to/ejazarain/leaving-oracle-the-licence-is-the-easy-part-9ko</link>
      <guid>https://dev.to/ejazarain/leaving-oracle-the-licence-is-the-easy-part-9ko</guid>
      <description>&lt;p&gt;&lt;em&gt;First published on the &lt;a href="https://tech-style-co.blogspot.com/2026/11/leaving-oracle-licence-is-easy-part.html" rel="noopener noreferrer"&gt;Tech Style blog&lt;/a&gt;.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;Philip Marks wrote recently about the UK public sector and Oracle. A first look at procurement records, he said, found more than £7 million of Oracle Database related contract awards in 2026 alone, and that is only the contracts he could identify. His question was a fair one: how long can tight budgets keep paying for renewals when PostgreSQL has no licence fee at all?&lt;/p&gt;

&lt;p&gt;We agree with the direction. But in our experience the licence is the easy part of leaving. Here is where the lock-in really sits, and why we started building Paritas.&lt;/p&gt;

&lt;p&gt;  &lt;iframe src="https://www.youtube.com/embed/cbrdvDBCs2s" width="710" height="399"&gt;
  &lt;/iframe&gt;
&lt;/p&gt;

&lt;h2&gt;
  
  
  Where the lock-in sits
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;The contract.&lt;/strong&gt; Licences are usually priced by processor, with options and packs on top, and support renews every year as a share of what you paid. Move to new hardware or to a cloud and the licensing rules come with you. Every renewal is a negotiation you cannot walk away from, because the alternative is not ready.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;The code.&lt;/strong&gt; This is the big one. A long-lived Oracle estate holds years of PL/SQL: packages, triggers, collections, exception handlers, calls into &lt;code&gt;DBMS_&lt;/code&gt; and &lt;code&gt;UTL_&lt;/code&gt; packages that applications lean on without anyone remembering why. Nobody wants to rewrite it, and nobody can afford to stop the business while they do.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;The behaviour.&lt;/strong&gt; Even code that converts cleanly can answer differently. On Oracle, &lt;code&gt;SELECT 1 UNION SELECT 2 INTERSECT SELECT 2&lt;/code&gt; returns 2. On PostgreSQL it returns 1 and 2, because &lt;code&gt;INTERSECT&lt;/code&gt; binds tighter there. A &lt;code&gt;FOR i IN REVERSE 1 .. 3&lt;/code&gt; loop runs three times on Oracle and not at all on PostgreSQL. An empty string is NULL on Oracle and a value on PostgreSQL. None of these raises an error. They turn up later as wrong numbers.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;The people.&lt;/strong&gt; As Philip says, finding people who can migrate, architect and support a PostgreSQL estate is as hard as the technology. A team that has spent fifteen years in PL/SQL is an asset, and a migration that throws their knowledge away is a risk.&lt;/p&gt;

&lt;p&gt;Put together, this is why so many estates stay put. Not loyalty, and not the licence. The cost of being sure the new system gives the same answers.&lt;/p&gt;

&lt;h2&gt;
  
  
  What we are building
&lt;/h2&gt;

&lt;p&gt;Paritas is an Oracle-compatible database built on PostgreSQL. It runs in Oracle mode only, so your applications talk to it as they would to Oracle and real PL/SQL compiles and runs. Underneath, it is PostgreSQL, with PostgreSQL's tools, drivers and extensions, and no proprietary format to be locked into next.&lt;/p&gt;

&lt;p&gt;We do not claim it is a perfect copy of Oracle. Nobody honestly can. Our promise is narrower and, we think, more useful: we can tell you exactly where compatibility ends for your own code, with measured evidence. Every answer Paritas gives is checked against a real Oracle Database 21c. Where it differs, it goes on our list of limitations, which runs to more than 900 entries, each saying what happens and most saying what to do instead.&lt;/p&gt;

&lt;p&gt;Around Paritas we are building the tools a migration needs. pgrecon, our free assessment tool, is out today: it reads an Oracle schema and tells you what it contains before a migration is priced. Development tools and connectivity drivers are coming, and none of them is available yet. The enterprise layers we are working on power the PostgreSQL underneath Paritas, and they are being built so they can power plain PostgreSQL as well.&lt;/p&gt;

&lt;h2&gt;
  
  
  Leaving on your own terms
&lt;/h2&gt;

&lt;p&gt;The way out of lock-in is not a leap. It is knowing, before you commit, which of your code will behave the same, which will not, and what each difference costs to fix. That turns a renewal from a hostage negotiation into a choice.&lt;/p&gt;

&lt;p&gt;Paritas is in development and not for sale yet. We are aiming to release it next quarter. If you are weighing a move off Oracle, read more at tech-style.co/product-paritas, try pgrecon at tech-style.co/product-pgrecon, or write to us at tech-style.co/contact?topic=Paritas.&lt;/p&gt;

</description>
      <category>oracle</category>
      <category>postgres</category>
      <category>database</category>
      <category>sql</category>
    </item>
    <item>
      <title>A cast to five bytes and a two-character word</title>
      <dc:creator>Ejaz Arain</dc:creator>
      <pubDate>Fri, 13 Nov 2026 09:01:54 +0000</pubDate>
      <link>https://dev.to/ejazarain/a-cast-to-five-bytes-and-a-two-character-word-4il</link>
      <guid>https://dev.to/ejazarain/a-cast-to-five-bytes-and-a-two-character-word-4il</guid>
      <description>&lt;p&gt;&lt;em&gt;First published on the &lt;a href="https://tech-style-co.blogspot.com/2026/11/a-cast-to-five-bytes-and-two-character.html" rel="noopener noreferrer"&gt;Tech Style blog&lt;/a&gt;.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;&lt;code&gt;CAST('中文' AS VARCHAR2(5))&lt;/code&gt; asks for five bytes of a value that takes six. Each of the two characters is three bytes long in a UTF-8 database, so the fifth byte falls inside the second character. Oracle, PostgreSQL and Paritas each answer differently, and until this month Paritas had the worst answer of the three.&lt;/p&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Expression&lt;/th&gt;
&lt;th&gt;Oracle Database 21c&lt;/th&gt;
&lt;th&gt;PostgreSQL 18.6, nearest form&lt;/th&gt;
&lt;th&gt;Paritas&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;CAST('中文' AS VARCHAR2(5))&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;
&lt;code&gt;中&lt;/code&gt;, 3 bytes&lt;/td&gt;
&lt;td&gt;
&lt;code&gt;varchar(5)&lt;/code&gt;: &lt;code&gt;中文&lt;/code&gt;, 6 bytes&lt;/td&gt;
&lt;td&gt;
&lt;code&gt;中&lt;/code&gt;, 3 bytes&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;CAST('中文' AS VARCHAR2(2))&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;NULL&lt;/td&gt;
&lt;td&gt;
&lt;code&gt;varchar(2)&lt;/code&gt;: &lt;code&gt;中文&lt;/code&gt;, 6 bytes&lt;/td&gt;
&lt;td&gt;NULL&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;CAST('中文' AS CHAR(5))&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;
&lt;code&gt;中&lt;/code&gt;, 3 bytes&lt;/td&gt;
&lt;td&gt;
&lt;code&gt;char(5)&lt;/code&gt;: &lt;code&gt;中文&lt;/code&gt; and three blanks, 9 bytes&lt;/td&gt;
&lt;td&gt;
&lt;code&gt;中&lt;/code&gt; and two blanks, 5 bytes&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;PostgreSQL has no &lt;code&gt;VARCHAR2&lt;/code&gt; and no lengths in bytes. &lt;code&gt;varchar(5 byte)&lt;/code&gt; is a syntax error, and &lt;code&gt;varchar(n)&lt;/code&gt; counts characters, so a column converted from &lt;code&gt;VARCHAR2(5)&lt;/code&gt; to &lt;code&gt;varchar(5)&lt;/code&gt; can hold up to 20 bytes of UTF-8 where Oracle's held five.&lt;/p&gt;

&lt;h2&gt;
  
  
  What our build did
&lt;/h2&gt;

&lt;p&gt;Until 6 November a cast in Paritas cut at the fifth byte wherever that fell, so the value kept the first character and two bytes of the second. The cast itself raised nothing. An &lt;code&gt;INSERT&lt;/code&gt; stored the broken text, &lt;code&gt;LENGTH&lt;/code&gt; refused to read it, &lt;code&gt;pg_dump&lt;/code&gt; wrote it out and the restore lost the row.&lt;/p&gt;

&lt;p&gt;Oracle stops before the character the size would cut, and gives NULL when no whole character fits. Since 6 November 2026 both &lt;code&gt;VARCHAR2&lt;/code&gt; and &lt;code&gt;CHAR&lt;/code&gt; in Paritas do that. In UTF-8 the byte at the cut says where to stop, so a long value costs no walk from its beginning.&lt;/p&gt;

&lt;p&gt;The idea for the &lt;code&gt;VARCHAR2&lt;/code&gt; half came from a fix in the open-source base Paritas is built on. That version answers an empty string where Oracle answers NULL, and it leaves &lt;code&gt;CHAR&lt;/code&gt; as it was.&lt;/p&gt;

&lt;h2&gt;
  
  
  How it was measured
&lt;/h2&gt;

&lt;p&gt;The Oracle column is Oracle Database 21c. The regression test &lt;code&gt;ora_byte_cast&lt;/code&gt; holds 294 of its answers: seven strings of one- to four-byte characters, cast to &lt;code&gt;VARCHAR2&lt;/code&gt; and &lt;code&gt;CHAR&lt;/code&gt; at each size, by bytes, by the default and by characters, read back as &lt;code&gt;LENGTHB&lt;/code&gt;, &lt;code&gt;LENGTH&lt;/code&gt; and the value. Paritas runs the same 294 statements. On 6 November 2026, 274 of them matched.&lt;/p&gt;

&lt;p&gt;The PostgreSQL column is a stock PostgreSQL 18.6 with a UTF-8 database, run on 10 November 2026.&lt;/p&gt;

&lt;h2&gt;
  
  
  What is still different
&lt;/h2&gt;

&lt;p&gt;All 20 cells that differ are &lt;code&gt;CHAR&lt;/code&gt; casts that stopped short, and they differ in &lt;code&gt;LENGTHB&lt;/code&gt; and &lt;code&gt;LENGTH&lt;/code&gt; alone. Paritas pads such a value to its size, so &lt;code&gt;CAST('中文' AS CHAR(5))&lt;/code&gt; is the first character and two blanks. Oracle pads only when the value is stored in a &lt;code&gt;CHAR&lt;/code&gt; of that size or more, and leaves it short everywhere else. A stopped value and a padded one are therefore a single value to &lt;code&gt;DISTINCT&lt;/code&gt; in Paritas.&lt;/p&gt;

&lt;p&gt;&lt;code&gt;EUC_JP&lt;/code&gt; and &lt;code&gt;LATIN1&lt;/code&gt; follow the same rule in the tests, but we have no Oracle instance in those character sets, so nothing checks them against Oracle's own answers.&lt;/p&gt;

&lt;p&gt;Paritas is an Oracle-compatible database built on PostgreSQL, from Tech Style. It starts from an open-source base on PostgreSQL 18.6. We are building tools around it for migration, development and connecting applications. pgrecon, our free assessment tool, is out today, and the development tools and drivers are not available yet. Paritas is still in development and we are aiming to release it next quarter. More at &lt;a href="https://www.tech-style.co/product-paritas" rel="noopener noreferrer"&gt;tech-style.co/product-paritas&lt;/a&gt;.&lt;/p&gt;

</description>
      <category>postgres</category>
      <category>oracle</category>
      <category>database</category>
      <category>sql</category>
    </item>
    <item>
      <title>Ranking 58 electric cars on sourced facts only, and what the rules turned up</title>
      <dc:creator>Ejaz Arain</dc:creator>
      <pubDate>Fri, 13 Nov 2026 01:29:19 +0000</pubDate>
      <link>https://dev.to/ejazarain/ranking-58-electric-cars-on-sourced-facts-only-and-what-the-rules-turned-up-1k3p</link>
      <guid>https://dev.to/ejazarain/ranking-58-electric-cars-on-sourced-facts-only-and-what-the-rules-turned-up-1k3p</guid>
      <description>&lt;p&gt;Most car rankings start from a test drive or a reviewer's opinion. For the Q4 2026 edition of the TrustList rankings we tried something stricter: order electric and plug-in hybrid cars only on facts that can be sourced and dated. These are crash-test results from Euro NCAP, IIHS or NHTSA, plus what each maker states on its own pages for that market.&lt;/p&gt;

&lt;p&gt;This post covers the rules we used, and what they did to the results.&lt;/p&gt;

&lt;h2&gt;
  
  
  The rules
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;Fixed, public weights.&lt;/strong&gt; Safety 25, range 20, charging 15, software updates 15, battery warranty 10, driver assistance 10, app 5.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;A rank number needs evidence.&lt;/strong&gt; A car is ranked if it has a crash-test result or three sourced facts. Anything else is listed, not ranked.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Like with like.&lt;/strong&gt; Ranges are compared only on the same test cycle. A range with no named cycle is held but not compared.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Facts expire.&lt;/strong&gt; A fact read more than a year ago is not counted until it is read again.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Price is shown, never scored.&lt;/strong&gt; Nobody pays for a place.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;Each fact on the page carries the date it was read. For this edition that was 17 or 18 October 2026.&lt;/p&gt;

&lt;h2&gt;
  
  
  What the rules did
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;Coverage.&lt;/strong&gt; The UK electric ranking lists 58 cars and ranks 50. The UK plug-in hybrid ranking lists 13 and ranks 5. The Europe electric ranking lists 15 and ranks 12.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Safety barely separates the leaders.&lt;/strong&gt; All of the UK top 24 have a Euro NCAP result. Twenty-one have five stars and three have four (Kia EV3, Kia EV4, Cupra Raval). The heaviest weight, then, decides almost nothing at the top.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Missing fields decide a lot.&lt;/strong&gt; For 13 of the UK top 24 we hold nothing about software updates from the maker's UK pages. For 11 we hold nothing on battery warranty. Not one of the five ranked plug-in hybrids has software updates on record, and in Europe 10 of the 12 ranked cars have none. These are gaps in what the makers publish, not proof that a feature is missing. A sourced-facts model can only credit what is written down.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Rule 3 matters.&lt;/strong&gt; The longest WLTP range in the UK top 24 is the Volkswagen ID.7, at 697 km. It ranks 21st, because we hold nothing on its charging, software updates or driver assistance. The Cupra Born (624 km) and Cupra Raval (442 km) quote ranges with no named test cycle, so those figures are not compared with the WLTP ones.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Units are not always comparable.&lt;/strong&gt; Some makers publish a 10 to 80 percent charging time. Others give only a peak power, such as "up to 260 kW DC" for the Hyundai IONIQ 5. Among the cars that publish the time, the UK range runs from 18 minutes (Kia EV6, Genesis GV60) to 32 minutes (Toyota bZ4X).&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Rule 2 lets a car rank without a crash test.&lt;/strong&gt; The Toyota Prius Plug-in Hybrid is fifth among UK plug-in hybrids on three sourced facts: 85 km of WLTP electric range, a three-year battery warranty and its app. In Europe, the Leapmotor B03X, the Leapmotor T03 and the Rimac Nevera rank the same way.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Price stays out of the score.&lt;/strong&gt; The UK number one, the Polestar 3, starts at £76,540. The Kia EV3 is seventh from £31,555. The Cupra Raval, 24th, is the cheapest of the top 24 at £25,495 with the Electric Car Grant applied.&lt;/p&gt;

&lt;h2&gt;
  
  
  What we would change
&lt;/h2&gt;

&lt;p&gt;The biggest weakness of the model is visible above. A maker that publishes less ranks lower, whatever the car is like. We think that is the right incentive for a buyer reading makers' pages. But it means the ranking measures disclosure as much as the car. The next edition is due in January 2027, and every gap listed here can be closed by a dated page from the maker.&lt;/p&gt;

&lt;p&gt;The rankings, with each fact and its read date:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://trustlist.uk/best/electric-cars/united-kingdom" rel="noopener noreferrer"&gt;https://trustlist.uk/best/electric-cars/united-kingdom&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://trustlist.uk/best/plug-in-hybrid-cars/united-kingdom" rel="noopener noreferrer"&gt;https://trustlist.uk/best/plug-in-hybrid-cars/united-kingdom&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://trustlist.uk/best/electric-cars/europe" rel="noopener noreferrer"&gt;https://trustlist.uk/best/electric-cars/europe&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;Method: &lt;a href="https://trustlist.uk/trust" rel="noopener noreferrer"&gt;https://trustlist.uk/trust&lt;/a&gt;
&lt;/li&gt;
&lt;/ul&gt;

</description>
      <category>datascience</category>
      <category>opendata</category>
      <category>electricvehicles</category>
      <category>data</category>
    </item>
    <item>
      <title>Publishing to several social networks with one API call, shown with a real response</title>
      <dc:creator>Ejaz Arain</dc:creator>
      <pubDate>Tue, 10 Nov 2026 07:52:58 +0000</pubDate>
      <link>https://dev.to/ejazarain/publishing-to-several-social-networks-with-one-api-call-shown-with-a-real-response-3kpi</link>
      <guid>https://dev.to/ejazarain/publishing-to-several-social-networks-with-one-api-call-shown-with-a-real-response-3kpi</guid>
      <description>&lt;p&gt;&lt;em&gt;First published on &lt;a href="https://rutba.io/blog/publishing-once-to-several-networks-with-a-real-response" rel="noopener noreferrer"&gt;rutba.io&lt;/a&gt;.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F5f8tthtnv6cnyxmed7cx.jpg" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F5f8tthtnv6cnyxmed7cx.jpg" alt="A diagram: one post fanning out to Bluesky, Mastodon, Telegram, Discord and WordPress, with one result recorded for each account." width="800" height="420"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Rutba Relay takes one post and a list of accounts, adapts the post to each network, publishes in the background and reports a separate result for every account. This article shows a real request and response from that API, lists what a customer can publish to today, and compares it with Ayrshare and Hootsuite, whose pricing and documentation we read on 10 November 2026.&lt;/p&gt;

&lt;h2&gt;
  
  
  What a customer can publish to today
&lt;/h2&gt;

&lt;p&gt;The catalogue at &lt;code&gt;GET /v1/platforms&lt;/code&gt; lists 55 destinations, and Relay has an adapter for 18 of them. Five are open to any customer now, and a sixth is a test destination that reaches no network at all.&lt;/p&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Destination&lt;/th&gt;
&lt;th&gt;How you connect it&lt;/th&gt;
&lt;th&gt;What the adapter allows&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Bluesky&lt;/td&gt;
&lt;td&gt;Handle and app password&lt;/td&gt;
&lt;td&gt;300 characters, up to 4 images of 0.9 MB&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Discord&lt;/td&gt;
&lt;td&gt;Incoming webhook URL&lt;/td&gt;
&lt;td&gt;2,000 characters, up to 10 images or videos of 10 MB&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Mastodon&lt;/td&gt;
&lt;td&gt;Sign-in on your own instance&lt;/td&gt;
&lt;td&gt;500 characters, up to 4 images, or 1 video of 40 MB&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Telegram&lt;/td&gt;
&lt;td&gt;Channel name. Use our bot or your own, and make it an admin of the channel&lt;/td&gt;
&lt;td&gt;4,096 characters, up to 10 images of 10 MB or videos of 50 MB&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;WordPress&lt;/td&gt;
&lt;td&gt;Self-hosted site URL, username and application password&lt;/td&gt;
&lt;td&gt;No practical text limit, up to 10 images, native tags&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Sandbox&lt;/td&gt;
&lt;td&gt;Nothing to set up&lt;/td&gt;
&lt;td&gt;For test suites. No network is contacted&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;&lt;em&gt;Read from the live catalogue on 10 November 2026.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;The other twelve adapters are written. Five of those networks can be connected within the limits each one sets until it has reviewed our app, and those limits decide whether a customer can use them. The other seven cannot be connected yet.&lt;/p&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Network&lt;/th&gt;
&lt;th&gt;State on 10 November&lt;/th&gt;
&lt;th&gt;What that means for a customer&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Facebook Pages, Instagram, Threads&lt;/td&gt;
&lt;td&gt;Connectable within Meta's limits. Our app stays in Development mode until Meta's review is done&lt;/td&gt;
&lt;td&gt;Only people with a role on our app can connect, so customers cannot use these yet&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;TikTok&lt;/td&gt;
&lt;td&gt;Connectable within TikTok's limits while it reviews our app, on its sandbox keys&lt;/td&gt;
&lt;td&gt;Only named test accounts can connect, and posts stay private to the creator&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;YouTube&lt;/td&gt;
&lt;td&gt;Connectable within Google's limits. Google has verified our app's data access, and its separate YouTube API audit has not passed yet&lt;/td&gt;
&lt;td&gt;Every upload is forced private until that audit passes, so it is no use for publishing yet&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;LinkedIn, Pinterest, Reddit, Slack&lt;/td&gt;
&lt;td&gt;No app registered yet&lt;/td&gt;
&lt;td&gt;Cannot be connected&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Google Business Profile, Snapchat&lt;/td&gt;
&lt;td&gt;Each opens this API by request, and we do not have access yet&lt;/td&gt;
&lt;td&gt;Cannot be connected&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;X&lt;/td&gt;
&lt;td&gt;No app registered. X charges per request, so it will be sold against prepaid credit, and that is not in place&lt;/td&gt;
&lt;td&gt;Cannot be connected&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;blockquote&gt;
&lt;p&gt;&lt;strong&gt;If you build a picker from the catalogue&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;&lt;code&gt;available: true&lt;/code&gt; means this deployment holds the keys for that network's app. Facebook reports &lt;code&gt;true&lt;/code&gt; before Meta's review has finished, so read &lt;code&gt;integration_status&lt;/code&gt; as well. &lt;code&gt;gated&lt;/code&gt; means the network's own review still applies, and &lt;code&gt;note&lt;/code&gt; says what it restricts.&lt;/p&gt;

&lt;p&gt;On the Agency plan an organisation can register its own app with a network through &lt;code&gt;/v1/org/platform-apps&lt;/code&gt;, and connections then use that app in place of ours. Our test suite covers that route with an invented Facebook app. It has not been proven with a customer's approved app, so talk to us before planning around it.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;h2&gt;
  
  
  The run behind the examples
&lt;/h2&gt;

&lt;p&gt;The requests and responses below come from one run on 10 November 2026: the Relay gate, its delivery worker and the public API door, running on a development machine and called with an API key. Every publish went to Sandbox accounts, so no social network was contacted. The previews used the real rules for Bluesky and Mastodon, with connection rows we inserted for the run, because a preview only adapts the post and never reaches a network.&lt;/p&gt;

&lt;p&gt;The ids are the ones that run produced, and the responses are trimmed to the fields that matter. On the hosted service the base URL is &lt;code&gt;https://api.relay.rutba.io&lt;/code&gt; and live keys begin &lt;code&gt;rsk_live_&lt;/code&gt;.&lt;/p&gt;

&lt;p&gt;The free plan includes API keys and one webhook endpoint. Its keys reach the Sandbox only, so you can build against the Sandbox accounts used below without paying. The stated allowance is 500 Sandbox calls a month, and the plan's limit of 30 posts a month counts Sandbox posts too, so a test suite that publishes often will reach that first. A free key that targets a live network is refused at the request with a &lt;code&gt;payment_required&lt;/code&gt; error naming the networks, before anything is queued.&lt;/p&gt;

&lt;p&gt;Publishing to a live network through the API needs the Agency plan; its current price is on the &lt;a href="https://rutba.io/services/social" rel="noopener noreferrer"&gt;Rutba Social page&lt;/a&gt;. Agency is sold there by written quote today rather than self-serve checkout. Once a workspace is on it, the API key works immediately.&lt;/p&gt;

&lt;h2&gt;
  
  
  Connect an account
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;curl -X POST https://api.relay.rutba.io/v1/connections \
  -H &lt;span class="s2"&gt;"Authorization: Bearer $RELAY_API_KEY"&lt;/span&gt; \
  -H &lt;span class="s2"&gt;"content-type: application/json"&lt;/span&gt; \
  -d &lt;span class="s1"&gt;'{ "platform": "sandbox", "fields": { "handle": "@first-account" } }'&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;





&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="nl"&gt;"data"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="nl"&gt;"id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"u0czr5buhlftcszrxuik6ant"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="nl"&gt;"platform"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"sandbox"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="nl"&gt;"handle"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"@first-account"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="nl"&gt;"display_name"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"Sandbox account"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="nl"&gt;"status"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"active"&lt;/span&gt;
  &lt;span class="p"&gt;}&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Bluesky, Discord, Telegram and WordPress connect through this same call, each with its own &lt;code&gt;fields&lt;/code&gt;, which the catalogue lists per network. Mastodon goes through a sign-in on your own instance. For an account that belongs to somebody else, &lt;code&gt;POST /v1/connect-sessions&lt;/code&gt; makes a hosted link they can open themselves.&lt;/p&gt;

&lt;h2&gt;
  
  
  See what each network will get
&lt;/h2&gt;

&lt;p&gt;A preview runs the same adaptation the publisher runs and writes nothing. This post is 372 characters long, which suits Mastodon and does not suit Bluesky.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;curl -X POST https://api.relay.rutba.io/v1/posts/preview \
  -H &lt;span class="s2"&gt;"Authorization: Bearer $RELAY_API_KEY"&lt;/span&gt; \
  -H &lt;span class="s2"&gt;"content-type: application/json"&lt;/span&gt; \
  -d &lt;span class="s1"&gt;'{
    "content": { "text": "Version 4 of our invoicing app is out today. Recurring invoices can now be paused for a month without losing the schedule, statements export to CSV as well as PDF, and the slow customer search on accounts with more than 20,000 rows is fixed. The full list of changes is on the changelog, and the upgrade is automatic for every hosted account, so nobody has to do anything." },
    "connection_ids": ["vg8ubpzn43y38uqxpki8wr3u", "qeiby35tu44xz6t0kjjt9adf"]
  }'&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Bluesky's part of the 200 response:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="nl"&gt;"connection_id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"vg8ubpzn43y38uqxpki8wr3u"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nl"&gt;"platform"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"bluesky"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nl"&gt;"handle"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"yourbrand.bsky.social"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nl"&gt;"connection_status"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"active"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nl"&gt;"text"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"Version 4 of our invoicing app is out today. Recurring invoices can now be paused for a month without losing the schedule, statements export to CSV as well as PDF, and the slow customer search on accounts with more than 20,000 rows is fixed. The full list of changes is on the changelog, and the…"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nl"&gt;"warnings"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;
    &lt;span class="p"&gt;{&lt;/span&gt;
      &lt;span class="nl"&gt;"code"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"too_long"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
      &lt;span class="nl"&gt;"field"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"text"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
      &lt;span class="nl"&gt;"message"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"Bluesky allows 300 characters, got 372"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
      &lt;span class="nl"&gt;"fixable"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="kc"&gt;true&lt;/span&gt;
    &lt;span class="p"&gt;}&lt;/span&gt;
  &lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nl"&gt;"blocking"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nl"&gt;"publishable"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="kc"&gt;true&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;The text was cut at a word boundary to 296 characters, and the warning says why. Mastodon's copy came back whole at 372 with no warnings. Send &lt;code&gt;"validation": "strict"&lt;/code&gt; and nothing is adapted: in the same run Bluesky came back with &lt;code&gt;"publishable": false&lt;/code&gt; and a &lt;code&gt;too_long&lt;/code&gt; entry under &lt;code&gt;blocking&lt;/code&gt;, and Mastodon stayed publishable.&lt;/p&gt;

&lt;p&gt;On Bluesky, Mastodon, Telegram and Discord, Relay puts the link and hashtags in the body, so they count towards the limit. In lenient mode it shortens your words to make room and leaves the link and every hashtag whole. Given the same 372 characters with a link and two tags, the Bluesky rules cut the words to 246 characters and the post came to 297. The 192-character post in the next step comes to 243 with that link and those tags.&lt;/p&gt;

&lt;h2&gt;
  
  
  Publish to several accounts at once
&lt;/h2&gt;

&lt;p&gt;One request, with an &lt;code&gt;Idempotency-Key&lt;/code&gt; so that a retry cannot post twice. The third target uses a Sandbox override that asks for a refusal, so the response shows what a failure looks like.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;curl -X POST https://api.relay.rutba.io/v1/posts \
  -H &lt;span class="s2"&gt;"Authorization: Bearer $RELAY_API_KEY"&lt;/span&gt; \
  -H &lt;span class="s2"&gt;"Idempotency-Key: release-4-announcement"&lt;/span&gt; \
  -H &lt;span class="s2"&gt;"content-type: application/json"&lt;/span&gt; \
  -d &lt;span class="s1"&gt;'{
    "content": {
      "text": "Version 4 of our invoicing app is out today. Recurring invoices can now be paused for a month, statements export to CSV as well as PDF, and the slow customer search on large accounts is fixed.",
      "link": "https://example.com/changelog/4",
      "tags": ["changelog", "saas"]
    },
    "targets": [
      { "connection_id": "u0czr5buhlftcszrxuik6ant" },
      { "connection_id": "dlhdpjmr5jr8wkbpxf1vg5q3" },
      { "connection_id": "rzesyqu5iao9x44oxbodhogm",
        "overrides": { "outcome": "content_rejected" } }
    ]
  }'&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;The answer is a 202, trimmed here to the post and its deliveries:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="nl"&gt;"data"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="nl"&gt;"id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"gsvpcm1j1n4jerme5kxrmej7"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="nl"&gt;"status"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"queued"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="nl"&gt;"source"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"api"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="nl"&gt;"deliveries"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;
      &lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="nl"&gt;"id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"tkcmunic8f9vgbkun4lz42gt"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nl"&gt;"platform"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"sandbox"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"connection_id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"u0czr5buhlftcszrxuik6ant"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nl"&gt;"status"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"pending"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nl"&gt;"attempts"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mi"&gt;0&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
      &lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="nl"&gt;"id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"pmjmr51qfyj9pmzsx5xliv0x"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nl"&gt;"platform"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"sandbox"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"connection_id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"dlhdpjmr5jr8wkbpxf1vg5q3"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nl"&gt;"status"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"pending"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nl"&gt;"attempts"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mi"&gt;0&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
      &lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="nl"&gt;"id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"oliszvo4p9bah2ouekd75dn8"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nl"&gt;"platform"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"sandbox"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"connection_id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"rzesyqu5iao9x44oxbodhogm"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nl"&gt;"status"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"pending"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nl"&gt;"attempts"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mi"&gt;0&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt;
    &lt;span class="p"&gt;]&lt;/span&gt;
  &lt;span class="p"&gt;}&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;No network has been contacted at this point. The API has written one post and one delivery per target, and each delivery is queued on its own, so the call returns quickly however many accounts it names and a slow network cannot hold up the others.&lt;/p&gt;

&lt;p&gt;Replace &lt;code&gt;targets&lt;/code&gt; with &lt;code&gt;"platforms": ["bluesky", "mastodon", "telegram"]&lt;/code&gt; to reach every active account on those networks. If one of them has no active connection, the request is refused with a 409 and &lt;code&gt;connection_unavailable&lt;/code&gt;. Add &lt;code&gt;scheduled_at&lt;/code&gt; and &lt;code&gt;timezone&lt;/code&gt; to send the post later.&lt;/p&gt;

&lt;h2&gt;
  
  
  Read the result
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;curl https://api.relay.rutba.io/v1/posts/gsvpcm1j1n4jerme5kxrmej7 \
  -H &lt;span class="s2"&gt;"Authorization: Bearer $RELAY_API_KEY"&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;





&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="nl"&gt;"data"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="nl"&gt;"id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"gsvpcm1j1n4jerme5kxrmej7"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="nl"&gt;"status"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"partial"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="nl"&gt;"published_at"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"2026-11-10T04:29:10.419Z"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="nl"&gt;"deliveries"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;
      &lt;span class="p"&gt;{&lt;/span&gt;
        &lt;span class="nl"&gt;"id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"tkcmunic8f9vgbkun4lz42gt"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"platform"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"sandbox"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"status"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"succeeded"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"attempts"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"remote_id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"sbx_d4c45fa83f129e36b5c0f119"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"remote_url"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"https://sandbox.rutba.io/p/sbx_d4c45fa83f129e36b5c0f119"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"error"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="kc"&gt;null&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"error_code"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="kc"&gt;null&lt;/span&gt;
      &lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
      &lt;span class="p"&gt;{&lt;/span&gt;
        &lt;span class="nl"&gt;"id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"pmjmr51qfyj9pmzsx5xliv0x"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"platform"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"sandbox"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"status"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"succeeded"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"attempts"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"remote_id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"sbx_f490bd67448b7d2ddee4b8ba"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"remote_url"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"https://sandbox.rutba.io/p/sbx_f490bd67448b7d2ddee4b8ba"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"error"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="kc"&gt;null&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"error_code"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="kc"&gt;null&lt;/span&gt;
      &lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
      &lt;span class="p"&gt;{&lt;/span&gt;
        &lt;span class="nl"&gt;"id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"oliszvo4p9bah2ouekd75dn8"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"platform"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"sandbox"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"status"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"rejected"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"attempts"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"remote_id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="kc"&gt;null&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"remote_url"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="kc"&gt;null&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"error"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"Sandbox: the post was refused on request"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"error_code"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"content_rejected"&lt;/span&gt;
      &lt;span class="p"&gt;}&lt;/span&gt;
    &lt;span class="p"&gt;]&lt;/span&gt;
  &lt;span class="p"&gt;}&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Two accounts took the post and one refused it, so the post as a whole is &lt;code&gt;partial&lt;/code&gt;. The refused delivery shows one attempt, because a refusal is final. Rate limits and outages are retried, each delivery on its own budget. &lt;code&gt;GET /v1/deliveries?post_id=…&lt;/code&gt; returns the same rows with filters and a cursor, and &lt;code&gt;POST /v1/deliveries/{id}/retry&lt;/code&gt; sends one destination again, which Relay refuses for a delivery the network has rejected.&lt;/p&gt;

&lt;h2&gt;
  
  
  Send it twice on purpose
&lt;/h2&gt;

&lt;p&gt;A timeout leaves you not knowing whether the post went out, so the safe move is to send the same request again. With the same &lt;code&gt;Idempotency-Key&lt;/code&gt; and body, the run returned the original post id and a response header of &lt;code&gt;idempotent-replay: true&lt;/code&gt;. Keys are remembered for 24 hours. The same key with a different body is refused with a 409:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="nl"&gt;"error"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="nl"&gt;"code"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"idempotency_conflict"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="nl"&gt;"message"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"Idempotency-Key \"release-4-announcement\" was already used with a different request body"&lt;/span&gt;
  &lt;span class="p"&gt;}&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  Hear about it by webhook
&lt;/h2&gt;

&lt;p&gt;This post produced five events at the test receiver: &lt;code&gt;post.created&lt;/code&gt;, &lt;code&gt;delivery.failed&lt;/code&gt;, &lt;code&gt;delivery.succeeded&lt;/code&gt; twice and &lt;code&gt;post.partial&lt;/code&gt;. Do not build on their order. In an earlier run the same day, &lt;code&gt;post.partial&lt;/code&gt; arrived before the second &lt;code&gt;delivery.succeeded&lt;/code&gt;.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="nl"&gt;"id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"evt_cw8G-dyyQXy0ZPA2"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nl"&gt;"type"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"post.partial"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nl"&gt;"created_at"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"2026-11-10T04:29:10.460Z"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nl"&gt;"data"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="nl"&gt;"post_id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"gsvpcm1j1n4jerme5kxrmej7"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="nl"&gt;"status"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"partial"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="nl"&gt;"succeeded"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mi"&gt;2&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="nl"&gt;"failed"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="nl"&gt;"external_id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="kc"&gt;null&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="nl"&gt;"deliveries"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;
      &lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="nl"&gt;"id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"tkcmunic8f9vgbkun4lz42gt"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nl"&gt;"platform"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"sandbox"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nl"&gt;"status"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"succeeded"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"remote_url"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"https://sandbox.rutba.io/p/sbx_d4c45fa83f129e36b5c0f119"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"error"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="kc"&gt;null&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nl"&gt;"error_code"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="kc"&gt;null&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
      &lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="nl"&gt;"id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"pmjmr51qfyj9pmzsx5xliv0x"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nl"&gt;"platform"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"sandbox"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nl"&gt;"status"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"succeeded"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"remote_url"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"https://sandbox.rutba.io/p/sbx_f490bd67448b7d2ddee4b8ba"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"error"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="kc"&gt;null&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nl"&gt;"error_code"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="kc"&gt;null&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
      &lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="nl"&gt;"id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"oliszvo4p9bah2ouekd75dn8"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nl"&gt;"platform"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"sandbox"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nl"&gt;"status"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"rejected"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"remote_url"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="kc"&gt;null&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="nl"&gt;"error"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"Sandbox: the post was refused on request"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nl"&gt;"error_code"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"content_rejected"&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt;
    &lt;span class="p"&gt;]&lt;/span&gt;
  &lt;span class="p"&gt;}&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Each request carries &lt;code&gt;x-relay-signature: t=&amp;lt;unix seconds&amp;gt;,v1=&amp;lt;hex&amp;gt;&lt;/code&gt;, an HMAC-SHA256 of the timestamp and the raw body joined by a full stop. A retry of the same event keeps the same &lt;code&gt;x-relay-delivery&lt;/code&gt; id, so you can deduplicate on it.&lt;/p&gt;

&lt;h2&gt;
  
  
  Against Ayrshare and Hootsuite
&lt;/h2&gt;

&lt;p&gt;Start with what counts against us. Ayrshare and Hootsuite already publish to Instagram, TikTok and LinkedIn for their customers, and Relay cannot yet. If one of those networks is the reason for your integration, that settles it for now.&lt;/p&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;&lt;/th&gt;
&lt;th&gt;Rutba Relay&lt;/th&gt;
&lt;th&gt;Ayrshare&lt;/th&gt;
&lt;th&gt;Hootsuite&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;What it is&lt;/td&gt;
&lt;td&gt;A publishing API with a web console on the same routes&lt;/td&gt;
&lt;td&gt;A publishing API for developers, with a light dashboard&lt;/td&gt;
&lt;td&gt;A social media management suite, with a REST API beside it&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Lowest listed price with the API&lt;/td&gt;
&lt;td&gt;Free for the Sandbox only, up to 30 posts a month. For live networks, the Agency plan (its current price on &lt;a href="https://rutba.io/services/social" rel="noopener noreferrer"&gt;https://rutba.io/services/social&lt;/a&gt;), by written quote, no cap on accounts or seats&lt;/td&gt;
&lt;td&gt;$149 a month (Premium), one profile with up to 14 accounts&lt;/td&gt;
&lt;td&gt;Its plans page does not say which plans include the API. Standard starts at $99 per user a month on annual billing, with 10 accounts&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Growing&lt;/td&gt;
&lt;td&gt;Agency has no account or seat cap&lt;/td&gt;
&lt;td&gt;$299 a month for up to 10 profiles, $599 for 30, then a per-profile rate&lt;/td&gt;
&lt;td&gt;Professional starts at $199 per user a month, with unlimited accounts&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Trying it&lt;/td&gt;
&lt;td&gt;A free plan with the console, and API keys that reach the Sandbox only&lt;/td&gt;
&lt;td&gt;A 28-day trial on Launch, no free plan&lt;/td&gt;
&lt;td&gt;A 14-day trial&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Open to customers today&lt;/td&gt;
&lt;td&gt;Bluesky, Discord, Mastodon, Telegram, WordPress&lt;/td&gt;
&lt;td&gt;Bluesky, Facebook, Google Business, Instagram, LinkedIn, Pinterest, Reddit, Snapchat, Telegram, Threads, TikTok, X, YouTube&lt;/td&gt;
&lt;td&gt;Instagram, TikTok, LinkedIn and the other large networks, plus Bluesky&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;The call&lt;/td&gt;
&lt;td&gt;
&lt;code&gt;POST /v1/posts&lt;/code&gt; answers 202, then one delivery per account&lt;/td&gt;
&lt;td&gt;
&lt;code&gt;POST /api/post&lt;/code&gt; returns a &lt;code&gt;postIds&lt;/code&gt; entry per platform&lt;/td&gt;
&lt;td&gt;
&lt;code&gt;POST /v1/messages&lt;/code&gt; takes &lt;code&gt;socialProfileIds&lt;/code&gt; and a send time at least five minutes ahead&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Test destination&lt;/td&gt;
&lt;td&gt;Sandbox accounts that refuse, rate-limit or lose a response on request&lt;/td&gt;
&lt;td&gt;Parameters such as &lt;code&gt;randomPost&lt;/code&gt; for test content. We found no separate sandbox in its docs&lt;/td&gt;
&lt;td&gt;None in the guides we read&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Repeated requests&lt;/td&gt;
&lt;td&gt;
&lt;code&gt;Idempotency-Key&lt;/code&gt;, kept for 24 hours, replays the first answer&lt;/td&gt;
&lt;td&gt;Optional &lt;code&gt;idempotencyKey&lt;/code&gt;, duplicates are rejected&lt;/td&gt;
&lt;td&gt;Not covered in its scheduling guide&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Inbox and listening&lt;/td&gt;
&lt;td&gt;Neither&lt;/td&gt;
&lt;td&gt;A messaging API for Instagram, Facebook, WhatsApp and X&lt;/td&gt;
&lt;td&gt;Inbox, listening and benchmarking&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;&lt;em&gt;Read on 10 November 2026 from ayrshare.com/pricing, ayrshare.com/docs, hootsuite.com/plans and developer.hootsuite.com. Prices in US dollars.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;Our prices are marked as indicative while plans are being finalised, and a quote is confirmed in writing before anything is charged.&lt;/p&gt;

&lt;h3&gt;
  
  
  Which one fits
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Hootsuite&lt;/strong&gt; if a marketing team needs to answer comments and watch mentions from one screen. Relay has no inbox and no listening.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Ayrshare&lt;/strong&gt; if your product needs Instagram, TikTok, LinkedIn or X this month, or if you post for thousands of your own customers and want a per-profile price.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Relay&lt;/strong&gt; if your destinations are Bluesky, Mastodon, Telegram, Discord or WordPress, if somebody who does not write code also needs a console, or if you want your test suite to exercise refusals and rate limits on demand. Ayrshare's publish endpoint lists Bluesky and Telegram, and it does not list Mastodon, Discord or WordPress.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Every endpoint, field and plan limit is on relay.rutba.io, and the platforms page shows the state of each network. &lt;a href="https://relay.rutba.io/docs" rel="noopener noreferrer"&gt;Read the API reference&lt;/a&gt;.&lt;/p&gt;

</description>
      <category>api</category>
      <category>webdev</category>
      <category>socialmedia</category>
      <category>tutorial</category>
    </item>
    <item>
      <title>What the evidence behind an e-signature should contain</title>
      <dc:creator>Ejaz Arain</dc:creator>
      <pubDate>Tue, 10 Nov 2026 04:11:21 +0000</pubDate>
      <link>https://dev.to/ejazarain/what-the-evidence-behind-an-e-signature-should-contain-3oko</link>
      <guid>https://dev.to/ejazarain/what-the-evidence-behind-an-e-signature-should-contain-3oko</guid>
      <description>&lt;p&gt;&lt;em&gt;First published on &lt;a href="https://rutba.io/blog/what-the-evidence-behind-an-e-signature-should-contain" rel="noopener noreferrer"&gt;rutba.io&lt;/a&gt;.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F0n27rlxdabm30zmd2ewt.jpg" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F0n27rlxdabm30zmd2ewt.jpg" alt="Eight tiles for what an evidence record holds: who was asked, how they proved it, the document hash, the consent accepted, the events in a chain, a public timestamp, a receipt for each party and a check anyone can run." width="800" height="420"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Most legal systems accept an electronic signature. The EU's eIDAS regulation and the United States' ESIGN Act are the best known examples, and plenty of other countries have their own. So the argument, when there is one, is rarely about whether an electronic signature can count. It is about evidence: can you show what happened, two or five years later, to somebody who has every reason to doubt you?&lt;/p&gt;

&lt;p&gt;That evidence is usually called an audit trail or a certificate of completion, and providers vary a great deal in what goes into it. These are the parts worth looking for.&lt;/p&gt;

&lt;h2&gt;
  
  
  Who was asked, and how each person proved who they were
&lt;/h2&gt;

&lt;p&gt;The record should name each person invited to sign and say how each one proved who they were. An email link proves that somebody could read that inbox. A code sent to a phone proves a little more, and an access code agreed in advance more again. None of these is wrong for every agreement, but the record must say which one was used for each signer, and must never claim more than was checked.&lt;/p&gt;

&lt;p&gt;In Rutba Sign the level is chosen per signer (email, a phone code, an access code or location), and the certificate states what was actually done for each one. If a signer proved nothing beyond clicking a link in an email, the certificate says exactly that.&lt;/p&gt;

&lt;h2&gt;
  
  
  Exactly what they saw and agreed to
&lt;/h2&gt;

&lt;p&gt;A dispute often turns on which version somebody signed. The record should fix the document with a cryptographic fingerprint (a hash) the moment it arrives, and record any disclosure or consent the signer accepted on the way. Rutba Sign pins each document by its hash on arrival and never rewrites it. Signatures and filled-in values are added to the PDF through the format's own append-only mechanism, so the original bytes stay checkable underneath them.&lt;/p&gt;

&lt;h2&gt;
  
  
  When each step happened, in an order nobody can rearrange
&lt;/h2&gt;

&lt;p&gt;Invited, opened, identity checked, signed: each event needs a time, and the sequence needs protecting as much as the times. If events are kept as separate rows, somebody with access to the database could reorder or quietly remove one. Chaining each event to the one before it by hash makes that visible. A timestamp from a public timestamping authority (the standard is RFC 3161) shows the record existed at a given moment without relying on the provider's own clock.&lt;/p&gt;

&lt;p&gt;Rutba Sign records the signing as it happens, chains the events by hash, and seals the completion record with an RFC 3161 timestamp from a public authority.&lt;/p&gt;

&lt;h2&gt;
  
  
  Proof each party can keep, and check without you
&lt;/h2&gt;

&lt;p&gt;Two things are easy to overlook. First, a signer who signs today may wait weeks for the other parties. In Rutba Sign every act is countersigned the moment it happens, so that person leaves with a receipt of their own act straight away. Second, evidence that only the provider can confirm is only as good as your relationship with that provider. Rutba Sign's verification is public: anybody can check a completed package or a single receipt against a published key set, without an account or a key, and nothing reaches your own systems. The answer is valid, tampered or unknown.&lt;/p&gt;

&lt;h2&gt;
  
  
  What to ask any provider
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Does the certificate say how each signer proved who they were, or only that they signed?&lt;/li&gt;
&lt;li&gt;Is the document fixed by a hash when it arrives, and is the original kept unchanged?&lt;/li&gt;
&lt;li&gt;Are the events chained so that a reordered or missing event shows?&lt;/li&gt;
&lt;li&gt;Is the record timestamped by a public authority, or only by your own servers?&lt;/li&gt;
&lt;li&gt;Can my counterparty verify the signed document without an account, and after I stop being your customer?&lt;/li&gt;
&lt;li&gt;Does a party who signs first get proof of their own act before everyone has signed?&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Where Rutba Sign stops today
&lt;/h2&gt;

&lt;p&gt;Some European transactions require a qualified electronic signature, which needs a qualified trust service provider to verify identity and issue certificates. Rutba Sign does not offer qualified signatures yet: the partners they require are still outstanding. For most everyday commercial agreements, the evidence above is what decides a dispute.&lt;/p&gt;

&lt;p&gt;It is also in early access. Organisations are onboarded by hand, there is no card checkout yet, and accounts for individuals are built but not open to the public.&lt;/p&gt;

&lt;p&gt;The public check needs no account and no key: &lt;a href="https://rutba.io/sign/verify" rel="noopener noreferrer"&gt;rutba.io/sign/verify&lt;/a&gt;. The same engine is available as an API, and &lt;a href="https://rutba.io/blog/verification-that-never-touches-your-servers" rel="noopener noreferrer"&gt;this article&lt;/a&gt; goes further into how the check works. The product is at &lt;a href="https://sign.rutba.io" rel="noopener noreferrer"&gt;sign.rutba.io&lt;/a&gt;.&lt;/p&gt;

</description>
      <category>security</category>
      <category>cryptography</category>
      <category>webdev</category>
      <category>saas</category>
    </item>
    <item>
      <title>Strapi Remote Backup Pro, backing up a Strapi CMS without installing anything in it</title>
      <dc:creator>Ejaz Arain</dc:creator>
      <pubDate>Mon, 09 Nov 2026 21:24:20 +0000</pubDate>
      <link>https://dev.to/ejazarain/strapi-remote-backup-pro-backing-up-a-strapi-cms-without-installing-anything-in-it-42h1</link>
      <guid>https://dev.to/ejazarain/strapi-remote-backup-pro-backing-up-a-strapi-cms-without-installing-anything-in-it-42h1</guid>
      <description>&lt;p&gt;&lt;em&gt;First published on the &lt;a href="https://tech-style-co.blogspot.com/2026/11/strapi-remote-backup-pro-backing-up.html" rel="noopener noreferrer"&gt;Tech Style blog&lt;/a&gt;.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;Every Strapi backup tool we looked at is a plugin. Installing one means adding a dependency to a live CMS, redeploying it, and trusting code that runs inside the production process. If you are an agency backing up a client's site, you may not have deploy access at all.&lt;/p&gt;

&lt;p&gt;Strapi Remote Backup Pro works from outside. You point it at the CMS URL and sign in as an admin, and it talks to the same admin API the Strapi admin panel uses. Nothing is installed, so nothing has to be redeployed or removed afterwards, and it cannot destabilise a CMS it is not running inside. It is in development, and this post says how far it has got.&lt;/p&gt;

&lt;p&gt;  &lt;iframe src="https://www.youtube.com/embed/6UyMFLHwxAU" width="710" height="399"&gt;
  &lt;/iframe&gt;
&lt;/p&gt;

&lt;h2&gt;
  
  
  What works today
&lt;/h2&gt;

&lt;p&gt;The engine and the command line, published on npm as 0.1.0. The commands are &lt;code&gt;login&lt;/code&gt;, &lt;code&gt;backup&lt;/code&gt;, &lt;code&gt;restore&lt;/code&gt;, &lt;code&gt;inspect&lt;/code&gt; and &lt;code&gt;verify&lt;/code&gt;.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;npx @tech-style/strapi-remote-backup-pro backup &lt;span class="nt"&gt;--url&lt;/span&gt; https://cms.example.com &lt;span class="nt"&gt;--email&lt;/span&gt; admin@example.com
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;It needs Node.js 22.19 or later. If you would rather not deal with Node, a bootstrap installer stages a pinned, checksum-verified runtime and puts a &lt;code&gt;strapi-backup&lt;/code&gt; command on the PATH. That installer has been measured working on Windows and has not yet been run on macOS or Linux.&lt;/p&gt;

&lt;p&gt;The round trip is proved on Strapi v5: backups have been restored repeatedly between two live Strapi 5.52.0 instances and compared record by record.&lt;/p&gt;

&lt;h2&gt;
  
  
  What a backup holds
&lt;/h2&gt;

&lt;p&gt;Content entries across collection and single types, drafts and published, in every locale. The media library with its folder structure. Content-type and component schemas as they stood at backup time.&lt;/p&gt;

&lt;p&gt;The archive is a plain .zip that any operating system can open:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;backup-2026-08-18T1430.zip
├── manifest.json            always plaintext, always first
├── schemas/                 content types and components
├── content/
│   └── api--article.article.ndjson   one JSON record per line
├── media/
│   ├── media.ndjson         filenames, folder paths, hashes
│   └── files/               named by content hash, de-duplicated
└── meta/
    ├── locales.json
    └── run-report.json      counts, durations, warnings
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Each entry carries a SHA-256 checksum, and the archive can be encrypted with AES-256-GCM. The manifest is never encrypted, so an archive can be identified without its passphrase. The format is documented in full, so your backups stay readable even if the tool goes away.&lt;/p&gt;

&lt;h2&gt;
  
  
  Restore shows you the plan first
&lt;/h2&gt;

&lt;p&gt;You pick content types, individual records and how many relation hops to follow. Restoring a few articles brings the authors and categories they point at, so nothing ends up referencing a record that is not there.&lt;/p&gt;

&lt;p&gt;Because restore writes to a live CMS, it always produces a diff first: creates, updates, deletes and skips, with warnings about schema drift and relations that would land unresolved. Nothing is written until you confirm.&lt;/p&gt;

&lt;h2&gt;
  
  
  Built to behave like a guest
&lt;/h2&gt;

&lt;p&gt;It holds admin credentials, so it is careful with them. The password is exchanged once for a session token and dropped. It is never written to disk, to an archive or to a log. Strapi throttles admin sign-in, so a failed sign-in is never retried automatically, because a retry could lock you out of your own CMS. Concurrency is capped low by default and it backs off when rate-limited. A backup should never be the reason a site goes down.&lt;/p&gt;

&lt;h2&gt;
  
  
  Not built yet
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Seven of the eight destinations. A local or network folder works today. S3 and the services that speak its API, Azure Blob, Google Drive, Dropbox, OneDrive, SFTP and FTPS are designed behind a provider interface but still throw when called.&lt;/li&gt;
&lt;li&gt;Scheduled backups as a Windows service or a systemd daemon, including one catch-up run after a machine sleeps through several windows.&lt;/li&gt;
&lt;li&gt;The desktop app. It is designed and skeletoned in Avalonia, and nothing behind it runs yet.&lt;/li&gt;
&lt;li&gt;Strapi v4. The v4 dialect is written but has never been run against a v4 instance, so we call it written, not supported. One limit will stay: v4 identifies records only by an instance-local number, so restoring a v4 archive into a different instance needs an explicit identity mapping.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;If you have a v4 site that needs backing up, tell us. We would rather prove it against yours than ask you to take our word for it.&lt;/p&gt;

&lt;p&gt;Strapi Remote Backup Pro is MIT licensed. It is a Tech Style product: &lt;a href="https://www.tech-style.co/product-strapi-remote-backup" rel="noopener noreferrer"&gt;tech-style.co/product-strapi-remote-backup&lt;/a&gt;. The source is at &lt;a href="https://github.com/eharain/strapi-remote-backup-pro" rel="noopener noreferrer"&gt;github.com/eharain/strapi-remote-backup-pro&lt;/a&gt;.&lt;/p&gt;

</description>
      <category>strapi</category>
      <category>backup</category>
      <category>node</category>
      <category>devops</category>
    </item>
    <item>
      <title>JSON Compress, lossless JSON compression whose output is still JSON</title>
      <dc:creator>Ejaz Arain</dc:creator>
      <pubDate>Mon, 09 Nov 2026 21:05:02 +0000</pubDate>
      <link>https://dev.to/ejazarain/json-compress-lossless-json-compression-whose-output-is-still-json-27hn</link>
      <guid>https://dev.to/ejazarain/json-compress-lossless-json-compression-whose-output-is-still-json-27hn</guid>
      <description>&lt;p&gt;&lt;em&gt;First published on the &lt;a href="https://tech-style-co.blogspot.com/2026/11/json-compress-lossless-json-compression.html" rel="noopener noreferrer"&gt;Tech Style blog&lt;/a&gt;.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;Send a thousand records over an API and you send a thousand copies of every key name. A status with four possible values is spelled out a thousand times, and so is a currency that is always "GBP". Minifying takes out the whitespace, which is the small part of the problem. The repetition stays.&lt;/p&gt;

&lt;p&gt;JSON Compress is our open-source library for the repetition. It writes each key name once, turns arrays of like-shaped objects into columns and rows, and stores repeated values once. On record-shaped data the result is typically 45 to 75% smaller than minified JSON, and it comes back byte for byte. The output is still JSON, so it goes wherever the original went: an HTTP body, a WebSocket frame, a Postgres &lt;code&gt;jsonb&lt;/code&gt; column, a queue message.&lt;/p&gt;

&lt;p&gt;  &lt;iframe src="https://www.youtube.com/embed/FlY6yl79UDo" width="710" height="399"&gt;
  &lt;/iframe&gt;
&lt;/p&gt;

&lt;h2&gt;
  
  
  What it does to a document
&lt;/h2&gt;

&lt;p&gt;There are four transformations, and each can be turned off:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;A key catalogue. Every distinct key name is written once and replaced by a short token, with the busiest key getting the shortest one.&lt;/li&gt;
&lt;li&gt;Columnar tables. An array of like-shaped objects becomes a column list and a matrix of rows. This is the biggest win, and it is why record sets compress far better than nested configuration.&lt;/li&gt;
&lt;li&gt;Constant and dictionary columns. A column whose value never changes is stored once. A column drawn from a small set of strings becomes a short list plus small integers.&lt;/li&gt;
&lt;li&gt;A string catalogue. Anything else that repeats is written once, but only when the reference costs fewer bytes than the copies would. That is measured, not guessed.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Four records are too few to show a saving, but they show the shape:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="nl"&gt;"id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="nl"&gt;"name"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Ada"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="nl"&gt;"role"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"admin"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="nl"&gt;"team"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"core"&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;},&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="nl"&gt;"id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;2&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="nl"&gt;"name"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Bob"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="nl"&gt;"role"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"admin"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="nl"&gt;"team"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"core"&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;},&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="nl"&gt;"id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;3&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="nl"&gt;"name"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Cy"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;  &lt;/span&gt;&lt;span class="nl"&gt;"role"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"user"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;  &lt;/span&gt;&lt;span class="nl"&gt;"team"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"core"&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;},&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="nl"&gt;"id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;4&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="nl"&gt;"name"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Dee"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="nl"&gt;"role"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"user"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;  &lt;/span&gt;&lt;span class="nl"&gt;"team"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"core"&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;becomes&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"jc"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"k"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"id"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"name"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"role"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"team"&lt;/span&gt;&lt;span class="p"&gt;],&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"s"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"admin"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"user"&lt;/span&gt;&lt;span class="p"&gt;],&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"d"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt;
    &lt;/span&gt;&lt;span class="nl"&gt;"~t"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="mi"&gt;0&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;2&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;3&lt;/span&gt;&lt;span class="p"&gt;],&lt;/span&gt;&lt;span class="w"&gt;
    &lt;/span&gt;&lt;span class="nl"&gt;"~e"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="mi"&gt;0&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;0&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;2&lt;/span&gt;&lt;span class="p"&gt;],&lt;/span&gt;&lt;span class="w"&gt;
    &lt;/span&gt;&lt;span class="nl"&gt;"~cv"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"core"&lt;/span&gt;&lt;span class="p"&gt;],&lt;/span&gt;&lt;span class="w"&gt;
    &lt;/span&gt;&lt;span class="nl"&gt;"~r"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;[[&lt;/span&gt;&lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Ada"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;0&lt;/span&gt;&lt;span class="p"&gt;],&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="mi"&gt;2&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Bob"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;0&lt;/span&gt;&lt;span class="p"&gt;],&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="mi"&gt;3&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Cy"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;],&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="mi"&gt;4&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Dee"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;]]&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;At four thousand rows the key names, the word "core" and the two roles are still written exactly once each.&lt;/p&gt;

&lt;h2&gt;
  
  
  The numbers, including the bad one
&lt;/h2&gt;

&lt;p&gt;These come from &lt;code&gt;javascript/examples/benchmark.js&lt;/code&gt; in the repository, which round-trips every case before it reports a size:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;An API record set of 1,000 users: 206.2 KB minified, 54.8 KB compressed, 73% smaller. With gzip on both, still 20% smaller than gzip alone.&lt;/li&gt;
&lt;li&gt;A time series of 2,000 readings: 73% smaller, and 19% over gzip.&lt;/li&gt;
&lt;li&gt;1,500 structured log lines: 76% smaller, and 13% over gzip.&lt;/li&gt;
&lt;li&gt;A nested API response of orders with lines: 59% smaller, and 6% over gzip.&lt;/li&gt;
&lt;li&gt;GeoJSON with 400 features: 46% smaller, and 5% over gzip.&lt;/li&gt;
&lt;li&gt;A small config file with little repetition: 29% smaller, but 22% larger than gzip alone.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;The last row is there on purpose. Most JSON meets gzip on its way out of a server, and gzip already removes much of this. On a small document with little repetition the envelope costs more than it saves. &lt;code&gt;measure()&lt;/code&gt; and the &lt;code&gt;stats&lt;/code&gt; command tell you which case you are in before you change anything.&lt;/p&gt;

&lt;h2&gt;
  
  
  Lossless, including the awkward cases
&lt;/h2&gt;

&lt;p&gt;Getting 70% on tidy data is easy. The documents nobody thought about are where a library like this succeeds or fails. Key order survives, even inside packed tables. A missing key stays different from a null one. Keys that look like numbers keep their position. A key named &lt;code&gt;__proto__&lt;/code&gt; comes back as data. Circular references throw instead of hanging the process.&lt;/p&gt;

&lt;p&gt;Every test run also builds 2,000 seeded random documents, with ragged rows and hostile key names, and compares each round trip byte for byte with what JSON itself produces. All sixteen combinations of options run against the same documents.&lt;/p&gt;

&lt;h2&gt;
  
  
  Six languages, the same bytes
&lt;/h2&gt;

&lt;p&gt;The format is written down in a specification, and there are six implementations of it. Each was written from the specification rather than translated from the JavaScript, and given the same document they all write the same bytes. So you can compress in a Python job and restore in a Go worker, or compress in the browser and restore in .NET.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;npm install @tech-style/json-compress
dotnet add package TechStyle.JsonCompress
pip install json-compress
go get github.com/eharain/JSON-Compress/go
cargo add json-compress
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;JavaScript, .NET, Python, Go and Rust are released at 1.0.3. PHP passes the same tests and installs from the repository until its Packagist listing is ready. Java is planned. CI checks every port against a shared corpus of 144 documents in both directions: each must restore all 144 envelopes and must write the same 144 itself. None of the implementations has a dependency.&lt;/p&gt;

&lt;p&gt;In a browser there is no build step at all. The bundle is served by jsDelivr straight from the repository, about 21 KB minified and 7 KB over the wire. Our &lt;a href="https://www.tech-style.co/json-minifier" rel="noopener noreferrer"&gt;online JSON minifier&lt;/a&gt; loads it from that same URL and does all its work in the page, so nothing you paste is uploaded.&lt;/p&gt;

&lt;h2&gt;
  
  
  Where it earns its place
&lt;/h2&gt;

&lt;p&gt;It does most for JSON that travels: paginated API responses, WebSocket and SSE traffic with no per-message compression, &lt;code&gt;localStorage&lt;/code&gt; with its small quota, JSON columns, structured logs, and queue messages that hit a broker's size limit. For a small, varied config file, leave it alone.&lt;/p&gt;

&lt;p&gt;JSON Compress is MIT licensed. It is a Tech Style product: &lt;a href="https://www.tech-style.co/product-json-compress" rel="noopener noreferrer"&gt;tech-style.co/product-json-compress&lt;/a&gt;. The source and the specification are at &lt;a href="https://github.com/eharain/JSON-Compress" rel="noopener noreferrer"&gt;github.com/eharain/JSON-Compress&lt;/a&gt;.&lt;/p&gt;

</description>
      <category>json</category>
      <category>javascript</category>
      <category>opensource</category>
      <category>webdev</category>
    </item>
    <item>
      <title>Paritas: an Oracle-compatible database built on PostgreSQL that tells you where compatibility ends</title>
      <dc:creator>Ejaz Arain</dc:creator>
      <pubDate>Fri, 06 Nov 2026 12:17:39 +0000</pubDate>
      <link>https://dev.to/ejazarain/paritas-an-oracle-compatible-postgresql-that-tells-you-where-compatibility-ends-o6a</link>
      <guid>https://dev.to/ejazarain/paritas-an-oracle-compatible-postgresql-that-tells-you-where-compatibility-ends-o6a</guid>
      <description>&lt;p&gt;&lt;em&gt;First published on the &lt;a href="https://tech-style-co.blogspot.com/2026/11/paritas-oracle-compatible-postgresql.html" rel="noopener noreferrer"&gt;Tech Style blog&lt;/a&gt;.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;&lt;em&gt;Updated 18 November 2026: Paritas now runs in Oracle mode only. Every session reads Oracle's SQL, and PostgreSQL's client tools and drivers still connect.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;When a company moves off Oracle, most of the effort goes into converting the code. The part that hurts later is quieter. PostgreSQL is not Oracle, and in places it computes a different answer to the same expression. There is no error at build time and none in test. A pricing query returns a slightly wrong number, and a customer is the one who finds it.&lt;/p&gt;

&lt;p&gt;Paritas is our answer to that. It is an Oracle-compatible database built on PostgreSQL 18. It runs in Oracle mode only, and it compiles and runs real PL/SQL: packages, triggers, collections and exceptions. It is still in development and not for sale. This post is mostly about how we test it, because that is the part we think matters.&lt;/p&gt;

&lt;p&gt;  &lt;iframe src="https://www.youtube.com/embed/7iFw1ncwq7s" width="710" height="399"&gt;
  &lt;/iframe&gt;
&lt;/p&gt;

&lt;h2&gt;
  
  
  Same code, different answers
&lt;/h2&gt;

&lt;p&gt;Here are three cases, each measured on live engines with Oracle Database 21c as the reference. All three convert cleanly. None raises an error you would see at build time.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;code&gt;SELECT 3.4e38f * 10f&lt;/code&gt; multiplies binary floats past the top of the type. Oracle returns &lt;code&gt;inf&lt;/code&gt;. Stock PostgreSQL refuses the literal, and the nearest equivalent raises "value out of range".&lt;/li&gt;
&lt;li&gt;
&lt;code&gt;SELECT 1 UNION SELECT 2 INTERSECT SELECT 2&lt;/code&gt; has no parentheses. Oracle returns 2. PostgreSQL binds INTERSECT tighter and returns 1 and 2.&lt;/li&gt;
&lt;li&gt;
&lt;code&gt;FOR i IN REVERSE 1 .. 3 LOOP&lt;/code&gt; runs 3, 2, 1 on Oracle. PostgreSQL's REVERSE takes the bounds the other way round, so the loop runs no iteration at all.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Paritas gives Oracle's answer in each case. A loop that walks a collection backwards and silently does nothing is exactly the kind of bug that gets through code review. The floating-point fix has since been merged into the upstream open-source project.&lt;/p&gt;

&lt;p&gt;  &lt;iframe src="https://www.youtube.com/embed/cbrdvDBCs2s" width="710" height="399"&gt;
  &lt;/iframe&gt;
&lt;/p&gt;

&lt;h2&gt;
  
  
  The harness came first
&lt;/h2&gt;

&lt;p&gt;Anyone can fork a database. What we built first was the test harness. Oracle Database 21c, stock PostgreSQL and the unmodified open-source base run beside Paritas, and every answer is compared with Oracle's. A difference only counts once a live engine shows it. On 9 October two fixes written straight from Oracle's manual gave the wrong answer on a real Oracle 21c, which is why the manual alone is never the test.&lt;/p&gt;

&lt;p&gt;It has three parts:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;A differential corpus of 764 SQL and PL/SQL cases, each with the answer a real Oracle instance returned. Every verdict is kept from run to run, so a change that fixes one answer and breaks another shows up in the next run.&lt;/li&gt;
&lt;li&gt;An application gauntlet of 591 units and 92,000 lines of real PL/SQL from nine schemas, among them the Alexandria, Logger, utPLSQL and PL/JSON libraries and Oracle's HR and OE samples, compiled unchanged. It ranks what breaks, so the most common blocker gets fixed first.&lt;/li&gt;
&lt;li&gt;170 stress cases on long values, and an AddressSanitizer build in CI.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Where it stands
&lt;/h2&gt;

&lt;p&gt;These are the figures from mid-October:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Real PL/SQL compiling unchanged: 137 of the 253 package-level units that Oracle itself compiles, or 54%.&lt;/li&gt;
&lt;li&gt;Answers matching Oracle: 599 of the 764 corpus cases, or 78%.&lt;/li&gt;
&lt;li&gt;Calls into built-in packages that resolve: 1,436 of 2,994 call sites, or 48%.&lt;/li&gt;
&lt;li&gt;Errors behaving like Oracle (the codes handlers catch, SQLCODE, SQLERRM, RAISE_APPLICATION_ERROR): 31 of 38 cases.&lt;/li&gt;
&lt;li&gt;Stress cases: one known crash case is open, a PL/SQL &lt;code&gt;SELECT ... INTO&lt;/code&gt; of a ROWID, which crashes the unmodified base too. A 24-hour soak with flat memory runs last, before release.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;We are aiming to release it next quarter.&lt;/p&gt;

&lt;h2&gt;
  
  
  Where compatibility ends
&lt;/h2&gt;

&lt;p&gt;Our list of limitations runs to more than 500 entries, each saying what happens and usually what to do instead.&lt;/p&gt;

&lt;p&gt;Some things are out of the first release by decision: object types with methods, the network and XML packages, DBMS_SCHEDULER and DBMS_JOB, database links and flashback queries. Autonomous transactions are refused when the code compiles, because a fake one would be a trap. Optimizer hints are read as comments.&lt;/p&gt;

&lt;p&gt;Others are simply open today. Integer division truncates, so &lt;code&gt;SELECT 10/4&lt;/code&gt; gives 2 where Oracle gives 2.5. GREATEST and LEAST skip a NULL where Oracle returns NULL. LISTAGG and FORALL are not there yet.&lt;/p&gt;

&lt;p&gt;We would rather you read that here than find it six months into a project.&lt;/p&gt;

&lt;h2&gt;
  
  
  It pairs with pgrecon
&lt;/h2&gt;

&lt;p&gt;pgrecon, our free assessment tool, tells you what an Oracle estate contains and roughly what moving it will cost. The Paritas harness tells you which of that code behaves differently on the destination, expression by expression. They already share plumbing: the tables the gauntlet compiles against are extracted and converted by pgrecon.&lt;/p&gt;

&lt;p&gt;pgrecon is the first of the tools we are building around Paritas, and the only one out today. Development tools and connectivity drivers are coming, and none of them is available yet.&lt;/p&gt;

&lt;p&gt;If you are planning a move off Oracle and would like to see the harness run, ask us through the product page. It is more convincing to watch than to read about.&lt;/p&gt;

&lt;p&gt;Paritas is a Tech Style product: &lt;a href="https://tech-style.co/product-paritas" rel="noopener noreferrer"&gt;tech-style.co/product-paritas&lt;/a&gt;. pgrecon is at &lt;a href="https://tech-style.co/product-pgrecon" rel="noopener noreferrer"&gt;tech-style.co/product-pgrecon&lt;/a&gt;.&lt;/p&gt;

</description>
      <category>postgres</category>
      <category>oracle</category>
      <category>database</category>
      <category>sql</category>
    </item>
    <item>
      <title>pgrecon, an Oracle to PostgreSQL assessment that never connects to your database</title>
      <dc:creator>Ejaz Arain</dc:creator>
      <pubDate>Mon, 02 Nov 2026 09:59:06 +0000</pubDate>
      <link>https://dev.to/ejazarain/pgrecon-an-oracle-to-postgresql-assessment-that-never-connects-to-your-database-45m</link>
      <guid>https://dev.to/ejazarain/pgrecon-an-oracle-to-postgresql-assessment-that-never-connects-to-your-database-45m</guid>
      <description>&lt;p&gt;&lt;em&gt;First published on the &lt;a href="https://tech-style-co.blogspot.com/2026/11/pgrecon-oracle-to-postgresql-assessment.html" rel="noopener noreferrer"&gt;Tech Style blog&lt;/a&gt;.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;Most Oracle to PostgreSQL projects are priced before anyone has read the code. Someone counts tables and guesses at the PL/SQL, and the expensive surprises turn up late: package-level state, autonomous transactions, LONG columns, interval partitioning, database links. pgrecon is our free, open-source tool for finding those things first.&lt;/p&gt;

&lt;p&gt;It is on GitHub under Apache 2.0 and on PyPI as &lt;code&gt;pgrecon&lt;/code&gt;. It needs Python 3.11 or later.&lt;/p&gt;

&lt;p&gt;  &lt;iframe src="https://www.youtube.com/embed/JbwpslUh6Mg" width="710" height="399"&gt;
  &lt;/iframe&gt;
&lt;/p&gt;

&lt;h2&gt;
  
  
  It never connects to your database
&lt;/h2&gt;

&lt;p&gt;That matters, because it decides whether a bank or a hospital will let you run the tool at all. pgrecon writes a plain SQL*Plus script, SELECT only, against the dictionary views. The DBA reads it, runs it with a read-only account and hands back a folder of files. Only files cross the boundary.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;pgrecon script &lt;span class="nt"&gt;--source-version&lt;/span&gt; 19
sqlplus readonly_user@service @pgrecon_extract.sql SCHEMA_NAME
pgrecon load dump_dir &lt;span class="nt"&gt;--db&lt;/span&gt; inventory.db
pgrecon report &lt;span class="nt"&gt;--db&lt;/span&gt; inventory.db
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;The extracting account needs SELECT_CATALOG_ROLE or the equivalent grants. Oracle 11.2 and later use the standard script, which is tested nightly against Oracle XE 21c and Oracle Free 23ai. Older servers, 9.2 to 11.1, get a legacy script that rebuilds DDL from the catalog instead of calling DBMS_METADATA, because on those systems DBMS_METADATA is slow when it works at all.&lt;/p&gt;

&lt;h2&gt;
  
  
  Findings you can check
&lt;/h2&gt;

&lt;p&gt;The report comes from 80 rules, each with a stable id and its own fixture tests. PL/SQL is parsed with a real grammar, so a finding names the object and the line where the problem sits:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;high    R-PKG-01   PKG_LEDGER          2 package-level declaration(s), first at line 2
high    R-TRG-02   TRG_EMP_AUDIT       PRAGMA AUTONOMOUS_TRANSACTION (first at line 5)
high    R-TYPE-01  LEGACY_NOTES.BODY   LONG
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Same dump in, same findings out. An engineer can open the code and see the problem rather than take the tool's word for it. DDL that fails to parse is reported as a finding too, never skipped.&lt;/p&gt;

&lt;p&gt;You can try it without an Oracle database. The repository ships a real dump taken from an Oracle XE 21c instance loaded with a deliberately awkward schema, and it produces 58 findings.&lt;/p&gt;

&lt;h2&gt;
  
  
  An estimate you can argue with
&lt;/h2&gt;

&lt;p&gt;&lt;code&gt;pgrecon estimate&lt;/code&gt; turns the findings into person-days, as a sum of named parts: baseline, schema conversion, finding remediation, PL/SQL porting by volume and data movement, with testing on top. On the bundled sample it comes to a range of 106 to 180 person-days, 131 expected.&lt;/p&gt;

&lt;p&gt;It is a range on purpose. A single number for a migration is a guess dressed up as a fact. Every run prints its assumptions, and the default rates are conservative. Treat it as a scoping tool, not a quote.&lt;/p&gt;

&lt;h2&gt;
  
  
  Conversion, where it can be proved
&lt;/h2&gt;

&lt;p&gt;Since version 0.2 the same inventory drives a converter. It writes PostgreSQL DDL for what it can prove: tables (NUMBER stays exact, never a float), keys, checks, indexes, native partitions, views with (+) joins rewritten as ANSI joins, sequences restarted where they were, and standalone functions and procedures whose every construct has an equivalent in PL/pgSQL.&lt;/p&gt;

&lt;p&gt;Everything else goes into a residue file, one line per object, naming the construct and the line. Packages, CONNECT BY, autonomous transactions, BULK COLLECT and REF CURSOR interfaces are refused by name rather than guessed at.&lt;/p&gt;

&lt;p&gt;Two rules hold. Nothing invalid ships: CI applies the sample conversion to live PostgreSQL 16, 17 and 18 on every commit. Nothing is lost silently: what the converter cannot carry faithfully becomes a residue line, not quietly wrong output.&lt;/p&gt;

&lt;h2&gt;
  
  
  How big it goes
&lt;/h2&gt;

&lt;p&gt;A synthetic estate of 5,000 tables and 100,000 lines of PL/SQL, one package body alone 16,000 lines long, loads and parses in under 40 seconds on a laptop. The generator is in the repository, so you can repeat the measurement.&lt;/p&gt;

&lt;h2&gt;
  
  
  Where it stands
&lt;/h2&gt;

&lt;p&gt;pgrecon is alpha. The extraction scripts and the inventory are stable, and the rule catalogue is still growing. If it refuses something in your schema, open an issue with the residue line. Residue never contains data.&lt;/p&gt;

&lt;p&gt;pgrecon is a Tech Style product: &lt;a href="https://www.tech-style.co/product-pgrecon" rel="noopener noreferrer"&gt;tech-style.co/product-pgrecon&lt;/a&gt;. The code is at &lt;a href="https://github.com/Muzzammil242/pgrecon" rel="noopener noreferrer"&gt;github.com/Muzzammil242/pgrecon&lt;/a&gt;.&lt;/p&gt;

</description>
      <category>postgres</category>
      <category>oracle</category>
      <category>database</category>
      <category>opensource</category>
    </item>
    <item>
      <title>Rutba Data Files: twenty-five business templates, and the paperwork each one prints</title>
      <dc:creator>Ejaz Arain</dc:creator>
      <pubDate>Sun, 01 Nov 2026 09:42:17 +0000</pubDate>
      <link>https://dev.to/ejazarain/rutba-data-files-twenty-five-business-templates-and-the-paperwork-each-one-prints-2jb9</link>
      <guid>https://dev.to/ejazarain/rutba-data-files-twenty-five-business-templates-and-the-paperwork-each-one-prints-2jb9</guid>
      <description>&lt;p&gt;&lt;em&gt;First published on &lt;a href="https://rutba.io/blog/rutba-data-files-twenty-five-business-templates-and-what-they-print" rel="noopener noreferrer"&gt;rutba.io&lt;/a&gt;.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;Rutba Data Files, the free database in Rutba Office, comes with a working database for twenty-five kinds of small business, from a takeaway to a landlord. Each has its tables, queries, reports and print templates ready, with a year of invented records or none.&lt;/p&gt;

&lt;p&gt;Most small businesses keep their records in a spreadsheet until the copies start to disagree. A database fixes that, but an empty one asks you to design tables before you can type a single customer in. Rutba Data Files, the free database in Rutba Office for Windows, answers that with a working database for twenty-five kinds of small business, each one ready to use as it stands or to change.&lt;/p&gt;

&lt;p&gt;Data Files itself does what Microsoft Access does for a small business. A database is one .rbase file on your computer, with SQLite inside and a published format, holding related tables, queries you design or write in SQL, forms, reports, and print templates that lay out one record as a business sends it. &lt;a href="https://rutba.io/blog/rutba-data-files-a-free-database-for-small-businesses" rel="noopener noreferrer"&gt;The Data Files post&lt;/a&gt; goes through all of that. This one is about the templates.&lt;/p&gt;

&lt;p&gt;  &lt;iframe src="https://www.youtube.com/embed/-DEvQQVbzng" width="710" height="399"&gt;
  &lt;/iframe&gt;
&lt;/p&gt;

&lt;h2&gt;
  
  
  What one template holds
&lt;/h2&gt;

&lt;p&gt;Each business template is a whole database, not a starter table. It has between eleven and nineteen tables, a form for every table, the queries the owner of that kind of business asks every week, reports to print them, and print templates for what the business sends out. Across the twenty-five there are 392 tables, 404 queries, 237 reports and 122 print templates.&lt;/p&gt;

&lt;p&gt;The first table in each is called Start Here. It holds the everyday tasks a step at a time, and every step says which table, form, query, report or print template to open. Its report prints the whole guide. When you know your way round, delete the table: nothing else uses it.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F4pi2oqdwgri3zts5058t.jpg" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F4pi2oqdwgri3zts5058t.jpg" alt="The Start Here report of a takeaway database in Data Files: a page headed Start here, the everyday tasks, step by step, with numbered steps for taking a phone order and sending it to the kitchen." width="800" height="500"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;em&gt;Start Here: the takeaway's everyday tasks, each step naming what to open.&lt;/em&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;With sample records&lt;/strong&gt;, a template is a business already trading: a year or more of invented orders, sales and payments, made up a day at a time, from about 2,600 records at the letting business to over 88,000 at the corner shop. It is the quickest way to see what the queries and reports are for.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Empty&lt;/strong&gt;, it has the same tables, queries, forms, reports and print templates with nothing in them, waiting for your own records.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Everything in the sample records is invented: the business, its people and their addresses, email addresses on example domains that reach nobody, and phone numbers from the ranges kept for drama and fiction. Tax, company and bank numbers are zeros.&lt;/p&gt;

&lt;h2&gt;
  
  
  Starting with your own records
&lt;/h2&gt;

&lt;p&gt;Every guide says where to begin when you start empty, and it is always the Business table: your name, address, phone and VAT number, and the words at the foot of a receipt. Every invoice, receipt and letter prints its heading from there. Then come the lists the rest point at, then the everyday records as they happen.&lt;/p&gt;

&lt;p&gt;At the takeaway, for example, that means the delivery zones with their charges and the driver's fee for a drop, then the sizes, menu items, ingredients and the recipe lines for each dish, then the staff. Customers are added as they first order. From then on each order is an Orders record with its lines, each night has a Nights sheet, and each week every driver has a pay sheet with their drops pointing at it.&lt;/p&gt;

&lt;h2&gt;
  
  
  The twenty-five businesses
&lt;/h2&gt;

&lt;p&gt;They come in five groups. Each name below links to its page on office.rutba.io, which has its full guide, every table and field, a download, and a film of its own.&lt;/p&gt;

&lt;h3&gt;
  
  
  Shops and food
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;a href="https://office.rutba.io/samples/larkspur-corner-store" rel="noopener noreferrer"&gt;Larkspur Corner Store&lt;/a&gt;, a neighbourhood shop: the till with VAT, stock, supplier orders and loyalty customers. Prints a sale receipt on an 80 mm till roll and a supplier order.&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://office.rutba.io/samples/bramblegate-wine-and-deli" rel="noopener noreferrer"&gt;Bramblegate Wine and Deli&lt;/a&gt;, a food and drink shop: stock kept by batch and date, a morning date check that marks down and writes off, and age checks at the till. Prints a reduced label on a 58 mm roll, a markdown label sheet and a refusals register.&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://office.rutba.io/samples/little-fig-cafe" rel="noopener noreferrer"&gt;Little Fig Cafe&lt;/a&gt;: the menu with recipes and food costs, till orders, the rota, waste and the nightly cash-up. Prints receipts, purchase orders and payslips.&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://office.rutba.io/samples/saffron-lane-pizza-and-curry" rel="noopener noreferrer"&gt;Saffron Lane Pizza and Curry&lt;/a&gt;, a takeaway: phone, walk-in and online orders, delivery zones and drivers, meal deals and the night's takings. Prints a customer receipt, a kitchen ticket, a delivery slip and a driver pay sheet.&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://office.rutba.io/samples/hazel-row-flowers" rel="noopener noreferrer"&gt;Hazel Row Flowers&lt;/a&gt;, a florist: stems and their waste, bouquet recipes, deliveries and weddings. Prints a gift card message, a delivery note, a wedding quote and a wedding invoice.&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://office.rutba.io/samples/tansy-row-pharmacy" rel="noopener noreferrer"&gt;Tansy Row Pharmacy&lt;/a&gt;, a pharmacy counter: stock by batch and expiry, pharmacist checks, prescription collections and home deliveries. Prints a delivery round sheet and an expiry return note.&lt;/li&gt;
&lt;/ul&gt;

&lt;h3&gt;
  
  
  Trade, making and building
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;a href="https://office.rutba.io/samples/northbank-trading" rel="noopener noreferrer"&gt;Northbank Trading&lt;/a&gt;, a wholesaler: customers, suppliers, orders, purchase orders, stock and invoices. Prints invoices, delivery notes and statements.&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://office.rutba.io/samples/granite-and-grain-woodworks" rel="noopener noreferrer"&gt;Granite and Grain Woodworks&lt;/a&gt;, a furniture workshop: materials, bills of materials, work orders and makers' hours. Prints a quote, a works order and a VAT invoice.&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://office.rutba.io/samples/kilnside-builders" rel="noopener noreferrer"&gt;Kilnside Builders&lt;/a&gt;, a small building firm: quotes, contracts, stage payments, variations, retentions and job costs. Prints a contract, a stage invoice and a variation order.&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://office.rutba.io/samples/copperbeech-motors" rel="noopener noreferrer"&gt;Copperbeech Motors&lt;/a&gt;, a used car dealer: preparation costs, test drives, finance, warranties and part-exchanges. Prints a sales invoice, a part-exchange valuation, a warranty certificate and a window card.&lt;/li&gt;
&lt;/ul&gt;

&lt;h3&gt;
  
  
  Services
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;a href="https://office.rutba.io/samples/marigold-hair-and-beauty" rel="noopener noreferrer"&gt;Marigold Hair and Beauty&lt;/a&gt;, a salon: the appointment book, commission, retail stock and gift vouchers. Prints a gift voucher and a commission statement.&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://office.rutba.io/samples/copper-pole-barbers" rel="noopener noreferrer"&gt;Copper Pole Barbers&lt;/a&gt;: the queue board, takings by barber, loyalty cards and chair rent. Prints a chair rental agreement and its invoice.&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://office.rutba.io/samples/ironbridge-repairs" rel="noopener noreferrer"&gt;Ironbridge Repairs&lt;/a&gt;, for phones, laptops and small appliances: jobs, quotes, parts and warranties. Prints a booking-in receipt and a collection receipt.&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://office.rutba.io/samples/quarrybank-motors" rel="noopener noreferrer"&gt;Quarrybank Motors&lt;/a&gt;, a garage and MOT centre: vehicles, job cards, MOT tests, services and reminders. Prints an estimate, a job card and a reminder letter.&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://office.rutba.io/samples/fernhollow-cleaning" rel="noopener noreferrer"&gt;Fernhollow Cleaning&lt;/a&gt;, a cleaning company: sites, contracts, the rota and visits. Prints a cleaning contract, a site visit sheet and payslips.&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://office.rutba.io/samples/bramble-studio" rel="noopener noreferrer"&gt;Bramble Studio&lt;/a&gt;, a consultancy or agency: projects, time sheets and expenses. Prints a proposal, a letter of engagement and a weekly time sheet.&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://office.rutba.io/samples/tannery-yard-fitness" rel="noopener noreferrer"&gt;Tannery Yard Fitness&lt;/a&gt;, a gym: monthly plans, direct debits, class bookings and personal training packs. Prints a membership agreement and a membership card.&lt;/li&gt;
&lt;/ul&gt;

&lt;h3&gt;
  
  
  Health, learning and community
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;a href="https://office.rutba.io/samples/cedar-lane-clinic" rel="noopener noreferrer"&gt;Cedar Lane Clinic&lt;/a&gt;, a small private clinic: patients, appointments, visit notes and recalls. Prints an appointment letter, a recall letter and an insurer statement.&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://office.rutba.io/samples/lantern-learning-centre" rel="noopener noreferrer"&gt;Lantern Learning Centre&lt;/a&gt;, a tuition or training centre: students and families, registers, test results and termly fees. Prints a term report and a certificate of completion.&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://office.rutba.io/samples/rowanmere-community-trust" rel="noopener noreferrer"&gt;Rowanmere Community Trust&lt;/a&gt;, a charity or club: members, supporters, gifts and the tax claimed on them, events, volunteers and grants. Prints a donation receipt, an event ticket and a tax claim schedule.&lt;/li&gt;
&lt;/ul&gt;

&lt;h3&gt;
  
  
  Property, premises and staff
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;a href="https://office.rutba.io/samples/hollybrook-lettings" rel="noopener noreferrer"&gt;Hollybrook Lettings&lt;/a&gt;, a landlord with homes, shops and workshops: leases, rent invoices, deposits, repairs and safety checks. Prints a tenancy agreement, a rent arrears letter and a notice of inspection.&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://office.rutba.io/samples/fernleigh-estates" rel="noopener noreferrer"&gt;Fernleigh Estates&lt;/a&gt;, an estate and letting agent: properties, applicants, viewings, offers, sales to completion and managed lets. Prints a memorandum of sale and a landlord statement.&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://office.rutba.io/samples/gullhaven-guest-house" rel="noopener noreferrer"&gt;Gullhaven Guest House&lt;/a&gt;, a guest house or B and B: rooms, rates, bookings, deposits and booking-site commission. Prints a booking confirmation, a guest bill and a registration card.&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://office.rutba.io/samples/copperfield-house" rel="noopener noreferrer"&gt;Copperfield House&lt;/a&gt;, an office building's front desk: visitors, badges, contractor inductions, deliveries and fire roll calls. Prints a visitor pass on a 58 mm roll and a fire roll call.&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://office.rutba.io/samples/wrenmoor-garden-centre" rel="noopener noreferrer"&gt;Wrenmoor Garden Centre&lt;/a&gt;, for any business with staff: contracts, holidays, absence, timesheets, pay runs and payslips. Prints a payslip, a leave request and an annual pay summary.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Paperwork that fits the job
&lt;/h2&gt;

&lt;p&gt;Of the 122 print templates, ninety-one are on A4, twelve on A5, fourteen on an 80 mm till roll and five on a 58 mm roll, for labels, cards and passes. Each takes its letterhead from the Business table and its lines from the record, and prints from the form showing that record, or saves as a PDF.&lt;/p&gt;

&lt;p&gt;They are made for the way each business works rather than one invoice dressed up twenty-five ways. The takeaway prints a kitchen ticket as the order is taken and a delivery slip to tape to the bag, for deliveries only. The deli prints a reduced label for each pack it marks down. The letting business sends a rent arrears letter, and the charity a schedule of the gifts it claims tax on.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Flzf2o4by472ionmtuvgs.jpg" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Flzf2o4by472ionmtuvgs.jpg" alt="A takeaway's delivery slip printed from Data Files on a narrow roll: the customer, address, postcode, phone, zone, due time and driver, the items with their sizes, the order total, the cash to collect, and a note to hand the cash in at the end of the night." width="800" height="500"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;em&gt;The takeaway's delivery slip shows the cash to collect, or a line saying the order is paid already.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;  &lt;iframe src="https://www.youtube.com/embed/cyZxFcTHAtQ" width="710" height="399"&gt;
  &lt;/iframe&gt;
&lt;/p&gt;

&lt;h2&gt;
  
  
  Made to be changed
&lt;/h2&gt;

&lt;p&gt;No template will match your business exactly, so every guide ends with ways to bend it. Some examples, from the guides themselves:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;The takeaway charges by zone. To charge by distance, add a Miles field to Customers and a calculated delivery charge in a query, such as 1.50 plus 0.50 a mile.&lt;/li&gt;
&lt;li&gt;The deli sells by the item. To sell cheese and meat by weight, add a Weight field to Sale Lines and work out each line as Round([Weight] * [Unit Price], 2).&lt;/li&gt;
&lt;li&gt;The landlord owns its buildings. To manage them for owners, add an Owners table with each owner's management fee, and a query that takes the fee off the rent to show what you pay them.&lt;/li&gt;
&lt;li&gt;The charity claims tax back on gifts. Where there is no such scheme, delete the Tax Claims table, the query that lists gifts to claim and the claim schedule report; where the scheme pays a different share, change the 0.25 in that query.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;  &lt;iframe src="https://www.youtube.com/embed/scWTPXde7ms" width="710" height="399"&gt;
  &lt;/iframe&gt;
&lt;/p&gt;

&lt;h2&gt;
  
  
  Five simpler ones
&lt;/h2&gt;

&lt;p&gt;Beside the businesses sit five small databases of one to four tables, for when a whole business is more than you need: Contacts, with a phone list to print; Inventory, with every stock movement and what is running low; Membership, with the renewals coming due; Customers and sales, for the deals in hand and each call or meeting; and a Lending library for books and who has them.&lt;/p&gt;

&lt;h2&gt;
  
  
  Newer designs, and your changes kept
&lt;/h2&gt;

&lt;p&gt;The templates arrive with Rutba Office's own update check, signed by Rutba. A database made from one remembers where it came from, and when a newer design comes out it is offered, never forced. New tables and fields are added and nothing is taken away. A query, form or template you never touched is replaced, and one you changed keeps your version, with the newer one beside it.&lt;/p&gt;

&lt;p&gt;To learn Data Files from the beginning, &lt;a href="https://rutba.io/blog/the-data-files-course-sixteen-films-from-an-empty-file-to-a-shop" rel="noopener noreferrer"&gt;the Data Files course&lt;/a&gt; builds a shop's database from an empty file in short films. Data Files is one of the apps you add from Choose apps in Rutba Office.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Download Rutba Office.&lt;/strong&gt; Data Files and its twenty-five business templates come free with Rutba Office for Windows, with no telemetry, and no account except for Talk. &lt;a href="https://office.rutba.io/download" rel="noopener noreferrer"&gt;Download&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Moving from Microsoft Access or another file database such as LibreOffice Base? Data Files imports the tables of Access .mdb and .accdb files and of dBASE files into a new database, kept in one file on your own computer. Rutba Office is a Tech Style product: &lt;a href="https://tech-style.co/product-rutba-office" rel="noopener noreferrer"&gt;tech-style.co/product-rutba-office&lt;/a&gt;. Its own site, with the free download, is &lt;a href="https://office.rutba.io" rel="noopener noreferrer"&gt;office.rutba.io&lt;/a&gt;.&lt;/p&gt;

</description>
      <category>database</category>
      <category>opensource</category>
      <category>smallbusiness</category>
      <category>productivity</category>
    </item>
    <item>
      <title>Ten films of the Rutba Suite at work, each run by an invented business</title>
      <dc:creator>Ejaz Arain</dc:creator>
      <pubDate>Sun, 01 Nov 2026 09:41:34 +0000</pubDate>
      <link>https://dev.to/ejazarain/ten-films-of-the-rutba-suite-at-work-each-run-by-an-invented-business-14l1</link>
      <guid>https://dev.to/ejazarain/ten-films-of-the-rutba-suite-at-work-each-run-by-an-invented-business-14l1</guid>
      <description>&lt;p&gt;&lt;em&gt;First published on &lt;a href="https://rutba.io/blog/films-of-the-rutba-suite-at-work" rel="noopener noreferrer"&gt;rutba.io&lt;/a&gt;.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;Ten short films now show the Rutba Suite doing a day's work: a corner shop, a wholesaler, a takeaway, a garden centre, a furniture workshop and a building firm, all invented, each using the apps for what that business actually needs.&lt;/p&gt;

&lt;p&gt;A product page can say that the till and the website share one catalogue. A film can show a price changed in one place and charged in the other. So each product in the Rutba Suite's “Run the business” shelf now has a film of three to five minutes, set in a business that needs it, and each film has a post here that follows it step by step.&lt;/p&gt;

&lt;h2&gt;
  
  
  The ten films
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Commerce:&lt;/strong&gt; &lt;a href="https://rutba.io/blog/rutba-commerce-on-film-a-corner-shop-from-the-website-to-the-till" rel="noopener noreferrer"&gt;a corner shop's website, catalogue and till&lt;/a&gt;, at Larkspur Corner Store.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Inventory:&lt;/strong&gt; &lt;a href="https://rutba.io/blog/rutba-inventory-on-film-a-warehouse-from-goods-in-to-buying-again" rel="noopener noreferrer"&gt;a warehouse from goods in to buying again&lt;/a&gt;, at Northbank Trading.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Orders:&lt;/strong&gt; &lt;a href="https://rutba.io/blog/rutba-orders-on-film-a-takeaway-from-the-board-to-the-door" rel="noopener noreferrer"&gt;a takeaway's order from the board to the door&lt;/a&gt;, at Saffron Lane.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;CRM:&lt;/strong&gt; &lt;a href="https://rutba.io/blog/rutba-crm-on-film-leads-calls-and-a-late-delivery-on-one-record" rel="noopener noreferrer"&gt;leads, calls and a late delivery on one record&lt;/a&gt;, at Northbank Trading.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;People:&lt;/strong&gt; &lt;a href="https://rutba.io/blog/rutba-people-on-film-the-time-clock-the-pay-run-and-the-hiring-board" rel="noopener noreferrer"&gt;the time clock, the pay run and the hiring board&lt;/a&gt;, at Wrenmoor Garden Centre.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Books:&lt;/strong&gt; &lt;a href="https://rutba.io/blog/rutba-books-on-film-an-invoice-paid-and-the-year-so-far" rel="noopener noreferrer"&gt;an invoice paid and the year so far&lt;/a&gt;, at Northbank Trading.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Facilities:&lt;/strong&gt; &lt;a href="https://rutba.io/blog/rutba-facilities-on-film-a-workshop-its-assets-and-a-lapsed-contractor" rel="noopener noreferrer"&gt;a workshop's assets and a lapsed contractor&lt;/a&gt;, at Granite and Grain.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Fleet:&lt;/strong&gt; &lt;a href="https://rutba.io/blog/rutba-fleet-on-film-the-lorry-the-wrong-licence-cannot-take" rel="noopener noreferrer"&gt;the lorry the wrong licence cannot take&lt;/a&gt;, at Kilnside Builders.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Manufacturing:&lt;/strong&gt; &lt;a href="https://rutba.io/blog/rutba-manufacturing-on-film-a-walnut-table-released-to-the-floor" rel="noopener noreferrer"&gt;a walnut table released to the floor&lt;/a&gt;, at Granite and Grain.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Sign:&lt;/strong&gt; &lt;a href="https://rutba.io/blog/rutba-sign-on-film-understand-the-paper-then-draft-it-for-the-place" rel="noopener noreferrer"&gt;understand the paper, then draft it for the place&lt;/a&gt;, on the public Rutba Sign site.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;  &lt;iframe src="https://www.youtube.com/embed/uY0dtLDsYs4" width="710" height="399"&gt;
  &lt;/iframe&gt;
&lt;/p&gt;

&lt;h2&gt;
  
  
  Why invented businesses
&lt;/h2&gt;

&lt;p&gt;Software films usually show an empty account, or a real customer's data with names blurred. Neither shows what the product is for. Each of these businesses was made up with a year of trading behind it: Northbank Trading has customers who pay late and a supplier who cancels an order, Kilnside Builders has a driver whose licence has expired and a tipper whose insurance has lapsed. The films were shot on copies of the apps loaded with those made-up records, so no real customer, employee or figure appears in any of them.&lt;/p&gt;

&lt;p&gt;Several businesses appear more than once. Northbank Trading's stock, customers and books are one set of records across three films, and Granite and Grain's workshop machines turn up in both Facilities and Manufacturing, which is the point of a suite: the apps share a record rather than an export, as &lt;a href="https://rutba.io/blog/how-the-rutba-modules-fit-together-for-a-small-business" rel="noopener noreferrer"&gt;an earlier post on how the modules fit together&lt;/a&gt; explains.&lt;/p&gt;

&lt;h2&gt;
  
  
  What a film may show
&lt;/h2&gt;

&lt;p&gt;Every script was checked against the apps before shooting, and a step the app could not do was cut rather than faked. Where a film found a fault, it went to the people who own that app to be fixed, rather than being hidden on camera. Each film is on its product's page and on the Rutba YouTube channel.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;The Rutba Suite.&lt;/strong&gt; Every product in the suite, each with its film, prices and the apps it includes. &lt;a href="https://rutba.io/suites" rel="noopener noreferrer"&gt;Browse the suite&lt;/a&gt;&lt;/p&gt;

</description>
      <category>smallbusiness</category>
      <category>saas</category>
      <category>productivity</category>
      <category>business</category>
    </item>
    <item>
      <title>Rutba Vision: video surveillance for camera networks past the size one recorder copes with</title>
      <dc:creator>Ejaz Arain</dc:creator>
      <pubDate>Sat, 31 Oct 2026 15:29:37 +0000</pubDate>
      <link>https://dev.to/ejazarain/rutba-vision-video-surveillance-for-camera-networks-past-the-size-one-recorder-copes-with-106b</link>
      <guid>https://dev.to/ejazarain/rutba-vision-video-surveillance-for-camera-networks-past-the-size-one-recorder-copes-with-106b</guid>
      <description>&lt;p&gt;&lt;em&gt;First published on &lt;a href="https://rutba.io/blog/rutba-vision-camera-networks-past-the-size-one-recorder-copes-with" rel="noopener noreferrer"&gt;rutba.io&lt;/a&gt;.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;A handful of cameras is a product you buy. A hundred and fifty, writing terabytes a day, is an operations problem, and it fails the same ways each time. The disks fill and recording silently stops. The event database bloats until queries time out. A camera's clock drifts and its footage stops counting as evidence. And one box is the whole system, so one failure is an outage. Rutba Vision is built around those failures, and this is how.&lt;/p&gt;

&lt;p&gt;  &lt;iframe src="https://www.youtube.com/embed/BgM3jx6Ma6k" width="710" height="399"&gt;
  &lt;/iframe&gt;
&lt;/p&gt;

&lt;h2&gt;
  
  
  The same software at every size
&lt;/h2&gt;

&lt;p&gt;Every machine runs the same node agent, and a site's nodes take three roles. Edge nodes hold the cameras: the relay keeps the only connection to each camera and fans it out to the recorder, live view, detection and RTSP out. Analysis nodes run the AI and codec work, and are added as the analytics grow. The core runs the Vision Bus, the index, the API and the console. A branch with a handful of cameras runs all three roles on one machine, and a large warehouse spreads them over several. Nothing changes but the node count.&lt;/p&gt;

&lt;h2&gt;
  
  
  Sites stand alone, and HQ sees them together
&lt;/h2&gt;

&lt;p&gt;Each site records and analyses its own cameras and keeps its own footage. Sites dial out to a hub at HQ over TLS, so no site needs an inbound port. Each uplink keeps a 30-day outbox that drains in order when the line comes back, and moves on only when the hub acknowledges, so an outage of days loses nothing.&lt;/p&gt;

&lt;p&gt;The hub holds the sites' events, incidents, tracks, thumbnails and health in one store, and fetches footage from a site only when someone opens it. A regional hub can uplink to a national one, so the picture follows the way the organisation is run.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fexwwuywbbfdl72ipybcc.jpg" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fexwwuywbbfdl72ipybcc.jpg" alt="A hub at HQ above three sites: a warehouse with 150 cameras on five nodes, a plant with 40 cameras on one node and a branch with 8 cameras on one node. Metadata goes up and footage comes on demand." width="799" height="381"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Recording is the floor, not the feature
&lt;/h2&gt;

&lt;p&gt;The recorder copies each camera's own stream into self-contained fMP4 segments and hashes every file with SHA-256 as it writes. Nothing is decoded on the way, so recording costs packet handling rather than a GPU. Segments are written to a spool and renamed into place, so a crash never leaves half a segment in the catalogue, and each one plays on its own.&lt;/p&gt;

&lt;p&gt;Nothing above the recorder can stop it. Detection, AI, indexing and distribution can all be down, and footage is still written, catalogued and kept. Cameras are assigned to nodes rather than tied to one: a node silent for 15 seconds loses its cameras to the others, and recording resumes there.&lt;/p&gt;

&lt;p&gt;The everyday failures are dealt with where they happen. Each edge node's storage guard enforces retention and free space itself. Metadata is kept in one file per day, so expiring it is deleting a file and nothing bloats. Video is stamped in UTC as it arrives, so footage never depends on a camera's clock, and the clocks are still checked on a schedule.&lt;/p&gt;

&lt;h2&gt;
  
  
  AI where it earns its keep
&lt;/h2&gt;

&lt;p&gt;Detection is switched on camera by camera, each with its own stream, resolution and frame rate. A loading bay can watch for theft and loitering, while a corridor that only needs recording costs nothing but disk. Zones mark what matters, such as a doorway or a restricted aisle, and masks leave out a public pavement or a swaying tree. Flicker that never stops, such as an on-screen clock or a blinking LED, is learned and left out of motion without a mask.&lt;/p&gt;

&lt;p&gt;Inference runs through one runtime on a CPU, an Intel GPU or an NVIDIA card, and the default detectors are permissively licensed. Search takes plain language: ask for a red car at the north gate after 10pm yesterday, and it reads the time, the camera, the colour and the object out of the question. The AI runs on site, so the footage stays there.&lt;/p&gt;

&lt;h2&gt;
  
  
  Evidence that holds
&lt;/h2&gt;

&lt;p&gt;An evidential hold on a camera's footage is never deleted, whatever the retention setting or the pressure on the disks. An export is the segments joined without re-encoding, with a manifest of SHA-256 hashes saying who exported it and when. One command reports every camera's clock against the server, so whether the cameras are in sync is a question with an answer.&lt;/p&gt;

&lt;h2&gt;
  
  
  Feeds the systems you already run
&lt;/h2&gt;

&lt;p&gt;Video walls and other VMS pull RTSP from Rutba Vision instead of from the cameras. Incidents open tickets in ERP systems and service desks over signed webhooks, and building systems get doors and alarms over MQTT. Cameras are declared in one file rather than set up in forty clicks nobody can review.&lt;/p&gt;

&lt;p&gt;The bus, the relay, the recorder, the store, the search and the console are our own code, and each borrowed engine sits behind one module of ours, so replacing it means replacing that module.&lt;/p&gt;

&lt;h2&gt;
  
  
  On your site
&lt;/h2&gt;

&lt;p&gt;Rutba Vision is the one Rutba service you host yourself. Your team can run it on your site, we can run it for you with the footage still on your premises, or a chain of branches can each run their own nodes and join at a hub. Whichever it is, the hardware and the footage are yours.&lt;/p&gt;

&lt;p&gt;If you have run a large camera estate, which of these failures reached you first?&lt;/p&gt;

&lt;p&gt;Rutba Vision is a Tech Style product: &lt;a href="https://tech-style.co/product-rutba-vision" rel="noopener noreferrer"&gt;tech-style.co/product-rutba-vision&lt;/a&gt;. The Rutba service built on top of it is at &lt;a href="https://rutba.io/services/vision" rel="noopener noreferrer"&gt;rutba.io/services/vision&lt;/a&gt;.&lt;/p&gt;

</description>
      <category>computervision</category>
      <category>architecture</category>
      <category>security</category>
      <category>video</category>
    </item>
  </channel>
</rss>
