http://www.ibexpert.com/download/

На сайте, почему-то   



Что нового?
http://www.ibexpert.com/rus/news/ibe_2008.02.18_eng.txt

Это сообщение отредактировал(а) Akella - 18.8.2009, 23:07

http://www.ibexpert.com/download/
Вышла версия  IBExpert 2008.11.18   


Что нового
http://ibexpert.net/ibe/index.php?n=Doc.WhatsNew#ibe-g

Самую свежую версию IBExpert обычно можно скачать тут

New IBExpert version 2009.01.17
http://ibexpert.net/ibe/index.php?n=Main.News#news14

Скачать

http://www.ibexpert.com/download/

В версии 2009.06.15 небольшие проблемы (недоделки) с юникодом. Ждём новую версию.

http://www.ibexpert.com/download/

Добавлено через 6 минут и 5 секунд
http://ibexpert.net/ibe/index.php?n=Main.News#news32

New IBExpert Version 2009.11.02 available

Вышла новая версия IBExpert 2010.01.06

New features include:

    * Lock your SQL queries
    * New ident/unident shortcuts
    * Now supports Firebird 2.5's Trace/Audit services
    * New IBEBlock: ibec_DirectoryExists

Новость на сайте

Скачать

Сегодня выпущена новая версия IBExpert 2010.03.17
http://ibexpert.net/ibe/index.php?n=Doc.WhatsNew


Это сообщение отредактировал(а) Akella - 21.6.2010, 12:24

http://www.ibexpert.com/download/

http://www.ibexpert.net/ibe/index.php?n=Doc.WhatsNew

Я так понял, что в версии  2010.07.05 только несколько исправлений

http://www.ibexpert.net/ibe/index.php?n=Doc.WhatsNew
New IBExpert version 2010.07.05 available!

1. Minor bug fixes and small improvements


---
http://www.ibexpert.com/download/

New IBExpert version 2010.07.26 available!
http://www.ibexpert.com/download/ 

What is new?
http://www.ibexpert.net/ibe/index.php?n=Doc.WhatsNew

New features in detail

New features overview:

IBExpert 2010.07.26
------------------------------------------

1. Data Frame, Form View:

* Fixed problem "control has no parent window" when browsing recordsets
with blob fields.


2. IBEBlock:

* Memory leak eliminated when executing nested ibeblocks using EXECUTE IBEBLOCK
statement.

* ibec_ExtractMetadata function: added ServerVersion, AddKeyword, RemoveKeyword options.
All options are intended mostly for control quoting of identifiers that match keywords.

