Sql Find Duplicates

Remove playlist duplicates is a simple perl script which on track change detects all duplicate playlist entries and leaves just the first one of each of them. I have files duplicated on my mp3 player and hard drive and when I plugged my player in, my collection contained duplicate entries. this...

Email::Find allows you to find RFC 822 email addresses in plain text. Email::Find is a module for finding a subset of RFC 822 email addresses in arbitrary text (see "CAVEATS"). The addresses it finds are not guaranteed to exist or even actually be email addresses at all (see "CAVEATS"), but...

SQL::Generator is a Perl module to generate SQL-statements with oo-perl. SYNOPSIS use SQL::Generator; With this module you can easily (and very flexible) generate/construct sql-statements. As a rookie, you are used to write a lot of sprintf`s every time i needed a statement (i.e.for DBI)....


Platforms: *nix

DL/SQL is declarative, turing-complete programming language based on top of SQL database. The main idea is to store both program and data in one SQL table and make all the computations in it. The current version of interpreter written in PHP contains quasi-lazy evaluation and simple caching....


Platforms: *nix

MP3::Find::Filesystem is a File::Find-based backend to MP3::Find. SYNOPSIS use MP3::Find::Filesystem; my $finder = MP3::Find::Filesystem->new; my @mp3s = $finder->find_mp3s( dir => /home/peter/music, query => { artist => ilyaimy, album => myxomatosis, }, ignore_case => 1, );.


Platforms: *nix

MP3::Find::Base is a base class for MP3::Find backends. SYNOPSIS package MyFinder; use base MP3::Find::Base; sub search { my $self = shift; my ($query, $dirs, $sort, $options) = @_; # do something to find and sort the mp3s... my @results = do_something(...); return @results; }...


Platforms: *nix

MP3::Find is a Perl module to search and sort MP3 files based on their ID3 tags. SYNOPSIS # select with backend you want use MP3::Find qw(Filesystem); print "$_n" foreach find_mp3s( dir => /home/peter/cds, query => { artist => ilyaimy, title => deep in the am, }, ignore_case => 1,...


Platforms: *nix

SQL::Amazon::Request::Help is an Interface to retrieve Help content. SYNOPSIS $dbh = DBI->connect(dbi:Amazon:, $amznid, undef, { amzn_mode => books, amzn_locale => us, amzn_max_pages => 3 }) or die "Cannot connect: " . $DBI::errstr; # # search for some Perl DBI books # $sth =...


Platforms: *nix

SQL::Amazon::UserGuide is a Perl module with user Guide for DBD/SQL::Amazon. SYNOPSIS # # create the parser, passing in the current Amazon metadata # my $parser = SQL::Amazon::Parser->new(%attrs); # # parse a SQL statement, returning a SQL::Amazon::Statement # my $stmt =...


Platforms: *nix

NetAddr::IP::Find is a Perl module to find IP addresses in plain text. SYNOPSIS use NetAddr::IP::Find; $num_found = find_ipaddrs($text, &callback); This is a module for finding IP addresses in plain text. Functions NetAddr::IP::Find exports one function, find_ipaddrs(). It works very...


Platforms: *nix

SYNOPSIS use File::Find::Rule; # find all the subdirectories of a given directory my @subdirs = File::Find::Rule->directory->in( $directory ); # find all the .pm files in @INC my @files = File::Find::Rule->file() ->name( *.pm ) ->in( @INC ); # as above, but without method chaining my...


Platforms: *nix

File::Find::Similars is a Similar files locator. SYNOPSIS use File::Find::Similars; File::Find::Similars->init(0, @ARGV); similarity_check_name(); Similar-sized and similar-named files are picked as suspicious candidates of duplicated files. What descirbes it better than a actual...


Platforms: *nix

sql++ is an easily configurable, feature-rich, portable command-line SQL tool. It can be used with many different databases and in place of other commandline tools such as MySQLs mysql-client, Microsoft SQL, PostgreSQLs psql, and Oracles sqlplus. sql++ project has features such as multiple...


Platforms: *nix

SQL Uniform is a database client with a graphical user interface (GUI). The project is a helper application to relational databases of various types regarding query, maintenance, data comparison, export (convert), and import. It supports any kind of database and database servers to which there...


Platforms: *nix

SQL::Schema is a Perl module to convert a data dictionary into SQL statements. SYNOPSIS use DBI; my $dbh = DBI->connect(...); use SQL::Schema; my $schema = SQL::Schema->new($dbh); my $sql = $schema->string; print $sql; print "$schema"; WARNING This is alpha software. It...


Platforms: *nix

Atlantis Data Space Analyser is a free graphical tool for making capacity judgements for SQL Server - find out why you consume the data space that you do. Data Space Analyser makes the task of capacity planning and research a much quicker and enjoyable task. It produces graphical...


Platforms: Windows

Instant File Find is a search tool that lets you find files instantly on your computer. It is designed to speed up your daily work by helping you locate files instantly. With quick buttons, you can list all music or document files (or other types) on your computer instantly. You can get search...


Platforms: Windows

dbForge SQL Complete Express is a free add-in for SQL Server Management Studio and Visual Studio. It offers powerful autocompletion and formatting of T-SQL code that replaces native Microsoft T-SQL Intellisense. Besides the extension of the List Members, Complete Word and Parameter Info...


Platforms: Windows

DTM SQL runner is a free command line tool for SQL statements execution. The runner allows the user to specify ODBC data source name and file with SQL statement to be executed. This handy tool for developers, database administrators and advanced users is suitable for batch and scheduled job...


Platforms: Windows

Decrypts SQL stored procedures, functions, triggers, and views on SQL Server. If you have encrypted an object definition in your database(s) by specifying WITH ENCRYPTION option, and by some reason you cannot restore it's original T-SQL script, the SQL Decryptor will easily do it for you...


Platforms: Windows