Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

SQLiteSpy is a fast and compact GUI database manager for SQLite. It reads SQLite 3 files and executes SQL against them. Its graphical user interface makes it very easy to explore, analyze and manipulate SQLite databases.

License:    Freeware for personal and educational use.

Whats new: >>

Implement the SQLite 3.8.0.2 bug fixes.

http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index

[SiLæncer]

Database .NET is a simple, uniform and intuitive database management tool for multiple databases. It makes Local and Remote database administration easier without installing anything. With it you can Create databases, Design tables, Edit data, Export data, Generate scripts and run SQL queries.

An innovative, powerful and intuitive multiple database management tool, based on .NET Framework 4.0.

Freeware

Whats new: >>

Code: [Auswählen]

Ver 9.2 (2013/09/09) Stable Version
- The main program update ( Main ):
Add: Add Object rapid screening process ( Quick Filter ): Enter the displayed objects immediately after updating, you can quickly find and exclude excessive or unnecessary objects appear (Ctrl +;) (5000)
Add: Add the traditional user interface display ( User Interface -> Traditional Style ) (4994)
Upd: graphical user interface ( Graphical User Interface ) display and processing efficiency, a lot of detail optimization and update (4994)
Upd: Update object tree view: 1. When an object exceeds displayed, automatically displays the horizontal scroll function, (2) When the mouse is moved over the object, automatically highlighted (4994), 3. Increasing Object heavy brush processing speed ( 5000)
Upd: Database Object Search ( Search Objects ): Double-click search results to enhance the processing speed (5000)
Fix: SQL History ( SQL History ): solved if the main program in the UNC path \ \ run directly, this function will not issue (4994)
Fix: correction to reset the font and size (Font and Size) Default no effect problems (4994)
Upd: Other minor fixes and optimization includes many updates ... they accumulate processing (5000)
- SQL Editor ( SQL Editor ):
Add: rewrite the search and replace function ( Quick Find and Replace ): closely integrated with the editor, the operation more simple and fast (5000)
Upd: Improved replace function (Replace): 1. Solutions can not handle the same question repeated characters (eg: a -> aa), 2. Replace the first to highlight the first, 3 new shortcut: Ctrl + H (5000)
- Script generation ( Data Definition Language ):
Fix: (MySQL) table field type TIMESTAMP correction default yyyy-MM-dd hh: mm: ss No single quotes (') problem (5000)
Upd: (MySQL) table field type TIMESTAMP increased ON UPDATE CURRENT_TIMESTAMP defined display processing (5000)
Upd: (MySQL) table option to increase AUTO_INCREMENT = n define the display processing (5000)
- Auto-complete processing ( AutoComplete * ):
Upd: the focus of the project under the proposed model (Focused Item) automatically centered display processing (with auto-completion mode) (5000)
Upd: increased focus on project ( Focused Item ) display processing: Click on the down arrow under the proposed model is selected after a project) (4994)
- Query Builder ( Query Builder * ):
Add: Object Browser, and the list of fields to support the mouse wheel to scroll up and down processing (Scrolling) (4994)
Fix: correction when the number of columns is large field link cable (Connector Line) display processing method (4994)


http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new: >>

· Add materialized views
· Make simple views auto-updatable
· Add many features for the JSON data type, including operators and functions to extract elements from JSON values
· Implement SQL-standard LATERAL option for FROM-clause subqueries and function calls
· Allow foreign data wrappers to support writes (inserts/updates/deletes) on foreign tables
· Add a Postgres foreign data wrapper to allow access to other Postgres servers
· Add support for event triggers
· Add optional ability to checksum data pages and report corruption
· Prevent non-key-field row updates from blocking foreign key checks
· Greatly reduce System V shared memory requirements

http://www.postgresql.org/

[SiLæncer]

Whats new: >>

Code: [Auswählen]

