# data type

A data type defines a set of values or characters together with the operations that can be performed on them.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## What Is a Schema Change? Types, Risks, and How to Catch Them

DevFeed: [What Is a Schema Change? Types, Risks, and How to Catch Them](<https://devfeed.tech/articles/what-is-a-schema-change-types-risks-and-how-to-catch-them-145882.md>)

Original publisher: [Read original article](<https://montecarlo.ai/blog-what-is-a-schema-change>)

Author: Virna Sekuj

Published: 2026-11-19T17:23:51Z

Content type: article

Language: en

Sources: [Monte Carlo](<https://devfeed.tech/sources/monte-carlo.md>)

Topics: [schema design](<https://devfeed.tech/topics/schema-design.md>), [Data Quality](<https://devfeed.tech/topics/data-quality.md>), [Database Migration](<https://devfeed.tech/topics/database-migration.md>), [expand and contract migration](<https://devfeed.tech/topics/expand-and-contract-migration.md>), [data type](<https://devfeed.tech/topics/data-type.md>), [CI/CD](<https://devfeed.tech/topics/cicd.md>)

Tags: [agent-trust](<https://devfeed.tech/tags/agent-trust.md>), [agent-trust-glossary](<https://devfeed.tech/tags/agent-trust-glossary.md>), [agents](<https://devfeed.tech/tags/agents.md>), [ai](<https://devfeed.tech/tags/ai.md>), [breaking-schema-change](<https://devfeed.tech/tags/breaking-schema-change.md>), [changes](<https://devfeed.tech/tags/changes.md>), [chema-change](<https://devfeed.tech/tags/chema-change.md>), [dashboards](<https://devfeed.tech/tags/dashboards.md>), [data](<https://devfeed.tech/tags/data.md>), [database-schema-change](<https://devfeed.tech/tags/database-schema-change.md>), [dataset](<https://devfeed.tech/tags/dataset.md>), [glossary](<https://devfeed.tech/tags/glossary.md>), [pipelines](<https://devfeed.tech/tags/pipelines.md>), [schema](<https://devfeed.tech/tags/schema.md>), [schema-change](<https://devfeed.tech/tags/schema-change.md>), [schema-change-detection](<https://devfeed.tech/tags/schema-change-detection.md>), [schema-drift](<https://devfeed.tech/tags/schema-drift.md>), [schema-evolution](<https://devfeed.tech/tags/schema-evolution.md>), [warning](<https://devfeed.tech/tags/warning.md>)

### AI overview

Schema changes alter dataset structure, and uncoordinated changes can silently leave pipelines, dashboards, models, and AI agents returning incomplete or wrong results. Adding columns is usually safe; removing or renaming columns and changing types are usually breaking, though additions can also affect strict loaders or SELECT * queries. The source distinguishes individual schema changes from schema drift, which accumulates or arrives without coordination, and planned, versioned schema evolution. It describes three detection approaches: data contracts enforced in CI for data an organization controls, pipeline tests limited to anticipated checks, and automated monitoring for changes in all tables, including third-party sources. Safer management includes additive migrations, versioning breaking changes, checking lineage, naming production columns explicitly, and routing alerts to downstream owners. Lineage helps identify affected assets, including agents, so teams can triage a change.

### Source excerpt

A schema change is any change to the structure of a dataset, such as a column being added, removed, renamed, or given a new data type. Schema changes are a normal part of evolving software, but when they happen without warning, they break the pipelines, dashboards, models, and AI agents that depend on that data, often without throwing an error.

## 6 Sneaky Bugs That Were Hurting My Next.js Site's SEO

DevFeed: [6 Sneaky Bugs That Were Hurting My Next.js Site's SEO](<https://devfeed.tech/articles/6-sneaky-bugs-that-were-hurting-my-next-js-site-s-seo-140885.md>)

Original publisher: [Read original article](<https://hackernoon.com/6-sneaky-bugs-that-were-hurting-my-nextjs-sites-seo?source=rss>)

Author: Mr Sanzid

Published: 2026-11-18T14:59:29Z

Content type: article

Language: en

Sources: [HackerNoon](<https://devfeed.tech/sources/hackernoon.md>)

Topics: [Search engine optimization (SEO)](<https://devfeed.tech/topics/seo.md>), [Google Search](<https://devfeed.tech/topics/google-search.md>), [bugfixes](<https://devfeed.tech/topics/bugfixes.md>), [data type](<https://devfeed.tech/topics/data-type.md>), [Structured-data](<https://devfeed.tech/topics/structured-data.md>)

Tags: [2](<https://devfeed.tech/tags/2.md>), [2026](<https://devfeed.tech/tags/2026.md>), [3](<https://devfeed.tech/tags/3.md>), [added](<https://devfeed.tech/tags/added.md>), [admin](<https://devfeed.tech/tags/admin.md>), [after](<https://devfeed.tech/tags/after.md>), [aggregate](<https://devfeed.tech/tags/aggregate.md>), [aggregation](<https://devfeed.tech/tags/aggregation.md>), [all](<https://devfeed.tech/tags/all.md>), [also](<https://devfeed.tech/tags/also.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [api](<https://devfeed.tech/tags/api.md>), [bugs](<https://devfeed.tech/tags/bugs.md>), [cloudinary-image-urls](<https://devfeed.tech/tags/cloudinary-image-urls.md>), [data](<https://devfeed.tech/tags/data.md>), [debugging](<https://devfeed.tech/tags/debugging.md>), [fixed](<https://devfeed.tech/tags/fixed.md>), [images](<https://devfeed.tech/tags/images.md>), [mongodb](<https://devfeed.tech/tags/mongodb.md>), [mongoose-schema-validation](<https://devfeed.tech/tags/mongoose-schema-validation.md>), [next-js](<https://devfeed.tech/tags/next-js.md>), [nextjs](<https://devfeed.tech/tags/nextjs.md>), [nextjs-image-optimization](<https://devfeed.tech/tags/nextjs-image-optimization.md>), [site](<https://devfeed.tech/tags/site.md>), [structured](<https://devfeed.tech/tags/structured.md>), [structured-data](<https://devfeed.tech/tags/structured-data.md>), [technical-seo](<https://devfeed.tech/tags/technical-seo.md>), [web-development](<https://devfeed.tech/tags/web-development.md>)

### AI overview

A Next.js phone comparison site had several silent data and rendering bugs despite clean builds and logs. A one-image URL was split at commas embedded in Cloudinary URLs; the fix splits only at recognized URL boundaries. Twenty-five release dates stored as strings sorted behind Date values in MongoDB; converting them restored newest-first order. Tables required remark-gfm, and wide tables needed a scrollable wrapper. Google still treated redirected legacy URLs as canonical until recrawling, so a temporary sitemap prompted recrawls. Product JSON-LD was omitted when a phone had only a converted price, while official US list prices could qualify as offers. Vercel's free image-optimization quota caused uncached images to return 402; a custom loader delegated Cloudinary transformations to Cloudinary. The article also recommends keeping unknown specs distinct from yes/no and auditing real rendered pages and database types. These findings came from one site and are not claimed as universal.

### Source excerpt

Six silent bugs broke images, sorting, SEO, and structured data on a Next.js site. Here's how the developer discovered and fixed them.

## New in Symfony 8.2: Smarter Controller Arguments

DevFeed: [New in Symfony 8.2: Smarter Controller Arguments](<https://devfeed.tech/articles/new-in-symfony-8-2-smarter-controller-arguments-137827.md>)

Original publisher: [Read original article](<https://symfony.com/blog/new-in-symfony-8-2-smarter-controller-arguments>)

Author: Javier Eguiluz

Published: 2026-11-17T08:13:00Z

Content type: release

Language: en

Sources: [Symfony](<https://devfeed.tech/sources/symfony-blog.md>)

Topics: [Symfony](<https://devfeed.tech/topics/symfony.md>), [Parameter](<https://devfeed.tech/topics/parameter.md>), [data type](<https://devfeed.tech/topics/data-type.md>), [Dependency injection](<https://devfeed.tech/topics/dependency-injection.md>), [Authorization](<https://devfeed.tech/topics/authorization.md>), [console](<https://devfeed.tech/topics/console.md>)

Tags: [api](<https://devfeed.tech/tags/api.md>), [apis](<https://devfeed.tech/tags/apis.md>), [arguments](<https://devfeed.tech/tags/arguments.md>), [commands](<https://devfeed.tech/tags/commands.md>), [console](<https://devfeed.tech/tags/console.md>), [controller](<https://devfeed.tech/tags/controller.md>), [request](<https://devfeed.tech/tags/request.md>), [symfony](<https://devfeed.tech/tags/symfony.md>)

### AI overview

Symfony 8.2 extends argument resolution across controller actions and invokable commands. Union and intersection service types autowire when all members alias the same service; mixed unions/intersections require `#[Autowire]`. Query and header mapping can defer unconvertible values to other resolvers, including those that build dates or entities. For `#[IsGranted]`, earlier checks still run before payload parsing, while a later check using a mapped argument maps and validates it before voting; invalid data therefore produces a validation error, and voters now receive the mapped object. `#[MapEntity]` can return arrays via `findBy()` (empty when no matches), and its `expr` can be a closure, requiring PHP 8.5 for closures in attributes. `#[MapQueryString(key: ...)]` accepts JSON strings and returns 400 for malformed JSON. Payload mapping falls back to `+json` or `+xml` media type suffixes when no matching decoder format is available, while configured encoders remain in use.

### Source excerpt

Symfony can inject services, map request data into typed objects and fetch Doctrine entities based on the arguments of your controllers. Symfony 8.2 improves this feature to make it work in more cases, and some improvements apply to console commands too....

## I benchmarked Snowflake Postgres mirroring for two days. Here are the numbers.

DevFeed: [I benchmarked Snowflake Postgres mirroring for two days. Here are the numbers.](<https://devfeed.tech/articles/i-benchmarked-snowflake-postgres-mirroring-for-two-days-here-are-the-numbers-136382.md>)

Original publisher: [Read original article](<https://medium.com/snowflake/i-benchmarked-snowflake-postgres-mirroring-for-two-days-here-are-the-numbers-b50eba22b8de?source=rss----34b6daafc07---4>)

Author: Ondřej Blaha

Published: 2026-11-17T01:00:34Z

Content type: article

Language: en

Sources: [Snowflake Builders](<https://devfeed.tech/sources/snowflake-builders.md>)

Topics: [Snowflake streaming data architecture](<https://devfeed.tech/topics/snowflake-streaming-data-architecture.md>), [elt](<https://devfeed.tech/topics/elt.md>), [Transactions](<https://devfeed.tech/topics/transactions.md>), [data type](<https://devfeed.tech/topics/data-type.md>), [Apache Iceberg](<https://devfeed.tech/topics/apache-iceberg.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [arrays](<https://devfeed.tech/tags/arrays.md>), [batch](<https://devfeed.tech/tags/batch.md>), [cost](<https://devfeed.tech/tags/cost.md>), [data-engineering](<https://devfeed.tech/tags/data-engineering.md>), [gotchas](<https://devfeed.tech/tags/gotchas.md>), [impact](<https://devfeed.tech/tags/impact.md>), [latency](<https://devfeed.tech/tags/latency.md>), [load](<https://devfeed.tech/tags/load.md>), [mirroring](<https://devfeed.tech/tags/mirroring.md>), [numbers](<https://devfeed.tech/tags/numbers.md>), [oltp](<https://devfeed.tech/tags/oltp.md>), [operations](<https://devfeed.tech/tags/operations.md>), [pipeline](<https://devfeed.tech/tags/pipeline.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [postgresql-replication](<https://devfeed.tech/tags/postgresql-replication.md>), [refresh](<https://devfeed.tech/tags/refresh.md>), [replication](<https://devfeed.tech/tags/replication.md>), [snowflake](<https://devfeed.tech/tags/snowflake.md>), [source](<https://devfeed.tech/tags/source.md>), [two-days](<https://devfeed.tech/tags/two-days.md>)

### AI overview

On a Snowflake Postgres STANDARD_M instance in one AWS region, mirrored rows reached the near-real-time `TABLE$live` view in about 26 seconds at the median and 37 seconds at p90 across refresh intervals; the regular table could lag by up to one interval. Under the tested write load, moving from a 30-second to a 2-minute interval cut apply-task cost 73%, while small OLTP transactions showed little source impact and batch inserts into mirrored tables were 20-30% slower. The author recommends starting at 2 minutes, using `$live` for operational freshness, adding primary keys before mirroring, and committing bulk loads in chunks of up to 100,000 rows. Important limits include lossy mappings for some PostgreSQL types, `$changes` history being cleared by column changes, and `RESTART_MIRROR` triggering a full table copy. Results are from one instance size and region with limited repetitions, and are not an SLA.

### Source excerpt

Latency distributions, cost per refresh interval, impact on the source database, bulk loads and operations. Measured on the smallest instance that supports mirroring. Snowflake Postgres, managed PostgreSQL running inside a Snowflake account, has been generally available since 24 February 2026, and data mirroring into Snowflake followed on 15 October 2026. I didn't just want to see that it works. I wanted real numbers under a simulated load, so that I can tell clients how it actually behaves and compare the cost with what we had expected. The marketing says "seconds" and "sub-minute", and nobody had published a latency distribution, a cost per interval or the impact on the source database, so I spent two days measuring them. TL;DR Freshness: new rows show up in TABLE$live after ~26 s (median), ~37 s (p90), no matter whether the refresh interval is 30 seconds or 10 minutes. The table itself lags behind $live by up to one refresh interval. Cost: the serverless apply task cost 0.063 credits/h idle at a 30-second interval and 0.25 credits/h under a steady write load. Switching to 2 minutes cut the loaded cost by 73 %, to 10 minutes by 88 %. Source impact: small OLTP transactions barely notice the mirror. Batch inserts into a mirrored table were 20-30 % slower than into a non-mirrored table on the same instance. Operations: SUSPEND_MIRROR took 2.5-4.7 s under load, RESTART_MIRROR re-copies every table despite saying "soft", adding an 8M-row table to a running mirror took under a minute, and the replication slot survived every suspend/resume of the instance. Gotchas: numeric without precision becomes FLOAT, json/jsonb become TEXT, 2-D arrays become NULL, PostgreSQL refuses ADD COLUMN ... DEFAULT <volatile> on mirrored tables, any ADD, DROP or RENAME COLUMN wipes that table's $changes history, and tables without a primary key turn insert-only. Why this matters Every team that runs an application on Postgres and analytics in Snowflake owns a pipeline between the two. It is usu

## Unenumerbrated

DevFeed: [Unenumerbrated](<https://devfeed.tech/articles/unenumerbrated-136390.md>)

Original publisher: [Read original article](<https://thedailywtf.com/articles/unenumerbrated>)

Author: Ellis Morning

Published: 2026-11-16T06:30:00Z

Content type: article

Language: en

Sources: [The Daily WTF](<https://devfeed.tech/sources/the-daily-wtf.md>)

Topics: [enum](<https://devfeed.tech/topics/enum.md>), [data type](<https://devfeed.tech/topics/data-type.md>)

Tags: [client](<https://devfeed.tech/tags/client.md>), [count](<https://devfeed.tech/tags/count.md>), [database](<https://devfeed.tech/tags/database.md>), [enum](<https://devfeed.tech/tags/enum.md>), [feature-articles](<https://devfeed.tech/tags/feature-articles.md>), [has](<https://devfeed.tech/tags/has.md>), [index](<https://devfeed.tech/tags/index.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [payments](<https://devfeed.tech/tags/payments.md>), [queries](<https://devfeed.tech/tags/queries.md>), [string](<https://devfeed.tech/tags/string.md>)

### AI overview

A MySQL column defined as `enum('0', '1')` caused confusing query results because enum values are strings, while unquoted integer comparisons can refer to their 1-based enum indices. Thus `successful='1'` compares with the string value, whereas `successful=1` compares with the first enum index, `'0'`. The author recommends using descriptive enum labels such as `successful` and `unsuccessful` instead of numeric-looking labels. The excerpt also notes that some ORM or query-builder frameworks quote values and rely on MySQL's conversions, adding to the confusion.

### Source excerpt

Submitter Valts shares an enumerated mystery: This happened a few years ago (before COVID). A colleague called me over because he couldn't make sense of the results he was getting from some MySQL queries in MySQL Workbench. I don't remember the queries in particular, but let's say select * from payments where client_id=1234 showed 12 rows, all having the successful field set to 1. But when you selected select count(*) from payments where client_id=1234 and successful=1 you got back 0 rows. And this was reproducible on my machine, too. Yet in code similar queries worked just fine. After a lot of head-scratching and increasingly bizarre hypotheses, we finally figured out what was going on. In the far, far past, in dark days gone by, someone had defined the database field as enum('0', '1'). This SEEMS pretty rational ... until you start reading up how MySQL treats enums. Enums, it turns out, are all STRING values. But in queries you can use either their string values, or their integer indices, starting at 1. So in this case, the string "0" has the integer index of "1", and the string "1" has the integer index of "2". So select * from payments where successful='1' is quite different from select * from payments where successful=1. For extra confusion, under most other circumstances MySQL normally silently converts between strings and integers as needed. Some ORM/QueryBuilder frameworks even simply quote ALL values and let MySQL handle the conversions. Facepalms were had. In the aftermath, I blame the person who defined this field more than I blame MySQL for its bizzare enum conventions. If you're doing enums (which are generally a good thing), then give them proper names like successful and unsuccessful or something. Not 0 and 1. This code and this database table is still in use today, but luckily it's the only such gotcha in the entire system. Enums in the database are scarce and the rest of them are sane. [Advertisement] Keep all your packages and Docker containers in

## VellSSLH: Sound Type-Guided Selective Speculative Load Hardening for LLVM IR

DevFeed: [VellSSLH: Sound Type-Guided Selective Speculative Load Hardening for LLVM IR](<https://devfeed.tech/articles/vellsslh-sound-type-guided-selective-speculative-load-hardening-for-llvm-ir-136054.md>)

Original publisher: [Read original article](<https://arxiv.org/abs/2611.18463>)

Author: Swarn Priya

Published: 2026-11-16T05:00:00Z

Content type: article

Language: en

Sources: [arXiv: Cryptography and Security](<https://devfeed.tech/sources/arxiv-cryptography-and-security.md>)

Topics: [side channel](<https://devfeed.tech/topics/side-channel.md>), [compiler hardening](<https://devfeed.tech/topics/compiler-hardening.md>), [LLVM](<https://devfeed.tech/topics/llvm.md>), [Cryptography](<https://devfeed.tech/topics/cryptography.md>), [data type](<https://devfeed.tech/topics/data-type.md>)

Tags: [analysis](<https://devfeed.tech/tags/analysis.md>), [cryptographic](<https://devfeed.tech/tags/cryptographic.md>), [cs-cr](<https://devfeed.tech/tags/cs-cr.md>), [hardening](<https://devfeed.tech/tags/hardening.md>), [ir](<https://devfeed.tech/tags/ir.md>), [llvm](<https://devfeed.tech/tags/llvm.md>), [llvm-ir](<https://devfeed.tech/tags/llvm-ir.md>), [load](<https://devfeed.tech/tags/load.md>), [runtime](<https://devfeed.tech/tags/runtime.md>), [secret](<https://devfeed.tech/tags/secret.md>), [security](<https://devfeed.tech/tags/security.md>), [semantics](<https://devfeed.tech/tags/semantics.md>), [ssa](<https://devfeed.tech/tags/ssa.md>), [transformation](<https://devfeed.tech/tags/transformation.md>), [type](<https://devfeed.tech/tags/type.md>), [type-system](<https://devfeed.tech/tags/type-system.md>), [x25519](<https://devfeed.tech/tags/x25519.md>)

### AI overview

VellSSLH selectively inserts speculative load hardening in LLVM IR, using annotated Public and Secret inputs to infer which values may become secret during speculation and protect them where needed. Its extracted checker validates the IR; Rocq proofs establish speculative constant-time security for accepted programs and architectural behavior preservation for a reference transformation. Evaluated optimized variants are rechecked for security but are outside that preservation proof, and binary security still depends on backend and hardware assumptions. On 24 cryptographic entries tested on a bare-metal Intel processor, VellSSLH had 4.03% lower geometric-mean runtime than LLVM SLH (13 comparisons favored VellSSLH, eight favored LLVM SLH, and three were inconclusive). For X25519, it was 22.69% faster than LLVM SLH with 1.86% overhead over unprotected code; it also had 19.65% lower runtime than Ultimate SLH.

### Source excerpt

arXiv:2611.18463v1 Announce Type: new Abstract: Constant-time cryptographic programs written in C can still leak secrets during speculative execution. Mispredicted branches may allow instructions to access secret data and expose it through observable behavior. Speculative load hardening (SLH) addresses these leaks, but protecting values unnecessarily can introduce significant runtime overhead. We present VellSSLH, which selectively inserts speculative load hardening at LLVM IR. Programmers specify Public and Secret inputs in annotated C programs, and our analysis infers which values may become secret during speculation. The transformation then inserts misspeculation-flag operations and protections only where needed. VellSCT, our extracted checker, validates the resulting LLVM IR. We formalize speculative constant-time (SCT) security by extending Vellvm's LLVM semantics with speculative execution, attacker directives, and leakage observations. Our security type system reasons about SSA joins, symbolic values, poison, pointer provenance, and observable faults, and supports declared declassifications and trusted external services. In Rocq, we prove that programs accepted by the checker satisfy SCT, and that a reference hardening transformation preserves architectural behavior. Evaluated optimized variants are rechecked for SCT but are not covered by this preservation proof. Our mechanized guarantees apply at LLVM IR; security of the generated binary additionally depends on backend and hardware assumptions. We evaluate VellSSLH on 24 cryptographic entries on a bare-metal Intel processor. VellSSLH achieves 4.03% lower geometric-mean runtime than LLVM SLH, with 13 comparisons favoring VellSSLH, eight favoring LLVM SLH, and three inconclusive. For X25519, VellSSLH improves runtime by 22.69% over LLVM SLH with only 1.86% overhead over unprotected code. Compared with Ultimate SLH, VellSSLH achieves 19.65% lower runtime.

## CoordX Types: A Trustless, Swappable Type System for Shared Records

DevFeed: [CoordX Types: A Trustless, Swappable Type System for Shared Records](<https://devfeed.tech/articles/coordx-types-a-trustless-swappable-type-system-for-shared-records-133318.md>)

Original publisher: [Read original article](<https://arxiv.org/abs/2611.16128>)

Author: David Hyland-Wood, Rob Ewin

Published: 2026-11-13T05:00:00Z

Content type: article

Language: en

Sources: [arXiv: Cryptography and Security](<https://devfeed.tech/sources/arxiv-cryptography-and-security.md>)

Topics: [Programming Language Type Systems](<https://devfeed.tech/topics/programming-language-type-systems.md>), [schema design](<https://devfeed.tech/topics/schema-design.md>), [trust](<https://devfeed.tech/topics/trust.md>), [data type](<https://devfeed.tech/topics/data-type.md>)

Tags: [cs-cr](<https://devfeed.tech/tags/cs-cr.md>), [interpreter](<https://devfeed.tech/tags/interpreter.md>), [protocol](<https://devfeed.tech/tags/protocol.md>), [records](<https://devfeed.tech/tags/records.md>), [regular](<https://devfeed.tech/tags/regular.md>), [schemas](<https://devfeed.tech/tags/schemas.md>), [security](<https://devfeed.tech/tags/security.md>), [structure](<https://devfeed.tech/tags/structure.md>), [trust](<https://devfeed.tech/tags/trust.md>), [type-system](<https://devfeed.tech/tags/type-system.md>)

### AI overview

CoordX Types adds meaning to protocol-verified shared-record entries by specifying which entries count, how to interpret their positions, and what parties may or must do. Each type is a signed object fixed by its digest; parties evaluate it independently, without relying on a server, registry, or another party's software. Types identify the interpreter they require, allowing interpreters with different capabilities and designs to coexist in one record. The schema language constrains payloads to regular languages and entry structures to regular tree languages; its rules and computed values are total primitive-recursive functions, so evaluation always halts. The abstract says the paper compares the system with KQML, FIPA-ACL, and CBCL and relates it to language-theoretic security.

### Source excerpt

arXiv:2611.16128v1 Announce Type: new Abstract: The CoordX Protocol carries signed and encrypted entries between parties. It proves who wrote each entry and who had permission to write it. It does not say what an entry means. That task belongs above the protocol layer. This paper describes the CoordX type system, the layer that gives entries a meaning. A type is a short document that says how to read one part of a shared record: which entries count, what each position means, what a party may do there, and what a party must do next. The type system has two key properties. It is trustless: a type is an ordinary signed object fixed by its digest, and every party evaluates it for itself over entries that the CoordX Protocol has already verified. No party has to trust a server, a registry or another party's software. It is swappable: a type names the interpreter it is written for, so many interpreters, of different capabilities and designs, can be used side by side in one record. We describe how to write type schemas, and we define the expressive power of the schema language. Payloads form a regular language. Entry structure forms a regular tree language. Every rule and every computed value is a total function in the primitive recursive class, so evaluation always halts. We compare this with KQML, FIPA-ACL and CBCL, and we relate it to language-theoretic security.

## Rust 1.100 Released With The "Never" Type Finally Stable

DevFeed: [Rust 1.100 Released With The "Never" Type Finally Stable](<https://devfeed.tech/articles/rust-1-100-released-with-the-never-type-finally-stable-130854.md>)

Original publisher: [Read original article](<https://www.phoronix.com/news/Rust-1.100-Released>)

Author: Michael Larabel

Published: 2026-11-12T18:51:12Z

Content type: release

Language: en

Sources: [Phoronix](<https://devfeed.tech/sources/phoronix.md>)

Topics: [Rust](<https://devfeed.tech/topics/rust.md>), [data type](<https://devfeed.tech/topics/data-type.md>)

Tags: [apis](<https://devfeed.tech/tags/apis.md>), [cargo](<https://devfeed.tech/tags/cargo.md>), [dependencies](<https://devfeed.tech/tags/dependencies.md>), [dependency](<https://devfeed.tech/tags/dependency.md>), [desktop-linux](<https://devfeed.tech/tags/desktop-linux.md>), [feature](<https://devfeed.tech/tags/feature.md>), [improvements](<https://devfeed.tech/tags/improvements.md>), [linux-benchmarking](<https://devfeed.tech/tags/linux-benchmarking.md>), [linux-hardware-benchmarks](<https://devfeed.tech/tags/linux-hardware-benchmarks.md>), [linux-hardware-reviews](<https://devfeed.tech/tags/linux-hardware-reviews.md>), [linux-how-to](<https://devfeed.tech/tags/linux-how-to.md>), [linux-performance](<https://devfeed.tech/tags/linux-performance.md>), [linux-server-benchmarks](<https://devfeed.tech/tags/linux-server-benchmarks.md>), [malicious-packages](<https://devfeed.tech/tags/malicious-packages.md>), [min](<https://devfeed.tech/tags/min.md>), [open-source-graphics](<https://devfeed.tech/tags/open-source-graphics.md>), [phoronix](<https://devfeed.tech/tags/phoronix.md>), [phoronix-test-suite](<https://devfeed.tech/tags/phoronix-test-suite.md>), [programming-language](<https://devfeed.tech/tags/programming-language.md>), [rust](<https://devfeed.tech/tags/rust.md>), [stable](<https://devfeed.tech/tags/stable.md>), [type](<https://devfeed.tech/tags/type.md>), [ubuntu-benchmarks](<https://devfeed.tech/tags/ubuntu-benchmarks.md>), [ubuntu-hardware](<https://devfeed.tech/tags/ubuntu-hardware.md>)

### AI overview

Rust 1.100 stabilizes the never type (`!`), used for computations that never produce a value, after ten years and five failed stabilization attempts. It also stabilizes core parts of the Allocator API and adds Cargo reporting for unused dependencies, work to reduce cache collisions, and a `min-publish-age` setting that can delay accepting recently published dependencies. The excerpt gives three to five days as example cooldown periods, noting that malicious packages may be detected soon after publication. It mentions other API stabilizations and improvements without describing them.

### Source excerpt

Rust 1.100 is out today as the newest version of this popular programming language...

## I Knew the Terms. I Couldn't Explain Them.

DevFeed: [I Knew the Terms. I Couldn't Explain Them.](<https://devfeed.tech/articles/i-knew-the-terms-i-couldn-t-explain-them-130856.md>)

Original publisher: [Read original article](<https://thetshaped.dev/p/i-knew-the-terms-i-couldnt-explain>)

Author: Petar Ivanov

Published: 2026-11-12T11:01:59Z

Content type: article

Language: en

Sources: [The T-Shaped Dev](<https://devfeed.tech/sources/the-t-shaped-dev.md>)

Topics: [data type](<https://devfeed.tech/topics/data-type.md>), [await](<https://devfeed.tech/topics/await.md>), [architecture-components](<https://devfeed.tech/topics/architecture-components.md>)

Tags: [3](<https://devfeed.tech/tags/3.md>), [about](<https://devfeed.tech/tags/about.md>), [after](<https://devfeed.tech/tags/after.md>), [also](<https://devfeed.tech/tags/also.md>), [api](<https://devfeed.tech/tags/api.md>), [api-design](<https://devfeed.tech/tags/api-design.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [array](<https://devfeed.tech/tags/array.md>), [async](<https://devfeed.tech/tags/async.md>), [await](<https://devfeed.tech/tags/await.md>), [away](<https://devfeed.tech/tags/away.md>), [bug](<https://devfeed.tech/tags/bug.md>), [can](<https://devfeed.tech/tags/can.md>), [course](<https://devfeed.tech/tags/course.md>), [explain](<https://devfeed.tech/tags/explain.md>), [failed](<https://devfeed.tech/tags/failed.md>), [free](<https://devfeed.tech/tags/free.md>), [i](<https://devfeed.tech/tags/i.md>), [interview](<https://devfeed.tech/tags/interview.md>), [terms](<https://devfeed.tech/tags/terms.md>)

### AI overview

The course targets a gap between recognizing JavaScript concepts and explaining them aloud: learners answer each question before seeing a model answer. In its async example, `forEach` discards promises returned by async callbacks, so the loop finishes before the work; the excerpt also notes that async predicates passed to `filter` are a bug because promises are truthy. It offers `Promise.all(items.map(...))` to await parallel work or `for...of` for sequential work. The course is described as having 660+ questions and architecture scenarios across React, Node.js, TypeScript and system design, with answers tagged by level. The free sample includes three chapters, 76 questions, three architecture scenarios and chapter self-tests. These details come from the supplied excerpt.

### Source excerpt

The interview I almost failed, the course I built around it, and 3 free chapters you can try today.

## Introducing the Extractions API

DevFeed: [Introducing the Extractions API](<https://devfeed.tech/articles/introducing-the-extractions-api-129097.md>)

Original publisher: [Read original article](<https://openrouter.ai/blog/announcements/extractions-api/>)

Author: William Kofski

Published: 2026-11-10T00:00:00Z

Content type: release

Language: en

Sources: [OpenRouter](<https://devfeed.tech/sources/openrouter.md>)

Topics: [API](<https://devfeed.tech/topics/api.md>), [data type](<https://devfeed.tech/topics/data-type.md>), [Image](<https://devfeed.tech/topics/image.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [alpha](<https://devfeed.tech/tags/alpha.md>), [api](<https://devfeed.tech/tags/api.md>), [api-key](<https://devfeed.tech/tags/api-key.md>), [apis](<https://devfeed.tech/tags/apis.md>), [array](<https://devfeed.tech/tags/array.md>), [asset](<https://devfeed.tech/tags/asset.md>), [assets](<https://devfeed.tech/tags/assets.md>), [cloudflare](<https://devfeed.tech/tags/cloudflare.md>), [confidence](<https://devfeed.tech/tags/confidence.md>), [fields](<https://devfeed.tech/tags/fields.md>), [images](<https://devfeed.tech/tags/images.md>), [launch](<https://devfeed.tech/tags/launch.md>), [models](<https://devfeed.tech/tags/models.md>), [name](<https://devfeed.tech/tags/name.md>), [numbers](<https://devfeed.tech/tags/numbers.md>), [request](<https://devfeed.tech/tags/request.md>), [spans](<https://devfeed.tech/tags/spans.md>), [text](<https://devfeed.tech/tags/text.md>), [values](<https://devfeed.tech/tags/values.md>)

### AI overview

The alpha Extractions API lets you name typed fields and receive values from text, images, or PDFs. Cloudflare's Clairic supports all field types and up to four PNG/JPEG images; it can return spans, null probabilities and estimate distributions. ScaleDown Extract handles one PDF or image per request, but supports only text and list fields and returns confidence without spans or null probabilities. Mercury Decide reads text and returns text and list fields. A receipt example shows Clairic flagging a misspelled merchant name with lower spelling confidence, while other fields scored highly; a PDF example shows Extract returning a lower-confidence total. Route low-confidence values for review, and treat estimates by their distributions. The API is in alpha, so its shape may change.

### Source excerpt

A new API for pulling typed fields out of documents and images: name the fields, get values, spans and confidence back. Three models serve it at launch; on Cloudflare's Clairic the same request reads text and images and returns numbers, dates, lists, estimates and forecasts.

## Store and process large strings in Amazon Redshift SUPER columns

DevFeed: [Store and process large strings in Amazon Redshift SUPER columns](<https://devfeed.tech/articles/store-and-process-large-strings-in-amazon-redshift-super-columns-122142.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/big-data/store-and-process-large-strings-in-amazon-redshift-super-columns/>)

Author: Ritesh Sinha

Published: 2026-11-06T20:19:36Z

Content type: tutorial

Language: en

Sources: [AWS Big Data Blog](<https://devfeed.tech/sources/aws-big-data-blog.md>)

Topics: [Amazon Redshift](<https://devfeed.tech/topics/amazon-redshift.md>), [data type](<https://devfeed.tech/topics/data-type.md>), [data migrations](<https://devfeed.tech/topics/data-migrations.md>), [data-engineering](<https://devfeed.tech/topics/data-engineering.md>), [sql-database](<https://devfeed.tech/topics/sql-database.md>), [cloud-migration](<https://devfeed.tech/topics/cloud-migration.md>), [data lake](<https://devfeed.tech/topics/data-lake.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-redshift](<https://devfeed.tech/tags/amazon-redshift.md>), [amazon-s3](<https://devfeed.tech/tags/amazon-s3.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [arrays](<https://devfeed.tech/tags/arrays.md>), [data](<https://devfeed.tech/tags/data.md>), [data-type](<https://devfeed.tech/tags/data-type.md>), [data-warehouse](<https://devfeed.tech/tags/data-warehouse.md>), [data-workflows](<https://devfeed.tech/tags/data-workflows.md>), [json](<https://devfeed.tech/tags/json.md>), [migration](<https://devfeed.tech/tags/migration.md>), [semi](<https://devfeed.tech/tags/semi.md>), [simplify](<https://devfeed.tech/tags/simplify.md>), [store](<https://devfeed.tech/tags/store.md>), [strings](<https://devfeed.tech/tags/strings.md>), [structured-data](<https://devfeed.tech/tags/structured-data.md>), [type](<https://devfeed.tech/tags/type.md>)

### AI overview

Amazon Redshift's SUPER enhancements let you store individual strings in semi-structured data up to 16 million bytes, process long strings in memory, and use SUPER in databases with case-insensitive collation. Large-string support requires patch 206 or later and `enable_large_strings_opt_in` set to Yes; provisioned clusters must be rebooted, while Serverless uses a workgroup setting. Cast SUPER values to VARCHAR before applying string functions to avoid errors and truncation. The larger limit applies to in-memory operations, not VARCHAR(MAX) table columns; views, UDFs, and stored procedures created before enabling the setting must be recreated to use it. Case-insensitive database behavior can coexist with SUPER, with `COLLATE` specifying case sensitivity where needed. The text also recommends setting SUPER attribute case handling carefully, explicitly casting values, and aligning the large-string setting across data-sharing warehouses.

### Source excerpt

Storing large semi-structured data such as JSON and arrays in a data warehouse often means splitting or truncating your data. With PartiQL and the SUPER data type, Amazon Redshift is now equipped to handle these issues. In this post, we walk you through three key SUPER data type enhancements that simplify semi-structured data workflows and reduce common migration challenges.

## true or false in CSS

DevFeed: [true or false in CSS](<https://devfeed.tech/articles/true-or-false-in-css-121945.md>)

Original publisher: [Read original article](<https://blog.master.dev/true-or-false-in-css/>)

Author: Preethi Sam

Published: 2026-11-06T13:38:19Z

Content type: article

Language: en

Sources: [Master.dev Blog RSS Feed](<https://devfeed.tech/sources/master-dev-blog-rss-feed.md>)

Topics: [CSS](<https://devfeed.tech/topics/css.md>), [selectors](<https://devfeed.tech/topics/selectors.md>), [data type](<https://devfeed.tech/topics/data-type.md>), [Front end](<https://devfeed.tech/topics/frontend.md>), [typesafety](<https://devfeed.tech/topics/typesafety.md>), [Web Development](<https://devfeed.tech/topics/web-development.md>)

Tags: [blog-post](<https://devfeed.tech/tags/blog-post.md>), [boolean](<https://devfeed.tech/tags/boolean.md>), [boolean-type](<https://devfeed.tech/tags/boolean-type.md>), [conditional](<https://devfeed.tech/tags/conditional.md>), [container-queries](<https://devfeed.tech/tags/container-queries.md>), [css](<https://devfeed.tech/tags/css.md>), [css-custom-properties](<https://devfeed.tech/tags/css-custom-properties.md>), [css-variables](<https://devfeed.tech/tags/css-variables.md>), [custom-properties](<https://devfeed.tech/tags/custom-properties.md>), [data-type](<https://devfeed.tech/tags/data-type.md>), [has](<https://devfeed.tech/tags/has.md>), [html](<https://devfeed.tech/tags/html.md>), [inheritance](<https://devfeed.tech/tags/inheritance.md>), [logic](<https://devfeed.tech/tags/logic.md>), [performance](<https://devfeed.tech/tags/performance.md>), [property](<https://devfeed.tech/tags/property.md>), [scope](<https://devfeed.tech/tags/scope.md>), [style-queries](<https://devfeed.tech/tags/style-queries.md>)

### AI overview

CSS has no native boolean data type, but registered custom properties can emulate true/false flags for conditional styling. The excerpt registers `--isBackpack` and `--isDuffel` with syntax `"true | false"`, defaults them to `false`, and disables inheritance. `:has()` sets each flag on `:root` when its checkbox is checked; a named root container then exposes those values to style queries. The example uses `@container` conditions to hide products outside the selected categories, including the combined checkbox state. This replaces long checked/unchecked selector combinations with readable conditions. Registration is recommended in the excerpt for type safety, performance, and avoiding inheritance; a root container name is unnecessary when the queried property is on the direct parent or is inheritable.

### Source excerpt

CSS doesn't have a boolean type, but it does have the true and false keywords. Register a custom property that only accepts them, flip it with :has(), and container style queries turn messy :checked selector combinations into readable conditions.

## Oracle to ClickHouse: CDC, Batch & Type Mapping Guide

DevFeed: [Oracle to ClickHouse: CDC, Batch & Type Mapping Guide](<https://devfeed.tech/articles/oracle-to-clickhouse-cdc-batch-type-mapping-guide-121705.md>)

Original publisher: [Read original article](<https://estuary.dev/blog/oracle-to-clickhouse>)

Author: Seán Whelan

Published: 2026-11-06T12:26:57Z

Content type: tutorial

Language: en

Sources: [Estuary](<https://devfeed.tech/sources/estuary.md>)

Topics: [Oracle Database](<https://devfeed.tech/topics/oracle-database.md>), [Data pipelines](<https://devfeed.tech/topics/data-pipelines.md>), [data type](<https://devfeed.tech/topics/data-type.md>), [schema-evolution](<https://devfeed.tech/topics/schema-evolution.md>)

Tags: [batch](<https://devfeed.tech/tags/batch.md>), [cdc](<https://devfeed.tech/tags/cdc.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [guide](<https://devfeed.tech/tags/guide.md>), [mapping](<https://devfeed.tech/tags/mapping.md>), [oracle](<https://devfeed.tech/tags/oracle.md>), [type](<https://devfeed.tech/tags/type.md>)

### AI overview

For Oracle tables that change continuously, the excerpt recommends log-based CDC through LogMiner: it reads redo logs in SCN order, captures hard deletes, and resumes from a checkpoint if the required archived logs remain available. Setup requires ARCHIVELOG mode, supplemental logging, adequate log retention, and primary keys on replicated tables. ClickHouse stores changes as row versions; ReplacingMergeTree collapses versions by sorting key during merges, while queries may need FINAL before merges complete. The excerpt also explains tombstones and delete markers, key-change handling, type-mapping pitfalls (especially Oracle DATE and NUMBER), insert batching, and recovery limits. Method choice depends on needs: file exports and scheduled batch copies suit snapshots or reporting; Debezium with Kafka fits teams already running that stack, though its ClickHouse sink needs pre-created tables and does not support deletes directly; ClickPipes has no Oracle CDC source. Estuary is presented as a managed LogMiner capture and ClickHouse materialization, with configurable sync frequency and documented type limitations, including skipped LOB and binary columns.

### Source excerpt

Move data from Oracle to ClickHouse: map types, handle updates and deletes with ReplacingMergeTree, and compare 4 CDC and batch methods.

## Branded Phone Type

DevFeed: [Branded Phone Type](<https://devfeed.tech/articles/branded-phone-type-122149.md>)

Original publisher: [Read original article](<https://glebbahmutov.com/blog/branded-phone-type/>)

Author: Gleb Bahmutov

Published: 2026-11-06T05:00:00Z

Content type: article

Language: en

Sources: [Gleb Bahmutov](<https://devfeed.tech/sources/gleb-bahmutov.md>)

Topics: [typesafety](<https://devfeed.tech/topics/typesafety.md>), [data type](<https://devfeed.tech/topics/data-type.md>), [union types](<https://devfeed.tech/topics/union-types.md>), [Test-driven development](<https://devfeed.tech/topics/tdd.md>)

Tags: [000](<https://devfeed.tech/tags/000.md>), [2](<https://devfeed.tech/tags/2.md>), [3](<https://devfeed.tech/tags/3.md>), [blog](<https://devfeed.tech/tags/blog.md>), [blog-post](<https://devfeed.tech/tags/blog-post.md>), [cypress](<https://devfeed.tech/tags/cypress.md>), [phone](<https://devfeed.tech/tags/phone.md>), [process](<https://devfeed.tech/tags/process.md>), [repo](<https://devfeed.tech/tags/repo.md>), [test](<https://devfeed.tech/tags/test.md>), [testing](<https://devfeed.tech/tags/testing.md>), [type](<https://devfeed.tech/tags/type.md>), [typescript](<https://devfeed.tech/tags/typescript.md>)

### AI overview

The excerpt describes using TypeScript branded types to distinguish test and real phone numbers from ordinary strings. It defines test numbers as 10-digit strings starting with "000," and real numbers as 10-digit strings starting with neither "000" nor "555"; formatted numbers have a separate pattern. Assertion functions validate a string at runtime and let TypeScript treat it as the corresponding branded type, catching type mismatches statically while still allowing phone numbers to be used as strings. The excerpt mentions ambient `.d.ts` declarations for shared types and backend data validated on receipt.

### Source excerpt

In my previous blog post Branded Types I have shown a useful technique for repre

## This Week in Rails: November 6, 2026

DevFeed: [This Week in Rails: November 6, 2026](<https://devfeed.tech/articles/this-week-in-rails-november-6-2026-122152.md>)

Original publisher: [Read original article](<https://rubyonrails.org/2026/11/6/this-week-in-rails>)

Author: Greg

Published: 2026-11-06T00:00:00Z

Content type: news

Language: en

Sources: [Ruby on Rails](<https://devfeed.tech/sources/ruby-on-rails-compress-the-complexity-of-modern-web-apps.md>)

Topics: [Ruby on Rails](<https://devfeed.tech/topics/ruby-on-rails.md>), [Test automation](<https://devfeed.tech/topics/test-automation.md>), [data type](<https://devfeed.tech/topics/data-type.md>), [Image](<https://devfeed.tech/topics/image.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [active-record](<https://devfeed.tech/tags/active-record.md>), [activerecord](<https://devfeed.tech/tags/activerecord.md>), [added](<https://devfeed.tech/tags/added.md>), [aggregate](<https://devfeed.tech/tags/aggregate.md>), [aggregation](<https://devfeed.tech/tags/aggregation.md>), [aliases](<https://devfeed.tech/tags/aliases.md>), [apply](<https://devfeed.tech/tags/apply.md>), [apps](<https://devfeed.tech/tags/apps.md>), [association](<https://devfeed.tech/tags/association.md>), [batch](<https://devfeed.tech/tags/batch.md>), [batching](<https://devfeed.tech/tags/batching.md>), [bind](<https://devfeed.tech/tags/bind.md>), [cache](<https://devfeed.tech/tags/cache.md>), [cdn](<https://devfeed.tech/tags/cdn.md>), [changes](<https://devfeed.tech/tags/changes.md>), [checkout](<https://devfeed.tech/tags/checkout.md>), [connection-pool](<https://devfeed.tech/tags/connection-pool.md>), [connectionpool](<https://devfeed.tech/tags/connectionpool.md>), [news](<https://devfeed.tech/tags/news.md>), [rails](<https://devfeed.tech/tags/rails.md>)

### AI overview

Rails 8.0.5.2 and 8.1.4.1 were released as security updates addressing 21 issues. The excerpt also describes fixes across Active Record, Active Support, routing, caching, Active Storage, and Action Controller. Notable repairs restore bind values in `where!` and `having!`, correct relation merging and count behavior, and address association preloading with scopes, ordering, and subclasses. Cache changes keep local entries consistent with batch writes and deletes; `MemCacheStore#write_multi` now honors `unless_exist` and avoids double compression. Other changes improve URL generation, query serialization, test filtering, media metadata handling, and error reporting. New capabilities include comma-separated `RAILS_MASTER_KEY` values for key rotation and `checkout_wait.active_record` notifications for connection-pool waits. The excerpt lists many individual changes but does not provide the full release notes.

### Source excerpt

Hi, it's Greg, bringing you the latest changes in the Rails codebase. It was a busy week, with a lot of changes, so buckle up!

## WooCommerce Analytics with DuckDB

DevFeed: [WooCommerce Analytics with DuckDB](<https://devfeed.tech/articles/woocommerce-analytics-with-duckdb-119603.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/woocommerce-analytics-with-duckdb/>)

Author: Juan Arruti

Published: 2026-11-05T16:31:19Z

Content type: article

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [DuckDB](<https://devfeed.tech/topics/duckdb.md>), [read-replica](<https://devfeed.tech/topics/read-replica.md>), [Percona Server for MySQL](<https://devfeed.tech/topics/percona-server-for-mysql.md>), [data type](<https://devfeed.tech/topics/data-type.md>), [Data pipelines](<https://devfeed.tech/topics/data-pipelines.md>), [Percona](<https://devfeed.tech/topics/percona.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [columnar](<https://devfeed.tech/tags/columnar.md>), [columnar-databases](<https://devfeed.tech/tags/columnar-databases.md>), [database-trends](<https://devfeed.tech/tags/database-trends.md>), [databases](<https://devfeed.tech/tags/databases.md>), [duckdb](<https://devfeed.tech/tags/duckdb.md>), [innodb](<https://devfeed.tech/tags/innodb.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [percona](<https://devfeed.tech/tags/percona.md>), [percona-server-for-mysql](<https://devfeed.tech/tags/percona-server-for-mysql.md>), [storage-engine](<https://devfeed.tech/tags/storage-engine.md>), [woocommerce](<https://devfeed.tech/tags/woocommerce.md>)

### AI overview

Columnar DuckDB replicas can speed WooCommerce analytics while the primary MySQL InnoDB server handles transactions. In a test with 400,000 orders, asynchronous replication to AliSQL's DuckDB engine reduced database size from 7.3 GiB to 601 MiB. Built-in reports ran roughly 10-63 times faster, segmented reports 14-83 times faster, and all eleven reports from an unmodified customer analytics plugin were faster; a query against live order tables took about 4.1 seconds on DuckDB versus 4 minutes 16 seconds on InnoDB. The setup used a second copy of WooCommerce pointed at the replica because WordPress uses one database connection for analytics and store traffic. Results have caveats: some MySQL-specific SQL failed on DuckDB, text grouping can differ because DuckDB ignores column collations, and floating-point decimal handling caused sub-cent differences. DuckDB also exposes less monitoring detail. The article notes that Percona does not offer or support a production DuckDB build.

### Source excerpt

MySQL and DuckDB Unlike row-oriented databases, which store data for a single record sequentially on disk, favoring single-row lookups, columnar databases store all the values from a column contiguously in storage, allowing only the selected column to be read from disk. The default MySQL engine is InnoDB, which is ACID-compliant and great for OLTP (Online ... Continued The post WooCommerce Analytics with DuckDB appeared first on Percona.

## Polars vs pandas: What's the Difference?

DevFeed: [Polars vs pandas: What's the Difference?](<https://devfeed.tech/articles/polars-vs-pandas-what-s-the-difference-121070.md>)

Original publisher: [Read original article](<https://realpython.com/polars-vs-pandas/>)

Author: Ian Eyre

Published: 2026-11-05T14:00:00Z

Content type: tutorial

Language: en

Sources: [Real Python](<https://devfeed.tech/sources/real-python.md>)

Topics: [pandas](<https://devfeed.tech/topics/pandas.md>), [Data analysis](<https://devfeed.tech/topics/data-analysis.md>), [Python](<https://devfeed.tech/topics/python.md>), [data transformation](<https://devfeed.tech/topics/data-transformation.md>), [Data visualization](<https://devfeed.tech/topics/data-visualization.md>), [data type](<https://devfeed.tech/topics/data-type.md>), [parquet](<https://devfeed.tech/topics/parquet.md>), [pip](<https://devfeed.tech/topics/pip.md>)

Tags: [analysis](<https://devfeed.tech/tags/analysis.md>), [data](<https://devfeed.tech/tags/data.md>), [data-analysis](<https://devfeed.tech/tags/data-analysis.md>), [difference](<https://devfeed.tech/tags/difference.md>), [faster](<https://devfeed.tech/tags/faster.md>), [pandas](<https://devfeed.tech/tags/pandas.md>), [polars](<https://devfeed.tech/tags/polars.md>), [python](<https://devfeed.tech/tags/python.md>), [vs](<https://devfeed.tech/tags/vs.md>)

### AI overview

Polars and pandas can produce the same analysis, but their APIs and execution options differ. Polars uses expressions and contexts to build chained queries without mutating the original DataFrame; pandas supports both index-based operations and method chains. In the tutorial's grouped-sales benchmark, Polars and its LazyFrame ran faster than pandas, while pandas created its DataFrame faster. These timings vary by workload and setup; LazyFrames cannot handle every operation lazily, and streaming is limited to supported operations. Polars streaming processes data in chunks and may help when data exceeds memory, though combining batches can add time; pandas has no built-in streaming. The tutorial also shows `.to_pandas()` and `from_pandas()` conversions, Narwhals for a shared API that preserves the input backend, and built-in plotting through Altair in Polars and Matplotlib in pandas. Both target single-node use; the text points to PySpark for distributed processing.

### Source excerpt

Discover the key differences in Polars vs pandas to help you choose the right Python library for faster, more efficient data analysis.

## Get a load of Excel's new multi-value cells

DevFeed: [Get a load of Excel's new multi-value cells](<https://devfeed.tech/articles/get-a-load-of-excel-s-new-multi-value-cells-116360.md>)

Original publisher: [Read original article](<https://www.computerworld.com/article/4244163/get-a-load-of-excels-new-multi-value-cells.html>)

Author: Howard Wen

Published: 2026-11-04T11:00:00Z

Content type: article

Language: en

Sources: [Computerworld](<https://devfeed.tech/sources/computerworld.md>)

Topics: [Tool](<https://devfeed.tech/topics/tool.md>), [data type](<https://devfeed.tech/topics/data-type.md>), [structure](<https://devfeed.tech/topics/structure.md>), [Sequences](<https://devfeed.tech/topics/sequences.md>), [microsoft 365](<https://devfeed.tech/topics/microsoft-365.md>)

Tags: [array](<https://devfeed.tech/tags/array.md>), [beta-channel](<https://devfeed.tech/tags/beta-channel.md>), [cells](<https://devfeed.tech/tags/cells.md>), [data-structures](<https://devfeed.tech/tags/data-structures.md>), [edition-us](<https://devfeed.tech/tags/edition-us.md>), [excel](<https://devfeed.tech/tags/excel.md>), [language-en](<https://devfeed.tech/tags/language-en.md>), [list](<https://devfeed.tech/tags/list.md>), [microsoft-365](<https://devfeed.tech/tags/microsoft-365.md>), [microsoft-365-microsoft-excel-microsoft-office-office-suites-productivity-software](<https://devfeed.tech/tags/microsoft-365-microsoft-excel-microsoft-office-office-suites-productivity-software.md>), [microsoft-office](<https://devfeed.tech/tags/microsoft-office.md>), [nested](<https://devfeed.tech/tags/nested.md>), [office-suites](<https://devfeed.tech/tags/office-suites.md>), [preview](<https://devfeed.tech/tags/preview.md>), [productivity](<https://devfeed.tech/tags/productivity.md>), [productivity-software](<https://devfeed.tech/tags/productivity-software.md>), [scalar](<https://devfeed.tech/tags/scalar.md>), [storytype-tips](<https://devfeed.tech/tags/storytype-tips.md>)

### AI overview

Excel's preview feature lets a single cell hold structured lists, arrays, and nested arrays. Lists preserve separate text, number, date, and Boolean items; arrays hold row-and-column grids, and nested arrays can keep formula results such as TEXTSPLIT outputs inside a cell instead of spilling across the sheet and triggering #SPILL! errors. Create lists with Ctrl+J or Insert > List; braces can contain arrays. Direct references may spill the contents, while INDEX or field access can retrieve selected items. The feature is available on Windows and Mac to Microsoft 365 Insiders in the Beta Channel, but not Excel for the web or perpetual licenses. Limitations include reduced visibility during auditing, higher memory use and potentially slower calculations, compatibility errors in unsupported Excel versions, and limited support from legacy functions such as SUMIF, COUNTIF, and VLOOKUP. Compatibility Version 3 is required for most nested array calculations; preview behavior may change.

### Source excerpt

Until now, Microsoft Excel has followed a strict structural rule: each cell on a worksheet can hold only a single scalar value. While you can string together text using commas or write dynamic array formulas to spill values across adjacent rows and columns, the cell itself remains a single-item container. But Excel has evolved. A feature currently in preview lets you store multiple distinct, structured values within a single cell. Three new data structures can now be put inside a cell: A list maintains a sequence of independent values arranged in a single column. Unlike a plain text string separated by commas, an in-cell list treats each entry as a distinct data element. A list cell can hold a mix of text, numbers, dates, and Boolean values while preserving the native data type of each item. An array stores a grid of rows and columns inside one cell. A nested array allows formulas to generate and return arrays inside other arrays. This allows complex outputs to be confined within individual cells instead of trying to spill them across adjacent worksheet rows and columns. These in-cell data structures can simplify complex formula processing and reduce clutter on the worksheet. Availability: These in-cell data structures are available in Excel for Windows and Mac to members of the Microsoft 365 Insider program who are on the Beta Channel. Microsoft has not yet said when the features will begin rolling out to all M365 subscribers, and they are not supported in perpetual license versions (such as Office 2021 or Office 2024) or Excel for the web. Use cases Here are examples of how these three in-cell structures can be used. Multi-item categorizing Imagine categorizing your co-workers, who each have expertise in using up to five M365 software tools: Excel, OneNote, Outlook, PowerPoint, and Word. Or they specialize in selling any number of categories of products. To store this information on a spreadsheet, you could designate a column for each software tool or product cate

## SCRAMJet: An Ultra Low Latency JetClass-Scale Transformer for the HL-LHC Level-1 Trigger

DevFeed: [SCRAMJet: An Ultra Low Latency JetClass-Scale Transformer for the HL-LHC Level-1 Trigger](<https://devfeed.tech/articles/scramjet-an-ultra-low-latency-jetclass-scale-transformer-for-the-hl-lhc-level-1-trigger-114338.md>)

Original publisher: [Read original article](<https://arxiv.org/abs/2611.00086>)

Author: Aadeesh Sharma, Chang Sun, Lauri Laatu, Arianna Cox, Benedikt Maier, Alexander Tapper, Maria Spiropulu, Wayne Luk, Zhiqiang Que

Published: 2026-11-03T05:00:00Z

Content type: article

Language: en

Sources: [arXiv: Machine Learning](<https://devfeed.tech/sources/arxiv-machine-learning.md>)

Topics: [quantization](<https://devfeed.tech/topics/quantization.md>), [Real-time AI interactions](<https://devfeed.tech/topics/real-time-ai-interactions.md>), [data type](<https://devfeed.tech/topics/data-type.md>)

Tags: [area](<https://devfeed.tech/tags/area.md>), [arithmetic](<https://devfeed.tech/tags/arithmetic.md>), [attention](<https://devfeed.tech/tags/attention.md>), [budget](<https://devfeed.tech/tags/budget.md>), [circuit](<https://devfeed.tech/tags/circuit.md>), [cs-lg](<https://devfeed.tech/tags/cs-lg.md>), [dataset](<https://devfeed.tech/tags/dataset.md>), [distributed](<https://devfeed.tech/tags/distributed.md>), [fixed](<https://devfeed.tech/tags/fixed.md>), [fpgas](<https://devfeed.tech/tags/fpgas.md>), [hep-ex](<https://devfeed.tech/tags/hep-ex.md>), [latency](<https://devfeed.tech/tags/latency.md>), [logic](<https://devfeed.tech/tags/logic.md>), [low-latency](<https://devfeed.tech/tags/low-latency.md>), [model](<https://devfeed.tech/tags/model.md>), [operations](<https://devfeed.tech/tags/operations.md>), [optimization](<https://devfeed.tech/tags/optimization.md>), [physics-ins-det](<https://devfeed.tech/tags/physics-ins-det.md>), [projection](<https://devfeed.tech/tags/projection.md>), [quantization](<https://devfeed.tech/tags/quantization.md>), [resource](<https://devfeed.tech/tags/resource.md>), [transformer](<https://devfeed.tech/tags/transformer.md>), [trigger](<https://devfeed.tech/tags/trigger.md>)

### AI overview

SCRAMJet reports 71.4 ± 0.6% accuracy on ten-class JetClass using 0.157M multiply-accumulates, 6.1 accuracy points above the strongest published resource-constrained model at one-eighth its operations. For the LHC FPGA trigger setting, it replaces multi-head attention with a low-rank projection, uses learned per-parameter fixed-point quantization, and compiles to Verilog with distributed arithmetic optimization. It meets timing on a Virtex UltraScale+ VU13P at 147 ns using 25.7% of logic. The authors also identify "virtual channels": attention channels that still carry signal during training but receive zero bit-width and disappear from the compiled circuit, without the loss reflecting their removal. At a matched budget, flooring attention datalane width prevents this and gains 3.1 accuracy points.

### Source excerpt

arXiv:2611.00086v1 Announce Type: cross Abstract: Level-1 Triggers at the LHC classify collisions within a few microseconds on FPGAs, where a network is a fully unrolled circuit whose cost is area rather than time. We present SCRAMJet, a transformer encoder that replaces multi-head attention with a low-rank projection, trains under per-parameter learned fixed-point quantization, and compiles to Verilog with distributed arithmetic optimization. On the ten-class JetClass dataset it reaches $71.4 \pm 0.6\%$ accuracy with 0.157M multiply-accumulates, 6.1 accuracy points above the strongest published resource-constrained model at an eighth of the operations, and meets timing on a Virtex UltraScale+ VU13P at 147 ns using 25.7% of the logic. We also show that resource-aware training silently removes attention channels: one whose learned bit-width reaches zero still carries signal during training but is absent from the compiled circuit, so the loss never sees it go. We call these virtual channels, and a floor on the attention datalane that prevents them is worth 3.1 accuracy points at matched budget. Code and trained checkpoints are available at https://github.com/Aaddy-1/hgq-jetformer.

## Improving Partition Pruning for Cross-Type Joins in Tanzu Greenplum

DevFeed: [Improving Partition Pruning for Cross-Type Joins in Tanzu Greenplum](<https://devfeed.tech/articles/improving-partition-pruning-for-cross-type-joins-in-tanzu-greenplum-112925.md>)

Original publisher: [Read original article](<https://blogs.vmware.com/tanzu/improving-partition-pruning-for-cross-type-joins-in-tanzu-greenplum/>)

Author: VMware Community

Published: 2026-11-02T09:38:00Z

Content type: article

Language: en

Sources: [VMware](<https://devfeed.tech/sources/vmware-blogs.md>)

Topics: [database-optimization](<https://devfeed.tech/topics/database-optimization.md>), [table-partitioning](<https://devfeed.tech/topics/table-partitioning.md>), [data type](<https://devfeed.tech/topics/data-type.md>), [Optimization](<https://devfeed.tech/topics/optimization.md>), [typesafety](<https://devfeed.tech/topics/typesafety.md>)

Tags: [constraint](<https://devfeed.tech/tags/constraint.md>), [cross](<https://devfeed.tech/tags/cross.md>), [framework](<https://devfeed.tech/tags/framework.md>), [greenplum](<https://devfeed.tech/tags/greenplum.md>), [inference](<https://devfeed.tech/tags/inference.md>), [modern-apps](<https://devfeed.tech/tags/modern-apps.md>), [partition](<https://devfeed.tech/tags/partition.md>), [vmware-tanzu-greenplum](<https://devfeed.tech/tags/vmware-tanzu-greenplum.md>)

### AI overview

GPORCA can now infer constraints through casts and other deterministic single-column expressions, allowing partition pruning for cross-type joins. In the example, a nanosecond timestamp filter is propagated through an implicit cast to a microsecond partition key, so the query can skip 364 of 366 daily partitions instead of scanning all of them. The change adds expression mapping, recursive tracing to base columns, and datetime type alignment; strict type compatibility checks are intended to prevent incorrect substitutions. Expression constraint handling is gated by the `optimizer_expression_constraints` GUC for incremental adoption, while the type correctness fixes are always active. The post says the optimization avoids query rewrites and manual redundant filters.

### Source excerpt

This technical post on VMware Tanzu Greenplum walks through the changes to GPORCA's constraint derivation framework that make partition pruning and predicate inference work for cross-type joins. The post Improving Partition Pruning for Cross-Type Joins in Tanzu Greenplum appeared first on Tanzu. The post Improving Partition Pruning for Cross-Type Joins in Tanzu Greenplum appeared first on VMware Blogs.

## Prompt Less, Infer More: Static Analysis-Guided LLM Type Annotation for Python

DevFeed: [Prompt Less, Infer More: Static Analysis-Guided LLM Type Annotation for Python](<https://devfeed.tech/articles/prompt-less-infer-more-static-analysis-guided-llm-type-annotation-for-python-112679.md>)

Original publisher: [Read original article](<https://arxiv.org/abs/2610.41617>)

Author: Wonseok Oh, Michael Pradel, Hakjoo Oh

Published: 2026-11-02T05:00:00Z

Content type: article

Language: en

Sources: [arXiv: Software Engineering](<https://devfeed.tech/sources/arxiv-software-engineering.md>)

Topics: [data type](<https://devfeed.tech/topics/data-type.md>), [Static code analysis](<https://devfeed.tech/topics/static-code-analysis.md>), [Python](<https://devfeed.tech/topics/python.md>), [Large Language Model](<https://devfeed.tech/topics/llm.md>)

Tags: [abstract](<https://devfeed.tech/tags/abstract.md>), [annotation](<https://devfeed.tech/tags/annotation.md>), [annotations](<https://devfeed.tech/tags/annotations.md>), [arxiv](<https://devfeed.tech/tags/arxiv.md>), [coding-assistant](<https://devfeed.tech/tags/coding-assistant.md>), [context](<https://devfeed.tech/tags/context.md>), [cost](<https://devfeed.tech/tags/cost.md>), [cost-savings](<https://devfeed.tech/tags/cost-savings.md>), [cs-se](<https://devfeed.tech/tags/cs-se.md>), [efficiency](<https://devfeed.tech/tags/efficiency.md>), [exploit](<https://devfeed.tech/tags/exploit.md>), [frontier](<https://devfeed.tech/tags/frontier.md>), [frontier-model](<https://devfeed.tech/tags/frontier-model.md>), [gpt](<https://devfeed.tech/tags/gpt.md>), [gpt-5-5](<https://devfeed.tech/tags/gpt-5-5.md>), [inference](<https://devfeed.tech/tags/inference.md>), [llm](<https://devfeed.tech/tags/llm.md>), [prompt](<https://devfeed.tech/tags/prompt.md>), [python](<https://devfeed.tech/tags/python.md>), [static-analysis](<https://devfeed.tech/tags/static-analysis.md>), [type](<https://devfeed.tech/tags/type.md>)

### AI overview

SALT combines static analysis with LLM inference to annotate missing Python types: it resolves some types statically, prioritizes which cases need LLM queries, and supplies concise type-aware context. In evaluations on 12 real-world Python projects, it achieved the best accuracy among the systems evaluated and reduced estimated LLM costs by up to 78.5% versus a strong coding-assistant baseline. The abstract reports similar cost savings with GPT-5.5; it does not provide specific accuracy figures or further evaluation details.

### Source excerpt

arXiv:2610.41617v1 Announce Type: new Abstract: Type annotations improve the maintainability and reliability of Python programs, but many real-world projects remain under-annotated because manual annotation is time-consuming and error-prone. Recent neural and LLM-based type inference systems can recover missing annotations, yet they often trade accuracy for efficiency. Existing approaches often fail to exploit project-wide type evidence, or do so inefficiently through unnecessary model calls and noisy prompts. We present SALT, an LLM-based type inference system guided by static analysis. SALT integrates static analysis with LLM inference to resolve types statically, prioritize LLM queries, and construct concise type-aware context. To demonstrate the effectiveness of SALT, we evaluated it on 12 real-world Python projects. SALT achieves the best accuracy among the evaluated systems and reduces estimated LLM cost by up to 78.5% compared with a strong coding-assistant baseline. It also shows similar cost savings with the frontier model GPT-5.5, demonstrating that SALT remains effective with strong LLMs.

## Well-Typed ComfyUI Cannot Go Wrong: Gradual Refinement Types for Generative-AI Workflow Graphs

DevFeed: [Well-Typed ComfyUI Cannot Go Wrong: Gradual Refinement Types for Generative-AI Workflow Graphs](<https://devfeed.tech/articles/well-typed-comfyui-cannot-go-wrong-gradual-refinement-types-for-generative-ai-workflow-graphs-107360.md>)

Original publisher: [Read original article](<https://arxiv.org/abs/2610.37673>)

Author: Pingchuan Ma, Zhantong Xue, Hui Li, Zhaoyu Wang, Yuguang Zhou, Shuai Wang, Xiaoqin Zhang

Published: 2026-10-30T04:00:00Z

Content type: article

Language: en

Sources: [arXiv: Software Engineering](<https://devfeed.tech/sources/arxiv-software-engineering.md>)

Topics: [comfyui](<https://devfeed.tech/topics/comfyui.md>), [data type](<https://devfeed.tech/topics/data-type.md>), [quantization](<https://devfeed.tech/topics/quantization.md>), [Generative AI](<https://devfeed.tech/topics/generative-ai.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [ai-workflow](<https://devfeed.tech/tags/ai-workflow.md>), [ai-workflows](<https://devfeed.tech/tags/ai-workflows.md>), [comfyui](<https://devfeed.tech/tags/comfyui.md>), [compatibility](<https://devfeed.tech/tags/compatibility.md>), [component](<https://devfeed.tech/tags/component.md>), [composition](<https://devfeed.tech/tags/composition.md>), [control](<https://devfeed.tech/tags/control.md>), [crashes](<https://devfeed.tech/tags/crashes.md>), [cs-mm](<https://devfeed.tech/tags/cs-mm.md>), [cs-pl](<https://devfeed.tech/tags/cs-pl.md>), [cs-se](<https://devfeed.tech/tags/cs-se.md>), [diagnostics](<https://devfeed.tech/tags/diagnostics.md>), [execution](<https://devfeed.tech/tags/execution.md>), [generative](<https://devfeed.tech/tags/generative.md>), [generative-ai](<https://devfeed.tech/tags/generative-ai.md>), [github](<https://devfeed.tech/tags/github.md>), [github-repository](<https://devfeed.tech/tags/github-repository.md>), [graph](<https://devfeed.tech/tags/graph.md>), [graphs](<https://devfeed.tech/tags/graphs.md>), [issue-tracker](<https://devfeed.tech/tags/issue-tracker.md>), [types](<https://devfeed.tech/tags/types.md>), [workflow](<https://devfeed.tech/tags/workflow.md>)

### AI overview

ComfyUI's validator can accept workflow connections that violate semantic requirements among model families, tensor geometry, control modalities, and quantization, leading to runtime failures or silent errors. A classification of repository reports found such failures in 8% of issue reports and 21% of issue-tracker runtime failures; 32% were silent. The paper presents ComfyTy, which uses reusable node schemas to express accepted and produced properties, combines them into graph constraints, and checks for incompatibilities before execution. It detected 66.4% of confirmed injected faults admitted by ComfyUI's validator. Across real workflows, it reported no false alarms on 765 known-good workflows and detected 67% of 108 reconstructed failures. In a 10-person study, diagnostics improved fault-localization accuracy from 35.0% to 87.5% and repair accuracy from 30.0% to 62.5%.

### Source excerpt

arXiv:2610.37673v1 Announce Type: cross Abstract: Generative-AI workflows are programs assembled from independently developed models and operators. Their correctness depends on relationships among model families, tensor geometry, control modalities, and quantization levels. In ComfyUI, these relationships can be violated even when every connection is accepted by its validator, causing expensive runtime crashes or silent failures. To measure how often such semantic composition failures occur, we classify all 8,766 issues and 1,368 discussion threads of ComfyUI's GitHub repository with an LLM, checked for cross-model agreement. They account for 8\% of issue reports and 21\% of issue-tracker runtime failures, and 32\% of them are silent. Because execution cannot reliably reveal those failures, we present ComfyTy, a gradual refinement type system that checks component compatibility before execution as a compositional property of workflow graphs. Each node declares a reusable schema that states which model families, sizes, modalities, and quantizations it accepts and produces. Wiring nodes together combines their schemas into constraints, which ComfyTy solves to find and report incompatibilities. To evaluate ComfyTy, we first inject faults into official ComfyUI workflows and execute every resulting graph. ComfyTy detects 66.4\% of the confirmed injected faults, all of which ComfyUI's own validator admits. On real workflows across more model families, it raises no false alarm on 765 known-good workflows and detects 67\% of 108 failures rebuilt from user reports. Finally, in a user study with 10 participants, its diagnostics raise fault-localization accuracy on faulty workflows from 35.0\% to 87.5\% and repair accuracy from 30.0\% to 62.5\%.

## Creating a Typescript union, while also having runtime access to the values

DevFeed: [Creating a Typescript union, while also having runtime access to the values](<https://devfeed.tech/articles/creating-a-typescript-union-while-also-having-runtime-access-to-the-values-106007.md>)

Original publisher: [Read original article](<https://www.jvt.me/posts/2026/10/28/typescript-const-array/>)

Author: Jamie Tanna

Published: 2026-10-28T12:17:12Z

Content type: article

Language: en

Sources: [Jamie Tanna](<https://devfeed.tech/sources/articles-on-jamie-tanna-software-engineer.md>)

Topics: [union types](<https://devfeed.tech/topics/union-types.md>), [data type](<https://devfeed.tech/topics/data-type.md>)

Tags: [blogumentation](<https://devfeed.tech/tags/blogumentation.md>), [documentation](<https://devfeed.tech/tags/documentation.md>), [example](<https://devfeed.tech/tags/example.md>), [forgejo](<https://devfeed.tech/tags/forgejo.md>), [function](<https://devfeed.tech/tags/function.md>), [git](<https://devfeed.tech/tags/git.md>), [github](<https://devfeed.tech/tags/github.md>), [gitlab](<https://devfeed.tech/tags/gitlab.md>), [hosting](<https://devfeed.tech/tags/hosting.md>), [important](<https://devfeed.tech/tags/important.md>), [parameter](<https://devfeed.tech/tags/parameter.md>), [pattern](<https://devfeed.tech/tags/pattern.md>), [platform](<https://devfeed.tech/tags/platform.md>), [platforms](<https://devfeed.tech/tags/platforms.md>), [reference](<https://devfeed.tech/tags/reference.md>), [renovate](<https://devfeed.tech/tags/renovate.md>), [runtime](<https://devfeed.tech/tags/runtime.md>), [typescript](<https://devfeed.tech/tags/typescript.md>), [union](<https://devfeed.tech/tags/union.md>), [values](<https://devfeed.tech/tags/values.md>)

### AI overview

A TypeScript string union constrains values at compile time, but does not provide a runtime list to iterate over or use when generating documentation. The excerpt shows defining the values once in an array with `as const`, then deriving the union type as `(typeof Platforms)[number]`. This makes the values available at runtime while retaining the `Platform` type for function parameters. The example uses `github`, `gitlab` and `forgejo`; the excerpt does not elaborate on other approaches.

### Source excerpt

I very regularly end up writing this pattern - primarily in Renovate's code - so thought I'd write it up as a form of blogumentation, so I can refer back to it in the future. (This example uses concepts from the Renovate codebase, but does not take any code from it) For instance, let's say that you have a known union of big Git-hosting platforms - github, gitlab and forgejo. If you wanted to make sure that a given function parameter could only include them, you'd write i.e. export type Platform = 'github' | 'gitlab' | 'forgejo'; Normally this would be sufficient for usage, and nothing else is needed. But if you then want to be able to reference the ?? - for instance, as part of generating documentation - then you need some way of accessing each of these values at runtime. This leads us to: export const Platforms = [ 'github', 'gitlab', 'forgejo', // no shade to other platforms ] as const; // `as const` is important! export type Platform = (typeof Platforms)[number]; Now, you can access Platforms at runtime (and loop through them), while also enforcing the use of Platform as a function parameter.

## OpenTofu 1.13 Lets Module Authors Reduce Unknown Values at Plan Time

DevFeed: [OpenTofu 1.13 Lets Module Authors Reduce Unknown Values at Plan Time](<https://devfeed.tech/articles/opentofu-1-13-lets-module-authors-reduce-unknown-values-at-plan-time-100780.md>)

Original publisher: [Read original article](<https://www.infoq.com/news/2026/10/opentofu-1-13-unknown-values/>)

Author: Mark Silvester

Published: 2026-10-26T21:26:00Z

Content type: news

Language: en

Sources: [InfoQ](<https://devfeed.tech/sources/infoq.md>)

Topics: [opentofu](<https://devfeed.tech/topics/opentofu.md>), [data type](<https://devfeed.tech/topics/data-type.md>), [Null-Safety](<https://devfeed.tech/topics/null-safety.md>), [modules](<https://devfeed.tech/topics/modules.md>), [versioning](<https://devfeed.tech/topics/versioning.md>)

Tags: [architecture-design](<https://devfeed.tech/tags/architecture-design.md>), [cloud-native-computing-foundation](<https://devfeed.tech/tags/cloud-native-computing-foundation.md>), [development](<https://devfeed.tech/tags/development.md>), [devops](<https://devfeed.tech/tags/devops.md>), [error](<https://devfeed.tech/tags/error.md>), [functions](<https://devfeed.tech/tags/functions.md>), [infrastructure-as-code](<https://devfeed.tech/tags/infrastructure-as-code.md>), [module](<https://devfeed.tech/tags/module.md>), [news](<https://devfeed.tech/tags/news.md>), [opentofu](<https://devfeed.tech/tags/opentofu.md>), [opentofu-1-13-unknown-values](<https://devfeed.tech/tags/opentofu-1-13-unknown-values.md>), [plan](<https://devfeed.tech/tags/plan.md>), [terraform](<https://devfeed.tech/tags/terraform.md>), [values](<https://devfeed.tech/tags/values.md>)

### AI overview

OpenTofu 1.13 adds `convert` and `assumenotnull` so module authors can give the planner type and non-null guarantees for otherwise unknown values. This can resolve `count` or `for_each` instance decisions while resource attributes remain unknown until apply. Authors must ensure the values satisfy those guarantees; violations are reported during apply. Terraform shipped the equivalent `convert` function first, and OpenTofu chose to match its design. The release also introduces opt-in experimental lint rules and Symbol Libraries, which cannot directly access resources, data sources or provider functions. It removes WinRM support from `remote-exec` and `file`; changes to `base64gzip` may trigger resource updates despite equivalent decompressed output. The excerpt also reports Windows ARM64 packages, a macOS 13 minimum, and 1.13.2 security fixes.

### Source excerpt

OpenTofu 1.13 adds convert and assume... functions that let module authors give the planner type and value hints for unknown values, so more expressions resolve during tofu plan. If a value unknown during planning later violates a guarantee, OpenTofu reports an error during apply. By Mark Silvester

[Next page](<https://devfeed.tech/topics/data-type.md?cursor=WyIyMDI2LTEwLTI2VDIxOjI2OjAwKzAwOjAwIiwgIjA4NjIwZDQ1LWNkNjQtNGZhMS04NmJhLTRiYWI5ODY3MGMwMSJd>)