LinuxLinks.com
Newbies What Next ? News Forums Calendar
Home | Register | News | Forums | Portal Pages | MyLinks | New | Hot | Link Us

Search/Browse

 Category Gateway
More Options
Category:  


LinuxLinks News
 · Chess in a Few Bytes
 · Learn the Art of Computer Programming With These Great Free Beginner Books
 · CD Audio Grabbers
 · fitlet is a tiny fanless PC full of openness
 · MintBox Mini gives Linux users a pocket-sized PC
 · 6 Invaluable Assembly Books
 · Why Mac users dont switch to Linux
 · MIPS Creator CI20 review
 · Getting a Time Without NTP
 · CES 2015: Intel announces $149 Compute Stick which runs Windows and Linux
(more...)

 

Latest Links
cbmfs
rufascube
RufasGate
RufasSlider
RufaSwap
WorldCupSokerban
Hexinator
rufascube
fv
(more...)

 



Top : Software : Databases : Utilities

Categories:

 Conversion (25)
 Developer (49)
 Optimization (8)
 Reports (11)

Highlights
Chess in a Few Bytes
Linux has a good range of extremely strong chess engines such as Stockfish, Critter, Togo II, Crafty, GNU Chess, and Komodo. The chess engines featured in this article offer no match to a good chess engine, but they show how much can be achieved with a minuscule codebase.

(Read more)
ScummVM
ScummVM is a program which allows you to run certain classic graphical point-and-click adventure games, provided you already have their data files. The clever part about this: ScummVM just replaces the executables shipped with the game, allowing you to play them on systems for which they were never designed. Read more

