Free insert sql software for linux

INSERT (the Inside Security Rescue Toolkit) aims to be a multi-functional, multi-purpose disaster recovery and network analysis system. It boots from a credit card-sized CD-ROM and is basically a stripped-down version of Knoppix. It features good hardware detection, fluxbox, emelfm, links-hacked, ssh, tcpdump, nmap, chntpwd, and much more.
INSERT provides full read-write support for NTFS partitions (using captive), and the ClamAV virus scanner (including a fairly recent signature database and a GUI). It also has a network boot facility.
Main features:
- full read-write support for NTFS-partitions using captive
- support for various file system types: EXT2,EXT3,MINIX,REISERFS,JFS,XFS,NTFS,FAT,MSDOS,NFS,SMBFS,NCPFS,UDF,UFS,HFS,HFS+
- support for linux software RAID and LVM
- support for WLAN adapters
- network analysis (e.g. nmap, tcpdump)
- disaster recovery (e.g. parted, gpart, partimage, testdisk, recover)
- virus scanning (Clam Antivirus)
- computer forensics (e.g. chkrootkit, rootkit hunter)
- surf the internet (e.g. links-hacked, AxY FTP)
- network boot server to boot network boot enabled clients that cannot boot from the CD
- based on Linux kernel 2.4.27 and Knoppix 3.6

packet2sql converts any text file/log file which contains ipchains packet logs into a stream of SQL inserts.
If called with no options, packet2sql will read the log input from stdin. Since syslog dates do not include the year, packet2sql will assign one. If the month of a log entry comes after the current month, it assigns the previous year, otherwise it assigns the current year. This is helpful for processing Decembers logs in January. It is also helpful for people who archive logs and wish to recreate them. You can also use the -y option to override the
month guessing heuristic and assign one yourself. The option -y 1998 will assign the year 1998 to all log files specified after the -y option. Note that if you use the -y option and wish to read log entries from stdin, you must specify - for the file to read from.
Enhancements:
- Made it possible to install somewhere else with INSTALL_PREFIX env. var
- Fix for occasional misaligned IP address fields (Closes 465208) (schuppy)

BITE SQL Reports project consists of an advanced SQL reports for existing databases.
BITE is SQL reporting software that can be "plugged" into any existing database to add advanced reporting capabilities.
You can build reports and store them in the same database, view, print, save, and FTP these reports to pre-defined places, or distribute the "viewer" software so that others can run the reports that you build.
Enhancements:
- An initial Makefile has been added.
- gcc compile issues have been fixed.

SBC is a collection of scripts consisting in several PHP scripts for webpages that have the following objetives in common:
- Easy to use and install.
- Fully customizable.
- Commented code in order newbies to learn some PHP.
- XHTML 1.0 compliant
- Fast and simple.
It can be very easily integrated in any Web site just by including "sbclinks.php" after configuring it.
SBCLinks is a PHP/MySQL script that lets you run your link/download directory. At the moment it has implemented only a hits counter. If I see that people is interested in this stuff, I will implement some other cool features such as:
- Vote system.
- Broken link reports
- Link reviews.
Installation:
mysqladmin -u root -p create sbc
mysql -u root -p sbc < sbclinks.sql
now edit config.php and change the variables.
Add new categories and links and it should work loading the URL in the browser.
When you import the database to MySQL, you can remove sql directory.
Usage:
Using SBCLinks is very easy. The only thing that you have to do is installing phpMyAdmin and add links and categories.
When you add a category, if it "pid" field is 0, it will hang at the root of the directory. If "pid" is the "id" of another category, it will hang at that category... its very easy. For that root categories, there is a field called "icon" that will load an image for that category in img/ directory. There is also a "descr" field to add a description of that category. If you add subcategories, leave this
fields in blank.
When you add a link, in the field "pid" you must enter the ID of the parent category where you want to hang that link.
If you add a link to a webpage, insert "0" in field "kind".
If you add a link to a file, insert "1" in the field "kind".

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=>"",
db_name=>$db_name,db_driver=>"mysql");
if ($db1->db_exist)
{ $db1->connect_db;
$db1->del_tables;
$db1->create_tables_mysql;
$db1->inscomp_from_file("$file");
}
else
{
$db1->create_db;
$db1->connect_db;
$db1->create_tables_mysql;
$db1->inscomp_from_file("$file");
}
# Reaction Insertion

my $qart = Chemistry::Artificial::SQL::new($db1);
my $qr =$qart->q_reaccion(C=CC=C.C=C>>C1=CCCCC1,smiles);
$db1->reactionsert($qr,"","0");

This package provides the necessary functions to interact with the database. The methods implemented in this module are oriented to give users control of the database without knowing how to use SQL queries.

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc. The minimum version of Java supported is 1.4.x. We recommend 1.5.x. See the Old Versions page for versions of SQuirreL that will work with older versions of Java.

SQuirreLs functionality can be extended through the use of plugins. A short introduction can be found here. To see the change history (including changes not yet released) click here.

