# functions Published articles for functions. This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles. ## "Regex for Rows": Simplifying Pattern Detection in SQL with MATCH\_RECOGNIZE DevFeed: ["Regex for Rows": Simplifying Pattern Detection in SQL with MATCH\_RECOGNIZE]() Original publisher: [Read original article]() Author: Kent Marten; Sergei Fedorov Published: 2026-09-16T17:14:05Z Content type: tutorial Language: en Sources: [Databricks]() Topics: [SQL](), [databricks](), [Cybersecurity](), [Security & Privacy]() Tags: [count](), [cybersecurity](), [databricks](), [failed](), [false-positives](), [functions](), [login](), [partition](), [product](), [real-time](), [regex](), [sql](), [window-functions]() ### AI overview This tutorial explains how Databricks supports SQL MATCH_RECOGNIZE for detecting ordered event patterns. It shows how the clause can simplify sequence detection, including identifying repeated login failures followed by a successful login, compared with complex SQL queries and window functions. ### Source excerpt Imagine you work in cybersecurity and you have a table that tracks login attempts... ## On-Demand Masked Sessions with Twilio Proxy, Voice and Serverless DevFeed: [On-Demand Masked Sessions with Twilio Proxy, Voice and Serverless]() Original publisher: [Read original article]() Author: Leroy Chan Published: 2026-09-16T00:00:00Z Content type: tutorial Language: en Sources: [Twilio Blog]() Topics: [proxy](), [sessions](), [communications](), [Serverless](), [Back end](), [functions](), [callback]() Tags: [backend](), [callback](), [communications](), [developer-insights](), [functions](), [proxy](), [ridesharing](), [serverless](), [sessions](), [state](), [voice](), [workflow]() ### AI overview This tutorial explains how to build an on-demand masked calling system with Twilio Proxy, Twilio Voice, and Twilio Serverless Functions. It uses a reserved Twilio number, IVR-based tracking-code collection, a backend lookup, and a two-bounce workflow with Twilio Sync to create private sessions dynamically when phone numbers cannot be pre-associated. ### Source excerpt Manage marketplace communications without pre-associating numbers. Use Twilio Proxy, Voice, and Serverless to build dynamic, Just-in-Time masked session calls. ## Build a support chatbot with Appwrite Functions and VectorsDB DevFeed: [Build a support chatbot with Appwrite Functions and VectorsDB]() Original publisher: [Read original article]() Author: Atharva Deosthale Published: 2026-09-10T00:00:00Z Content type: tutorial Language: en Sources: [Appwrite Blog]() Topics: [Appwrite](), [Chat Bot](), [Retrieval-Augmented Generation](), [Embeddings](), [React](), [SDKs](), [Node.js]() Tags: [api](), [build](), [chat](), [deploy](), [embedding](), [functions](), [node-js](), [rag](), [react](), [retrieval](), [support](), [tutorials]() ### AI overview This tutorial builds Harbor Help, a support chatbot for a fictional project-management product. It uses Appwrite VectorsDB to store help-center article embeddings, an Appwrite Function to retrieve relevant excerpts and generate answers through OpenRouter, and Appwrite Sites to host a React interface. The chatbot uses retrieval-augmented generation and can refuse questions outside the help center. ### Source excerpt Seed a help center, retrieve relevant articles with VectorsDB, and answer customer questions through an Appwrite Function. Deploy the chat interface on Appwrite Sites. ## Estimating branch probabilities DevFeed: [Estimating branch probabilities]() Original publisher: [Read original article]() Published: 2026-08-09T07:00:00Z Content type: article Language: en Sources: [MaskRay]() Topics: [LLVM]() Tags: [algorithm](), [analysis](), [functions](), [graph](), [llvm](), [structure]() ### AI overview This post explains how LLVM estimates branch probabilities when profile data is unavailable. It examines the heuristic that classifies control-flow blocks and successor paths using unreachable, cold, unwinding, and loop information, and presents a standalone reimplementation. ### Source excerpt LLVM's BranchProbabilityInfo assigns every multi-successor terminator a probability distribution over its successors. This post describes the estimation used when no profile is available and reimplements it as a standalone program. ## Lambda-powered functions land in OTTL DevFeed: [Lambda-powered functions land in OTTL]() Original publisher: [Read original article]() Author: OpenTelemetry Authors; Docs CC BY Published: 2026-07-22T20:04:49Z Content type: release Language: en Sources: [Blog on OpenTelemetry]() Topics: [OpenTelemetry](), [telemetry](), [sensitive data](), [data]() Tags: [collection-operations](), [experimental](), [functions](), [lambda](), [opentelemetry](), [pipelines](), [release](), [sensitive-data](), [telemetry](), [transformation]() ### AI overview OpenTelemetry Collector Contrib v0.157.0 introduces lambda expressions to OTTL, enabling reusable inline logic in generic higher-order functions. The release adds eight experimental functions for collection transformations, including filtering, mapping, finding, reducing, and conditional operations. ### Source excerpt As telemetry pipelines become more sophisticated, so do the transformations they need to perform: sanitizing sensitive data, normalizing inconsistent schemas, and enforcing attribute contracts. While OTTL provides a rich set of transformation functions, expressing collection operations has required dedicated functions with hardcoded behavior for each new use case. OpenTelemetry Collector Contrib v0.157.0 changes that by introducing lambda expressions to OTTL. Lambdas let users pass inline logic directly to generic higher-order functions, making complex collection transformations both reusable and concise. The release includes eight new functions that leverage this capability: Filter, MapEach, MapKeys, Any, All, Find, Reduce, and When. ## Waiting for PostgreSQL 19 - new pg\_get\_\*\_ddl() functions DevFeed: [Waiting for PostgreSQL 19 - new pg\_get\_\*\_ddl() functions]() Original publisher: [Read original article]() Author: depesz Published: 2026-04-09T16:37:45Z Content type: article Language: en Sources: [select \* from depesz;]() Topics: [PostgreSQL](), [SQL](), [Databases]() Tags: [functions](), [pg-dump](), [pg-get-database-ddl](), [pg-get-role-ddl](), [pg-get-tablespace-ddl](), [pg19](), [postgresql](), [schema](), [sql](), [uncategorized](), [waiting]() ### AI overview This article examines proposed PostgreSQL 19 SQL-callable pg_get_*_ddl() functions that generate DDL for recreating databases, roles, and tablespaces. It demonstrates their output and options, notes that role passwords are not exported, and observes that support for additional object types is still missing. ### Source excerpt On 5th of April 2026, Andrew Dunstan committed patch: Add pg_get_database_ddl() function Add a new SQL-callable function that returns the DDL statements needed to recreate a database. It takes a regdatabase argument and an optional VARIADIC text argument for options that are specified as alternating name/value pairs. The following options are supported: pretty (boolean) ... Continue reading "Waiting for PostgreSQL 19 - new pg_get_*_ddl() functions" ## Waiting for PostgreSQL 19 - Add IGNORE NULLS/RESPECT NULLS option to Window functions. DevFeed: [Waiting for PostgreSQL 19 - Add IGNORE NULLS/RESPECT NULLS option to Window functions.]() Original publisher: [Read original article]() Author: depesz Published: 2025-10-13T11:13:52Z Content type: article Language: en Sources: [select \* from depesz;]() Topics: [PostgreSQL]() Tags: [first-value](), [functions](), [ignore](), [lag](), [last-value](), [lead](), [nth-value](), [null](), [nulls](), [pg19](), [postgresql](), [uncategorized](), [waiting](), [window](), [window-functions]() ### AI overview The article describes a PostgreSQL patch adding IGNORE NULLS and RESPECT NULLS options, also called a null treatment clause, to the lead, lag, first_value, last_value, and nth_value window functions. IGNORE NULLS skips NULL values, while RESPECT NULLS remains the default behavior. ### Source excerpt On 3rd of October 2025, Tatsuo Ishii committed patch: Add IGNORE NULLS/RESPECT NULLS option to Window functions. Add IGNORE NULLS/RESPECT NULLS option (null treatment clause) to lead, lag, first_value, last_value and nth_value window functions. If unspecified, the default is RESPECT NULLS which includes NULL values in any result calculation. IGNORE NULLS ignores NULL values. ... Continue reading "Waiting for PostgreSQL 19 - Add IGNORE NULLS/RESPECT NULLS option to Window functions." ## Use Function Calls Instead of Parsing LLM Output DevFeed: [Use Function Calls Instead of Parsing LLM Output]() Original publisher: [Read original article]() Published: 2025-10-03T00:00:00Z Content type: article Language: en Sources: [Tim Kellogg]() Topics: [Large Language Model](), [API](), [Artificial Intelligence](), [OpenAI]() Tags: [agentic](), [api](), [functions](), [llms](), [openai](), [parsing]() ### AI overview The article argues that developers should use function-calling APIs instead of parsing formatted text from large language models. It presents functions as expressive enough to model failures, repeated calls, optional calls, and varied call sequences, and describes this approach as a foundation for agentic behavior. ### Source excerpt Instead of writing crap tons of parsing code for LLMs you can just use functions. It's easy. ## Flow from suspending functions and vice versa DevFeed: [Flow from suspending functions and vice versa]() Original publisher: [Read original article]() Published: 2025-08-18T00:00:00Z Content type: tutorial Language: en Sources: [Kt. Academy]() Topics: [Kotlin](), [kotlin-coroutines](), [Coroutines](), [functions]() Tags: [coroutines](), [functions](), [guide](), [how-to](), [kotlin](), [kotlin-coroutines](), [workshop-learning-programming]() ### AI overview A guide to converting suspending functions to Flow and converting Flow back to suspending functions in Kotlin Coroutines. ### Source excerpt A guide on how to convert suspending functions to Flow and vice versa in Kotlin Coroutines. ## Perfecting anti-aliasing on signed distance functions DevFeed: [Perfecting anti-aliasing on signed distance functions]() Original publisher: [Read original article]() Published: 2025-07-26T14:29:32Z Content type: article Language: en Sources: [The Last Static Blog RSS]() Topics: [signed distance functions](), [SDF]() Tags: [functions](), [graphics](), [math](), [prog](), [sdf](), [signed-distance-functions](), [visualization]() ### AI overview This article explains why anti-aliasing signed distance functions is more complicated than applying hardcoded constants or generic formulas. It develops anti-aliasing approaches from SDF properties such as the unit-length gradient and considers both inside/outside sign conventions. ### Source excerpt Doing anti-aliasing on SDF is not as straightforward as it seems. Most of the time, we see people use a smoothstep with hardcoded constants, sometimes with screen space information, sometimes cryptic or convoluted formulas. Even if SDFs have the perfect mathematical properties needed for a clean anti-aliasing, the whole issue has a scope larger than it appears at first glance. And even when trivial solutions exist, it's not always clear why they are a good fit. Let's study that together. SDF The article assumes that you are at least a bit familiar with what an SDF is, but if I had to provide a quick and informal definition, I would say something like: "It's a function (or lookup-table of said function, usually stored in a texture) which returns the signed distance from the specified coordinates to a given shape, where the sign indicates whether you're inside or outside the shape." A common visualization of it looks like this: SDF of a moving pie/pacman, using Inigo Quilez formula and colorscheme for visualization The distance is fancily colored here for illustrative purpose, and the shape is animated to see how it affects the field. Another way of seeing it is to switch to a 3D view: SDF of a moving pie/pacman, as seen in 3D For the sign interpretation, here we're using the convention positive inside and negative outside, as seen for example on the Wikipedia illustration. But this is not always the case, for example, Inigo prefers the opposite: negative inside and positive outside. I personally find the Wikipedia convention to be more intuitive and easy to work with, but that's a matter of preferences so we'll figure out the formulas for both models. Switching from one to the other is just a sign swap, but it's important to know what we are working with. Linear ramp A properly crafted SDF has a gradient of length 1, meaning the slope is either going up or down, but always at the same constant rate of 1: 1D side cut of an SDF depicting the gradient/slope This is an i ## How to turn callback functions into suspend functions or Flow DevFeed: [How to turn callback functions into suspend functions or Flow]() Original publisher: [Read original article]() Published: 2025-07-14T00:00:00Z Content type: tutorial Language: en Sources: [Kt. Academy]() Topics: [Kotlin](), [kotlin-coroutines](), [callback](), [functions](), [Continuation](), [API]() Tags: [callback](), [cancellation](), [continuation](), [coroutines](), [exceptions](), [functions](), [guide](), [how-to](), [interoperability](), [kotlin](), [kotlin-coroutines](), [suspend](), [workshop-learning-programming]() ### AI overview A guide to adapting callback-based APIs for Kotlin Coroutines. It explains how to convert callbacks that return one value into suspending functions and how to adapt callbacks that emit multiple values into Flows, including handling cancellation and exceptions. ### Source excerpt A guide on how to correctly convert callback-based functions into suspending functions or Flows in Kotlin Coroutines. ## Introducing Fermyon Wasm Functions on Akamai DevFeed: [Introducing Fermyon Wasm Functions on Akamai]() Original publisher: [Read original article]() Author: Matt Butcher Published: 2025-03-27T10:30:00Z Content type: release Language: en Sources: [Fermyon - Experience the next wave of cloud computing.]() Topics: [wasm](), [WebAssembly](), [Cloud]() Tags: [cloud](), [functions](), [performance](), [service](), [wasm](), [webassembly]() ### AI overview Fermyon introduces Wasm Functions, a globally hosted and managed service running within the Akamai Cloud. The article highlights its integration with Spin and WebAssembly and claims high performance. ### Source excerpt Fermyon Wasm Functions is a globally hosted and managed service runs within the Akamai Cloud and delivers absolutely mind-boggling performance with all the features you already know and love about Spin and WebAssembly. ## Function Types in Nix DevFeed: [Function Types in Nix]() Original publisher: [Read original article]() Published: 2024-08-27T00:00:00Z Content type: article Language: en Sources: [Garnix Blog]() Topics: [Nix](), [function]() Tags: [custom](), [function](), [functions](), [types]() ### AI overview A short note about custom typing for functions in Nix. ### Source excerpt A short note about custom typing for functions in Nix ## Kotlin/Wasm interop with Javascript - Gustavo Fão Valvassori DevFeed: [Kotlin/Wasm interop with Javascript - Gustavo Fão Valvassori]() Original publisher: [Read original article]() Published: 2024-03-27T00:00:00Z Content type: tutorial Language: en Sources: [Touchlab | Enterprise Mobile Innovation & Development]() Topics: [interoperability](), [Kotlin](), [wasm](), [function](), [functions]() Tags: [functions](), [interop](), [interoperability](), [javascript](), [kotlin](), [kotlin-multiplatform](), [kotlin-wasm](), [wasm](), [web-assembly]() ### AI overview This tutorial explains bidirectional interoperability between Kotlin/Wasm and JavaScript. It covers calling JavaScript from Kotlin/Wasm, exposing Kotlin/Wasm functions to JavaScript, export limitations, name collisions, and using JavaScript-defined types and browser APIs. ### Source excerpt Kotlin/Wasm provides a bi-directional interoperability between Kotlin and Javascript, allowing you to call functions on either side. Let's dive into the topic and explore its limitations and workarounds. ## Generics in Kotlin DevFeed: [Generics in Kotlin]() Original publisher: [Read original article]() Published: 2024-03-18T00:01:00Z Content type: tutorial Language: en Sources: [Kt. Academy]() Topics: [generics](), [Kotlin](), [Type Parameter](), [Programming](), [classes](), [function](), [interfaces](), [kotlin compiler]() Tags: [classes](), [functions](), [generics](), [interfaces](), [kotlin](), [kotlin-compiler](), [programming](), [type-parameter](), [workshop-learning-programming]() ### AI overview This tutorial explains how generics work in Kotlin. It covers generic functions, classes, and interfaces, including type parameters, type arguments, explicit specification, compiler inference, and relationships between argument and result types. ### Source excerpt The essence of how generics work in Kotlin. ## Effective Kotlin Item 20: Do not repeat common algorithms DevFeed: [Effective Kotlin Item 20: Do not repeat common algorithms]() Original publisher: [Read original article]() Published: 2024-01-29T00:00:00Z Content type: tutorial Language: en Sources: [Kt. Academy]() Topics: [Programming](), [Algorithms](), [functions](), [Kotlin]() Tags: [algorithms](), [business-logic](), [functions](), [kotlin](), [optimization](), [sorting](), [standard-library](), [workshop-learning-programming]() ### AI overview This Effective Kotlin article explains why developers should extract common, non-project-specific algorithms into named utility functions or libraries. It argues that reuse improves programming speed, readability, maintenance, and consistency, while reducing noise and repeated implementation. The article recommends learning and using standard-library functions where appropriate. ### Source excerpt Why extracting utility functions is so important for our programs. ## Kotlin Reflection: Method and property references DevFeed: [Kotlin Reflection: Method and property references]() Original publisher: [Read original article]() Published: 2023-10-16T00:15:00Z Content type: tutorial Language: en Sources: [Kt. Academy]() Topics: [Kotlin](), [Programming](), [classes](), [function](), [properties]() Tags: [classes](), [dependency-injection](), [functions](), [gson](), [interfaces](), [java](), [koin](), [kotlin](), [property](), [workshop-learning-programming]() ### AI overview This tutorial introduces Kotlin reflection, explaining how programs inspect classes, functions, properties, annotations, constructors, and other source-code elements at runtime. It also describes uses in Gson serialization, Koin dependency injection, and the hierarchy of Kotlin reflection reference types. ### Source excerpt The general hierarchy of Kotlin reference classes, and details about method and property references. ## Making Twig Macros Work Like Functions DevFeed: [Making Twig Macros Work Like Functions]() Original publisher: [Read original article]() Author: andrew@nystudio107.com (Andrew Welch) Published: 2023-07-14T18:38:00Z Content type: tutorial Language: en Sources: [nystudio107 | Articles on modern web development.]() Topics: [Programming](), [Development](), [reusable code](), [Code]() Tags: [functions](), [insights](), [just](), [languages](), [learn](), [like](), [macros](), [make](), [manipulate](), [programming](), [programming-languages](), [return](), [returning](), [reusable-code](), [twig](), [value](), [values]() ### AI overview A tutorial on making Twig macros return values that can be manipulated like function results. It demonstrates a sales-calculation macro, whitespace control, and returning a value for further computations such as sales tax. ### Source excerpt Learn how to make Twig macros return values you can manipulate, just like functions in other programming languages ## Why Do We Need Another Kind of Cloud Compute? DevFeed: [Why Do We Need Another Kind of Cloud Compute?]() Original publisher: [Read original article]() Author: Matt Butcher Published: 2023-03-28T17:13:47Z Content type: article Language: en Sources: [Fermyon - Experience the next wave of cloud computing.]() Topics: [cloud-computing](), [Serverless](), [WebAssembly]() Tags: [cloud](), [cloud-computing](), [functions](), [serverless](), [webassembly]() ### AI overview The article discusses WebAssembly as a new wave of cloud computing and identifies serverless functions as the reason another wave of cloud computing is needed. ### Source excerpt We talk about WebAssembly as the next wave of cloud computing. But why do we need another wave of cloud computing. The answer is serverless functions. ## Functions in Kotlin DevFeed: [Functions in Kotlin]() Original publisher: [Read original article]() Published: 2022-12-12T00:01:00Z Content type: tutorial Language: en Sources: [Kt. Academy]() Topics: [function](), [Kotlin](), [Code](), [generics](), [unit test]() Tags: [code](), [functions](), [generics](), [kotlin](), [parameter](), [syntax](), [unit-test](), [workshop-learning-programming]() ### AI overview A Kotlin tutorial explaining functions as core program building blocks, including function definitions and calls, naming conventions, parameters and return types, backticks for names, single-expression syntax, and inferred result types. ### Source excerpt Learn about what functions can offer us in Kotlin. ## Error Handling in Kotlin with Arrow and Either DevFeed: [Error Handling in Kotlin with Arrow and Either]() Original publisher: [Read original article]() Published: 2022-12-06T00:15:00Z Content type: tutorial Language: en Sources: [Kt. Academy]() Topics: [Error Handling](), [Kotlin](), [Exception](), [function](), [domain-specific language]() Tags: [domain-specific-language](), [error-handling](), [exception](), [functions](), [kotlin](), [syntax](), [workshop-learning-programming]() ### AI overview This tutorial explains how functional Kotlin code can represent errors in return types instead of exceptions. It compares nullable values with explicit error handling and introduces Arrow DSLs based on continuations to provide a unified API for different error types. ### Source excerpt Learn about Error Handling in Arrow, end how to effectively work with Either. ## Part 4: Beyond The Code and What I've Learned - Ethereum Payment DevFeed: [Part 4: Beyond The Code and What I've Learned - Ethereum Payment]() Original publisher: [Read original article]() Author: Emmanuel Goossaert Published: 2022-11-29T19:18:30Z Content type: tutorial Language: en Sources: [Code Capsule]() Topics: [Ethereum](), [Blockchain](), [Code](), [Back end](), [Front end]() Tags: [algorithms-and-programming](), [algorithms-and-programming-blockchain-crypto-ethereum-mongodb-nodejs-payment-programming-typ](), [blockchain](), [code](), [crypto](), [developer](), [developing](), [ethereum](), [functions](), [how-to](), [implementation](), [mongodb](), [networks](), [nodejs](), [payment](), [product-design](), [programming](), [typescript](), [web3]() ### AI overview The fourth and final article in a series reviews lessons from developing a hobby payment system for the Ethereum blockchain. It discusses extending the code, using redundant data providers, implementing couponing, handling Ethereum testing and production networks, and improving automation and safeguards before production use. ### Source excerpt I'm sharing what I've learned while developing this project in terms of tech specificities product design when creating for the blockchain. The post Part 4: Beyond The Code and What I've Learned - Ethereum Payment first appeared on Code Capsule. ## Kotlin Coroutines use cases for Data/Adapters Layer DevFeed: [Kotlin Coroutines use cases for Data/Adapters Layer]() Original publisher: [Read original article]() Published: 2022-11-15T00:00:00Z Content type: tutorial Language: en Sources: [Kt. Academy]() Topics: [Kotlin](), [kotlin-coroutines](), [Coroutines](), [callback](), [Concurrency](), [Databases](), [SQLite](), [Android]() Tags: [blocking](), [callback](), [coroutines](), [databases](), [functions](), [kotlin](), [kotlin-coroutines](), [sqlite](), [workshop-learning-programming]() ### AI overview This tutorial explains common Kotlin Coroutines use cases in the Data/Adapters Layer, including repository and provider implementations, adapting callback-based APIs into suspending functions, and handling blocking calls with an appropriate dispatcher. ### Source excerpt How do we use Kotlin Coroutines in the Data/Adapters Layer, how do we use callback or blocking functions. ## Scope functions DevFeed: [Scope functions]() Original publisher: [Read original article]() Published: 2022-09-23T00:05:00Z Content type: tutorial Language: en Sources: [Kt. Academy]() Topics: [Kotlin](), [functions](), [Library](), [object](), [Streams](), [Back end]() Tags: [also](), [apply](), [backend](), [functions](), [how-to](), [kotlin](), [let](), [scope-functions](), [standard-library](), [with](), [workshop-learning-programming]() ### AI overview A tutorial on Kotlin scope functions, including let, also, apply, and with. It explains how these standard-library extension functions transform or configure objects, presents application examples, and notes that scope-function-heavy code can make debugging harder. ### Source excerpt What is let, also, apply and with, and how to use them in our applications. [Next page]()