Example of usage:
ibec_ExtractMetadata(MyDB, 'D:\MyDB.sql', 'ServerVersion=FB21; AddKeyword=FIRST,SECOND,KEY;
RemoveKeyword=START,TIME; ...', cbb);

You can use following server version identifiers with ServerVersion option:
IB5X, IB61, IB65, IB70, IB71, IB75, IB2007, FB10, FB15, FB20, FB21, FB25, YA10.


* ibec_SetEnvironmentVariable function implemented.

ibec_SetEnvironmentVariable function is a wrapper for Windows API SetEnvironmentVariable
function which sets the value of an environment variable for the current process.

Syntax:

function ibec_SetEnvironmentVariable(VarName : string; Value : string) : integer;

If the function succeeds, the return value is nonzero. If the function fails, the return value is zero.


3. Dependencies Frame:

* "Apply block to selected objects" item added to context menu. This allows
users to process selected objects using custom ibeblocks.


4. Blob Viewer/Editor:

* Added "As IBE/FB Block" tab with possibility of integrated debugging.
Currently only debugging of IBEBlocks supported.


5. Extract Metadata:

* Support of default database collate for FB 2.5 databases implemented.


6. Create Database:

* Added "Default collation" field to specify default collate for FB 2.5 databases


7. View Editor:

* Fixed some problems with resolving dependencies of a view when creating the Recreate Script.


8. IBEScript, SQL Scripts:

* Added possibility to use environment variables in INPUT, OUTPUT and SET BLOBFILE statements.

Example:

execute ibeblock
as
begin
ibec_SetEnvironmentVariable('MyScriptDir', 'D:\Scripts\MyScripts');
ibec_SetEnvironmentVariable('MyDataDir', 'D:\Data');
ibec_SetEnvironmentVariable('MyBlobData', 'D:\Data\Blobs');
end;

SET BLOBFILE '%MyBlobData%\mytable.lob';

OUTPUT '%MyDataDir%\mytable.sql';
select * from mytable
asinsert;
COMMIT;

INPUT '%MyScriptDir%\ProcessData.sql';


9. Table/View Editor:

* Added possibility to drop foreign key directly from the fields list, if exists
(from the context menu)

* Support of altering of computed by expressions implemented (FB 2.5)


10. SP/Trigger Debugger:

* Support of EXECUTE STATEMENT ... ON external connection implemented.


11. Minor bugfixes and improvements...

http://ibexpert.net/ibe/index.php?n=Doc.WhatsNew#ibe-q
IBExpert 2010.10.08

http://ibexpert.net/ibe/index.php?n=Doc.WhatsNew#ibe-r


Скачать: http://www.ibexpert.com/download/

IBExpert new version 2011.04.03 available

What's New?
1. SQL Editor 
•    Added the possibility to share SQL Editor queries between registered databases - Common queries. These queries are made available from all registered databases. 
•    The Find query tab allows you to search for queries in Histories and sets of the SQL Editor queries of any registered database. Also it is possible to perform a search in IBEBlocks and Firebird blocks stored in the IBExpert User Database. 
•    Both features are available only if usage of the IBExpert User Database (Options / Environment options / User Database) is enabled. 
2. Table Data Comparer 
•    Fixed the occasionally occurring stream write error. 
3. Database Restore 
•    Added the option to register a database straight after a successful restore (Register database after restore checkbox when Restore in new database is selected). 
4. Table Editor / Script 
•    Decode domains checkbox added. 
5. Code Editors / Code Completion 
•    Added the possibility to display a list of object names containing a specified string, instead of starting with that string. Just add the dollar sign to the beginning of an object name. For example, $tmp + [Ctrl+Space] will list all database objects (SQL keywords, etc.) containing tmp in the object name. 
Alternatively you can use two asterisks to get the same result: *tmp* + [Ctrl+Space]. 
6. To-do List 
•    Support of UTF8 implemented. 
7. Database Explorer 
•    Saving and restoring of the Database Explorer tree state (expanded folders, active node) between IBExpert sessions implemented. 
8. Environment Options / Confirmations 
•    Added an option to control what to do with an active transaction when closing a form. By default IBExpert requests for your choice for each active transaction when you close a form. Now you can change this behavior and choose Commit or Rollback as the default action. 
9. SP/Trigger/Block Debugger 
•    Improved VAR values editor. 
•    Support of UTF8. 
10. IBEBlock 
•    The implementation of ibec_iif and ibec_Coalesce functions was optimized: the evaluation of input expressions stops as soon as the result of the entire expression becomes evident in left to right order of the evaluation. 
•    ibec_GetDiskFreeSpace function implemented. This function retrieves information about the amount of space that is available on a disk volume. 
Syntax: 
 function ibec_GetDiskFreeSpace(DirectoryName : variant) : variant; 
DirectoryName is a directory on the disk. If this parameter is NULL or an empty string, the function uses the root of the current disk. ibec_GetDiskFreeSpace returns the total number of free bytes on a disk that are available to the user who is associated with the calling thread. 
Example: 

•    ibec_GetServerLog function implemented. This function retrieves a Firebird/InterBase server log using the Services API (if available) and saves it into a specified file (or variable). 
Syntax 
 function ibec_GetServerLog(ConnectParams : string; FileName : variant) : variant; 
If FileName is specified as NULL or an empty string, the ibec_GetServerLog function returns the server log as the result. Otherwise it returns NULL. 
Example 
 execute ibeblock 
 as 
   begin 
     res = ibec_GetServerLog('ServerName=localHOST/3070; User=SYSDBA; Password=masterke; 
                              ClientLib="C:\Program Files\Firebird25\bin\fbclient.dll"', 
                              'W:\srvlog.txt'); 
   end 
11. A lot of minor bug fixes and small improvements 
The IBExpert Team



Скачать: http://www.ibexpert.com/download/

IBExpert new version 2011.09.05 available
http://www.ibexpert.com/download/

Что нового в версии 12.01.2011: http://ibexpert.net/ibe/index.php?n=Doc.WhatsNew#ibe-v




Скачать (прямая ссылка)>>


Я заметил, что немного обновили интерфейс, IBExpert теперь работает шустрее, при чем это видно невооружённым глазом.

Вверху, над таблицей структуры есть панелька, показывающая информацию о выбранном поле, например вот для вычисляемого поля:

Вышла новая версия IBExpert 2011.12.11: http://ibexpert.net/ibe/index.php?n=Doc.WhatsNew#ibe-w



Скачать, прямая ссылка >>

Вышла новая версия IBExpert  2012.02.21



Скачать >>

Скачать >>


IBExpert 2012.05.09

1. Code Formatter 
•    Implemented formatting of IN AUTONOMOUS TRANSACTION statement. 
•    There is a new option for SELECT and UPDATE statements, Line feed before column list delimiter, which allows you to format them as below: 
   SELECT Customer
        , Contact_First
        , Contact_Last
        , Address_Line1
          ...

   UPDATE Help_Items
     SET Item_Parent_Id = :Varpitem_Parent_Id
       , Item_Title = :Varpitem_Title
       , Item_Order = :Varpitem_Order
       , Item_Data = :Varpitem_Data
         ...
2. Import Data 
•    Trim string values if they are too long option added (General Options tab). If this option is enabled, IBExpert will silently truncate strings if they exceed the target field length. 
3. Code Editors / Code Insight / Code Parameters Hint 
•    For stored procedures the parameters’ hint now contains a description of the current input parameter. If there is no description specified for the current parameter – a description of the procedure itself will be displayed, if it exists. 
•    For user-defined functions the parameters’ hint displays a UDF description, if it exists. 
•    For the VALUES part of INSERT statements the parameters' hint displays a description of the current field or table description. 
•    The following options are available under Options / Editor Options / Code Insight allowing you to customize the behavior of the parameters tip: 
o    Show current parameter/field description. 
o    Show parent object description if there is no description for current parameter/field. 
o    Maximum number of description lines to show. 
4. Code Editors 
•    Quick Comment feature implemented. Using the [Ctrl] + [/] (Ctrl + Slash) shortcut you can quickly comment/uncomment the current line of code or selected block using the single line comment style (-- at the beginning of the line). 
5. Search Metadata 
•    Fixed the problem with searching non-ASCII text when using UTF8 connection charset. 
6. IBEBlock 
•    ibec_ImportData: Support of TrimStrings option added. 
•    ibec_Decode function implemented. The ibec_Decode function has the functionality of an IF...THEN...ELSE statement. 
Syntax: 
  function ibec_Decode(Expression : variant; Search : variant; Result : variant; 
                       [Search : variant; Result : variant]... [; Default : variant]) : variant;
•    Expression is the value to compare. 
•    Search is the value that is compared against Expression. 
•    Result is the value returned, if Expression is equal to Search. 
•    Default is optional. If no matches are found, the ibec_Decode will return Default. If Default is omitted, then the ibec_Decode function will return NULL (if no matches are found). 
Example: 
  CityName = ibec_Decode(CityCode, 1, 'Berlin', 2, 'Rome', 3, 'Bangkok', 'Unknown'); 
•    The following functions have been implemented for reading/writing from/to a file stream: 
function ibec_fs_ReadByte(FileHandle : variant) : integer; 
function ibec_fs_WriteByte(FileHandle : variant; Value : integer) : integer; 
function ibec_fs_ReadWord(FileHandle : variant) : integer; 
function ibec_fs_WriteWord(FileHandle : variant; Value : integer) : integer; 
function ibec_fs_ReadDoubleWord(FileHandle : variant) : integer; 
function ibec_fs_WriteDoubleWord(FileHandle : variant; Value : integer) : integer; 
function ibec_fs_ReadInt32(FileHandle : variant) : integer; 
function ibec_fs_WriteInt32(FileHandle : variant; Value : integer) : integer; 
•    ibec_fs_ReadByte function reads one byte from the file stream and returns an unsigned integer value (0..255). 
•    ibec_fs_ReadWord function reads two bytes from the file stream and returns an unsigned integer value (0..65535). 
•    ibec_fs_ReadDoubleWord function reads for bytes from the file stream and returns an unsigned integer value (0..4294967295). 
•    ibec_fs_ReadInt32 function reads for bytes from the file stream and returns a signed integer value (–2147483648..2147483647). 
•    ibec_fs_WriteByte functions writes one byte to the file stream as a 8-bit unsigned integer. 
•    ibec_fs_WriteWord functions writes two bytes to the file stream as a 16-bit unsigned integer. 
•    ibec_fs_WriteDoubleWord functions writes four bytes to the file stream as a 32-bit unsigned integer. 
•    ibec_fs_WriteInt32 functions writes for bytes to the file stream as a 32-bit signed integer. 
All ibec_fs_WriteXXX functions return the number of bytes written to the file stream. 
•    Below is an example of an IBEBlock which scans a database file and retrieves some useful information about the distribution of database pages. You can also find this block in the \Blocks\Samples\DB Pages Statistics directory. 
   execute ibeblock (DBFileName varchar(1000) comment 'Path to database file')
   returns (
     PageType varchar(100) comment 'Page Type',
     PageCount integer comment 'Page Count',
     PagePercent numeric(15,2) comment 'Page %',
     PageMb numeric(15,2) comment 'Size, Mb')
   as
   begin
     TimeStart = ibec_GetTickCount();
     iPageIndex = 0;
     aPages = ibec_Array(0,0,0,0,0,0,0,0,0,0,0);
     aPageTypes = ibec_Array('Unused', 'Database Header', 'Page Inventory Page', 'Transaction Inventory Page', 'Pointer Page',
                             'Data Page', 'Index Root Page', 'Index Page', 'Blob Data Page', 'Generator Page', 'Write Ahead Log');

     aBitMasks = ibec_Array(1, 2, 4, 8, 16, 32, 64, 128);

     fs = ibec_fs_OpenFile(DBFileName, __fmOpenRead + __fmShareDenyNone);
     if (fs is null) then
       Exit;
     try
       ibec_fs_Seek(fs, 16, __soFromBeginning);

       iPageSize = ibec_fs_ReadWord(fs);
       iPageSizeSub20 = iPageSize - 20;

       ibec_fs_Seek(fs, iPageSize + 20, __soFromBeginning);
       sPIP = ibec_fs_ReadString(fs, iPageSizeSub20);
       NextPIPIndex = iPageSizeSub20 * 8 - 1;

       ibec_fs_Seek(fs, 0, __soFromBeginning);
       while (not ibec_fs_Eof(fs)) do
       begin
         if (ibec_mod(iPageIndex, 100) = 0) then
         begin
           TimeSpent = ibec_Div(ibec_GetTickCount() - TimeStart, 1000);
           iSpeed = ibec_IIF((iPageIndex = 0) or (TimeSpent = 0), 0, ((iPageSize / 1024) * iPageIndex) / 1024 / TimeSpent);
           ibec_Progress(iPageIndex || '  :  ' || TimeSpent || '  :  ' || iSpeed || ' Mb/s');
         end;
         iVal = ibec_fs_ReadByte(fs);

         iPIPBytePos = ibec_mod(ibec_div(iPageIndex, 8), iPageSizeSub20) + 1;
         iPIPBitMaskIdx = ibec_mod(iPageIndex, 8);
         if (iPIPBitMaskIdx = 0) then
           iPIPByte = ibec_Ord(ibec_Copy(sPIP, iPIPBytePos, 1));
         iPIPBitMask = aBitMasks[iPIPBitMaskIdx];
         IsUsed = (ibec_and(iPIPBitMask, iPIPByte) = 0);

         if (IsUsed) then
           aPages[iVal] = aPages[iVal] + 1;
         else
           aPages[0] = aPages[0] + 1;

         if (iPageIndex = NextPIPIndex) then
         begin
           ibec_fs_Seek(fs, 19, __soFromCurrent);
           sPIP = ibec_fs_ReadString(fs, iPageSizeSub20);
           NextPIPIndex = NextPIPIndex + iPageSizeSub20 * 8;
         end;

         iPageIndex = iPageIndex + 1;
         ibec_fs_Seek(fs, iPageIndex * iPageSize, __soFromBeginning);
       end;

       PageType = 'Total Pages';
       PageCount = iPageIndex;
       PagePercent = 100;
       PageMb = (PageCount * (iPageSize / 1024)) / 1024;
       suspend;

       foreach (aPages as PageCnt key Idx skip nulls) do
       begin
         PageType = aPageTypes[Idx];
         PageCount = PageCnt;
         PagePercent = (PageCnt/iPageIndex) * 100;
         PageMb = (PageCount * (iPageSize / 1024)) / 1024;
         suspend;
       end
     finally
       ibec_fs_CloseFile(fs);
     end
   end 
7. A lot of minor bug fixes and small improvements. 

Вышла новая версия.
Скачать >>

Подробнее >>




Скачать >>

New IBExpert version 2013.10.08 available
New features: 
1.    IBExpert Benchmark: Compare the performance of different hardware, software and operating systems for use as your Firebird Server! 
2.    Firebird 3.0 support: We have already integrated the first Firebird 3.0 functions and some of the new Firebird 3.0 Alpha version features have already been implemented. More to follow soon! 
3.    IBEBlock FTP support: Further commands have been integrated into the IBEBlock language for automated access to FTP servers. 
4.    Automatic update information: The new IBExpert version now automatically checks for updates and informs you of any new version as soon as it is published. 
5.    Our new online shop: Implemented using IBExpert, IBEBlock, Firebird and Apache on a Windows Server. We also offer workshops, so you can learn to integrate this technology in your own projects. 
6.    ... and much more. 

Скачать бесплатную версию IBExpert http://www.ibexpert.com/rus/ibe_sfx.exe

Новая версия IBExpert 2014.01.01 
Скачать бесплатную версию IBExpert http://www.ibexpert.com/rus/ibe_sfx.exe 


http://ibexpert.net/ibe/index.php?n=Doc.De...tStatisticsMode
http://ibexpert.net/ibe/index.php?n=Doc.WhatsNew#ibe-h1_2
http://ibexpert.net/ibe/index.php?n=Doc.WhatsNew#ibe-h1_11

Новая версия IBExpert 2014.03.16
Скачать бесплатную версию IBExpert http://www.ibexpert.com/rus/ibe_sfx.exe 


What´s new?    
1.    Export data

2.    Export data as SQL script

3.    Script Executive, IBEScript

4.    Support of CREATE/ALTER/RECREATE/DROP/COMMENT FUNCTION statements and version history for stored functions (Firebird 3)

5.    Extract Metadata

6.    Grant Manager

7.    Autogrant privileges

8.    PSQL parser

9.    SQL Editor

10.    Trace and Audit service

11.    Data frame

12.    IBEBlock

13.    Minor bug fixes and small improvements.

http://ibexpert.net/ibe/index.php?n=Doc.WhatsNew#ibe-i1

IBExpert new version 2015.06.01
1. Database Inside 
•    Support of Firebird 3 databases implemented. 
•    Fixed the accidental invalid floating point operation error. 
2. Database Comparer, Table Data Comparer 
•    Fixed the problem that caused IBExpert to crash in some cases. 
3. Support of online validation (Firebird 2.5.4) implemented 
There are two ways to perform online validation: 
•    In the Database Explorer select one or more tables and choose Validate selected table(s) online from the context menu. 
•    In the Table Editor select Validate online from the Editor menu. 
Online validation is available only in Firebird 2.5.4. 
4. Data grids 
•    Data tips for blob fields are shown in Unicode if it is necessary. 
5. Code Editors 
•    Support of statistical functions and linear regression functions (highlighting, parameter tips) implemented, Firebird 3. 
6. PSQL parser 
•    Support of REGR_xxx (linear regression) functions as window functions implemented (Firebird 3). 
7. Blob Viewer 
•    Added support of Firebird 3 format descriptors (As format page). 
8. Minor bug fixes and small improvements 

http://ibexpert.net/downloadcenter/index.php
http://www.ibexpert.com/rus/ibe_sfx.exe