Firebird Foreign Data Wrapper for PostgreSQL Release 0.1.5 is out

New version 0.1.5 is released in the unstable area and here is the ChangeLog:

  • Add basic Firebird version detection to ensure that only functions available on the remote Firebird server are actually pushed down
  • Push down functions COALESCE(), NULLIF()
  • Only push down SUBSTRING() if 2nd and 3rd arguments are INTs

Also fbsql is progressing (a command-line client for Firebird inspired by PostgreSQL’s psql)

Database .NET 10.3 released

Database .NET is an innovative, powerful and intuitive multiple database management tool.
You can Browse objects, Design tables, Edit rows, Export data and Run queries with a consistent interface.

You’re welcome to download the Database .NET right now at:
http://fishcodelib.com/Database.htm
All-In-One, Free, Simple and Standalone (No Installation).
Supported Platforms: Windows XP/2003/Vista/2008/7/8/2012/8.1 (x86/x64)

FBScanner 3.6.1 is released

New version of FBScanner (3.6.1) is released. FBScanner is an unique tool to trace and audit Firebird (1.0 – 2.5) and InterBase (4.0 – XE3) SQL traffic (connections, transactions, queries), it’s very efficient tool for performance optimization and SQL bug tracking.

FBScanner works like a proxy, and enables transparent data capture and analysis:

FBScanner is Firebird performance optimization tool

FBScanner can be used for the following tasks:

  • Find queries with bad performance (i.e., slow queries with high prepare and execute times, queries with bad plans)
  • Track transactions usage
  • Real-time view of connections, users and transactions (connections can be killed)
  • Retrospective analysis of SQL traffic
  • and more – see presentation here.

FBScanner has 2 licensing options:

  • Per server – FBScanner can be used on the single server or computer to track Firebird traffic.
  • Unlimited ISV subscription – FBScanner can be installed on any number of computers during the 1 year for use with the specific software application from the single independent software vendor (ISV).

All users of FBScanner 3 already have FBScanner 3.6.1 in IBSurgeon Deploy Center.

User of FBScanner 2.x can upgrade to FBScanner 3.6.1 with 50% discount – please contact upgrade@ib-aid.com

Download now:

Demo version of FBScanner can be found here:

FBScanner Demo version

Please look at the FBScanner User Guide to get more information about its capabilities:

FBScanner User Guide

IBX for Lazarus 1.0.5 Released

IBX for Lazarus 1.0.5 is now available for download from http://www.mwasoftware.co.uk/ibx

This is a very minor update from 1.0.4 to ensure compatibility with fpc 2.6.4. The specific issue is the proposed change to the TBookmark type definition in the DB unit. This was originally expected to be introduced in 2.6.4 and conditional compilation was set accordingly. As this type change has now been postponed, the conditional compilation flags have been updated such that the updated type definition is not expected until compiler version 2.7.x onwards.

News via Lazarus forums

1 102 103 104 105 106 200