Posts Tagged ‘Database’

For JavaScript and AJAX applications, Taffy DB is a beautiful tool.

Taffy DB is an open source JavaScript library that acts as a data layer inside the applications. Just think of it as a SQL database in your web browser.

JavaScript Database Library

Let’s say you have a collection of products and you want to find every product that costs less than $10 and is not a book. Simple, just write some JavaScript:

Major features:

  • Under 10K!
  • Simple, JavaScript Centric Syntax
  • Fast
  • Easy to include in any web application
  • Compatible with major Ajax libraries: YUI, JQuery, Dojo, Prototype, EXT, etc
  • CRUD Interface (Create, Read, Update, Delete)
  • Sorting
  • Looping
  • Advanced Queries

Check out the Getting Started Guide for Taffy DB‘s capabilities.

Sample / test data is an effective way to test web projects & applications. Other than meaningless data, real names, addresses, zip codes can make the whole testing stage easier.

WebResourcesDepot have collected some nice free test data generators which you may find useful:



GenerateData is a free, open source script written in JavaScript, PHP and MySQL that lets you quickly generate large volumes of custom data in a variety of formats for use in testing software, populating databases.

Generate Sample Data

Some features:

  • (JS-enabled) browser-friendly.
  • Many data types available: names, phone numbers, email addresses, cities, states, provinces, counties, dates, street addresses, number ranges, alphanumeric strings, lorem ipsum text and more.
  • Option to generate data in XML, Excel, HTML, CSV or SQL.
  • Country specific data (state / province / county) for Canada, US, Netherlands and UK.



DBMonster is a tool that generates random test data and inserts it into SQL database.

Test Data Generator


CSV Data Generator

This is a Ruby based free test data generator.



Datagenerator is a library and GUI for generating rule based test data for various databases like Mysql, Firebird, Interbase, MSSQL, Oracle, SQLite and PostgreSQL.

Data Generator



Data generator tool which supports many data types (primitive data types,but also names,addresses,post codes,etc.) and generates data in various formats (text,xml,db).It provides a GUI and is extensible by means of plugging-in new data-generator classes.


Spawner Data Generator

Spawner is a generator of sample/test data for databases. It can be configured to output delimited text or SQL insert statements. It can also insert directly into a MySQL 5.x database. Includes many field types, most of which are configurable.


Test Dictionary

A Java interface that quickly returns random proper names, terms and connectors. Useful for populating realistic test data.


Fresh Trash Generator

This is a Java utility package for generate random test data. is a website which shows connection string examples for nearly every data source including:

  • MySQL
  • Postgre SQL
  • Informix
  • Paradox
  • Textfile
  • & many more

Website also provides connection string examples for different connection types like ODBC, OLE DB, OleDbConnection (.NET).

MySQL restore is sometimes a bad experience if the database size is bigger than the allowed limit or the execution time of the restore script is not enough. Users generally restore databases with desktop softwares or through the command line in such situations.

MySQLDumper is a backup & restore management script for MySQL Databases, written in PHP and Perl, which fills this gap and offers a complete control over the databases.

Easy Mysql Backup Restore

MySQLDumper uses a proprietary technique to avoid execution interruption. It only reads and saves a certain amount of commands and then calls itself via JavaScript and memorizes how far in the process it was and resumes its action from its last standby.

MySQLDumper offers to write data directly into a compressed gz-File. The Restore-Script is able to read this file directly without unpacking it. Of course you can use it without compression, however using Gzip saves a sizeable amount of bandwidth.

Users can get e-mail notifications after the automated backup process:
Easy Mysql Restore


  • MySQLDumper can read dumpfiles from other scripts via the integrated parser (for example from phpMyAdmin).
  • Security: MySQLDumper can generate a .htaccess-file to protect itself and all of your backup-files.
  • MySQLDumper can do multipart-backups. That means: MySQLDumper can automatically split the dumpfile if it gets bigger than your chosen size. When you want to restore a backup and choose the wrong part – it doesn’ matter: MySQLDumper will notice that and will get the correct start file automatically.
  • Automatic error module.
  • MiniSql: You have access to your MySQL-Tables. You can delete tables, edit or insert data. You can run/ save any SQL-statement.
  • Database-overview: look at running processes or even stop them.
  • Very good file-overview: backups of the same database are shown as one entry. Click it to see all of the files.
  • Automatic file-deletion: set your own rules to delete old backups. Specify the age or the number of files when it will be deleted automatically to save server webspace.
  • Perl cron script: all features of the PHP-Script are now integrated in the Perl script that can be started via a cron job.
  • Configuration can be set seperatly for each script (PHP and Perl).
  • Before you start a backup all your parameters are shown again, so you definitely know what you are doing.
  • Send e-mails with or without your dump file attached / you can set the maximum size of the attachement. If it grows bigger it won’t be attached.
  • Send dumpfiles via FTP to another server. This is also working using the multipart feature.