Search Results for "sql command line" - Page 3

Python Sqlite Shell - a drop-in replacement for the standard sqlite shell (www.sqlite.org), expanded to allow user defined SQL functions to be easily created within the shell or within a SQL script using an in-line python function definition.

pyxmdb is a database utility for exporting and importing data between a delimited text file and virtually any DBMS. Tested with Python 2.3-2.6, Linux and Windows, SQLite, MySQL, PostgreSQL, Oracle and Ingres. User extendable for any Python DB-API driver.

SPWrapper generates java (and now python) classes able to invoke stored procedures and to execute sql statements for you: you just have to give it the stored procedure name or the sql statement.

The dbshell (dbsh) provides common, interactive, programmable environment and simple shell to connect and manipulate your favorite DB content.

Musiql is a command-line frontend to MPlayer that stores track and playlist information in an SQLite database and allows access to this database through SQL queries entered on the command line.

This tool will analyze your MySQL binary log (binlog) files. (Requires mysqlbinlog). Query speed, distribution, and size are reported.

A set of tools for generating and maintaining database schemas and data. Generates create, drop and upgrade scripts, as well as importing and exporting data. Especially useful for developers of applications with databases.

PgWorksheet is a simple GUI frontend to PostgreSQL for executing SQL queries and psql commands without using the psql command line tool. Please see the project home page for bug reports, forums and installation instructions.

OrganizerCalendar is a command line utility written in python that will help you organize your upcoming appointments using only command line, so you can use for example ssh to manage your calendar from remote computer.

A Del.icio.us add-on Python script to search links in exported bookmark files. Instead of using public overloaded del.icio.us servers to find and retrieve your links, use yummy and let it search your exported delicious bookmark files locally much faster.

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.

An implementation of a truly relational database language with Python. Inspired by Date and Darwen's 'Third Manifesto'.

Goal of oraschemadoc is to provide detailed documentation for all objects in schema covering Oracle specific features. Result of execution of oraschemadoc is set of static xhtml files. There are more features under development...

Python DB driver for Java JDBC. Allows CPython programs to use a java JDBC driver to connect with a database server. It's API is Python DB compliant. ZJdbcDA (a zope database adapter) is also included.

Securely store unstructured data in (keyword, record) pairs. Both keywords and record data are encrypted. Ideal for storing passwords, account information, etc. Thus, srd is a general-purpose password vault or a secure rolodesk application.

Command-line event calendar software suitable for everyday use.

A collection of various programming tools, written mainly for my own pleasure.

Pony is an object-relational mapper. 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...

This tool generates Data Access Objects and Value Objects for PHP4/MySQL web applications. This greatly improves the readability of PHP scripts that use a MySQL database. Requires Python.

...Please note: this project is not maintained anymore. Make your objects persistent in a RDBMS, just by designing how your classes map to an RDBMS schema, without having to write a single line of SQL!

This tool creates a PHP class to interface to a given database table. The PHP class is a simple relational object mapper. It maps table columns to class attributes. It provides basic CRUD methods as well as utility methods such as CSV import and export.

Belzebub is a tool for searching for files on all your removable media disks (e.g. CD's, ZIP disks or backup tapes). The search is based on a SQL database (Postgres, sqlite, mssql are planned in the future).

Lino is a suite of Python packages for IT professionals who offer business applications for small and medium-sized enterprises.

RIFF Isnt a File Formatter. RIFF is a small & simple command line utility written in Python to convert text data files in another text format (like delimited, SQL dump and fixed witdh).

DataSiphon is a data manipulation and transformation utility written in Python. It provides both command-line and graphical interfaces and allows users to easily move data between databases or files, performing on-the-fly Python-scripted transformations.