Search Results for "sql queries"

SQLDelight is a multiplatform Kotlin SQL library developed by Square. It generates typesafe Kotlin APIs from your SQL statements and integrates seamlessly with Android, iOS, JVM, and web platforms. SQLDelight ensures compile-time verification of SQL queries and supports migrations, transactions, and coroutines, making it a robust solution for cross-platform persistence.

Ktorm is a lightweight and efficient ORM Framework for Kotlin directly based on pure JDBC. It provides strong-typed and flexible SQL DSL and convenient sequence APIs to reduce our duplicated effort on database operations. All the SQL statements, of course, are generated automatically. Ktorm is open source and available under the Apache 2.0 license. Please leave a star if you've found this library helpful.

sq is a command line tool that provides jq-style access to structured data sources: SQL databases, or document formats like CSV or Excel. sq executes jq-like queries, or database-native SQL. It can join across sources: join a CSV file to a Postgres table, or MySQL with Excel. sq outputs to a multitude of formats including JSON, Excel, CSV, HTML, Markdown and XML, and can insert query results directly to a SQL database. sq can also inspect sources to view metadata about the source structure (tables, columns, size). ...

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.

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.

Query2Report provides a simple opensource business intelligence platform that allows users to build report/dashboard for business analytics or enterprise reporting. The application transforms bunch SQL queries to beautiful google charts. The application caters to real time reporting with automatic refresh functionality. Refer to video tutorials Concepts - https://youtu.be/NdEUZ2suiv8 Data Analytics Demo - https://youtu.be/evCf74Ou7kg Data Forecast Demo - https://youtu.be/Nmi1UIDpFpM Report Showcase - https://youtu.be/gxlEGq5iSm8 Getting Started - https://youtu.be/vyU7BUE5rbs Building First Report - https://youtu.be/MZm6rhf2_Ts Source Repo GitHub : https://github.com/yogeshsd/query2report

...Main features we want to achieve with KittyORM are: * simple and clear API; * high flexibility of working with model POJO files via database mappers that grants you an ability to focus on your business processes not on working with raw SQL queries; * full support of all features to create your SQLite schema via built-in annotations; * flexible way to manage all things you may want to change or implement; KittyORM project contains ORM library itself, demo and tutorial application available at Play Market and documentation located at https://akaish.github.io/KittyORMPages/ Current version: [0.1.2]