- The main program update ( Main ):
Add: Support MATERIALIZED VIEW Object Show / Delete / script generation ... and other processing (5008)
Supported database contains: PostgreSQL 9.3 / Oracle / SQL Server / SQL Azure
Add: increase [as an object using the object schema name prefix] Set ( Object (schema) -> schema.object ) (5008)
Upd: Object rapid screening process ( Quick Filter ): Optimization of continuous input processing efficiency and reduce the burden on the system (5008)
Fix: correction (4985) SQL Server tables renamed renamed treatment process updates cause SQLCe useless issues (5008)
Upd: Other minor fixes and optimization includes many updates ... they accumulate processing (5008)
- Data Table Editor ( Table Designer ):
Add: Support Oracle 12c create the table New Features: Added IDENTITY Columns Set (5008)
Fix: Constraints Editor ( Constraint Editor ): Fixed [all] database schema (Browse all databases), select the table column after update issues (5008)
- Script generation ( Data Definition Language ):
Add: increase [generate FOREIGN KEY constraint definition contains the name] Set ( xxx CONSTRAINT FOREIGN KEY ) (5008)
Fix: correction simultaneously generate multiple index object script, Sort Order may not correctly indicate the problem (5008)
Upd: (PostgreSQL) update script generation VIEW objects, adding WITH (options. ..) option settings, etc. Information (5008)
Fix: (Oracle 12c) solution can not be generated through GENERATED ALWAYS AS IDENTITY SEQUENCE object generated script problems (5008)
- Auto-complete processing ( AutoComplete * ):
Upd: Improved Data Sheet auto-sensing process (SCHEMA NAME +.): Allows the schema name case sensitive processing (5008)
Upd: (PostgreSQL) pg_catalog schema under (TABLES / VIEWS) object fields, cross-schema-aware processing automatically without specifying (5008)
Upd: Improved Exception Processing Character: 1. When the pre-processing when the manually entered QuotedString 2. Add more exceptional characters. Process (5008)
Upd: improvements and correction [all] database schema ( Browse All Databases ) under field awareness processing (5008)
- Row View ( Data Browser ):
Upd: separation mode ( Splitter mode ): supports full message display query results (table name / execution time / total time / number of records affected) (5008)
Upd: separate model and label mode ( mode Splitter / Tabbed mode ): Hold last browsing mode, when the query is executed again, we can maintain the last browsing mode (5008)
- Row Editing ( Data Editor ):
Upd: support (Oracle 12c) IDENTITY Columns incremented automatically display processing (5008)
http://fishcodelib.com/Database.htm

[SiLæncer]

4.0.7.0 (2013-09-23)

- bug #3993 Sorting in database overview with statistics doesn't work
- bug Handle the situation where PHP_SELF is not set
- bug #4080 Overwrite existing file not obeyed
- bug #3929 Database-specific privileges are not copied when cloning user
- bug #3997 Error handling in case MySQL extension is missing
- bug #4089 Moving Columns will alter column definition
- bug #4091 Insert ignore option does not work
- bug #4090 Downloading BLOB downloads page template
- bug #4092 Clicking on table name in view of information_schema redirects to wr
ong page
- bug #4079 Copy Table Add AUTO_INCREMENT value checkbox not working
- bug #4088 MySQL server version at index.php incorrect w/ controlhost
- bug #4001 Import error: Class 'ImportOds' not found
- bug #3986 Missing DROP VIEW button

http://www.phpmyadmin.net/

[SiLæncer]

Database Benchmark is a completely free and open source tool for database developers and engineers and anyone else who needs to test database performance. Thanks to the fact that it is open source, developers can easily modify it in any way they want in order to adapt tests to more specific applications or even create entirely new tests. In this day and age, when many companies are heavily reliant on databases, it is important to ensure that performance and reliability are up to scratch.

Freeware

Latest Changes

- Added support for STSdb4, MongoDB, LevelDB in Database Benchmark

http://database-benchmark.com/

[SiLæncer]

