Search Results for "syntax"

mycli is an enhanced command-line client for MySQL and MariaDB that features syntax highlighting and intelligent auto-completion for database queries. Built for developers and DBAs, it improves productivity with features like query history, table suggestions, and colored output. The tool is designed to be both powerful and user-friendly, making interactive database work more efficient and visually intuitive.

...It includes a connection manager so you can save connections and switch between them without constantly retyping CLI arguments or connection strings. For querying, it emphasizes productivity features like syntax highlighting, searchable query history, and vim-style keybindings so power users can move fast. For exploring data at scale, it can load and inspect very large result sets and provides filtering and fuzzy search to find rows and values efficiently.

athenaSQL is Athena SQL query builder, inspired by sparkSQL. It borrow some sparkSQL’s concept sparkSQL. It was initially designed to eliminate the need for hard-coding SQL queries as strings within Python scripts and as an alternative to any bespoke SQL query templating. However, it offers the flexibility to be used in various ways as needed.

...This open-source tool works cross-platform and is proud to be a part of the dbcli community. mssql-cli supports a rich interactive command line experience, with features such as auto-completion, fewer keystrokes needed to complete complicated queries. Syntax highlighting, highlights T-SQL keywords. Query history, easily complete an auto-suggested query that was previously executed. Configuration file support, customize the mssql-cli experience for your needs. Multi-line queries, execute multiple queries at once using the multi-line edit mode. Non-interactive support, execute a query without jumping into the interactive experience.

littletable is a lightweight in-memory data manager of collections of Python objects, providing ORM-like access for querying and joining data using object attributes as pseudo-columns.

HyperSQL is like a doxygen plus javadoc for SQL, hypermapping SQL views, packages, procedures, and functions to HTML source code listings and showing all code locations where these are used.

pyproperties provides support for properties files in Python. Being written entirely from scratch it is not in any way derived from java.util.Properties. There are projects which try to mimic j.u.P. This is not one of them. It can read, parse and store properties files but also provides some more advanced functionality like manipulating comments and type-guessing.

PyDbLite is a pure-Python, fast, in-memory database with a Pythonic syntax (no SQL)

XML-RPC/FastRPC/MySQL console with Python-like syntax

Serialization + persistance : in a few lines of code, compress and annotate Python objects into SQLite; then later retrieve them chronologically by keywords without any SQL. Most useful "standard" module for a database to store schema-less data.

A fast, portable, pure-Python database engine, with a Pythonic syntax (no SQL)

ShelveDB is a pure python SQL-like database engine, where queries are preformed in analogous python syntax. It uses only built-in modules and shelve as the data structure. It has regular expression searching, plus native python typing and type checking.

...The most interesting feature of Pony is its ability to write queries to the database using generator expressions. Pony works with entities which are mapped to a SQL database. Using generator syntax for writing queries allows the user to formulate very eloquent queries. It increases the level of abstraction and allows a programmer to concentrate on the business logic of the application. Following is an example of a query in Pony: select(p for p in Product if p.name.startswith('A') and p.cost <= 1000) Pony translates queries to SQL using a specific database dialect. ...

This simple wrapper module written in Python that allows easy interfacing with a MySQL database and utilizes the MySQLdb module. It requires very little knowledge of actual SQL syntax and is very easy to use.