Free tool for MindTheBird participants!

Hello All,

Good news for all MindTheBird participants – Nucleon Software http://www.nucleonsoftware.com offers free license of there “Database Master” software for all participants of MindTheBird.

If you would like to get such license, please send to free at mindthebird.com email with the following information: “FirstName”, “LastName”, E-Mail, optionally Company name, and get free license of DatabaseMaster (they will be sent in 2-3 work days).

We encourage all tools vendor to run similar programs for MindTheBird participants, and, of course, we ask everyone to join MindTheBird! to support Firebird and to get benefits and prizes.

To join MindTheBird! you just need to put one of MindTheBird! banners or presentations (http://www.mindthebird.com/downloadmtb.html) to your web-site or blog, link it to www.mindthebird.com or to www.firebirdsql.org and send us link to this page for verification.

Best regards,
MindTheBird Team

Falcon Programming supporting Firebird

Posted in Firebird-Devel:

Hello Firebird-Developers/Users,

FalconPL, a new and fast-growing programming language had included FirebirdSQL support as High Priority in their TODOs.

Firebird Database Server module driver for DBI system
Type: Module binding
Difficulty: Intermediate
Required skills: C++ (high), database (basic)
Time frame: 30 days
Mentoring: High
This idea consists of creating a binary native module using the Falcon multi-platform C++ SDK to provide an interface to the Firebird database server through the DBI abstract interface system.
The resulting module shall use the Falcon Service interface to expose methods used by the DBI system to access database resources. Other than that, the applicant shall implement a set of functions interfacing directly the Firebird database API which can be called directly by scripts bypassing the DBI interface.
The applicant will be in charge of designing an interface to the module functionality, implement it in C++, document it through the faldoc integrated module documentation system, provide code samples and automated unit test for evaluation by faltest.
The work will be evaluated based on the elegance of the interface, efficiency in terms of memory footprint and CPU consumption, completeness of the documentation (including samples) and on readability of the produced code. Extra consideration will be granted to work that promotes the uniquely multi-paradigm approach of the Falcon Programming Language in the interface provided to the final users. Top evaluation is given if the final work also provides a Falcon Service exposing the same functionalities provided to scripts via a C++ interface.

Facts Table:
http://www.falconpl.org/index.ftd?page_id=facts

About Falcon:
http://www.falconpl.org/index.ftd?page_id=about

And here’s the newsgroup:
http://groups.google.com/group/falconpl

Maybe somebody is interested to collaborate with the FalconPL creator (Giancarlo Nicolai) in adding and implementing the FirebirdSQL support.

Thanks and best regards,
Mario Sabado

IBSurgeon at FDD

From IBSurgeon blog:

7th Firebird Developers Days: Visit IBSurgeon’s presentations

17th of July, Piracicaba, Brazil: The 7th Firebird Developers Day will take place in the UNIMEP university theatre. This is undoubtedly the biggest worlwide event devoted to Firebird – more that 600 people, dozen of speakers and lot of interest.
As you may knows, Brazil is the N1 country in terms of number of Firebird users (following with Germany, Russia and USA), and Firebird is the number 1 database in Brazil too.
This will be 4th time IBSurgeon sponsors and presents at FDD. This year Dmitry Kuzmenko will speak about big Firebird databases (you may remember that recently we did test with 1Terabyte Firebird database) and about speed of test restores.
Also at this event IBSurgeon will announce some serious changes in licensing policy, intended to encourage people to treat Firebird databases in more careful way.
We will follow the results of conference and post updates here.

New release of Database Master 2.0 for Firebird

Database Master 2.0 for FireBird has been released. The new version  includes new great featureas, enhancements and some bug fixes.  Database Master also supports Oracle, SQLServer, MySQL, PostgreSQL,  SQLite, MongoDB, XML File, ODBC and OleDB connections.

What is new:

  • MongoDB support: Open Source and Document based database system is  supported now.
  • XML File support: You can add an Xml file as a relational database  and execute SQL queries.
  • Search Engine: You can search any data in your database without  writing any SQL query.
  • New reporting system is implemented.
  • XML Import: You can import your xml file into a database table.
  • New Export File Formats: Word 2007, Excel 2007, OpenOffice, PNG,  XPS, RTF, dBase formats are supported now.
  • Code Factory: You can genarate (C#,Java etc.) code from your database.
  • SQL Script Export: You can export View and Procedure structure now.
  • Templates and Snippets: Database Master supports now SQL tempaltes  and snippets.

Avoid using rand() in where clauses

I was working today, building a procedure to populate some tables and do some data updates and deletes, for speed testing for one of my FDD sessions.

I decided to use the built-in rand() function of Firebird 2.x in the where clause of updates and deletes, but found out that the execution time was tooking too long to complete. Looking at statistics, it showed weird numbers for Indexed Reads, like, the updates of 5 records generating 80.000 indexed reads in the Primary Key index.

After some debugging, I just found out that rand() was the guilt! I moved it outside the update/delete statement, storing the result in a variable, and using the variable in the where clause. It worked million times faster!

So, moral of history: Don’t use rand() in the where clause of updates and deletes statements. And yep, I know this is quite unusual use 😉

1 32 33 34 35 36 100