MySQL (Windows) 4.1 alpha Free Download at datapicks.com - A very fast, multi-threaded, multi-user and robust SQL database server

MySQL 4.0 further increases the speed of MySQL in a number of areas, such as bulk INSERTs, searching on packed indices, creation of FULLTEXT indices as well as COUNT(DISTINCT).

The table handler InnoDB is now offered as a feature of the standard MySQL server, including full support for transactions and row-level locking.

MySQL 4.0 will support secure traffic between the client and the server, greatly increasing security against malicious intrusion and unauthorised access. Web applications being a cornerstone of MySQL use, web developers have been able to use SSL to secure the traffic between the the end user browser and the Web application, be it written in PHP, Perl, ASP or using any other web development tool. However, the traffic between the development tool and the mysqld server process has been protected only by virtue of them being processes residing on computers within the same firewall. In MySQL 4.0, the mysqld server daemon process can itself use Secure Sockets Layer (SSL), thus enabling secure traffic to MySQL databases from, say, a Windows application residing outside the firewall.

Our German, Austrian and Swiss users will note that we have a new character set latin_de which corrects the German sorting order, placing German Umlauts in the same order as German telephone books.

Features to simplify migration from other database systems to MySQL include TRUNCATE TABLE (like in Oracle) and IDENTITY as a synonym for automatically incremented keys (like in Sybase). Many users will also be happy to learn that MySQL now supports the UNION statement, a long awaited standard SQL feature.

In the process of building features for new users, we have not forgotten requests by the community of loyal users. We have multi-table DELETE statements. By adding support for symbolic linking to MyISAM on the table level (and not just database level as before), as well as by enabling symlink handling by default on Windows, we hope to show that we take enhancement requests seriously. Functions like SQL_CALC_FOUND_ROWS and FOUND_ROWS() makes it possible to know how many rows a query would have returned without a LIMIT clause.

Top Database & SQL / Software Development programs

1) CASE Studio 2 v 2.23
Powerful database design tool which allows you to visually create Entity Relationship Diagrams (ERD) for various database systems - MS SQL, Oracle, DB2, MySQL, InterBase, Sybase etc. Features: ERD, SQL script generation, Reverse engineering...

2) Visual Open DB 1.75
Visual Open DB is a generic data analysing application that allows you to query any valid data source. It can be used by end users to perform data analysis and developers to interrogate database tables and views.

3) Aqua Data Studio 4.0
Aqua Data Studio is a SQL editor and developer tool that allows developers to easily create edit and execute SQL scripts as well as browse database structures

4) DBF Viewer 2000 2.45
DBF Viewer 2000 is a powerful, compact and easy-to-use viewer and editor for DBF files. You can view, edit, sort, use query by example, delete duplicates, create, print database tables a export the data from them to a variety of formats.

5) DB Explorer 3.0.0
Compare two database schemas and/or table data rows and report differences. Synchronise the differences for one or other database. Sync Schema generates the SQL DDL statements. Sync Data either transfers the rows or generates SQL DML statements.

6) DBF to CSV 2.01
The DBF to CSV program allows you to convert your dbf files to csv (comma-separated value) format. Generally, you can use any delimiter, such as TAB, semicolon etc. The program supports dBase III, dBase IV, FoxPro, VFP and dBase Level 7 formats

7) TOAD for Oracle Freeware 8.5
TOAD® empowers developers and DBAs to be more productive by providing an intuitive graphical user interface to Oracle. TOAD is a powerful, low-overhead tool that makes PL/SQL development faster and easier and simplifies database administration.

8) SQLite3 database manager LITE 3.1
SQLite3 database manager. Development tool for managing all database objects. SQL builder.

9) GIS ObjectLand 2.6.5
GIS ObjectLand is a universal Geographic Information System for Windows. Key features: vector-raster maps; multiuser data editing; import/export for MIF/MID, SHP, DXF, DBF, CSV; access permissions for users; using other DBMS (ODBC); COM interfaces.

10) Exportizer Pro 3.7
Exports database tables (DB, DBF, MDB, XLS, GDB, IB, HTML, UDL, TXT, CSV) to clipboard or file (XLS, RTF, XML, HTML, TXT, CSV, DBF). Many options allow full control over output.

New Database & SQL / Software Development programs

1) MyDeveloper Studio 3.00 beta
Powerful database development and administration environment for MySQL. Presents a large set of database tools for simplifying interaction with MySQL and automating the database development process. Has a unique built-in stored routine debugger.

2) SQL Data Examiner 2.2.0.20
SQL Data Examiner 2008 is a multi-platform data comparison and synchronization tool that merges selected databases with just a few clicks. The tool simplifies the process of data migration and saves hours of boring manual work.

3) Mexico Postal Code Database (Gold Edition) July.2008
Mexico postal codes database subscription. The database includes postal code, city name, colony name, state code, state name, latitude and longitude, time zone and area code in Mexico.

4) MS Access Print Multiple Objects Software 7.0
Print many MS Access tables, queries, forms, pages, modules, macros and reports without having to open each one. MS Access 2000 or higher required.

5) Oracle Copy Tables to Another Oracle Database Software 7.0
Copy tables from one Oracle database to another. Provide the login information for both databases.

6) FoxPro Copy Tables to Another FoxPro Database Software 7.0
Copy tables from one FoxPro database to another. Provide the file locations for both databases to connect. Connect to FoxPro via DBC file or multiple DBF files in a folder.

7) Export Query to Text for SQL Server 1.04.22
Export Query for Microsoft SQL Server helps to save a query results to text file. The program supports delimited or fixed length formats. Export utility has easy to learn and to use wizard interface. All modern versions of SQL Server are supported.

8) MySQL Copy Tables to Another MySQL Database Software 7.0
Copy tables from one MySQL server to another. Provide the login information for both databases.

9) MS Access Copy Tables to Another Access Database Software 7.0
Copy tables from one Access database to another.

10) SQL Script Builder 1.6.3.53
SQL Script Builder is powerful software that create a database file or sql script from any ODBC data source. The script or file will migrate the table(s) and the records. Scripts comes in 5 formats ; MySql, MS SQL, Oracle, Pervasive and PostgreSQL.