Nigel Weeks created a demo for an assignment (for his Paramedic Practice degree) for a small fictional town’s health clinic, some appointment rooms, and some remote health professionals that are employed a few days a week (You can check it online also download the source code : Firebird SQL , PHP , webrtc, Ubuntu Server):

Naturally, I used the tools I know and love: PHP, FirebirdSQL, a splash of CSS, and a dollop of HTML.

Its feature set:

-Client management, current and outdated contact information(historical support)
-Bookings to see specialists, and notes system to go with the consultancy
-Booking screen with calendar for each specialist, and automatic blocking out for longer appointments.
-Daily run sheets for specialists (so they can see their appointment load in the morning)
-Payment status reports on appointments
-Reports on Specialist’s booking loads, and booking trends for hour of the day
-Outstanding account reports
-A WebRTC TeleHealth system for remote client and specialist consultancy and more. Oh yes, role-based access control(rudimentary)

With the impending implementation of Firebird as a backend for LibreOffice Base, to replace HSQLDB, I re-ran the tests of converging and cyclic cascades that were previously carried out for other databases.

These tests were carried out using Firebird 2.5 running on Ubuntu Server 12.04.2


We continue to develop our .NET Provider for OLEDB. In the new build (#1434), we have implemented the methods to obtain database metadata:

  • OleDbConnection.GetOleDbSchemaTable
  • OleDbConnection.GetSchema


Supported schemas:

  • SchemaGuids
  • DbInfoKeywords
  • DbInfoLiterals
  • All schemas of the OLEDB Provider

Distinctions compared to standard OLEDB.NET Provider:

  • The SchemaGuids schema describes all schemas including SchemaGuids, DbInfoKeywords and DbInfoLiterals.
  • The SchemaGuids schema supports restrictions for the Schema column.


Supported schemas:

  • MetaDataCollections
  • Restrictions
  • DataTypes
  • ReservedWords
  • DataSourceInformation
  • CharacterSets
  • Collations
  • Tables
  • Views
  • Columns
  • Procedures
  • ProcedureParameters
  • ProcedureColumns
  • Indexes

Distinctions compared to standard OLEDB.NET Provider:

  • The MetaDataCollections schema supports restrictions for the column CollectionName.
  • The Restrictions schema supports restrictions for the columns CollectionName and RestrictionName.
  • More accurate population of the DataSourceInformation schema.
  • More accurate population of the Restrictions schema.

Implementation peculiarities

  • Caching of data from its own schemas (SchemaGuids, DbInfoKeywords, DbInfoLiterals, …).
  • Coherence of information from metadata schemas with the descriptions of the resulting rowset columns and command parameters (ensured by IBProvider).
  • Different algorithms of metadata loading for Interbase and Firebird. Including – our provider takes into account the version of the server and the version of database ODS (ensured by IBProvider).
  • Caching of OLEDB metadata schemas is carried out on the IBProvider level (see a property «schema_cache»).

Other changes

  • The OleDbSchemaGuid class added with the lists of known OLEDB schema identifiers.
  • The OleDbSchemaRestriction class added with the lists of restriction indexes for known OLEDB schemas.
  • The OleDbLiteral class added.
  • The OleDbMetaDataCollectionNames class added.
  • The number of tests and debug structures ensuring the correct work of components increased.

New examples

If you are interested in working with stored procedures grouped into PACKAGE, please take a look at the new example for our .NET Provider:

  • Creation and working with PACKAGE (C#, FB3)
  • ADO.NET provider for Firebird is ready

    With the release of Delphi XE5, with support for iOS and Android it also brings InterBase versions of these two O.S-es, people started to question whether we can expect a version of Firebird for mobile platforms. Apparently, it will happen! Paul Beach said he already has a version of FB compiling for iOS, but it still needs testing. Anyway, the release versions for iOS / Android should not happen now, since developers are totally focused on Firebird 3 release.

    News via

    Firebird client can be build for Android
    Also on the Apple side: Paul Beach managed to cross-compile Firebird for iOS

    Ștefan Suciu announced his work on Implementing support for Firebird in Sqitch :

    I’m workingto implement support for Firebird (in the firebird branch) in Sqitch – a database change management application.

    Contributions are welcome! on Github

    NBackup via Services API is landed in DotNet FirebirdClient

    New GSOC update for the previous week:
    Current status of the firebird-sdbc driver is:

    – (Var)Char, Numeric and Date/Time types all supported. (No support for blob/clob/array/etc. yet.)
    – Data Editing in the GUI works.
    – Data Insertion works.
    – Table and Column definition/manipulation is mostly complete, there might still be a few minor-to-major issues, indexes aren’t supported at all.
    – Usable on Linux, Mac, Windows (thanks to tml for fixing the fbembed
    library / loading on Mac).

    ps: you can check also the previous updates #11,#10,#9

    The version of ADO.NET provider for Firebird is ready for your download!

    More info.

    The version of ADO.NET provider for Firebird is ready for your download!

    More info.

    « Previous PageNext Page »

    This Firebird & Interbase WebRing site owned by Carlos H. Cantu .
    [ Previous 5 Sites | Previous | Next | Next 5 Sites | Random Site | List Sites ]