Tag: firebird

RedExpert 2022.09 has been released

Leave a comment

New version of RedExpert 2022.09 is available.

Added:

  1. Ability to save columns order and width in trace manager
  2. Field with performance counters in Trace Manager
  3. Export tables of Trace Manager
  4. Import data from a text file with separator
  5. Export data to SQL script
  6. Ability to change activity for several triggers and indexes in the object tree
  7. External tables support
  8. Support for external procedures and functions
  9. Support for comments on tables, procedures, functions and views
  10. English version of the release notes

Fixed:

  1. Quoting of table names when generating INSERT, UPDATE, DELETE queries
  2. Slow loading of tables
  3. Incorrect recognition of default value for procedure parameters if ‘=’ is used
  4. Table column comment formatting in DDL query
  5. Rollback transaction on closing request dialog
  6. Error in generating date and time values in the test data generator
  7. Wrong message about successful creation of external procedures and functions in request editor
  8. Incorrect generation of “create generator” query
  9. Errors of trace parsing
  10. Autocomplete columns to alias escaped table

Download and install the new version.

Source Code Of IBProvider Client For Firebird

Leave a comment

Hello Everyone.

Recently we published the source code of IBProvider built-in client for work with Firebird without fbclient.dll.

https://github.com/ibprovider/TechDemo-IBProvider.FirebirdClient-v01

It supports Firebird from v0.9.4 till v3.0.

It’s a stable and completely tested thing which has worked since 2017.

If you are interested in such things – you are welcome.

Source code of the test system is available, too.

License: MIT.

Regards, IBProvider team.

New version of RedExpert 2022.05 is available

Leave a comment

Added:

  1. Support for Firebird/RedDatabase 4 type
  2. Tablespaces support
  3. Explained plan support for Firebird/RedDatabase 3.0 and higher
  4. Table related triggers tab and navigation
  5. Editing objects in the database browser
  6. Execution of procedures and functions when viewing and editing them
  7. Ability to place the editor vertically or horizontally
  8. Search by text in any SQL-field

Fixed:

  1. Calculating trigger type using bitwise operations
  2. Reloading of system objects after creating a table via GUI
  3. Continue data generation when data mismatch error occurs
  4. Generating SQL for a procedure without parameters
  5. Reloading the object tree during CREATE OR ALTER and RECREATE operations
  6. Autocomplete freeze
  7. Commenting/uncommenting using “CTRL + /”
  8. Generate name for new connection
  9. Display in the center of the primary monitor when there are two monitors in Linux systems
  10. Show connection page without scrollbar
  11. Generate INSERT queries for DEFAULT fields

Download and install the new version

New version of RedExpert 2022.02 is available

Leave a comment

Added:

  1. Edit object button
  2. Password request dialog if password is empty
  3. Ability to work with cursors in a procedure
  4. Downloading updates in the background

Fixed:

  1. Request for saving data when closing a dialog box
  2. Displaying tables on Firebird with version less than 2.5
  3. Generating a function creation request with EXTERNAL NAME
  4. Inability to set the order of the index fields
  5. Incorrect display of dependencies
  6. Wrong generated column edit query when using a domain
  7. Syntax highlighting in views
  8. Recognition of object names in queries if they are at the beginning of a string
  9. Error adding a record with IDENTITY field
  10. Autocomplete errors in queries with aliases
  11. Tab-indexing order on connection page
  12. Wrong error “TABLE is in use” on attempt to remove table
  13. Error opening browser in Linux
  14. Index is active by default when created
  15. Modified the update dialogs
  16. High CPU load after connect
  17. DDL command generation error due to case-sensitive identifiers
  18. Connecting to a database immediately after it is created
  19. Commit transactions after they have been used
  20. Re-executing an SQL script without mandatory commit/rollback after a previous run
  21. Option to set null for string parameters in the parameter dialogue

Download and install the new version.

Release of EFCore Provider for IBProvider

Leave a comment

Hello All!

We have a great New Year’s gift for everyone who uses IBProvider to work with Firebird.

This is the provider for Entity Framework Core v6.0 — Lcpi.EFCore.LcpiOleDb!

We tried to make it as good as possible.

And most importantly — we opened its source code!

So you can make it even better 🙂

Target platform

  • NET6 (Windows)
  • Entity Framework Core v6.0
  • Firebird v3.0.8
  • LCPI ADO.NET Provider for OLE DB
  • LCPI.IBProvider v5

