18 个仓库
Direct execution of SQL queries with parameter binding.
Explore 18 awesome GitHub repositories matching data & databases · Raw SQL Execution. Refine with filters or upvote what's useful.
Laravel is a comprehensive full-stack web framework designed for building scalable server-side applications. It provides an integrated development environment that centers on an object-relational mapper for database abstraction, a robust routing system, and a sophisticated service container for dependency injection. The framework is built to handle complex application requirements through a modular architecture that emphasizes convention over configuration. What distinguishes Laravel is its deep integration of background processing and event-driven communication. It features a task queue orch
Executing arbitrary SQL queries with secure parameter binding protects applications against injection vulnerabilities while maintaining database flexibility.
This project is a comprehensive educational curriculum designed to build proficiency across modern infrastructure, cloud-native technologies, and systems administration. It functions as a reference library and interview preparation resource, offering a structured collection of conceptual questions, practical coding challenges, and hands-on scenarios that cover the full spectrum of software delivery and operational workflows. The repository distinguishes itself through a modular, domain-specific structure that links instructional problem statements with verified implementation examples. By emp
Enables direct interaction with database tables through guided raw query execution tasks.
Dapper is a lightweight object-relational mapper for .NET that functions as a high-performance data access library. It operates by extending standard database connection interfaces, allowing developers to execute raw SQL queries while automating the mapping of database results to strongly-typed objects. The library distinguishes itself through its use of runtime code generation, which creates high-performance instructions to map database rows to object properties with minimal overhead. It provides flexible data retrieval options, supporting both memory-buffered loading for speed and row-by-ro
Executes custom SQL statements and stored procedures directly against a database for full control.
Entity Framework Core is an object-relational mapper that enables developers to interact with database systems using strongly-typed code. It serves as a comprehensive data access framework, providing a unified interface for mapping application objects to relational and non-relational database schemas while managing the lifecycle of data operations through a central context. The project distinguishes itself through a provider-based architecture that decouples core data access logic from specific database engines, allowing for consistent interaction across diverse storage systems. It features a
Wraps raw SQL queries as subqueries to allow further filtering, sorting, or projection using standard language-integrated query operators.
LearnPython is a programming tutorial consisting of a collection of practical code examples used to demonstrate Python language features and programming patterns. It serves as a comprehensive learning resource that implements core language concepts through functional code. The project provides specialized guides and samples covering several key domains. These include asynchronous network programming with event loops and coroutines, data visualization using numerical datasets for 2D and 3D plots, and web scraping for fetching content and automating login flows. It also features instructions on
Implements direct execution of SQL queries with parameter binding for database operations.
GRDB.swift is a comprehensive SQLite toolkit and object-relational mapper for Swift. It provides a database wrapper that handles local data persistence, connection management, and encrypted file storage for Apple platforms. The library features a dedicated observation framework that tracks database changes to automatically synchronize the application state and user interface in real time. It distinguishes itself with a type-safe query builder and a protocol-based mapping system that converts database rows into structured Swift objects. The toolkit covers a broad range of administrative and o
Enables the execution of raw SQL statements using bound arguments to prevent security vulnerabilities.
pysheeet 是一个技术参考库,提供了一系列精选的代码片段和实现模式,用于高级 Python 开发、系统集成和高性能计算。它充当实现底层网络编程、原生 C 扩展以及异步和并发编程的综合指南。 该项目为大语言模型的开发和部署提供了专门的框架,包括用于分布式 GPU 推理和高性能服务的工具。它还包括用于高性能计算集群编排的详细模式,涵盖 GPU 资源分配和多节点工作负载管理。 该库涵盖了广泛的功能,包括安全网络通信和加密、对象关系映射和数据库管理,以及复杂数据结构和算法的实现。它还提供用于内存管理、通过外部函数接口(FFI)进行原生互操作以及系统级 OS 集成的实用程序。
Provides capabilities for executing raw SQL strings with parameter binding to prevent injection attacks.
Objection.js is an object-relational mapper for Node.js that maps SQL database tables to classes and rows to model instances. It functions as a high-level abstraction layer built on top of the Knex.js query builder to provide structured model definitions and relational data mapping. The project distinguishes itself through its ability to manage complex object graphs, allowing for the persistence and eager-loading of deeply nested related data in single operations. It incorporates a data integrity layer that uses JSON schema validation to verify model instances before they are persisted to the
Supports direct execution of raw SQL queries with parameter binding for advanced database operations.
Records is a SQL database client designed for executing raw queries and managing result sets through a simplified interface. It provides a parameterized SQL executor to bind values to placeholders, ensuring safe data handling and preventing injection attacks, alongside a database transaction manager for grouping operations into atomic units. The project includes a dedicated command-line interface for running database statements and exporting query results directly to local files. This tooling allows for the conversion of SQL result sets into multiple serialization formats, including CSV, JSON
Executes database statements directly via a thin wrapper over the database driver to avoid abstraction overhead.
Records 是一套工具,提供 SQL 数据库客户端库、事务管理器以及用于命令行访问和数据导出的实用程序。它作为一个轻量级封装器,针对关系型数据库执行原始 SQL 查询,以简化数据格式检索结果。 该项目包括一个用于运行数据库查询的命令行界面,以及一个将关系查询结果转换为 CSV、JSON 或 Excel 文件以供外部分析的专用数据导出工具。 该库通过支持提交和回滚的原子事务控制涵盖了关系数据库管理。它通过 SQL 参数化处理安全性以防止注入漏洞,并包括用于减少网络开销的批量查询执行能力。
Executes raw SQL statements directly with parameter binding to retrieve results in simplified formats.
Ibis is a portable Python dataframe library and multi-backend query engine that provides a unified interface for executing data transformations across diverse compute engines. It functions as a Python SQL expression compiler and dialect transpiler, allowing users to define data logic once and execute it across cloud warehouses, embedded databases, and distributed clusters without rewriting code. The project distinguishes itself through a database backend abstraction that decouples transformation logic from the underlying execution engine. It enables polyglot data workflows by mixing raw SQL s
Allows the execution of arbitrary SQL strings for administrative tasks and table creation.
Trailbase 是一个后端即服务(BaaS)平台,以单个可执行文件的形式交付,集成了实时数据库引擎、身份和访问管理器以及类型安全的 API 生成器。它提供了一个全面的后端环境,包括基于 SQLite 的存储引擎和用于执行自定义逻辑的 WebAssembly 运行时服务器。 该平台通过自动将数据库模式转换为具有跨语言客户端绑定的 JSON API,以及允许执行用于服务器端渲染和自定义 HTTP 路由的便携式组件而脱颖而出。它还集成了向量数据库功能,以支持嵌入向量的存储和基于相似性的向量搜索。 该系统涵盖了广泛的操作功能,包括支持社交登录的用户认证、用于数据可见性的访问控制列表,以及用于实时数据更新的发布-订阅(pub-sub)同步。它还提供了通过 SQL 迁移管理数据库模式以及处理地理空间数据的工具。
Supports direct execution of raw SQL queries against the database for complex operations.
Slonik 是一个用于 Node.js 的类型安全 PostgreSQL 客户端,使用标记模板字面量(tagged template literals)来确保参数绑定并防止注入攻击。它提供了一个将应用连接到 PostgreSQL 的框架,并为查询和数据库模式提供自动类型检查。 该项目通过专门的 SQL 查询 Linter 脱颖而出,该 Linter 通过在开发过程中根据实时数据库模式验证代码,来检测无效列和类型不匹配。它还包括一个用于加载大数据集的高性能二进制批量数据插入器(使用原生二进制序列化),以及一个能够在主节点和副本节点之间进行动态查询路由的连接池管理器。 该库涵盖了广泛的数据库能力,包括原子事务管理、动态 SQL 查询构建,以及通过异步迭代流处理大数据集。它进一步提供了用于日志记录和基准测试的中间件拦截器、自定义类型解析,以及用于刷新数据库身份验证凭据的异步回调机制。
Enables execution of raw SQL statements using secure parameter binding via tagged templates.
DoctrineBundle 是一个 Symfony 集成,用于配置和管理 Doctrine 对象关系映射器(ORM)和数据库抽象层(DBAL)。它提供了将应用程序对象映射到关系数据库表并通过一致的编程接口执行原始查询所需的基础工具。 该项目包含一个带有命令行工具的数据库模式管理器,用于将数据库结构与实体映射同步并执行迁移。它还提供了一个数据库查询调试器和活动调试工具,通过 Web 界面跟踪性能和执行细节。 该 Bundle 涵盖了广泛的数据管理功能,包括元数据映射配置、全局查询过滤和自定义实体标识符生成。它还通过查询结果缓存支持性能优化,并提供了一个用于拦截数据库和实体生命周期更改的事件驱动系统。
Enables the execution of direct database operations via an abstraction layer to bypass the object mapper.
sqlite-net is a lightweight object-relational mapper and data access layer for SQLite. It provides tools for translating application classes into database tables, managing records through an entity mapper, and implementing local data persistence. The library includes an encrypted wrapper that secures database files using connection keys and native encryption configurations. It also features a data access layer that supports both synchronous and asynchronous operations to maintain application responsiveness during disk access. The project covers a range of database management capabilities, in
Allows the execution of raw SQL commands with parameter binding for complex data manipulation.
Python-Guide-CN is a Chinese translation of a comprehensive guide to idiomatic Python programming and software development. It serves as a curated programming tutorial and ecosystem reference, providing a structured path for learning Python syntax, standard libraries, and professional coding patterns. The project distinguishes itself by offering detailed instructions for setting up development environments across Windows, macOS, and Linux. It specifically focuses on the selection of interpreters and the management of virtual environments to ensure a consistent workspace. The guide covers a b
Covers the execution of parameterized or hand-written SQL queries for direct database interaction.
FreeSql 是一个 .NET 对象关系映射器(ORM)和数据访问层,可将面向对象的代码转换为适用于多种关系型数据库提供程序的 SQL。它作为一个流畅的 SQL 查询构建器和数据库架构同步器,允许开发者将数据库表和索引结构与实体类定义保持一致。 该框架专门针对 .NET Native AOT 进行了优化,以确保更小的内存占用和更快的启动时间。它包含一个数据库流量管理器,通过读写分离、动态分表和基于租户的数据隔离来分配负载。 其广泛的功能包括使用特定于提供程序的批量复制机制实现高性能数据摄入,利用窗口函数和递归 CTE 进行高级查询,以及基于 AOP 的数据变更审计监控。该系统还提供用于自动迁移的架构管理工具,以及用于从数据库元数据生成实体类的开发实用程序。
Runs raw SQL update statements with parameterized inputs for precise manual query control.
Pony is a Python object-relational mapper that maps classes to relational database tables using an object-oriented interface. It serves as a relational database toolkit providing the means to manage database transactions, identity mapping, and the lazy loading of related records. The project is distinguished by a SQL query translator that converts Python generator expressions into optimized SQL queries by analyzing the abstract syntax tree. It also includes a visual database schema designer for creating entity-relationship diagrams to automatically generate and synchronize relational database
Allows the execution of arbitrary SQL statements directly against the database when high-level abstractions are insufficient.