Links:

  • A_DBC
    Abstract Data Base Connector is an abstact OOP way to connect to several databases.
  • Acquired Virtual Distribution
    AVD is a continuation of the swim project. The goal is to create a suitable SQL server from swim's not-installed DB, and to maintain the swim client. AVD will be used as a gBootRoot method.
  • auth postgresql
    auth postgresql would provide the capability to keep all users info in a PostgreSQL database instead than in plain text files (as usually) and even more have a more performant system than NIS+.
  • BabelQL
    BabelQL is a C preprocessor script that allows many different SQL dialects to be generated from a single source file.
  • Barman
    Barman (backup and recovery manager) is an administration tool for disaster recovery of PostgreSQL servers written in Python. It allows to perform remote backups of multiple servers in business critical environments and help DBAs during the recovery phase.
  • Broadcast Oracle Sql
    A Python/Perl/Ruby script useful to submit a SQL statement to several Oracle instances.
  • Cacti
    Cacti is a complete frontend to RRDTool, it stores all of the necessary information to create graphs and populate them with data in a MySQL database. The frontend is completely PHP driven. Along with being able to maintain Graphs, Data Sources, and Round Robin Archives in a database, cacti handles the data gathering. There is also SNMP support for those used to creating traffic graphs with MRTG. Read more
  • cliPSafe
    cliPSafe is a command line interface (CLI) to Password Safe databases. cliPSafe only works with version 3 databases and it currently only operates in read-only mode.
  • cx_OracleDBATools
    Contains a number of Python scripts that handle Oracle DBA tasks in a cross platform manner.
  • Database Modeller
    Database Modeller is a simple tool for drawing entity-relationship (database schema) diagrams using Crow's Foot or Visio's Relational notation.
  • DataDiff
    DataDiff is a utility for comparing the contents of two identical sets of tables in MySQL and returning the rows that differ between the two.
  • dba-dialog
    A dialog interface to the four major RDMS (Oracle, DB2, PostgreSQL and MySQL). It is written in bash, and uses the dialog and Xdialog facility to let a DBA perform various administration tasks.
  • dbauth
    dbauth is a command-based utility used for creating, updating, removing and/or importing user's authenticated information such as: user IDs, passwords, groups and optionally comments, in a DB or DBM database format. dbauth supports three types of password encryption method and all types of Apache Limit directives.
  • DBConsole
    DBConsole is a database shell that currently supports SQLite, PostgreSQL, and MySQL.
  • DBD::InterBase
    A DBI driver for InterBase, written using InterBase C API.
  • dbischema
    A database schema update and porting tool. dbischema is written in perl, it requires DBI, XML::Parser, and DBD::mysql, DBD::Pg or both.
  • dbo
    dbo is a database object relational mapper (ORM) written entirely in Python. Tables are represented using a straightforward python class and row instances are encapsulated as python instances. Joins, views, transactions, and more.
  • DBOW
    DBOW is a database compiler-compiler or front-end. It takes table definitions in a meta language and prepares C, C++, PHP, Perl (etc) functions for manipulating the database. It will also produce SQL table data for MySQL.
  • DBTCP
    DBTCP is a proxy server for ODBC connection. It allows you to make a query from a linux machine to a database in a Windows machine through ODBC.
  • dbtool
    dbtool can be used to store and retrieve data in a key/value format in a hash database. Perl compatible regular expressions are supported both for storing and retrieving of data. It's main advantages are the ability to maintain huge amounts of data and speed. As of version 1.4 dbtool supports encrypted databases using the RIJNDAEL cipher algorithm.
  • DbtuTools
    A collection of tools for IBM's DB2 UDB database.
  • DiaDBDesigner
    DiaDbDesigner is a standalone module for constructing databases with the help of the diagram creation program Dia. In an easy to use environment you can join multiple diagrams together to form one model of interconnected tables.
  • Dumpgdbm
    Dumpgdbm is a batch or interactive tool which can dump keys and data from a GNU DBM file. It can display data in ASCII, decimal, hex, and octal formats. Posix regexp search functions are also provided.
  • ElyCA
    ElyCA is a certification authority (as well known as CA) written in Python released the General Public License (GPL) which provides an easy to use web interface to generate private keys, certificates, pkcs#12 and CRLs.
  • Emacs Photo Database
    Emacs Photo Database provides functions for managing a collection of photographic films, negatives, and prints stored in a SQL database. It is targeted at fine-art photographers and other people who use a wet-process workflow instead of digital imaging.
  • EMS MySQL Manager
    (commercial) EMS MySQL Manager is a powerful tool for MySQL Database Server administration and development. MySQL Manager works with any MySQL versions from 3.23 to 5.02 and supports all of the latest MySQL features including views, stored procedures and functions, InnoDB foreign keys and so on. It offers plenty of powerful tools for experienced users to satisfy all their needs. MySQL Manager has a new state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.
  • EMS MySQL Utils
    (commercial) Provides powerful data management utilities for MySQL Server, which make your work with the server much easier and faster. Currently MySQL Utils include MySQL Export - a powerful tool for MySQL data export, and MySQL Import - an utility for quick importing data to MySQL tables.
  • EMS PostgreSQL Utils
    (commercial) Powerful data management utilities for PostgreSQL Server, which make your work with the server much easier and faster. Currently PostgreSQL Utils include PostgreSQL Export - a powerful tool for PostgreSQL data export, and PostgreSQL Import - an utility for quick importing data to PostgreSQL tables.
  • FileExtender
    FileExtender is a Perl script to evaluate embedded SQL statements in any kind of text file (incl. HTML files) and extends these files with results from the database queries.
  • Freedbtool
    Freedbtool is a component of the Cjukebox music management system. It is a commandline tool for accessing the freedb.org database. It supports both download and upload of database files via the http version of the protocol. It also includes a modified version of Jeremy D. Zawodny's discid program
  • Gentry
    GTK Entry: a program to do data entry into a MySQL database using an GTK GUI application.
  • Graffiti
    Graffiti is an RDF store based on dynamic translation of RDF queries into SQL. It allows you to map any relational database schema into RDF semantics and vice-versa, and to store any RDF data in a relational database.
  • GreenSQL
    GreenSQL is a database firewall used to protect databases from SQL injection attacks. GreenSQL works in a proxy mode and has built-in support for MySQL. The logic is based on evaluation of SQL commands using a risk scoring matrix as well as blocking known DB administrative commands (such as DROP and CREATE).
  • GTK DBF Editor
    GTK DBF Editor is a simple DBF editor built with GTK+. It allows basic editing of DBF (dBase) files.
  • HandySQL
    HandySQL is a perl interface for MySQL. It connects directly to MySQL server, not using DBI/DBD and Mysql-msql modules. The main routines are written in C, and the top-level object-oriented interface is done in perl.
  • HashMan Database Tool
    A tool for managing GDBM, traditional DBM and Berkeley/Sleepycat DB hashfiles. Database through a command line interface or an interactive terminal based interface.
  • IMDbPY
    IMDbPY is a Python package useful to retrieve and manage the data of the IMDb movie database about both movies and people. Platform-independent and written in pure Python (and few C lines), it can retrieve data from both the IMDb's web server and a local copy of the whole database.
  • InnoInfo
    InnoInfo is a small command-line utility to analyze and dump data from innodb databases. It works completely seperate from MySQL and accesses the innodb data files directly. It can also be used to recover data from broken innodb stores.
  • JasperETL
    JasperETL is a complete and ready-to-run data integration platform for organizations of all sizes, providing high performance data extract-transform-load (ETL) capabilities. JasperETL is appropriate for all analytic and operational data integration needs, regardless of complexity. When used as part of the JasperSoft BI Suite, organizations can develop, manage, and document data integration processes for more accurate, more comprehensive reporting and online analytical processing (OLAP) with JasperReports, JasperServer, and JasperAnalysis.
  • JDB
    A package of commands for manipulating flat-ASCII databases from shell scripts. JDB is useful to process medium amounts of data.
  • KESI
    KESI is a tool to easily import CSV files into your SQL database tables. CSV files can be created using almost every spreadsheet and lots of other applications (E.g. KSpread). KESI can be configured to understand almost every possible CSV format. Additionally it is very easy to use, because of its KDE GUI.
  • KFreeDB
    KFreeDB is a KDE interface to the FreeDB CD information database. It allows you to query the FreeDB disc database and also submit discs yourself. It is one of the very few applications that supports submitting by HTTP protocol.
  • KSqlAnalyzer
    The KSqlAnalyzer is a tool for easy accessing the data of a MS-SQL-Database. It is made for developing and testing new SQL-Query's direclty on the Server. The functionality and the look&feel are similar to the program 'SQL-Query-Analyzer' written by Microsoft.
  • Lantica Sesame
    (commercial) Lantica Sesame is a cross-platform database manager. It features a form and report designer, query by example, Symantec Q&A compatibility and translator, client/server operation, and an embedded programming language.
  • libdejector
    Libdejector is a database tool which defeats SQL injection attacks by performing context-free validation of queries. While written in C, SWIG wrappers exist for Python and other languages will be following soon.
  • Maatkit
    Maatkit is a set of high-quality command-line tools for open-source databases, such as MySQL and PostgreSQL. The tools enable power users to do their work more safely and quickly by relying on tested software instead of scripting things themselves. Read more
  • Manqod
    Manqod is a desktop application for small companies to organize their data on an interface customised for them by themselves
  • MDB Tools
    MDB Tools is a set of libraries and utilities for reading Microsoft Access database (MDB) files.
  • MTK-MYB
    MTK-MYB provides a MySQL backup tool. This application was written with a focus on logging and monitoring. It comes with several addons for monitoring and reporting as well as backup integrity checks.
  • mtop
    mtop (MySQL top) monitors a MySQL server showing the queries which are taking the most amount of time to complete. Features include 'zooming' in on a process to show the complete query, 'explaining' the query optimizer information for a query and 'killing' queries. In addition, server performance statistics, configuration information, and tuning tips are provided.
  • mydbdoc
    mydbdoc is a command-line tool for auto-documenting MySQL schemas. Output formats include XML, HTML, and TXT. mysqldoc takes COMMENT arguments and translates them into useful formats.
  • MyLUA
    A patch to MySQL that allow users to write procedures in a scripting language called LUA.
  • mylvmbackup
    mylvmbackup is a Perl script for quickly creating backups of MySQL server's data files. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, makes an LVM snapshot of the volume containing the MySQL data directory, and unlocks the tables again.
  • MySQL Cluster Administration Tools
    The MyCAT project is a toolset for managing MySQL/Linux servers, and could be helpful for anyone managing a network of *nix servers whether running MySQL Cluster, standard replication, or not running MySQL at all.
  • mysql_auth
    An authentication module for the Squid proxy server to authenticate users on an mysql database. The database is a single table, and the table is a very simple user-password pair, with plain or encrypted passwords.
  • MySQL_CBN
    A script that check, periodically the tables of a MySQL Server. Using the BACKUP, CHECK, OPTIMIZE and ANALYZE, the script checks if everything is ok and alert you if anything is wrong.
  • mysqlconf
    mysqlconf is a Linuxconf module to help you configure MySQL database. It currently supports basic configuration like creating/destroying databases and users. It also allows to configure a few parameters in the my.cnf file.
  • mysqldiff
    mysqldiff is a Perl script front-end to the CPAN module MySQL::Diff which compares the data structures (i.e. table definitions) of two MySQL databases, and returns the differences as a sequence of MySQL commands suitable for piping into mysql which will transform the structure of the first database to be identical to that of the second (c.f. diff and patch).
  • NdeX
    A command line utility for fast binary searching sorted flat file constant databases. Partial key searches and files with tab delimited fields are supported. The archive, ndex.tar.gz, consists of the ANSI Standard C sources for the ndex program, and the rename, program that can be used to update a database, without locking, in a multiuser environment.
  • Object Relational Membrane
    The Object Relational Membrane is a Python package that provides the functionality of an object relational layer like EJB or other persistence storage systems. It is a thin compatibility layer between SQL table layouts and Object Oriented Python. While providing a good deal of functionality, it tries to be as small and simple as possible. It currently works with PostgreSQL, Firebird and MySQL.
  • odbc-bench
    OpenLink ODBC Bench is an open-source ODBC Benchmarking tool providing real-time comparative benchmarking for ODBC Drivers, Database Engines, and Operating Systems combinations.
  • OpenFTS
    OpenFTS (Open Source Full Text Search engine) is an advanced PostgreSQL-based search engine that provides online indexing of data and relevance ranking for database searching. Close integration with database allows use of metadata to restrict search results.
  • PEAR MDB
    PEAR MDB is a merge of the PEAR DB and Metabase php database abstraction layers. It provides a common API for all support RDBMS. The main difference to most other DB abstraction packages is that MDB goes much further to ensure portability.
  • pgBadger
    pgBadger is a PostgreSQL log analyzer build for speed with fully detailed reports from your PostgreSQL log file. It is a small Perl script that aims to replace and outperform the old php script pgFouine.
  • pgdiff
    pgdiff compares the structures of two PostgreSQL databases and returns the differences as a sequence of SQL commands which can be fed to psql to transform the structure of the first to be identical to the second (analagous to diff and patch).
  • pgmp
    pgmp is a PostgreSQL extension to add the GMP data types and functions directly into the database.
  • pgnotifyd
    pgnotifyd connects to a PostgreSQL database, listening for the named asynchronous notification. When notification is received, it executes the given command.
  • PgSqlClient
    PgSqlClient is an ADO.NET Data provider for PostgreSQL 7.4+ written in C#, 100% managed code, for use with MS .NET and Mono:: platforms, with support for the 3.0 protocol of PostgreSQL.
  • PostGIS
    PostGIS adds support for geographic objects to the PostgreSQL object-relational database. In effect, PostGIS "spatially enables" the PostgreSQL server, allowing it to be used as a backend spatial database for geographic information systems (GIS), much like ESRI's SDE or Oracle's Spatial extension.
  • Postgresql AutoDoc
    Postgresql AutoDoc is a utility which will run through PostgreSQL system tables and returns HTML, Dot, Dia and DocBook XML which describes the database.
  • protosquared
    A "data server prototype". It supports several data sources, such as XML and SQL databases and the communication protocol is highly configurable too.
  • psycopg
    psycopg is a PostgreSQL database adapter for the Python programming language. It was written from scratch with the aim of being very small and fast, and stable as a rock. The main advantages of psycopg are that it supports the full Python DBAPI-2.0, being thread safe at level 2 and providing some very usefull extensions like the user-defined type casters.
  • pxview
    pxview is a program to read Paradox DB files. It is based on the pxlib library. pxview allows to output csv for reading with spread sheets, sql to import into a relational database, html and sqlite.
  • Python Schema Diff
    Python Schema Diff is a python-based tool which permits to give the differences between two database schema. Its HTML rendering makes it easy for sharing this useful information among a team.
  • Querylog
    Querylog is a console tool for performing SQL queries on a (log) files. Lines from one or more text files or stdin are matched, using regular expressions to an in memory database on which SQL queries can be performed.
  • RecDB
    RecDB is a recommendation engine built entirely inside PostgreSQL 9.2. RecDB allows application developers to build recommendation applications in a heartbeat through a wide variety of built-in recommendation algorithms like user-user collaborative filtering, item-item collaborative filtering, singular value decomposition.
  • Round-Robin SQL
    Round Robin SQL (RRS) is a SQL implementation of a round robin database.
  • Ruby Dataquery Shell
    RDQS is a shell for querying various datasources such as SQL from a common interface. It does/should offer different data outputs, syntax highlighting, (grammatical) completion, shell interaction (e.g. backticks) and programmability.
  • scrmgr
    SCRMGR is a curses-based (text screen or 'console') screen manager and data entry system. It makes heavy use of "softkey labels" and "softkeys" (a.k.a. function keys F1-F10) to guide the user.
  • ShellSQL
    ShellSQL is a suite of programs designed to enable LINUX/UNIX shell scripts to connect to SQL engines and execute SQL queries and commands in a simple way enabling intergration with the rest of the script.
  • Simple DB
    The general idea of simple-db is to wrap the native client API of the database system into as thin a layer as possible and to provide the simple and uniform API to the upper levels.
  • Skeleton Engine for MySQL
    Skeleton Engine for MySQL is a full framework to plug in a new storage engine. It comes with prebuild autoconf files, and a full framework to plug in your own design. The AWS, HTTP, Memcache, Nitro, PBXT, and many other engines were put together from the skeleton engine.
  • SkunkDB
    SkunkDB is a collection of tools to deal with skunk databases. The aim is to create a library, support tools, and a format suitable for high-speed data retrieval. The database is a static key -> value mapping. The databases cannot be inserted into, or deleted from. They are designed to be created once and queried many times.
  • SQLIer
    SQLIer takes an SQL Injection vulnerable URL and attempts to determine all the necessary information to build and exploit an SQL Injection hole by itself, requiring no user interaction at all (unless it can't guess the table/field names correctly). By doing so, SQLIer can build a UNION SELECT query designed to brute force passwords out of the database.
  • sqlmap
    sqlmap is an automatic blind SQL injection tool, developed in python, capable to enumerate entire remote database, perform an active database fingerprint and much more. The aim of this project is to implement a fully functional database mapper tool which takes advantages of web application programming security flaws which lead to sql injection vulnerabilities.
  • The MySQL Sandbox
    MySQL Sandbox is a tool for installing one or more MySQL servers in isolation, without affecting other servers.
  • tyserv
    A DBMS for UNIX-like systems. It has isam-like access, transaction control, rollback, commit, exclusive lock, access control by client IP address, and user authentication. If you like old but simple database programming environments like COBOL+VSAM(KSDS) or C+C-ISAM, you will like Tyserv.
  • umbrello2sql
    umbrello2sql reads a umbrello entity relationship diagram and generates the correspondent SQL instructions to create a PostgreSQL database.
  • visual-db
    visual-db is a tool for the visualization of a PostgreSQL database as tables with relations between them.
  • XQuare Bridge
    XQuare Bridge expands existing relational database functionalities with advanced XML import/export capabilities. It supports flexible extraction and publishing of relational data into any target XML format, using the XQuery language. Using a powerful mapping language, it can also perform efficient insertion of structured XML data into existing relational tables, while taking into account the database integrity constraints and transforming the implicit relations appearing in the XML document into explicit ones in the database.
  • XQuare Fusion
    XQuare Fusion is a powerful information integration engine for querying in real-time multiple, heterogeneous and distributed data sources. Using XML-based data sources federation, it presents to applications a single, uniform XML view of all business information, which can then be queried with XQuery to produce XML documents.
  • XtraBackup
    XtraBackup an open-source, free MySQL backup software that performs non-blocking backups for InnoDB, XtraDB, and MyISAM databases. It works with all versions of Percona Server, MySQL, and MariaDB. It performs streaming, compressed, and incremental backups.
  • ZeosLib
    The main ZeosLib product is a set of native datasets and database components for MySQL, PostgreSQL, Interbase, Firebird, MS SQL, Sybase, Oracle, DB/2 for Borland compilers such as Delphi, C++ Builder and Kyli
  • ZFireBirdDA
    A python module needed as an interface between Zope and Kinterbasdb to access Firebird databases.



Share this Page
Bookmark and Share
Submit this page to popular social networks such as Digg, Twitter, StumbleUpon and more.


My LinuxLinks
MyLinks
  • Bookmarked links
  • Emailed Newsletter
  • Your own profile

  • Top Applications
    Top Free Software
    6 Lean Desktops
    14 File Managers
    21 Backup Tools
    21 Window Managers
    21 Productivity Tools
    21 Text Editors
    21 Video Emulators
    21 Home Emulators
    42 Graphics Apps
    42 Scientific Apps
    42 Email Apps
    12 Instant Messaging
    42 Games
    42 More Games
    21 More Games
    42 Audio Apps
    42 Video Apps
    80 Security Apps
    Free Console Apps
    14 Multimedia
    'Free' Proprietary
    21 Closed-Source Apps
    Top Commercial Apps
    42 Games
    Free Web Software
    21 Web CMS
    14 Wiki Engines
    8 Blog Apps
    6 eCommerce Apps
    Other Articles
    Migrating from Windows
    Distribution Guide
    Distro Portal Pages

    Migrate to Linux
    Thinking of switching to Linux? Check out our Linux Equivalents to Windows Software section, highlighting popular Linux equivalents to Windows software.

    This feature also includes over 150 individual software portal pages including Blender, Scribus, OpenOffice.org, Evolution, Eclipse, K3b, and MythTV, providing a wealth of essential information.

     

    Distribution Guides
    Distro Guide

    Debian
    Fedora
    Gentoo
    Mandriva
    OpenSuSE
    RedHat
    Slackware
    Ubuntu
    Xandros

    Absolute
    Linux Mint
    64 Studio

    LiveCDs
    Berry Linux
    GoblinX
    KNOPPIX
    Kubuntu
    NimbleX
    PCLinuxOS
    Sabayon
    SimplyMEPIS
    Xubuntu

    Entire List

     

    Services
    Web Calendar
    Linux Licenses

    Advertise at LinuxLinks.com

     

    Latest Portal Pages
    Mixxx
    energyXT2
    GRASS
    uDig
    QGIS
    gretl
    SPSS

     

    Add Link | Modify Link | About | FAQ | Guide | Privacy | Awards | Contact | SourceFiles.org
    Portal Version 0.7. Intel Blade.
    Comments to the webmaster are welcome.
    Copyright 2009 LinuxLinks.com All rights reserved.