Database .NET is a simple, uniform and intuitive database management tool for multiple databases. It makes Local and Remote database administration easier without installing anything. With it you can Create databases, Design tables, Edit data, Export data, Generate scripts and run SQL queries.

An innovative, powerful and intuitive multiple database management tool, based on .NET Framework 4.0.

Freeware

Whats new: >>

Code: [Auswählen]

- SQL Editor ( SQL Editor ):
Add: Highlight (Text) search criteria ( Highlight Search Terms ) (5018)
Add: Added code folding handle ( Code Folding ): can quickly expand / collapse block of code is displayed (support (...), BEGIN ... END, / * ... * / folding processing blocks such as) ( 5018)
Add: Additional instruction processing ( Additional Commands ): add custom variables function (servar) (5018)
1. (Defines scripting variables): setvar <varname> "value", (Using scripting variables) $ (varname)
2. (Executes multiple SQL statements) GO [count] or / [count]
Upd: Update multiple syntax highlighting colors (Syntax Highlighting Colors) (5018)
Upd: Update tab Batch Close (Close All But This / Close All): When asked to confirm the content added transaction processing (5018)
Fix: correction Repeat GO [count] parsing Count setting can not exceed> 10 issues (5018)
Fix: correction when the font size is set with a decimal point (xx), copy the text after the RTF format may more extra. X character issues (5018)
- Auto-complete processing ( AutoComplete * ):
Add: Highlight (List) search criteria ( Highlight Search Terms ) (5018)
Add: support for multi-selection field processing ( Multiple Selection ): can simultaneously select multiple table fields (5018)
Add: COLUMNS object is added to complete the list of message display field ( Column Details ) (5018)
Add: (SQL Server / SQLAzure / SybaseASE) TABLES / VIEWS other objects are added to the list ( Schema Name ) message display (5018)
Upd: auto-complete processing ( Code Snippets ) when the input is fully consistent with, and only lists a record, it will not automatically turn off (5018)
- Code management ( Code Manager ):
Fix: If you delete a tab open SQL file, the label will be restored to the original state is not saved, avoid causing other problems (5018)
- The main program update ( Main ):
Fix: correction (4994) lead to the normal running under Windows XP/2003 in question (5010)
Misc: Compatible with MySQL 5.6.14 (2013/09/20) / MySQL 5.5.34 (2013/09/20) / MySQL 5.1.72 (2013/09/20)
Upd: Other minor fixes and optimization includes many updates ... they accumulate processing (5018)


http://fishcodelib.com/Database.htm

[SiLæncer]

Database Browser is an easy to use tool allows you to connect to any database (Oracle, MS-SQL, MySQL, Firebird, etc) and browse or modify data, run sql scripts, export and print data.

Features

    * Works directly with Oracle, MS Sql Server, ODBC, MySql, PostgreSQL, Interbase and Firebird
    * Support for ODBC connection strings
    * Unlimited number of connections
    * One click switching from one connection to another
    * One click table browsing
    * Data browsing
    * Data exports into CSV, Excel, Html files
    * Execution history
    * SQL Builder with wide range of supported databases
    * Execution Log
    * Incremental Table Search

What's new: >>

unbekannt

http://www.etl-tools.com/database-editors/database-browser/overview.html

[SiLæncer]

4.0.8.0 (2013-10-06)

- bug #3988 Rename view is not working
- bug #4041 Interaction between linkified fields and grid editing
- bug #3975 Table grouping isn't implemented properly
- bug #4060 Browser tries to remember wrong password when creating new user
- bug #4002 Edit Index on big table doesn't show "Loading" or any message
- bug #4098 Default table tab is ignored
- bug #4099 Server/library difference warning: setting is ignored
- bug #4100 table tree group strategy
- bug #4102 ALTER TABLE ORDER BY and InnoDB
- bug #4103 Tracking report: cannot delete a statement
- bug #3996 Drizzle navigation doesn't expand
- bug #4074 GIS column editor: point not displayed
- bug #4109 Drizzle tables in navigation are shown as views
- bug #4095 NUL symbols added to the end of database dump file
- bug #4105 More disappears in table Structure
- bug #3992 Multi-row edit doesn't clear values when checking NULL

