Search Results for "sql queries"
Sort By:
Showing 131 open source projects for "sql queries"
View related business solutions-
Veeam Data Platform v13.1 - Get Your Free TrialTry Veeam Data Platform today. Experience the unified platform that's secure by design, portable by default, and proven to recover clean, fast, and anywhere.
-
MongoDB Atlas runs apps anywhereMongoDB Atlas gives you the freedom to build and run modern applications anywhere—across AWS, Azure, and Google Cloud. With global availability in over 115 regions, Atlas lets you deploy close to your users, meet compliance needs, and scale with confidence across any geography.
-
1
Ebean
Ebean ORM
Ebean provides multiple levels of query abstraction ORM Queries, mixed with SQL, DTO Queries, SqlQuery and JDBC. Work at the highest level of abstraction and drop down levels as needed. Built in DB migration generation and running. Support for "rebase" migrations as well as repeatable, init and 'normal' migrations. Ebean produces SQL that you would hand craft yourself. Use great SQL, never generate SQL cartesian product, always honor relational limit/offset. ... -
2
Chat2DB
AI-driven database tool and SQL client
Save time by working with data. Connect to all your data sources, and instantly generate optimal SQL for fast lightning information. If you don't know SQL well, you can get instant information without writing SQL. Generate high-performance SQL for your complicated queries using natural language, as well as correcting errors and getting AI suggestions to optimize the performance of SQL queries. Developers can write complex SQL queries quickly and accurately with the help of the AI SQL editor, saving time and improving development efficiency. ... -
3
CrateDB
CrateDB is a distributed and scalable SQL database
CrateDB is a distributed SQL database designed for massive machine data and real-time analytics. It combines the scalability and performance of NoSQL with the power and simplicity of SQL, allowing for horizontal scaling, full-text search, and complex queries over large datasets. Built in Java and powered by Elasticsearch and Lucene, CrateDB is optimized for high-velocity data ingestion and dynamic queries. -
4
XTDB
General-purpose bitemporal database for SQL, Datalog & graph queries
XTDB is a general-purpose bitemporal database for SQL, Datalog & graph queries. XTDB contains a perfect, immutable record of every fact your system has ever known. See the entire history of your business, everywhere. Immutable records are incomplete without time-traveling queries. XTDB allows you to query the entire timeline. Make retroactive corrections, simplify data migrations, and get clarity on out-of-order events. -
Earn up to 16% annual interest with Nexo.Generate interest, access liquidity without selling, and execute trades seamlessly. All in one platform. Geographic restrictions, eligibility, and terms apply.
-
5
jOOQ
jOOQ is the best way to write SQL in Java
jOOQ generates Java code from your database and lets you build type-safe SQL queries through its fluent API. jOOQ is an internal DSL and source code generator, modeling the SQL language as a type-safe Java API to help you write better SQL. -
6
Pinot
Apache Pinot - A realtime distributed OLAP datastore
...Apache Pinot supports dimension lookup joins currently. Full SQL join support in Apache Pinot is coming soon. In the interim, full SQL joins can be performed by querying Pinot via the Trino or PrestoDB connector. Apache Pinot provides SQL interface for querying interactively, as well as programmatically via rest-api. -
7
DQO Data Quality Operations Center
Data Quality Operations Center
...DQO comes with around 100 predefined data quality checks which helps you monitor the quality of your data. Table and column-level checks which allows writing your own SQL queries. Daily and monthly date partition testing. Data segmentation by up to 9 different data streams. Build-in scheduling. Calculation of data quality KPIs which can be displayed on multiple built-in data quality dashboards. -
8
Apache Phoenix
Mirror of Apache Phoenix
Apache Phoenix is a SQL skin over HBase delivered as a client-embedded JDBC driver targeting low latency queries over HBase data. Apache Phoenix enables OLTP and operational analytics in Hadoop for low latency applications by combining the best of both worlds. The power of standard SQL and JDBC APIs with full ACID transaction capabilities and the flexibility of late-bound, schema-on-read capabilities from the NoSQL world by leveraging HBase as its backing store. ... -
9
QuestDB
An open source SQL database designed to process time series data
QuestDB is a high-performance, open-source SQL database for applications in financial services, IoT, machine learning, DevOps and observability. It includes endpoints for PostgreSQL wire protocol, high-throughput schema-agnostic ingestion using InfluxDB Line Protocol, and a REST API for queries, bulk imports, and exports. QuestDB implements ANSI SQL with native extensions for time-oriented language features. -
AI-generated apps that pass security reviewRetool lets you generate dashboards, admin panels, and workflows directly on your data. Type something like “Build me a revenue dashboard on my Stripe data” and get a working app with security, permissions, and compliance built in from day one. Whether on our cloud or self-hosted, create the internal software your team needs without compromising enterprise standards or control.
-
10
Siddhi Core Libraries
Stream Processing and Complex Event Processing Engine
Fully open source, cloud-native, scalable, micro streaming, and complex event processing system capable of building event-driven applications for use cases such as real-time analytics, data integration, notification management, and adaptive decision-making. Event processing logic can be written using Streaming SQL queries via graphical and source editors, to capture events from diverse data sources, process and analyze them, integrate with multiple services and data stores, and publish output to various endpoints in real time. Agile development experience with SQL-like query language and graphical drag-and-drop editor supporting event simulation. ... -
11
BigQuery Utils
Useful scripts, udfs, views, and other utilities for migration
BigQuery Utils is a large utility repository focused on helping users operate, optimize, and migrate workloads in BigQuery through reusable assets rather than a single application. It brings together scripts, user-defined functions, views, stored procedures, dashboards, notebooks, and supporting tools that address common data warehouse and analytics tasks. The repository is especially useful for organizations that need practical building blocks for migration from other database systems,... -
12
JimuReport
Open source drag-and-drop reporting and dashboard builder platform
...JimuReport also includes components for building interactive charts, data tables, and analytical displays that can be used in enterprise applications. It can connect to multiple data sources and retrieve data through SQL queries, APIs, or other structured formats. It can be embedded into Java applications using Spring Boot integration modules. -
13
MyBatis Pagination
A pagination plugin
If you are using MyBatis, it is recommended to try this pagination plugin. This must be the most convenient pagination plugin. PageHelper supports any complex single-table, multi-table queries. As to some special cases, please refer to the Important notes. Through a comprehensive sample code and test, the basic usage of adding, deleting, modifying, and checking operations in the MyBatis XML mode and annotation mode is explained, and the application of dynamic SQL in different aspects and the best practice program in the use process are introduced. ... -
14
AWS X-Ray Java Agent
The official AWS X-Ray Auto Instrumentation Agent for Java
The AWS X-Ray Java Agent is a drop-in solution that enables the propagation of X-Ray traces within your Java web applications and servlet-based microservices. This includes automatic tracing for supported frameworks and libraries, including Spring, the AWS SDK, Apache HTTP clients, and JDBC-based SQL queries. The agent enables you to use the X-Ray SDK out of box, and requires no code changes to enable the basic propagation of traces. See the chart below for the current feature parity between the AWS X-Ray SDK and the AWS X-Ray Java Agent. The X-Ray Java Agent is implemented using the DiSCo library, a toolkit for building Java Agents in distributed environments. ... -
15
Orbit
ORBIT : Operating Business Intelligence Tool
ORBIT : Operating Business Intelligence Tool Making Data Accessible Through Centralized Database Access ORBIT is a business intelligence tool designed to make data accessible to a broad audience within your company by centralizing access to databases. With this application, users can easily create reports, perform interactive analyses, and extract insights from raw data. The application simplifies data handling by providing easy-to-use features for non-technical users while maintaining... -
16
ANTLR
Parser generator to read, process, or translate structured text
...It’s widely used in academia and industry to build all sorts of languages, tools, and frameworks. Twitter search uses ANTLR for query parsing, with over 2 billion queries a day. The languages for Hive and Pig, the data warehouse and analysis systems for Hadoop, both use ANTLR. Lex Machina uses ANTLR for information extraction from legal texts. Oracle uses ANTLR within SQL Developer IDE and their migration tools. NetBeans IDE parses C++ with ANTLR. The HQL language in the Hibernate object-relational mapping framework is built with ANTLR. -
17
DB Explorer
The modern AI‑first database client for developers DBAs and analyst
DB Explorer is a free, cross-platform database query tool and schema explorer built for developers, DBAs, and data analysts. It provides a clean graphical interface for connecting to multiple database systems, writing and executing SQL, exploring schemas, monitoring database health, and generating SQL queries using AI — all from a single application. Supported Databases: PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite, Amazon DynamoDB, and any JDBC-compatible database. -
18
DAOMedge
DAO for all database server types with the Java POJO code generator
Java Data Access Objects. A DAO system(ish). A simple to use DAO type library that transfers between database rows and POJO and vice versa. This translates from Java to SQL and back again. This code was written by a DBA whose approach isn't to persist java objects but to normalize the database and work from that side. The library and generator are fully documented. This comes with a simple scripting language language, called NotSQL because it is Not SQL, to make writing queries much easier. -
19
JDBC Driver for Amazon Neptune
Amazon Neptune JDBC Driver by Amazon Web Services
This driver provides read-only JDBC connectivity for the Amazon Neptune service using SQL, Gremlin, openCypher and SPARQL queries. The driver comes packed in a single jar file. To use the driver, place the jar file in the classpath of the application which is going to use it. For the initial public preview release, the driver will be available for download on GitHub along with the driver's .jar file and .taco file. To use the Driver in BI tools, please refer to the documentation. ... -
20
GETL
ETL engine based on Groovy
P.S. Dear friends. Repository migration to https://github.com/ascrus/getl . You can download jar file from this site or maven. GETL - based package in Groovy, which automates the work of loading and transforming data. His name is an acronym for «Groovy ETL». GETL is a set of libraries of pre-built classes and objects that can be used to solve problems unpacking, transform and load data into programs written in Groovy, or Java, as well as from any software that supports the work with... -
21
This project aims at creating an open source chemistry plugin / cartridge for the relational database system Oracle. Free Oracle chemistry cartridge.
-
22
SQLancer
Automated testing to find logic and performance bugs
SQLancer is a tool to automatically test Database Management Systems (DBMSs) in order to find bugs in their implementation. That is, it finds bugs in the code of the DBMS implementation, rather than in queries written by the user. SQLancer has found hundreds of bugs in mature and widely-known DBMSs. SQLancer implements approaches for automatically generating SQL statements. It contains various hand-written SQL generators that operate in multiple phases. First, a database schema is created, which refers to a set of tables and their columns. ... -
23
proreports
Simple Reporting System
ProReports is simple reporting system designed to generate reports in popular office formats - PDF, XLS, RTF, HTML, TXT, XML, JSON, CSV, PNG, GIF. These reports are generated based on the definition in the internal database system. ProReports supports jrxml (JasperReport) format. This type of report templates can be prepared in external editor, such as iReport. Also user can prepare report in internal format of ProReports (simple Visual Programming Language mixed with PHP5 and JAVA or... -
24
ORMLite Android
ORMLite Android functionality used in conjunction with ormlite-core
This package provides Android-specific functionality. Users that are connecting to SQL databases via JDBC connections should download the ormlite-jdbc package instead of this Android one. Object Relational Mapping Lite (ORM Lite) provides some simple, lightweight functionality for persisting Java objects to SQL databases while avoiding the complexity and overhead of more standard ORM packages. -
25
LitePal for Android
Android library that makes developers use SQLite database
LitePal is an open-source Android library designed to simplify working with SQLite databases. It uses an object-relational mapping approach so developers can perform most database operations without writing SQL. Models can be mapped directly to database tables with minimal configuration. The library automatically handles table creation, alteration, and deletion as application models evolve. It provides APIs for saving, updating, deleting, querying, aggregate operations, and transactions. LitePal also supports multiple databases, fluent queries, Java and Kotlin development, and direct SQL when greater control is required.
