Open source software recommendation (1)

Greensql database Firewall
========================================================== ================================
Greensql is a database firewall program used to prevent SQL injection attacks. Greensql uses the proxy mode to support MySQL databases. The structure is shown below:

MySQL stress testing tool
========================================================== ================================
Mysqlslap is a stress testing tool officially provided by MySQL. The following are important parameters:
-Defaults-file: configuration file storage location
-Concurrency: concurrency
-Engines, Engine
-Iterations: number of iterations
-Socket: Socket File Location

Automatic Test:
-Auto-generate-SQL: automatically generates test SQL
-Auto-generate-SQL-load-type: test the SQL type. Types include mixed, update, write, key, and read.
-Number-of-queries: Total number of executed SQL statements
-Number-int-cols: Number of int columns in the table
-Number-Char-cols: Number of char columns in the table

For example:
Shell> mysqlslap-defaults-file =/u01/mysql1/MySQL/My. CNF-concurrency = 50,100-iterations = 1-Number-int-cols = 4-auto-generate-SQL-load-type = write-engine = MyISAM- number of-queries = 200-S/tmp/mysql1.sock
Benchmark
Running for engine MyISAM
Average number of seconds to run all queries: 0.016 seconds
Minimum number of seconds to run all queries: 0.016 seconds
Maximum number of seconds to run all queries: 0.016 seconds
Number of clients running queries: 50
Average number of queries per client: 4

Benchmark
Running for engine MyISAM
Average number of seconds to run all queries: 0.265 seconds
Minimum number of seconds to run all queries: 0.265 seconds
Maximum number of seconds to run all queries: 0.265 seconds
Number of clients running queries: 100
Average number of queries per client: 2

Test of the specified database:
-Create-schema: Specifies the database name.
-Query: Specifies an SQL statement to locate a file containing SQL.

For example:
Shell> mysqlslap-defaults-file =/u01/mysql1/MySQL/My. CNF-concurrency = 25, 50-iterations = 1-create-schema = test-query =/u01/test. SQL-S/tmp/mysql1.sock
Benchmark
Average number of seconds to run all queries: 0.018 seconds
Minimum number of seconds to run all queries: 0.018 seconds
Maximum number of seconds to run all queries: 0.018 seconds
Number of clients running queries: 25
Average number of queries per client: 1

Benchmark
Average number of seconds to run all queries: 0.011 seconds
Minimum number of seconds to run all queries: 0.011 seconds
Maximum number of seconds to run all queries: 0.011 seconds
Number of clients running queries: 50
Average number of queries per client: 1

Google closure tools
========================================================== ================================
Google open-source its internal Javascript development tools, hoping to help external programmers develop faster web applications. Google believes that by allowing developers to use Google's own tools, they can not only create faster rich web applications, but also truly put the web on the wings. Closure JavaScript compilers and libraries were used by Google to develop Gmail, Google Docs, Google Maps, and other applications.

The closure tool includes a javascript optimizer to remove unnecessary code and compress other code to maximize the speed;
The Firefox extension closure inspector, working with firebug, aims to simplify debugging;
Closure compiler, which can run in the form of command line, web application, or Firefox extension;
Closure library, Google's standard JavaScript class library;
Closure templates provides a set of pre-compiled JavaScript interface components.

Download closure Compiler:
Http://code.google.com/p/closure-compiler/downloads/list

Download closure INSPECTOR:
Http://closure-inspector.googlecode.com/files/closureinspector09.xpi

Online Examination System tcexam
========================================================== ================================
Tcexam is a network-based open-source online examination system for generating and managing online questions. Recently, online examinations have gradually become popular in many schools and enterprises as a replacement for the traditional "paper and pen examination", which can greatly simplify the entire examination process, the general process of question taking, examination, management, and marking is integrated into a system, which not only reduces manpower, but also greatly improves the overall efficiency and the credibility of the test results.
Its other features include:
Automated Installation
Cross-platform
Multi-language support
All based on common software and standards (PhP5, MySQL, PostgreSQL, XHTML, JavaScript, PDF)
Browser-based user interface
Additional security measures such as IP detection
The supported data volume is unlimited.
Supports questions with multiple answers and free questions
Automatically send results to E-mail
Supports exporting results in XHTML and PDF formats.

Workflow tool cuteflow
========================================================== ================================
Cuteflow is a web-based document flow/workflow tool. After you define a document, it will be forwarded to each user in the list step by step according to the specified process.

◆ Web-based user interface
◆ Easy to install and use
◆ Work flow documents are integrated in mail Information
◆ Support different workflow lists
◆ Unlimited number of senders/recipients
◆ Workflow data and files can be bundled
◆ Independent platform
◆ Flexible user management

Requirements
• Webserver with PHP (v.5.0.x or higher)
• MySQL database (support for other databases is planned for future versions)
• SMTP e-mail server for sending workflow e-mails

Course Management System (dokeos)
========================================================== ================================
Dokeos is an open-source online education and curriculum management system. It has helped more than 1000 organizations in the world manage teaching and cooperation activities.

Dokeos is excellent in open-source online education solutions. It is a branch of claroline and its design habits are suitable for Chinese people. This platform is similar to blackboard in terms of resource management. The built-in discussion board is the famous phpBB, which is recommended.

Webpage flvplayer OS FLV
========================================================== ================================
OS FLV is an open-source and web-embedded flvplayer.

This player has a large number of options that can be set through embedded code.

It has an API written in PHP, allowing you to absolutely control some parameters, such:

• FLV files to be played
• Height, width, and color
• Automatic playback, automatic replay, and automatic loading options
• Volume and Cycle Mode

Flash video player JW player
========================================================== ================================
Jw flv Media Player is an open-source Flash video, audio, and image player used on Web pages. It supports sliverlight playback and enables the player to automatically display a group of images through an XML file, and play background music.

Online Parameter setup wizard: http://www.longtailvideo.com/support/jw-player-setup-wizard
Source code download: http://developer.longtailvideo.com/trac/browser/tags/mediaplayer-5.0

Original link: http://blog.why100000.com /? P = 965