http://www.phpmyadmin.net/

[SiLæncer]

Database .NET is a simple, uniform and intuitive database management tool for multiple databases. It makes Local and Remote database administration easier without installing anything. With it you can Create databases, Design tables, Edit data, Export data, Generate scripts and run SQL queries.

An innovative, powerful and intuitive multiple database management tool, based on .NET Framework 4.0.

Freeware

Whats new: >>

Code: [Auswählen]

- Auto-complete processing ( AutoComplete * ):
Add: Support table relationships [ IntelliSense-> REFERENCES ] auto-sensing process:
Add: support [table1] JOIN [table2] ON + Space automatically display table relationships statement (5028)
Upd: optimization [ IntelliSense-> COLUMNS ] object auto-sensing process:
Add: increase SELECT + Space + FROM automatically display (5028)
Add: increase WHERE + Space, GROUP BY + Space, ORDER BY + Space to automatically display (5028)
Add: Support multi-table field list display, automatically senses and displays related table fields (5028)
Upd: Field Name list to maintain the original order of creation without sorting process (5028)
Upd: improved perception of complex SQL statements processed and contain many optimization and Updates (5028)
Upd: optimization [ IntelliSense-> TABLES / VIEWS ] object auto-sensing process:
Add: increase VIEWS object list display (5028)
Add: increase JOIN + Space to automatically display (5028)
Add: support [selected] JOIN or FROM + Space automatically display (5028)
Upd: Improved user experience: In a multi-line comment / * xxx * / and after single-line comments - xxx with single quotes 'xxx' input is done automatically without processing (5028)
Upd: Strengthening the object background color display: the selected object (Selected Item) bright colors, tables (Tables) colors, fields (Columns) color code snippets (Snippets) color, association (References) Color (5028)
Fix: correction multi-table fields perception treatment: if. Further input after the field name, you can not correctly match the correct table field issues (5028)
Fix: correction exceptional character location = 1 can not be automatically added QuotedString problems (5028)
Fix: correction completion mode (Completion Mode) first treatment PageUp / PageDown may not start from the selected location problems (5028)
- Query Builder ( Query Builder * ):
Upd: add the same table when extended table name directly as Alias ​​Name (5028)
Upd: Alias ​​name contains an exception when the characters will be automatically added QuotedString processing (5028)
Upd: Enter the Alias ​​name blank, it will cancel and restore the original name of the table (5028)
Fix: correction related table setting, table setting if the name is not referenced Alias ​​problem (5028)
- The main program update ( Main ):
Add: New Korean interface language Korean language (by 컴포지트) (5028)
Upd: (Firebird) updated component FirebirdSql.Data.FirebirdClient.dll 3.2.0 ( ) (2013/10/05) (5028)
Upd: solving When SQLite error (5): database is locked, wait too long to respond lock status issues (30s-> 3s) (5028)
Upd: Other minor fixes and optimization includes many updates ... they accumulate processing (5028)
- SQL Editor ( SQL Editor ):
Fix: Highlight (Text) search criteria ( Highlight Search Terms ): correction off switch after searching other label is not automatically clear the highlighted issues (5028)
Upd: Updated code folding handle ( Code Folding ): BEGIN ... END, / * ... * / in the same row without treatment (5028)


http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new: >>

* Update hstore extension with JSON functionality
- Users who installed hstore prior to 9.3.1 must execute: ALTER EXTENSION hstore UPDATE; to add two new JSON functions and a cast.
* Fix memory leak when creating range indexes
* Serializable snapshot fixes
* Fix libpq SSL deadlock bug
* Fix timeline handling bugs in pg_receivexlog
* Prevent CREATE FUNCTION from checking SET variables unless function body checking is enabled
* Remove rare inaccurate warning during vacuum of index-less tables

