Projects tagged ‘data’ and ‘sql’

SubSonic is a toolset that helps a website build itself. It brings some of the fun and elegance of Ruby on Rails to ASP.NET.

pChart is a PHP class oriented framework designed to create aliased charts. Data can be retrieved from SQL queries, CSV files, or manually provided.

GDALib is a layer on top of ADO.NET which hides the complexity of a lot of database operations. It simplifies many common tasks by allowing the programmer to execute SQL queries against a database ... [More] , without having to worry about connections, exception handling and logging. [Less]

Simple to use library that handles a lot of things for you.

benerator is a framework for creating realistic and valid high-volume test data, used for testing (unit/integration/load) and showcase setup. Metadata constraints are imported from systems and/or ... [More] configuration files. Data can be imported from and exported to files and systems, anonymized or generated from scratch. Domain packages provide reusable generators for creating domain-specific data as names and addresses internationalizable in language and region. It is strongly customizable with plugins and configuration options. [Less]

The main goal of the project is to share data generators for Visual Studio Database Edition.

SqlHarvester is a free command-line based scripting engine written in .Net. It enables the import/export of database content across Sql Server 2005 database servers. During export mode database ... [More] content is scripted into flat Sql files. Unlike scripts generated by other commercial utilities these scripts validate database content at runtime so that data is inserted or updated based on the existence of primary keys. In this way scripts may be run on any database with the same schema in order to synchronize content across disconnected servers. The scripts also disable database constraints at runtime to avoid conflicts. The import of content via the tool is transactional. [Less]

The Problem If you have any dealings at all with data and databases, then you almost certainly will have have to deal with comma-separated values (CSV) data. Unfortunately, the CSV files you are ... [More] given, or are required to produce, never seem to be in quite the right format for your particular business application. And because of the structure of CSV records, using standard text procesing tools like sed, awk and perl on CSV files is not as simple as it might be. The Solution CSVfix is a command-line stream editor specifically designed to deal with CSV data. With it, you can: Convert fixed format, multi-line and DSV files to CSV Reorder, remove, split and merge fields Convert case, trim leading & trailing spaces Search for specific content using regular expressions Filter out duplicate data or data on exclusion lists Perform sed/perl style editing Enrich with data from other sources Add sequence numbers and file source information Split large CSV files into smaller files based on field contents Perform arithmetic calculations on individual fields Validate CSV data against a collection of validation rules Convert from CSV to fixed format, XML, SQL, DSV Summarise CSV data, calculating averages, modes, frequencies etc. You can see a full list of CSVfix commands here. Update: CSVfix Version 0.95 now available for download. This adds several new commands (including a new XML generating command) and the ability to use separators other than a comma in CSV input. Details of the changes are here. New: If you find CSVfix useful, please also check out CSVTest, a test data generator, at http://code.google.com/p/csvtest. [Less]

This framework's main focus is to write database applications with flex, writing SQL directly in AS3. It aims to simplify development by focusing on client-side. Transactions are supported, queries ... [More] can be executed synchronously or asynchronously. Data is encrypted to prevent reverse engineering, sql injection and so on. Server-side works on top of ADODB for PHP. Now using SOAP for the dialog, instead of a home made protocol. It gives access to Flex builder's webservice tools. See the demo [Less]