Susan Cline graciously took the time to document the steps she followed to setup an Apache Derby database from scratch and use the SQuirreL SQL Client to explore it.
Quite some time ago Kulvir Singh Bhogal wrote a great tutorial on SQuirreL and published it at the IBM developerWorks site. He has kindly allowed us to mirror it locally. The tutorial is not really up to date but especially for doing the first steps it is still of help.

SQuirrel was originally released under the GNU General Public License. Since version 1.1beta2 it has been released under the GNU Lesser General Public License.

Whats New in This Release:

1716859 Cant see data in content tab or row count tab (MS SQLServer databases
with a dash ("-") in their name would cause the content tab or row count
tabs to render no data.

1714476: (DB copy uses wrong case for table names) The copy operation would
sometimes fail to select records from the source table. Since the
case for the source table is always known to be correct, the plugin
no longer erroneously attempts to correct the case.

1700093: Formatter fails for insert script with multiple subselects

Refactoring Plugin: SQL-Server needs eol between GO and statement.

Fixed bug which appeared while editing tables in PostgreSQL 8.1. If the table
was created without an OID column, the last column would not be editable.

Fix for issue where dates arent correctly displayed or updated when using
treat date as timestamp pref in the SQl Editor result panel.

Use the last directory that a file was imported from when importing additional
files for binary fields.

1699294: Squirrel imports BLOB, but does not update data

Oracle Plugin: Handle slashes when they are used as statement separators.

137984 (Bug in alias delete) The problem was that notifications were being
sent to the alias drop-down that the item was being deleted which trigger an
update and new selection forcing the connect to alias window to be launched.
Now, the alias drop down is disabled while the update is happening and enabled
immediately afterward.

filofant project is a mail archiving and document indexing software intended for using in companies or workgroups which wants to share the knowledge embedded in their documents and emails.
Installation:
Currently there is no installscript, so you have to do all at your own...
1) Binaries
configure && make & make install
in the src directory.
It is recommended to provide an prefix for the installation like --prefix=/opt/filofant
2) CGIs
The CGIs will be installed in $PREFIX/bin/cgi-bin. If this is not the cgi-directory of your webserver, you should move them there.
3) Environment
filofant needs the variable FILOFANT_HOME to declared, to find its config and binary files. It this variable is not defined, the base config has to be stored at /etc/filofant.rc
This variable has to be set for the CGI also, eg in Apache you could set it with the SetEnv directive.
4) System
Create a systemuser for the filofant (eg. filofant). The user has to be access to the base directory ($FILOFANT_HOME) of the installation.
5) Database
PostgreSQL: Create a database with the createdb command, create an user of the same name as the system user with the createuser command (This user has to be database administrator).
su to the filofant user. Insert database schema from the file filofant.sql (in directory sql) If you have nonstandard system user for the webserver or the filofant, please correct the grants in the sql file before inserting it.
6) Base configuration
The file filofant.rc has to be located in the directory $FILOFANT_HOME/etc. Edit (or create) this file and enter the following lines:
BaseDir=/opt/filofant
User=filofant
DBUser=filofant
DBName=filofant
Fill in the appropriate data. I you have password protection at the database or the database is not at the same machine, add the following lines:
DBPwd=
DBPort=
DBHost=
Enhancements:
- A new binary for resolving system variables without password query changes access to system settings in scripts for cronjobs.
- This allows a tighter security setting for the database.
- Internal references in HTML previews will now be translated correctly to the filofant preview page.
- A bug regarding the embedding of images in HTML previews has been fixed.
- When using the fulltext search engine with more than one stopword, only the first was detected.
- This has been fixed.

Xplain2sql converts files from Xplain to SQL. xplain2sql supports a very large subset of Xplain, and it can convert from Xplain to Microsoft SQL Server, DB/2, Inprise InterBase, PostgreSQL, Oracle, MySQL, or ANSI-92 SQL.
It can also generate an XML description of the generated SQL. This XML description can be used to create low-level middle-tier code.
A Delphi/ADO XSLT style sheet is included. The C source code release should compile on any platform with an ANSI C compiler.
There are binary releases for FreeBSD, BeOS, Linux, and Windows 2000.
Xplain2sql supports a very large subset of Xplain already, and it is continually extended until full support is reached. Currently it can convert from Xplain to Microsoft SQL Server, Inprise InterBase, DB/2, PostgreSQL, Microsoft Access, and ANSI-92 SQL:
- Microsoft SQL Server support is very complete.
- Quite complete DB/2 support. Non literal inits are currently missing.
- InterBase support for init works only for literal inits (so attributes dont work). And because InterBase doesnt have the concept of temporary table, the extend and value only work for a single user.
- PostgreSQL is quite complete with the new PostgreSQL 7.3 release.
- Initial, but fairly complete Oracle support.
- Generates Microsoft Access data definition commands. However, it seems impossible to run an entire script against an Access database. Having to run each create table statement by hand is quite tedious.
- Generates good ANSI-92, however inits with non-literal values cannot be supported by ANSI-92 because it doesnt have the concept of before and after insert triggers.
Enhancements:
- Assert support was added.
- If-then-else is supported in init [default] statements for dialects that support triggers.