33 个仓库
Returns the first non-null value from a provided list or replaces specific values with null.
Distinct from Null Value Representations: None of the candidates fit; this is a database-specific data cleaning capability.
Explore 33 awesome GitHub repositories matching data & databases · Null Value Handling. Refine with filters or upvote what's useful.
Presto is a distributed SQL query engine designed for high-performance analytical processing across heterogeneous data sources. It functions as a data federation platform and massively parallel processing engine, allowing users to execute interactive queries against diverse storage systems without requiring data migration. By mapping remote metadata and structures to a unified relational namespace, it enables seamless cross-platform analysis through a standard SQL interface. The engine distinguishes itself through a pluggable connector architecture and a shared-nothing distributed processing
Simplifies data cleaning by providing functions to handle and replace null values.
Bootstrap Table is a jQuery plugin for rendering interactive data grids with sorting, pagination, and filtering. It features a remote data integration system for fetching and synchronizing content from JSON endpoints using AJAX and server-side processing. The project includes a styling layer that adapts markup to work with various CSS frameworks, such as Bootstrap, Semantic UI, Bulma, and Material Design. It provides specialized rendering modes, including a hierarchical tree grid for parent-child row relationships and a responsive card-view table that transforms grids into mobile-friendly lay
Implements specific sorting logic to ensure rows with empty values are placed at the end of the list.
PRQL is a functional, modular data transformation language that serves as a compiler for relational data pipelines. It allows developers to write expressive, pipelined queries that are translated into standard SQL dialects. By abstracting complex data manipulation into a readable, sequential syntax, the project enables the construction of maintainable workflows that remain independent of specific database engines. The language distinguishes itself through a robust compilation infrastructure that performs type validation and relational algebra analysis before generating target-specific code. I
Provides a coalescing operator to replace null values with specified defaults during data processing.
qs 是一个查询字符串解析和序列化库,用于将 URL 查询字符串转换为 JavaScript 对象,并将对象或数组转换回 URI 编码的字符串。它作为一个安全的解析器和 URI 编码实用程序,专门设计用于处理嵌套数据结构。 该库通过可配置的嵌套样式和数组序列化格式脱颖而出。它支持自定义字符编码逻辑,并利用字符集哨兵来管理 UTF-8 和 ISO-8859-1 之间的转换。 为了防止资源耗尽和安全漏洞,该项目实现了参数计数限制和严格的解析深度限制。它还包括空值处理、基于谓词的键过滤以及可插拔的编码函数,以管理数据的序列化方式。
Distinguishes between null and empty strings or omits keys with null values during serialization.
This project is a comprehensive library of practical Python code examples and patterns. It provides a collection of scripts and snippets designed to demonstrate a wide range of programming tasks, from basic syntax to advanced implementation patterns. The repository focuses on several core domains, including the implementation of concurrency and multithreading examples, data analysis snippets for cleaning and manipulating tabular data, and various data visualization examples. It also covers automation scripts for file system management and a variety of general programming patterns. Additional
Implements a tool to replace missing data with specified values or statistics like mean and median.
This repository is a collection of practical code snippets and implementation patterns for Flutter and Dart. It serves as a comprehensive guide and reference for asynchronous programming, state management patterns, and UI component design. The project provides advanced language reference material covering generics, reflection, factory constructors, and null-aware operators. It also includes specific utilities for manipulating Dart collections, such as helper methods for transforming and filtering maps, lists, and iterables. The coverage extends to high-level capabilities including asynchrono
Filters maps by removing all entries that contain null values.
AllAboutBugBounty is a curated collection of bug bounty techniques and payloads for web application security testing. It serves as a reference resource covering common web vulnerabilities and exploitation methods for security researchers, providing a structured approach to identifying and exploiting web application security flaws in bug bounty programs. The repository covers a wide range of attack categories including authentication bypass, cross-site scripting injection, server-side request forgery, web cache poisoning, and business logic abuse. It includes techniques for bypassing access co
Covers submitting null values to bypass two-factor authentication verification steps.
This is a configuration library for JVM applications that parses HOCON, JSON, and Java properties files into an immutable tree structure. It resolves ${...} placeholders by traversing the configuration tree and falling back to environment variables and system properties, and validates loaded configurations against a reference schema. The library loads configuration from classpath resources, files, URLs, system properties, and environment variables, merging them with priority-based override semantics. It provides typed value access with automatic type coercion, supports dot-path navigation,
Distinguishes between null and absent configuration values without throwing exceptions.
pgloader is a command-line tool that automates the migration of data and schema from various source databases and file formats into PostgreSQL. It combines schema discovery, parallel data pipelines, and type casting into a single, declarative workflow, using PostgreSQL's COPY protocol for high-throughput bulk loading. The tool distinguishes itself by compiling a dedicated command language into concurrent reader-writer pipelines that handle schema introspection, data transformation, and error-resilient batch processing. It supports migrating entire databases from MySQL, MS SQL, SQLite, and Pos
Strips NUL characters from string values during data loading.
Pinot is a distributed, columnar analytical database designed for high-concurrency, low-latency query processing. It functions as a real-time OLAP datastore, enabling interactive, user-facing analytics by ingesting and querying massive datasets from both streaming and batch sources. The system architecture relies on a centralized controller for cluster coordination and a distributed segment-based storage model to ensure horizontal scalability. The platform distinguishes itself through a hybrid ingestion pipeline that unifies real-time event streams and historical batch data into a single quer
Configures data ingestion and query execution to track and process null values instead of treating all fields as non-null.
GraphQL.NET 是一个用于在 C# 应用程序中构建和执行 GraphQL API 的服务端框架。它提供了一套全面的工具包,用于模式构建、分布式数据图的联合引擎,以及用于管理实时数据流的订阅处理器。 该项目的独特之处在于其灵活的模式构建器,支持程序化的代码优先定义和使用标准模式定义语言的声明式模式优先方法。它包括一个专门的联合引擎,用于将数据图拆分为子图并将其组合成统一的网关,以及一个专门设计用于通过批处理和缓存解决 N+1 查询问题的数据加载器实现。 该框架涵盖了广泛的操作功能,包括用于服务生命周期管理的依赖注入集成、用于字段解析拦截的中间件流水线,以及针对值类型优化以减少内存分配的执行流水线。它还提供用于查询复杂度分析、文档缓存和基于角色的访问控制的工具,以保护 API 端点。 对提前(AOT)模式编译的支持允许该框架在禁止动态代码生成的环境中执行。
Controls the serialization and deserialization of null values within custom scalar types.
pg is a PostgreSQL object-relational mapper (ORM) for Go that maps Go structs to database tables and provides a fluent query builder for constructing SQL statements programmatically. At its core, it automatically generates CREATE TABLE statements from Go struct definitions using struct tags and naming conventions, and builds queries through method chaining with placeholder-based parameter binding to prevent SQL injection. The library distinguishes itself through relation-aware join generation that automatically constructs JOIN clauses for has-one, has-many, many-to-many, and polymorphic assoc
Maps nullable columns using Go pointers or sql.Null types to distinguish NULL from zero values.
MockK is a Kotlin test double framework that creates mocks, spies, and relaxed mocks for unit testing, with support for final classes, static methods, and coroutines. It functions as a bytecode instrumentation library that modifies compiled class files at load time to intercept constructors, final methods, and static functions without source changes, and also provides dedicated libraries for constructor mocking and coroutine mocking. The framework is designed specifically for Kotlin, handling Kotlin-specific constructs like extension functions, singletons, and suspend functions. MockK disting
Handles null values in mocks by returning null or accepting null arguments for nullable type coverage.
Tortoise ORM is an asynchronous object-relational mapper for Python that mirrors Django's model and queryset API while running on asyncio. It defines database tables as Python classes with typed fields and supports foreign key, many-to-many, and one-to-one relations, providing a chainable query API for filtering, annotating, grouping, and prefetching related objects without blocking the event loop. The ORM includes a built-in migration engine that detects model changes, generates migration files, and applies or reverts schema changes through a command-line tool. It connects to PostgreSQL, MyS
Matches records where a field is null when the filter value is explicitly set to None in queries.
protobuf-net is a .NET library that serializes and deserializes objects using the Protocol Buffers binary format for efficient data exchange. It provides a code-first gRPC service framework, allowing developers to define service contracts directly from existing C# classes without writing separate .proto files. The library is nullable-aware, encoding null values in collections and nullable scalars using wrapper messages to distinguish null from default zero values, and includes an ahead-of-time serializer generator that compiles serializer code at build time to eliminate runtime code generati
Uses an extra message wrapper around a collection to encode null, empty, or populated states differently.
Mimesis 是一个 Python 合成数据生成器,用于为软件测试和开发创建逼真的虚假数据集和模拟数据。它作为一个基于模式的数据集生成器,能够生成结构化记录和关系数据集,同时也可作为生产数据脱敏工具,用合成值替换敏感信息。 该库的特色在于全面的多语言支持,允许生成特定区域的信息以模拟区域用户画像。它通过使用种子进行确定性数据生成来确保可重复性,从而在不同运行中创建一致的数据集。 该工具涵盖了广泛的合成内容,包括个人身份、财务数据、地理地址、网络元数据和科学序列。其功能扩展到通过条件逻辑和管道进行数据转换,以及与 DataFrame 和工厂模式的集成。它还支持生成标准化的系统代码、加密令牌和二进制文件模拟。 该框架可通过自定义数据提供程序和字段处理器进行扩展,允许用户集成特定领域的逻辑和外部 JSON 文件以进行专门的数据生成。
Introduces missing or placeholder data into synthetic datasets based on specified probabilities to test edge cases.
django-filter 是一个用于过滤 Django QuerySets 的库,通过使用声明性语法将 URL 参数映射到数据库查找。它作为模型过滤器生成器和数据库查找工具,将请求参数转换为查询以优化数据结果。 该项目支持基于模型字段定义自动生成搜索过滤器和用户界面表单。它通过自定义查找方法、关系路径和全文搜索集成支持高级检索逻辑,同时提供用于在 REST API 端点内优化结果的系统。 其功能面包括创建交互式过滤表单、渲染过滤后的列表视图,以及使用工厂函数进行动态过滤器集实例化。该系统还处理布尔值、UUID 和 ISO 8601 时间戳的特定类型过滤,以及使用经过身份验证的用户身份进行基于请求的过滤。
Checks if a field is empty or null using boolean toggles or dedicated menu labels within database queries.
Sprig is a comprehensive library of helper functions designed to extend the Go text template engine. It provides a wide array of custom functions that can be injected into the engine to enable complex data manipulation and logic directly within templates. The project offers specialized capabilities for cryptography, including the generation of private keys, X.509 certificates, and secure password hashes. It also includes advanced logic extensions for semantic versioning comparison, ternary evaluations, and the resolution of environment variables from the host operating system. The library co
Provides fallback values for empty variables and handles null values within template logic.
routing-controllers 是一个用于 TypeScript 的声明式 API 路由器和 Web 框架控制器。它提供了一个系统,用于使用基于类的装饰器和元数据定义 HTTP 路由和请求处理逻辑,从而将 API 端点组织成结构化的架构。 该项目利用基于适配器的服务器集成将路由逻辑与底层 Web 框架解耦,为 Express 和 Koa 提供了特定的集成。它具有一个基于反射的类型转换系统,可验证传入的请求参数并将其转换为类型化的类实例。 功能面涵盖了完整的请求-响应管道,包括中间件执行、响应拦截和全局错误管理。它支持高级路由实用程序,如全局路由前缀、基于文件系统的组件发现和依赖注入集成。其他功能包括基于角色的访问控制、已验证用户注入以及用于文件上传和响应流的专门处理程序。
Allows mapping null or undefined controller results to custom HTTP status codes or error classes.
Jbuilder 是一个用于 Ruby 的 JSON 模板引擎和构建器,提供了一种用于生成结构化 JSON 对象的领域特定语言(DSL)。它作为视图助手,使用逻辑、条件和循环将数据转换为 JSON 格式。 该项目通过使用局部模板(partials)和嵌套对象来构建复杂的数据结构,以保持模块化。它包括运行时键转换功能,允许在不同的命名约定(如蛇形命名法和驼峰命名法)之间转换属性键。 该系统支持动态 JSON 结构化,能够定义运行时键并管理 null 值的输出。它还提供了一种缓存渲染后的 JSON 片段的机制,以减少重复处理。
Provides control over whether null values are explicitly returned or omitted from the final JSON structure.