http://www.postgresql.org/

[SiLæncer]

Database .NET is a simple, uniform and intuitive database management tool for multiple databases. It makes Local and Remote database administration easier without installing anything. With it you can Create databases, Design tables, Edit data, Export data, Generate scripts and run SQL queries.

An innovative, powerful and intuitive multiple database management tool, based on .NET Framework 4.0.

Freeware

Whats new: >>

Code: [Auswählen]

Data Table Editor ( Table Designer ):
Upd: batch import processing ( Batch Import -> from File ): 1. updated automatically refresh processing character segmentation, 2 Fixed Tab character segmentation process stalled issues (5042)
Fix: correction (Oracle) field set to contain both DEFAULT and NOT NULL, the priority sequence error problem (5042)
- Auto-complete processing ( AutoComplete * ):
Fix: correction (5028) within a multi-line comment / * xxx * / no processing done automatically, but if annotations [non-multi-line] is displayed, the resulting impact on the bottom rows automatically sensing processing (5042)
Upd: optimization [ IntelliSense-> COLUMNS ] object auto-sensing process:
Upd: Improved Data table with FROM ... WITH / TABLESAMPLE / UNPIVOT / PIVOT syntax fields such as perception (5042)
- The main program update ( Main ):
Upd: Updated Italian interface language Italian language (by Paolo Saudin) (5042)
Fix: Multi-screen (Multi-Monitor) treatment:
Fix: correction in Win8 under the non-primary Windows TaskBar set in different locations when in full-screen display problems (5042)
Fix: correction TaskBar set at TOP Align handle display problems (5042)
Upd: (DB2/Informix) updated component IBM.Data.DB2.dll 9.7.4.4 (10.5.2.4) (after 08/03/2013) (5042)
Upd: Other minor fixes and optimization includes many updates ... they accumulate processing (5042)
Misc: (DB2/Informix) IBM Data Server Client Packages Version 10.5 Fix Pack 2 (after 08/03/2013)
Misc: Compatible with PostgreSQL 9.3.1 (after 08/03/2013) / 9.2.5 (after 08/03/2013) / 9.1.10 (after 08/03/2013) / 9.0.14 (after 08/03/2013 )
Misc: Compatible with Microsoft Windows 8.1 RTM (32bit and 64bit) (2013/10/17)


http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new: >>

Code: [Auswählen]