Key Features

  • Supporting of databases with 1 and 3 dialects.
  • Supporting of all FB3 datatypes, except arrays.
  • Providing a local evaluation by server’s rules.
  • Supporting mapping wide set of C# functions to SQL.
  • Providing extensions for nullable value types.

Acknowledgments

Thanks to our users and special thanks to Jeff Hampton who initiated this development process.

Thanks to the EFCore developers and special thanks to Andriy Svyryd.

Thanks to the developers npgsql/efcore.pg and FirebirdSQL/NETProvider.

Links

This news on our website: https://www.ibprovider.com/eng/news/n_211220-lcpi_efcore_lcpioledb.html

KR, IBProvider Team.

NEW VERSION OF RED EXPERT 2021.10 HAS BEEN RELEASED

Leave a comment

New version of RedExpert 2021.10 is available

Fixed:

  1. Autocomplete in query editor (not all tables were displayed in the list)
  2. Syntax highlighting
  3. Wrong table name after editing the trigger
  4. Hiding system packages for version prior to 3
  5. Connection cancellation
  6. Displaying an error while fetching ResultSet
  7. Parsing errors in the trace manager
  8. Slow work of the grant manager
  9. Inability to undo domain selection
  10. Inability to add a column to a table if cursor is outside the fields area (while table creating).
  11. Reloading objects in the tree after changing
  12. Jump to an object from the dependency tree
  13. Formatting of generated SELECT, INSERT, UPDATE queries

Changed:

  1. A name of constrained is generated immediately when the form is opened

Added:

  1. Display foreign key data while editing a table
  2. Context menu in “Set NULL” table
  3. A tab with object privileges
  4. System generators in the object tree
  5. Updating objects when they are changed in the query editor
  6. An update button for system tables

Download and install the new version.

New version of red expert 2021.07 has been released

Leave a comment

New version of RedExpert 2021.07 is available.

Corrections:

  1. Data type selection is implemented as a drop-down list
  2. While deleting the records marked for deletion are highlighted immediately
  3. Fixed the message about unsuccessful DDL operations
  4. Now it’s allowed to display unreadable characters in text blobs
  5. Fixed editing of the function
  6. Fixed SSH tunnel connection
  7. Stopped using template when creating tables
  8. Fixed column editing (when clicking on a column a new one was created)
  9. Fixed errors on the SQL tab of a domain
  10. Non-empty nodes in the tab with dependencies are highlighted in bold
  11. Fixed parsing variables in procedures (invalid parsing generated an incorrect SQL request for procedure creation)
  12. Packages not created by users were moved to the system packages branch
  13. Fixed connection to RedDatabase and Firebird versions 4+

Improvements:

  1. Now the database information is displayed by clicking the appropriate context menu item (not by selecting a database in the list)
  2. Significantly reduced time of loading scripts by reworking the syntax highlighting using ANTLR
  3. Autocompletion added to all textbars that use SQL
  4. Jump to database objects added to all text panels that use SQL
  5. Added “Users” node to the objects tree
  6. Added Jaybird4 driver

Download and install the new version.

New Version of Firebird Encryption Plugin Framework

Leave a comment

IBSurgeon releases a new version of Firebird Encryption Plugin Framework: the set of source files and ready-to-use compiled binaries to implement database encryption for Firebird databases.

Main features of Firebird Encryption Plugin Framework (version 2021):

1. Support of Firebird 4.0 and Firebird 3.0 out of the box, on Windows 32bit/64bit and Linux 32bit/64bit. The new version is ready to use with Firebird 4.0 without recompilation (but databases must be migrated, of course)

2. Client-side KeyHolder support. Now, fbclient.dll can load keys from KeyHolder.conf on the client-side, it allows the transparent and safe connection of developer tools, Firebird command-line tools. and other applications without key exchange support.

3. Included low-level tool for decryption of databases in case of corruption and (new in v2021) license of FirstAID recovery tool for 10 databases.

4. Gbak.exe supports encrypted backup and restore.

5. Client application examples are available for Delphi, Lazarus, PHP, .Net, Java, etc.

6. Now 2 licenses are available:
a) Unlimited license with sources, it includes upgrades for all minor releases of Firebird 4.0.x – USD$1999 (EUR 1655)
b) Unlimited license with sources and implementation consulting for 1 application, includes upgrades for all minor releases of Firebird 4.0.x – USD$2499(EUR 2055)

All existing customers of Firebird Encryption Framework Unlimited License will receive this major upgrade for free!

Download the demo version of Firebird Encryption to try it with your application!

1 2 3 4 5 … 18