Search Results for "sql query analyzer"

SQLite.swift provides compile-time confidence in SQL statement syntax and intent. SQLite.swift provides a pure-Swift interface, a type-safe, optional-aware SQL expression builder. It also provides a flexible, chainable, lazy-executing query layer. Automatically-typed data access. A lightweight, uncomplicated query and parameter binding interface. Developer-friendly error handling and debugging.

WCDB is an efficient, complete, easy-to-use mobile database framework used in the WeChat application. It's currently available on iOS, macOS and Android. Easy-to-use. Through WCDB, you can get objects from database in one line code. WINQ (WCDB language integrated query), WINQ is a native data querying capability which frees developers from writing glue code to concatenate SQL query strings. ORM (Object Relational Mapping), WCDB provides a flexible, easy-to-use ORM for creating tables, indices and constraints, as well as CRUD through ObjC objects. Efficient. Through the framework layer and sqlcipher source optimization, WCDB have more efficient performance. ...

...As this library is auto-initialize, if you want to get the address log, add the following method and call (we have to do like this to avoid build error in release build as this library will not be included in the release build) using reflection. Using the Android Debug Database with an encrypted database. See all the data in the shared preferences used in your application. Run any sql query on the given database to update and delete your data.

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). ...

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....

...It relieves developers from dealing with low-level database requirements while saving development time. SQLite is an awesome embedded relational database. Still, writing SQL and parsing query results are quite tedious and time-consuming tasks. greenDAO frees you from these by mapping Java objects to database tables (called ORM, “object/relational mapping”). This way you can store, update, delete, and query for Java objects using a simple object oriented API. We want to provide the fastest Android ORM.

metagloss is an annotation-centric android library for reducing boilerplate code.