Ver 9.6 (2013/10/24) Stable Version
- SQL Editor ( SQL Editor ):
Fix: solving continuous query large amounts of data may cause memory exhaustion issue (Out of memory) (5045)
Upd: Improved execute the command interrupt processing: 1. Increase the batch processing of SQL commands interrupt handling, 2. Interrupted update the status column shows (5045)
Upd: Improved timer function ( Timer for Automatic Execution ):
Upd: Add automatic delay processing, to avoid simultaneous treatment resulted in an exception (5045)
Upd: maintaining the original focus position, to avoid execution after losing (5045)
Upd: Updated code folding handle ( Code Folding ): When the contents of the file exceeds 1000K will not be processed, to avoid affecting the processing speed (5045)
- Auto-complete processing ( AutoComplete * ):
Upd: optimization [ IntelliSense-> REFERENCES ] associated with auto-sensing process (5045)
Upd: optimization [ IntelliSense-> TABLES / VIEWS ] object automatically senses Remedy: Increase [Schema name] +. perception (5045)
Upd: optimization [ IntelliSense-> COLUMNS ] object auto-sensing process:
Upd: add text input field filtering ( Filter Columns ), reduce unnecessary field shows (5045)
Upd: text input filtering process, when the list contains the selected field to give priority treatment (5045)
Upd: table relationships in a multi-table specified under the perception field processing, will no longer display the other table fields (5045)
Upd: Improved Data table with FROM ... WITH / TABLESAMPLE / UNPIVOT / PIVOT syntax fields such as perception (5042)
Upd: When the auto-complete window display range beyond the editor, it will automatically switch to the cursor displayed above (5045)
Fix: correction (5028) within a multi-line comment / * xxx * / no processing done automatically, but if annotations [non-multi-line] is displayed, the resulting impact on the bottom automatically sensing processing (5042)
- Query Builder ( Query Builder * ):
Add: Added to use quoted identifiers setting (Use Quoted Identifiers), canceled only contain characters automatically added exception handling (5045)
- Data Table Editor ( Table Designer ):
Upd: batch import processing ( Batch Import -> from File ):
Upd: Updated split characters automatically refresh processing (5042)
Fix: correction Tab character segmentation process stalled issues (5042)
Fix: correction (Oracle) field set to contain both DEFAULT and NOT NULL, the priority sequence error problem (5042)
- The main program update ( Main ):
Upd: more complete characters for object names exception handling issues (5045)
Upd: (Oracle) joined SCHEMA NAME title display name of the object (5045)
Upd: Updated Czech interface language Czech language (by Šůla Jiří) (5045)
Upd: Updated Italian interface language Italian language (by Paolo Saudin) (5042)
Fix: Multi-screen (Multi-Monitor) treatment:
Fix: correction in Win8 under the non-primary Windows TaskBar set in different locations when in full-screen display problems (5042)
Fix: correction TaskBar set at TOP Align handle display problems (5042)
Upd: (DB2/Informix) updated component IBM.Data.DB2.dll 9.7.4.4 (10.5.2.4) (after 08/03/2013) (5042)
Upd: Other minor fixes and optimization includes many updates ... they accumulate processing (5045)
Misc: (DB2/Informix) IBM Data Server Client Packages Version 10.5 Fix Pack 2 (after 08/03/2013)
Misc: Compatible with PostgreSQL 9.3.1 (after 08/03/2013) / 9.2.5 (after 08/03/2013) / 9.1.10 (after 08/03/2013) / 9.0.14 (after 08/03/2013 )
Misc: Compatible with Microsoft Windows 8.1 RTM (32bit and 64bit) (2013/10/17)
http://fishcodelib.com/Database.htm

[SiLæncer]

Exportizer is a free database export tool. It allows you to export data to a file, clipboard, or printer. Exportizer works via BDE or ADO. It can convert DB, DBF, text, CSV to text, CSV, XLS, RTF, XML, HTML, DBF, and INSERT statements. Many export options ensure full control over output. There is an ability to specify the source-to-target field mappings. Export operations can be performed either via the program interface or via command line with large number of parameters. You can easily generate needed command line directly from the GUI. It is possible to copy data to the clipboard or print it. There are several utility functions for data manipulating and bookmarking.

Features:

Opening tables from multi-table database files like XLS, XLSX, XLSM, XLSB, MDB, ACCDB, HTML, GDB, IB, FDB, UDL, and other multi-table databases like ODBC data sources etc.
Exporting data from all files, which are located in one folder, or all tables from a multi-table data source, at once (from interface or via command line).
Ability to specify custom increment number for Increment Field Value function.
Exporting data to Excel (XML-based) and DATABASE formats.
Using extra command line line options like /Silent, /LogFile, /CloseOnError etc.
Using extra export modes like Append and Empty+Insert.

Freeware

Whats new: >>

Minor changes.

http://www.vlsoftware.net/

[SiLæncer]

DbNinja is an advanced web-based toolset for MySQL database administration and development, and is a must-have for those who wish to access their hosted servers remotely. It supports all the latest features including: triggers, events, views, stored routines and foreign keys. DbNinja allows to import and backup data and MySQL object structures, manage users and much more. DbNinja has a highly functional and elegant user interface, and can be used securely in any modern browser on any OS.

Freeware

http://www.dbninja.com/