Edit Complex Sql

Easy and quick database administration, natively supports MSSQL, MySQL, SQLite, Postgre SQL, MS Access. Main features: Creating and restoring backups. Transfer data between databases, tables and data files (supported formats are XML, CSV, HTML, Excel). Edit database schema, tables, views, view,...

DBIx::SQL::Abstract is a Perl module that provides a convenient abstraction layer to a database. SYNOPSIS use DBIx::SQL::Abstract; my $dbh = DBIx::SQL::Abstract->new( %dbcfg ); Building SQL Abstractions. my($query, @bind) = $dbh->select($table, @fields, %where, @order); my($query,...

Edit by Text Editors allows you to open a file with Kate, Kwrite, Kedit, Khexedit by a KDE service menu. To install the service menu you must copy editby.desktop in ~/.kde/share/apps/konqueror/servicemenus. Download KDE-Apps.org Community Portal for KDE Applications Software Office Multimedia...


Platforms: *nix

Edit with gvim - with GVIM serverlist is a "Edit with gvim" context menu in Konqueror. Has support for gvims serverlist. This lets you open a file into any already running gvim instance. This is something I saw in Windows Explorer when I was using gvim there. After using it I couldnt believe I...


Platforms: *nix

Chemistry::SQL is an access database functions module. SYNOPSIS use strict; use Chemistry::SQL; use Chemistry::Artificial::SQL; my $db_name = $ARGV[0]; my $file = $ARGV[1]; my $db1 = Chemistry::SQL::new(db_host=>"127.0.0.1",db_user=>"root",db_port=>"3306",db_pwd=>"",...


Platforms: *nix

The Complex Language project is an object oriented programming language intended for scripting or rapid prototyping of applications. The design goals were to have very few simple but powerful concepts and to be easy to use and easy to learn. The project provides a working interpreter along with...


Platforms: *nix

SQL::Routine::Language is a Perl module for what language or grammar SQL::Routine speaks. SQL::Routine contains SQL schemas and queries, represented as a tree of atomic tokens; it is structurally like an abstract syntax tree or an XML DOM, but one that only accepts, respectively, a specific...


Platforms: *nix

SQL::Abstract::Limit is a portable LIMIT emulation. SYNOPSIS use SQL::Abstract::Limit; my $sql = SQL::Abstract::Limit->new( limit_dialect => LimitOffset );; # or autodetect from a DBI $dbh: my $sql = SQL::Abstract::Limit->new( limit_dialect => $dbh ); # or from a Class::DBI class: my...


Platforms: *nix

SQL::Interpolate is a Perl module to interpolate Perl variables into SQL statements. SYNOPSIS use SQL::Interpolate qw(:all); # Some sample data to interpolate: my $s = blue; my @v = (5, 6); # Variable references are transformed into bind parameters. # The most basic usage involves...


Platforms: *nix

SQL Relay is a persistent database connection pooling, proxying and load balancing system for Unix and Linux..


Platforms: *nix

SQL::Preproc is a Perl module to embed SQL in your Perl (ala SQL preprocessors). SYNOPSIS use SQL::Preproc subclass => Chart, emit => 1, keepsql => 1, syntax => [ Teradata ], pponly => 1, relax => 1, alias => 1, debug => 1; use DBI; use DBI qw(:sql_types); use...


Platforms: *nix

Strings edit is a library that provides I/O facilities for integer, floating-point, Roman numbers, and strings. Both input and output subroutines support string pointers for consequent stream processing. The output can be aligned in a fixed size field with padding. Numeric input can be checked...


Platforms: *nix

SQL Admin is a Java client application to connect and send queries to different databases through JDBC. SQLAdmin uses the brand new SWT Toolkit. The main idea is to create a multiplatform and multidatabase thin client. For example, you can connect to an Microsoft SQL Server from a Linux...


Platforms: *nix

SQL::Translator::Manual is a Perl module that contains a manual for SQL translator. SYNOPSIS SQL::Translator (AKA "SQLFairy") is a collection of modules for transforming (mainly) SQL DDL files into a variety of other formats, including other SQL dialects, documentation, images, and code. In...


Platforms: *nix

SQL::Translator::Producer::GraphViz is a GraphViz producer for SQL::Translator. SYNOPSIS use SQL::Translator; my $trans = new SQL::Translator( from => MySQL, # or your db of choice to => GraphViz, producer_args => { out_file => schema.png, add_color => 1, show_constraints => 1,...


Platforms: *nix

Oracle::SQL is a Perl extension for building SQL statements. SYNOPSIS use Oracle::SQL; No automatically exported routines. You have to specifically to import the methods into your package. use Oracle::SQL qw(:sql); use Oracle::SQL /:sql/; use Oracle::SQL :sql; This is a package...


Platforms: *nix

SQL::Statement::Embed can embed a SQL engine in a DBD or module. SQL::Statement is designed to be easy to embed in other modules and to be especially easy to embed in DBI drivers. It provides a SQL Engine and the other module needs to then provide a data source and a storage mechanism. For...


Platforms: *nix

RTx::RT34::Bulk::CF::Edit is a Perl module to allow bulk editing of custom fields..


Platforms: *nix

Dimedis::Sql is a SQL/DBI Interface for banking applications. SYNOPSIS use Dimedis::Sql; my $sqlh = new Dimedis::Sql ( ... ); $sqlh->install ( ... ); my $seq_id = $sqlh->insert ( ... ); my $modified = $sqlh->update ( ... ); my $blob_sref = $sqlh->blob_read ( ... ); $sqlh->use_db (...


Platforms: *nix

SQL::Shell is a command interpreter for DBI shells. SYNOPSIS use SQL::Shell; #Initialise and configure my $sqlsh = new SQL::Shell(%settings); $sqlsh->set($setting, $new_value); $value = $sqlsh->get($setting); #Interpret commands $sqlsh->execute_command($command);...


Platforms: *nix