Adriano dos Santos Fernandes (on the Firebird Development list): “I just built an example of Firebird 3 API usage with FreePascal. As said earlier, working with input/output buffers directly in non-C/C++ is difficult. This requires auxiliary classes. The others things seem ok and easy to use. We need some new functions in the new API, for example, to convert.” status vectors to strings, but this is not specific to Pascal.

node-firebird 0.5.1 released with the following functions implemented for Service Manager:

backup
restore
fixproperties
serverinfo
database validation
commit transaction
rollback transaction
recover transaction
database stats
users infos
user actions (add modify remove)
get firebird file log
tracing

List of functions implemeted :

// each row : fctname : [params], typeofreturn
var fbsvc = {
    "backup" : { [ "options"], "stream" },
    "nbackup" : { [ "options"], "stream" },
    "restore" : { [ "options"], "stream" },
    "nrestore" : { [ "options"], "stream" },
    "setDialect": { [ "database","dialect"], "stream" },
    "setSweepinterval": { [ "database","sweepinterval"], "stream" },
    "setCachebuffer" : { [ "database","nbpagebuffers"], "stream" },
    "BringOnline" : { [ "database"], "stream" },
    "Shutdown" : { [ "database","shutdown","shutdowndelay","shutdownmode"], "stream" },
    "setShadow" : { [ "database","activateshadow"], "stream" },
    "setForcewrite" : { [ "database","forcewrite"], "stream" },
    "setReservespace" : { [ "database","reservespace"], "stream" },
    "setReadonlyMode" : { [ "database"], "stream" },
    "setReadwriteMode" : { [ "database"], "stream" },
    "validate" : { [ "options"], "stream" },
    "commit" : { [ "database", "transactid"], "stream" },
    "rollback" : { [ "database", "transactid"], "stream" },
    "recover" : { [ "database", "transactid"], "stream" },
    "getStats" : { [ "options"], "stream" },
    "getLog" : { [ "options"], "stream" },
    "getUsers" : { [ "username"], "object" },
    "addUser" : { [ "username", "password", "options"], "stream" },
    "editUser" : { [ "username", "options"], "stream" },
    "removeUser" : { [ "username","rolename"], "stream" },
    "getFbserverInfos" : { [ "options", "options"], "object" },
    "startTrace" : { [ "options"], "stream" },
    "suspendTrace" : { [ "options"], "stream" },
    "resumeTrace" : { [ "options"], "stream" },
    "stopTrace" : { [ "options"], "stream" },
    "getTraceList" : { [ "options"], "stream" },
    "hasActionRunning" : { [ "options"], "object"}
}

this is an example to use with stream and object

fb.attach(_connection, function(err, svc) { 
    if (err)
        return;
    // all function that return a stream take two optional parameter
    // optread => byline or buffer  byline use isc_info_svc_line and buffer use isc_info_svc_to_eof
    // buffersize => is the buffer for service manager it can't exceed 8ko (i'm not sure)

    svc.getLog({optread:'buffer', buffersize:2048}, function (err, data) {
            // data is a readablestream that contain the firebird.log file
            console.log(err);
            data.on('data', function (data) {
                console.log(data.toString());
            });
            data.on('end', function() {
                console.log('finish');
            });
        });

    // an other exemple to use function that return object
    svc.getFbserverInfos(
            {
            "dbinfo" : true,
            "fbconfig" : true,
            "svcversion" : true,
            "fbversion" : true,
            "fbimplementation" : true,
            "fbcapatibilities" : true,
            "pathsecuritydb" : true,
            "fbenv" : true,
            "fbenvlock" : true,
            "fbenvmsg" : true
        }, {}, function (err, data) {
            console.log(err);
            console.log(data);
        }); 
});

The 12th edition of the Firebird Developers Day will take place in Piracicaba,SP – Brazil, in 08-Aug-2015, at Espaço Beira Rio (same place as last year).

The conference site with all the details will enter online in the end of May.

FDB Python driver for Firebird v1.4.4 is available for download

Here is the changelog http://pythonhosted.org//fdb/changelog.html#version-1-4-4

node-firebird 0.4.0 released with initial support for Service Manager .

For the moment only Backup Service is implemented

Firebird.attach(options, function(err, svc) { 
    if (err)
        return;
    svc.backup(
        {
            database:'/DB/MYDB.FDB',
            files: [
                    {
                     filename:'/DB/MYDB.FBK', 
                     sizefile:'0'
                    }
                   ]
        }, 
        function(err, data) {
            console.log(data);
        });

Firebird C++ NodeJS module is updated with 64bit fixes:

Please use this version  if you are on 64bit os : npm install -g firebird-libfbclient

Steve Krämer contributed Firebird Adminer driver

I’m proud to release a first version of my Firebird-Driver for Adminer. Thought, it’s a pre-alpha version. But it’s a first tool for all of those who are looking for a solution right now

Qt 5.4.1 and Qt creator 3.3.1 released with many fixes and enhancements

C++ NodeJS module is updated with fixes for the Node v.0.12 release.

Fix was related to nan version and api changes.

Upscene Productions is proud to announce the availability of the next release of the popular multi-DBMS development tool:

” Database Workbench 5.0.10 “

This release fixes several bugs as reported by our customers.

DBW 5

“There is so much new in Database Workbench 5, I don’t know where to start”, says Martijn Tonies, founder of Upscene Productions. “This release adds code editor features, has diagramming improvements, comes in multiple editions, is fully HiDPI aware and offers tunneling for MySQL and MariaDB connections. It all was a lot of work, but it was worth it!”

“We worked closely with out customer and implemented many of their requests and for new users, we offer multiple editions to suit their development needs. From design to productivity, there’s new features and improvements in almost everything!”

New features in version 5 include:

  • Support for the latest versions of database engines and MariaDB support
  • New and improved user interface
  • Code editor features like block staples, code folding, object linking and dynamic highlighting
  • “Diagram Navigator” for easier diagramming navigation
  • MySQL/MariaDB tunneling support
  • Firebird 3 Package Editor
  • Basic and Pro Edition to suit your needs
  • and much more…

For more information, see What’s new in Database Workbench 5?

Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server,
SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed based on selectable modules.

It includes tools for database design, database maintenance, testing, data transfer,
data import & export, database migration, database compare and numerous other tools.

About Database Workbench
Database Workbench is a database developer tool, over 10 years in the making and
is being used by thousands of developers across the globe who have come to rely on it
every day. From database design, implementation, to testing and debugging, it will aid you
in your daily database work.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been providing
database developers with useful tools for over 12 years. Slowly expanding the product portfolio
and gaining recognition amongst InterBase and Firebird database developers, they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL Server.

« Previous PageNext Page »

Link to us!

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